I am looking to get the sql column name for total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.
The Total Requirements figure is calculated from the ORDERS table to sum the requirements (minus any allocations) for all transaction types (Sales Orders, Work Orders, MRP suggestions, etc.). I'm sure that the figure is calculated using the RMNEXTQTY_0 - ALLQTY_0 to give the total requirements in the specified time bucket.
When filtering the lines you need to ensure that you exclude the replenishment type lines, e.g. Purchase Orders, Work Orders, MRP suggestions, etc..
That was it. Thank you!
Hi papisueno, happy to see that the community helped you figure out a solution!
If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey
Absolutely, always a huge help!
Absolutely, always a huge help!
*Community Hub is the new name for Sage City