Inventory Valuation Report

[prasanga01]

I am trying to write a report in MAS90 V4.3 where I can see the Inventory valuation for a given date and time (if possible). I am not sure which tables I need to associate to get this done any help?

 

[MASGuy]

That is NOT going to be an easy report as you would need to use the IM5 file which normally has a LOT of records. Going to be a slow report but can be done. Now there is a file, the IMM, that shows the beginning balance and average cost for each month and year so you could in theory do it for the beginning of any month but because it uses the average cost you will be close but not exact.

Visit Sage's Online Community

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

 

[prasanga01]

Thank you. I do see a report called I/M Trail Balance Report. in this report I can get the valuation for a past date. the only thing is that it give information for Inv on hand = 0. does anyone know the name of this report so I can open it and modify.

 

[dfeller]

Inventory trial balance report --> you can select not to include zero qty on hand items.

Dawn

Visit Sage's Online Community

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

 

[prasanga01]

I dont see anywhere where I can select not to include 0 qty hand in the trial balance report. now i do see this in the valuation report.