Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-224927 - Contract Shipment Not Showing in DPR Sale Priced Near by|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-224927]
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-225012 - DPR not reflecting contract application of scale ticket|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-225012]
I noticed that I had to run the DPR for 2/8/2019 to include 2/7/2019 transactions. Any date that is selected should include transactions for the same date.
I'm rather certain this occurs when the date field includes a time. I used to handle this by adding one day to the parameter date. I'm not sure if simply removing the time portion of the date would solve the problem.
I would suggest doing a quick experiment and see if we can simply add a day to the parameter coming in. In other words, allow the user to select 2/7/2019 but convert it to 2/8/2019 within the SP. We have to make sure that 2/8/2019 transactions are not included for date fields that don't have a timestamp.
Example:
* Contract 995166 (Sale Cash) has an original amount of 25 bushels (Barley)
* Scale 127332 was applied on 2/7/2019 for 25 bushels
* Scale 127332 was undistributed on 2/7/2019
* Scale 127332 was redistributed for 25 bushels on 2/8/2019
If I run the DPR for 2/7 the contract still shows a balance (wrong)
If I run the DPR for 2/8 the contract still shows a balance (wrong)
If I run the DPR for 2/9 the contract does not show (correct) but I shouldn't have to add a day to get the DPR for 2/8 or 2/7.
|