Sage 100

Inventory Valuation Report by Period -- will this go back to say 12/31 and give me a valuation? It appears that it's only giving me a change in value?

And is there a better way for a customer when they are in the month of May to get a valuation with a cutoff of December?

Wayne, is this version 4.4 or newer? if so the report should be showing the ending valuation not just the change. As far as I know it is the only way to get that valuation for anything prior to the current valuation. Prior to 4.4 I just told people that it was a waste of time to even run the report. I still don't have 100% faith in the accuracy of the report in 4.4 and newer. I sometimes see weird things such as zero on hand with a dollar amount in the ""inventory value"" column. (sometimes even zero on hand and a negative amount in the value column). But for the most part I think it will give a very close valuation for a prior period. Because I don't yet fully trust that report, I recommend clients run the regular valuation at month end after all ROG and SO invoicing is completed and prior to anything posted to the next month; however, this is rarely possible. My next recommendation is to run the Inventory Valuation Report by period as soon as possible after the ROG and SO invoice is complete for a given month. My gut instinct is that the farther back you try to go the more likely it could be incorrect. I think you need to make sure all the settings in Common Entry for Years to Retain Item History is set long enough to cover the period you are trying to get a valuation for .

Client wants to know why the Valuation Report by Period current period does not agree to the inventory valuation report when the two reports are run simultaneously...... I think it should but it doesn't appear to. Should it?? In a perfect world? What might be some reasons for the difference? V4.5 Advanced.

WAG but doesn't the valuation report use the costing file (in addition to warehouse detail and CI_Item for std and avg items) but the valuation by period also uses the transaction detail in some fashion?

in a perfect world they should match, but the reports calculate the valuation entirely different. I know that settings such not as including inactive items could cause variances in the two reports. Therese is right, The standard valuation report looks at current on hand and the costing methods to calculate. A fairly straightforward calculation. I actually looked at the code briefly to see how the valuation by period report works here is what I can see at a glance: The valuation report by period uses the IM_PeriodPostingHistory table and goes back to the beginning balance at the start of the fiscal year (gathers quantity on hand, unit cost and extended cost). It then looks at the ""change"" in that period and each of the following periods up to the reporting period to arrive at the ending totals.

I still recommend to all my customers to set up the valuation report in Paperless and run it at the end of each month. One of them actually runs it every night.