4Site
Support Request System
View Patch #50.501.038
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03161 -
Receipt Report does not use organization parameter
03154 -
Receipt Report divide by zero error
03150 -
Receipts Report - division by zero
Symptoms:
Request 3154 When I tried to run the Receipt Report this morning I received an error and was not able to run or print it. I received a message about the Crystal Reports - error detected by database DLL. Please investigate and advise when this report is available to run again. Request 3161 Report does not filter data on the supplied Organization parameter. This has implications in a multi-org environment.
Solution:
Request 3154 The Receipt Report failed in this case because voucher lines with zero quantity were referenced in calculations causing a divide by 0. Revised SQL Select statement to handle volines with zero quantity. Request 3161 In SQL Insert into #WorkVO, #WorkRC, #WorkPO statements added filter to select on the supplied Organization parameter (chartid).
Browse Patches
Find a Patch
Return to Request System Menu
