[Code Fix] tblGRStorageHistory.dblPaidAmount still using cost value.

Issue No: GRN-2440
Created 11/26/2020 6:57:34 PM
Type Bug-QC
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 19.1
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-234198 - Open Clearing Detail report gives inaccurate results|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-234198]     We are using tblGRStorageHistory.dblPaidAmount to get the original amount when Settle Storage has been posted to calculate the cost adjustment for the voucher. However, in MCP database it is still in the ' *Cost* ' value but it should be the ' *Total* ' (quantity x cost) value.     We need to have a data fix for the issue so we could create a correct data fix for the AP Clearing issue.     Also, as per discussion with [~leslie.arat] , Ithaca is already using the ' *Total* ' value but MCP still using ' *Cost* '.   _Note: This is a technical issue. Grain Dev should be able to understand and explain the issue if more information is needed._     _Steps:_   _Create scale ticket where distribution type is customer hold._   _Settle storage against spot or contract._   _Go to maintain storage._     _Issue:_   _Amount paid is in correct. Column is showing cost._     _Acceptance:_   _Should display the total amount paid._