Welcome to the Sage 50 Canada Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hello - I know this article shows how to upload your inventory listing ( https://ca-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=220924150010124 ).
But how I update the stock currently on hand as part of the upload? I can't make…
Hi,
I'm trying to determine what the best way to track the costs of external processes on inventory items? hoping some folks around here could chime in.
RM=RAW MATERIAL
AS=ASSEMBLY
FG=FINISHED GOOD
EXAMPLE:
1. 10 x Widgets item number (RMWIDGET1…
When entering a P.O. for Vendor/Supplier and it is an inventory item, does it remove from Inventory when processing that order?
Or does it remove when it has been invoiced.
Our current process for inventory stock is done the following ways:
-Sales…
Currently I have a one line GL entered inventory balance, but want to change it from a one line item to units. This is inventory that has not been tracked over the years, but I want to start drawing it down through internal allocations to various jobs…
We are a factory using Sage 50 Quantum. We use average cost and quantities were not negative. I managed to set the correct quantities and values of the inventory by using the inventory module, by first resetting the value to 0 in the module and then adding…
I've working on year end inventory adjustments. Is there another way to correct our inventory other than by doing individual inventory adjustments for each item? Is there an option where you can just enter the current inventory amount instead of doing…
Hi Everyone,
I am currently working for a company where they have not been utilizing the inventory module correctly- we are using Sage 50 Quantum Accounting. Currently we have all of our inventory (raw Materials, packaging and FG in Sage. We are only…
Client issue: Current inventory item has zero quantity and negative value. Need to end up with positive quantity and positive value. Also have items with quantity but negative value. I have tried inventory adjustments - but getting wonky numbers. Been…
Inventory sub ledger out of balance to GL. Sub ledger is higher than GL. Is there a way to post a one time entry to the Inv GL to bring into balance. Over 4000 items so no idea what is the issue.
Thanks
I realize this question may be very similar to others, I did look around though the forums... the answers to me didn't seem like they were what I was looking for, but I'm not an accountant in any stretch and started using Sage 3 weeks ago so please bear…
Last year there were adjustments made to add inventory using the date of 12/31/16 (NOT ME) adding parts that were just not here or really old parts. I need to get them off my bottom line because we do not have that much inventory. I know since I closed…
Hello everyone, I am new to Sage City, and looking forward to having all of this knowledge and wealth of experience at my finger tips. I use Sage 50 Premium Accounting.
I use my Inventory & Services module to set up Vendor services so that when I make…
jlb said: Negative inventory is a necessity,
If it's a necessity imposed on you by the owner(s) and you can't ever change it, run, don't walk, away. Life's too short.
jlb said: We have thousands of items which have been sold "by the case" instead…
I am looking to clean up our system as many services and inventory items have changed over the years, and am wondering if re-assigning item numbers will cause future problems in printing yearly reports.
ie: item number 100, is inactive inventory (ballet…
I have a tech support business and order goods based on customer need. I record all goods as inventory upon receipt and then add to the client invoice as billed.
I have realized that with filing PST (British Columbia), all of these items should have…
Here's a scenario I need help entering into Sage 50 Canadian:
We purchase a piece of inventory on a "lease" program (we make equal payments over 36 months) from a US supplier. Let's say the inventory piece is $36K USD, CDN equivalent would be $48,600…
I am looking to correct an issue with my inventory where a product was entered under the wrong item number when a purchase invoice was processed. I have two items that are quite similar but different brands. Brand A is currently at +10 and Brand B is…
Hi,
I've never seen a setting for this, the default inventory item report selection screen doesn't show all of the part number, I was wondering if there was a place to set the width so as to see more of the item number, or if this is baked into the…
We have items that almost always have other items sold with them. A flange with 6 studs and 6 nuts which are all individual items. Would like to create a new item "flangecomplete" that could be selected and all of these parts would be added.
Is this…
I have a successful craft business. Not sure how to value finished, unsold goods that I have been carrying for a couple of years. They are unsellable now because I have switched to online sales only and the products only sell well in person-to-person…
We are a small manufacturer. We've just finished creating all of our inventory items, including raw materials and finished goods. For finished goods, we used the "build" tab to create our BOMs, which identify the quantities of raw materials required for…
Hello everybody, need your help here.
First, I'm using Sage 50 Quantum 2013.
So here's the problem ;
I'm trying to flush 2 PO out of our system but they don't want to go. Here's the error I get :
"Sage 50 can not find the stock part of this transaction…
Hello all,
I have been having an issue for a while now with my inventory pricing. It works great for looking up inventory #, using it on an invoice, etc. but when I go to adjust said #, it says there is no price. It seems like all the newer item #…
Hi, I have 2 inventory items that have 0 quantity, but have a value. I can't seem to bring the value to 0.
see attached. I have tried to use the inventory adjustment module, but it won't work.
thanks
Hi Scrapgal,
You may want to create a new inventory item called project or kit. Then, you can use Build from Item Assembly to select other inventory items needed and assemble the new project or kit items you just created.
You can follow the steps…