Hi,
The inventory value report in the System is not tying out to the GL Report. So I was trying to build my own sql Report , while trying to tie out to the on hand quantity, there is a variance on some of the products. I'm using invent sum table to get the total quantity , which includes reserve physical, picked, on order etc. For most items it does tie out not for specific items. Also , I see that there are some open purchase orders, back from 2013 . Receipt = "Purchase Order " and When I click on the General tab , it the value is "Yes", does it have any impact on the Calculating The weighted inventory value Report . Our costing method is FIFO.
This is How I'm trying to achieve the weighted inventory value report:
Itemid year Transaction PO Qty Amount unit cost
123 2013 Not sold xyz 5 50 10
123 2014 SOLD abc 4 40 10
123 2015 SOLD jkl 10 100 10
Formula:(totalAmountofthoseqtynotsold) /(Totalqtynotsold)
As you see there is a open transaction, from 2013, will it have an impact on the Weighted average report.
If any of you have a sql of this kind of report also , it will be very helpful for me.
Thank you all.
Thanks,
Abhi.
