By using this website, you agree to our Terms of Use (click here)
I want to create a Inventory Turnover report which shows Purchase Qty and Shipped Qty of Items.
I started off by creating a GI
, but found trouble in Joining POLine (for purchase qty) and SOShipLine (for shipped qty). Even tried using SOLineSplit since it also has the shipped qty but couldn't get the GI working.
I created a report and subreport to display the Inventory Turnover, but that also isn't working right. (confused what date parameters to use... something isn't matching)
Is there any way to create this Inventory Turnover report which shows the following data
InventoryID | InventoryID_dec | Purchase Qty | Shipped Qty
I'm not positive but it sounds as though you are trying to reproduce a subset of the Historical Inventory Balance report. If this is correct, you can reverse engineer the report to see if you can use the same tables and joins.
The INItemSiteHistory table has totals by period by transaction types including sales, receipts, assemblies, disassemblies, etc. That might be a good work-around.