HDTN-237561 - Oil In Transit number incorrect

Issue No: AR-11252
Created 11/26/2019 6:45:13 AM
Type Integration
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 19.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-237561 - Oil In Transit number incorrect|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-237561]           This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.     [HDTN-237561 - Oil In Transit number incorrect|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-237561]   *Issue:*   The Creston Soybean Oil In Transit number is not correct. It is over stated.   *Investigation Result:*   Please use this query: [Shipment vs Invoice.sql|http://jira.irelyserver.com/secure/attachment/42696/Shipment+vs+Invoice.sql]   !pastedImage_d127659_0.png!   It shows the Shipment with its equivalent Invoice but those invoices are unposted.   !pastedImage_d127659_1.png!   The unposted invoices are causing the overstated in-transit qty.   !pastedImage_d127659_2.png!