Inventory Repots 1

[FlamingoLady]

The Inventory Trial Balance has incorrect pricing on it, but the Inventory Valuation Report and the Item in Inventory is correct. How can I only change the Inventory Trial Balance price, without effecting GL?

 

[MASGuy]

You cannot. The Inventory Trail Balance is meant to balance to the GL. In your case does it? The Inventory Valuation report is NOT meant to balance to the GL. It is a live report, meant to show valuation as of the moment you run the report. Also pricing, that is the price you sell it at has nothing to do with valuation. It is the unit cost. Also a couple of questions. Are your items Average, FIFO, Lot or Serial? And why do you think the Trial Balance is incorrect?

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[FlamingoLady]

Thank you for the info. I apologize, I did mean cost. The Trial Balance has the incorrect cost on two items. The item has the correct cost in the inventory module and in the Invetory Valuation Report. We use a mix of FIFO (this sometimes defaults to average because of overdistributions) other items we use serial.

So, if we do an inventory adjustment to fix a cost in the MAS90 will it change both reports (inventory valuation and trial balance) and the GL? After a cost adjustment is when the report no longer matches.

With exception of the two items the Inventory Trial Balance and the Inventory Valuation are the same.

 

[MASGuy]

If you use FIFO and serial there is no way an item can have an incorrect cost. Also you did not answer my question. Does the inventory trial balance tie to the GL?

If you adjust out an item and then bring it back in at a different cost this will be reflected in all reports.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc