Hey!
I was wondering if someone has figured out a way to make a GI that pulls from the Inventory Turnover project. I am trying to pull the “Qty of Items Sold” column by inventory ID and by financial period from the project.
Thanks for your help!
Hey!
I was wondering if someone has figured out a way to make a GI that pulls from the Inventory Turnover project. I am trying to pull the “Qty of Items Sold” column by inventory ID and by financial period from the project.
Thanks for your help!
Best answer by MarionHooley
Hi, I’ve managed to recreate this in a GI form. I’ve added in an additional column which shows qty on PO’s. This column is from the INSITESTATUS table, therefore you would be able to add other fields such as, Qty on SO, Qty Avail, Qty On Hand etc.
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.