Sage 100

Has anyone written a Crystal report in v4.5 that would show Inventory valuation on a 12 month period -- all on one page with the periods going across 1 to 12?

No but when you get yours written, let us know!

!2 month calendar or trailing?

Is qty and dollars or just dollars only

I have used the Inventory Sales History Report from MAS as a start point and modified it for a client. Since the report uses a work table for the data, I created a new Report Setting and my client runs the report from Reports/Inventory Sales History Report. One problem with the report is that the 12 months are set to a calendar year.

Sorry Wayne. Just re-read your post and the report I mentioned won't help at all since it just provides sales data and not valuation data