Unable to fix negative COGS due to adjustments in inventory module ?

Question

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 the correct quantities and values.

I believe this caused the COGS to become incorrect as it is now highly negative.

Any help on how i could proceed to have a correct COGS would be highly appreaciated.

Thank you,

Kevin

Richard S. Ridings · Answer

Assuming your original quantity of Item A100 is 10 and the cost is $5 each, then you would have used the Inventory Adjustment module and entered (Columns are Item code, Quantity, Unit Price and Amount) 
 A100 -10 -$5 -$50 
 and when you put the inventory back in stock you would use positive numbers 
 A100 9 $4.5 $40.50 
 I always make sure the inventory summary report shows zero quantity and value before I post the increase it quantity to actual. 
 Is this what you did? 
 If so, then the only thing I can think of is that there were post-dated transactions that you didn't account for when you did the adjustments. Is this possible? 
 Did you have any outstanding Goods Received Notes? I haven't traced how these affect the final inventory yet but they might affect the quantities and value if the purchase invoices are different than the receiving documents. 
 Are you using Locations and are you looking at the totals for one location or all locations?

Sage 50 Canada

Unable to fix negative COGS due to adjustments in inventory module ?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING