Sage 100

Welcome to the Sage 100 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.

FIFO items, zero qty on hand with negative average cost

Posted By sued2 5 months ago

We have a client that has several items with a negative average cost. The valuation method is FIFO and the current qty on hand is zero. Should we run the IM_CommitCheckClear_utl, the IM_ClarCommitDataEntry_utl and the Balance Quantity and Cost utilities to correct? I would do this in a test company first but wasn't sure if this was the best way to fix these.

Thanks

Sue

0 sued2 5 months ago

Never mind. I went ahead and tried it in a test company and it didn't make any difference. It appears that the Warehouse average cost looks reasonable for each warehouse. It's just the average cost in CI_item that's negative.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sued2 5 months ago

I have a resolution. I printed the inventory valuation report for one of the items and clicked on to show zero tiers. It turns out that they have positive and negative tiers that offset each other...but at different costs. I advised the user to manually adjust the tiers out and NOT to use the Negative Tier Adjustment utility. Once she manually adjusted them out, the average cost in CI_Item was no longer negative!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

FIFO items, zero qty on hand with negative average cost

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING