By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
June 30, 2021 11:45 am
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,
2 Replies
July 7, 2021 10:17 pm
Can you take inventoryitem, left join artran, group by inventoryitem.inventoryID, and then do a count on artran entries?
August 23, 2021 11:58 am
Here is the GI If I do the left join and count on the artran I still only get Sales on Inventory items. what data field on the artran should I be selecting?