4Site
Support Request System
View Patch #50.510.007
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03513 -
The Purchase Order Costs Report won't run on some client sites.
Symptoms:
This issue became apparent when setting up the Purchase Order Costs Report for Sherwood Copper (Request 01885) A Cost Center identifier is defined as a specific segment of a GL account number. The 4Site default is currently hardcoded in the pocost db procedure. Consequently, any client who has a different cost code scheme cannot run the PO Costs report.
Solution:
In the Stored procedure's SQL Select query, added two user definable parameters (starting position and the length of costcode string) to identify the segment of the GL account to be used as the costcode: ie, substring(account, start parameter, length parameter). In the fsRunJob Application, added the above two parameters so that clients can adjust the cost centre segment of the GL account. Also, in the existing 'Cost Center' parameter added a select query to use the client-entered values to load the correct account segment in the Cost Center lookup list. This will allow clients to run the PO Costs report once they define their unique costcode segment.
Browse Patches
Find a Patch
Return to Request System Menu