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.
It's not just one column, its a formula, "select QTYSTU_0 - CUMALLQTY_0 - CUMWIPQTY_0 from 'yourfolder'.STOCK", will give you the result you are looking for. Just replace yourfolder with the name of your working folder.
This is what I get after running the above. Value should be 379 but is instead showing 5988.
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
When looking at the detailed stock entry, keep in mind when applying your group by statement, to include things like LOC (location), STOFCY (Site), LOT (Lot), SLO (Sub-lot) when trying to get the exact value. Similarly if you want to see the query X3 uses, when in the function active classig logging. This is done by opening the calculator, entering "Openlog('TRA',4)" and then hitting search. Once you results are returned, closed de-active the classic logging by opening the calculator and entering "Closelog()". You can now read the log generated in the TRA folder to see what the X3 query was. The first parameter in openlog is the local storage space the log will be created and the 4 indicates you want to log all Read and For execution statements.
Absolutely, always a huge help!
*Community Hub is the new name for Sage City