MAS 90 V4.10 IM SETUP...

[bntactnt]

Can anyone help to set up the IM module correctly so that beginning inventory balance of Raw Materials (RM), Finished Goods (FG), and WIP all flows correctly in all modules including the GL? Now, at the beginning and at month-end I have to make JEs to disburse as follows;

i.e. 7/1/08:

Beg.Bal RM-COGS DEBIT
Beg.Bal RM-Balance Sheet CREDIT

AND same JEs for FG and WIP

End. Bal RM-Balance Sheet DEBIT
End. Bal RM-COGS CREDIT (PURCHASE ACCOUNT)

Thanks!

 

[regal1976]

Do you have the account fields set up correctly in the product line maintenance?

 

[BigLouie]

The correct way to do this is to do work with your reseller.

Normally you would disconnect Inventory from the GL then do an inventory receipt or adjustment both of which allow you to bring in your correct cost on each item. Normally this is imported using VI. You then post. Next run an inventory valuation report to get a dollar figure. This should match your GL figure. Reconnect Inventory with GL. When you enter in your beginning balances in the GL you should be using the figure from inventory valuation as the Inventory GL amount.