1 Reply Latest reply on Apr 4, 2018 3:52 PM by Richard Duffy

    Inventory Movement Query

      Hi, I need a query to show inventory movement by item both in and out. This should include all documents that affect inventory which I believe would be AR invoices, goods issues, receipts from production (all outs) and then goods returns, issues for production, and AP invoices (all ins). I'd like it to show the item no, item description, beginning balance, "In" column, "Out" column, and ending balance for a specific time period. A view of a 30, 60, 90 day time period would be best if possible. Please help when you can, thank you!@