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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finished Goods Inventory

Status
Not open for further replies.
Jul 18, 2002
46
US
Does anyone know how MAS 90 calculates Finished Goods Inventory on the Trial Balance. Ours seems to be about 2x what it should be.

Thanks,
Laura Wood
 
Pretty simple. It takes the beginning balance and adds or subtracts the monthly transactions and gives you an ending balance. The beginning balance is kept in another file. It is is double what it should be then just do a cycle count and adjust.

If you want to figure it out on your own then write a report based only on the IM5. Select the item and warehouse and transaction quantity. Put in a parameter to have all records up to the last day of the month you want it to balance to. then sum up the quantity and hide the details. It SHOULD match your TB.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top