By using this website, you agree to our Terms of Use (click here)
I have currently been using the historical inventory valuation for reporting month inventory values. This report needs to tie to the the balance in my inventory account. To accomplish this, I am having to the use a start period that is the beginning of time to the current period. The report size gets larger and larger every month due to an additional months data being added.
Are there any reports that can be run that do not include each months transaction details? Ideally, I would only need 4 columns:
Inventory ID, Description, Quantity on Hand & Value for any given historical period.
Any input would be appreciated!
Have you looked at INItemCostHist and INItemCostHistByPeriod DACs?
You could try to use INTranSplit , take QtyIn - QtyOut and set the parameter for a certain through date for TranDate. Then you could try to take the QtyIn and QtyOut and times then by the UnitCost. The difference could be your total cost.