Hello everyone!
I'm trying to make a sheet for an automatic sales follow up. I've integrate the systems with PQ, but the problem is :
We have the sales order.csv where is refreshed every day, and I need to do an analysis with the Purchase Requests and Inventory.
The logic basically is : If the stock of item X > sales line of item X then immediate service, else purchase analysis. If the quantity is bigger than the sales line, then put the date(lead time) of the purchase order. We also have more than one line of each item.
I'm trying to make a sheet for an automatic sales follow up. I've integrate the systems with PQ, but the problem is :
We have the sales order.csv where is refreshed every day, and I need to do an analysis with the Purchase Requests and Inventory.
The logic basically is : If the stock of item X > sales line of item X then immediate service, else purchase analysis. If the quantity is bigger than the sales line, then put the date(lead time) of the purchase order. We also have more than one line of each item.