In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions NO Sales on Stock Inventory Items
Hello, I am trying to create a GI that will show Inventory with No Sales/Shipment against the items, what table would I use to do this? I have been working with INTran but wondering if there is a better or different way to get NO SALES Inventory in an GI. Thanks,
Can you take inventoryitem, left join artran, group by inventoryitem.inventoryID, and then do a count on artran entries?