4Site
Support Request System
View Patch #50.039.030
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:
Req 3154 When I tried to run the Receipt Report (not the Receipt Transaction Report) 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. Req 3161 Report does not filter data on the supplied Organization parameter. This has implications in a multi-org environment.
Solution:
Req 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 Req 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
