Skip to main content
Solved

GI that pulls from Inventory Turnover

  • 21 February 2024
  • 1 reply
  • 73 views

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! 

View original
Did this topic help you find an answer to your question?

1 reply

  • Freshman II
  • 6 replies
  • Answer
  • December 6, 2024

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! 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings