Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inventory Repots 1

Status
Not open for further replies.

FlamingoLady

Technical User
Sep 11, 2009
20
US
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?
 
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
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top