4Site
Support Request System
View Patch #50.507.013
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03231 -
Non-Stock PO History Cost report is missing some PO lines if reversion
02798 -
Non-stock Purchasing History Cost report doesn't show credit POs
Symptoms:
Req.3231 Patch 4.4.10 changed the proc to only look for line versions that matched the highest version of the PO header. But in doing that it misses lines at lower versions that are perfectly valid. Req.2798 PHC.sql selects only RG type PO's (non-stock). But if you don't include the non-stock credit PO's (CR) the amounts are not really correct.
Solution:
Req.3231 Revised code in the stored procedure so that all valid PO lines within the specified date range are listed on the report - not just the lines which match the highest version of the PO header. Req.2798 Revised select query to include credit POs (po.type “CR”) in dataset. Also added condition to calculate CR amount as a negative value. Also expanded the subject to the full width of the page and truncate the subject so that subject + poid + spaces won't exceed 254. And expanded the supplier name which was also cut off.
Browse Patches
Find a Patch
Return to Request System Menu
