4Site
Support Request System
View Patch #50.039.099
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03284 -
Inventory Detail Listing report may be missing stock items
Symptoms:
The Inventory Detail Listing report appeared to be missing some stock items. When I looked into the report I found that the sup table was linked using an inner join on the prime supplier field (now obsolete). Since there is no supplier information on the report, I removed the sup table. Also some of our items do not have an associated stocbin record, so I changed the relationship between stocwhse and stocbin to a LEFT OUTER JOIN.
Solution:
Some stock items do not have an associated stock bin record, so I changed the relationship between stocwhse and stocbin to a LEFT OUTER JOIN. Now all items are included. I found that the sup table was linked using an inner join on the prime supplier field (now obsolete). Since there is no supplier information on the report, I removed the sup table.
Browse Patches
Find a Patch
Return to Request System Menu
