Hi all!
I’m trying to create a report for my company that will show inventory unit sales by INVENTORYID.
So far, every combination I’ve tried is “tripling” the units sold in the final query.
I have the below Joins:
ARTran Full → InventoryItem
ARTran Left → ARInvoice
InventoryItem Left → POVendorInventory
InventoryItem Left→ InItemCost
Grouped by: ARTran.InventoryID.
Results Grid:
- VendorID
- VendorInventoryID
- InventoryCD
- InventoryItem.Descr
- (Calculated Field) → =sum(iif([ARTran.TranType] = ‘CRM’, -1 * [ARTran.Qty], [ARTran.Qty])
All fields are showing correct except for the unit sales which seem to be tripled in quantity. Hoping someone can point out where this may be coming from :)
Thank you!