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.
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.
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.
*Community Hub is the new name for Sage City