Inventory - zero quantity and negative value.. how to fix

Question

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 a long time since I have encountered these issues, and the common sense way to fix isn't working (my opinion only). Their year end was Sept 30th so trying to do adjustment the year end inventory figures. Any assistance would be most appreciated.

Agate · Answer

RoadDancer: 
 Using the inventory adjustment feature is your best way to correct the inventory. However, I may suggest changing the system to not allow negative inventory. The other change I may suggest is changing from average costing to FIFO in Sage 50. What generally happens is clients do not put their inventory purchases in first before they invoice to the client. This creates negative inventory and incorrect values. 
 Hope this helps!

Sage 50 Canada

Inventory - zero quantity and negative value.. how to fix

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING