| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-248871 - Invoice Create Date Missing for SI-15100|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-248871]
Zeeland has a dashboard (Load Based Ticket Variance with Invoice) that depends on the creation date of the invoices. However, we discovered that there are invoices with missing dtmDateCreated. SI-15100 came from a basis contract so I'm assuming that it's a problem within the Price Contract code that is creating the invoice.
All invoices should have a dtmDateCreated
select strInvoiceNumber,
dtmBatchDate, dtmCalculated,
dtmDate, dtmDateCreated,
dtmDateFullyPaid, dtmDueDate,
dtmExportedDate, dtmForgiveDate,
dtmPostDate, dtmShipDate
from tblARInvoice where strInvoiceNumber in ('SI-15100', 'SI-15127')
!pastedImage_d141638_0.png|height=45,width=810!
*Steps:*
1. Create basis contract.
2. Process contract to Shipment then post.
3. Partially or fully price the basis contract.
*Issue:*
Check the invoice record in SQL, *dtmDateCreated* is be null
*Acceptance:*
*tblARInvoice.dtmDateCreated* should not be null
|