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.
This is what I get after running the above. Value should be 379 but is instead showing 5988.
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.
