This was such an obscure problem I thought it best to post it here!
We encountered an intermittent problem with the Stock Inquiry in WMS. For certain items, in multiple warehouses (some binned) a stock inquiry would only list the first bin qty on hand and also listed N/A as the bin number. For other items, the inquiry worked fine.
We were not on the current version, so we were advised to upgrade to 8.4.0D. This did not resolve the issue. This made Macola support suspicious of the Item Master and Item Location files and certain indexes.
Bottom line, to resolve the issue we had to:
1. Export, Initialize, Import the IMITMIDX and IMINVLOC files. (With all users logged out obviously!)
2. Run the WMS Update Utility, Start Update Process.
This resolved the problem and Stock Inquiry is now working as expected.
We encountered an intermittent problem with the Stock Inquiry in WMS. For certain items, in multiple warehouses (some binned) a stock inquiry would only list the first bin qty on hand and also listed N/A as the bin number. For other items, the inquiry worked fine.
We were not on the current version, so we were advised to upgrade to 8.4.0D. This did not resolve the issue. This made Macola support suspicious of the Item Master and Item Location files and certain indexes.
Bottom line, to resolve the issue we had to:
1. Export, Initialize, Import the IMITMIDX and IMINVLOC files. (With all users logged out obviously!)
2. Run the WMS Update Utility, Start Update Process.
This resolved the problem and Stock Inquiry is now working as expected.