| Description |
*Steps* :
# Take a look at the last invoice in i21 (TS). SI-218, image below
# Import the invoices.json file (copy attached)
## A copy can also be found on their server under D:\pcfiles\FOE\from_FOE_Test
# You can enable and run this task on their server
# Reviewed the log file (D:\i21Integration\i21ImportExportJSON\logs) - no errors
# Refreshed the invoice list. Only one invoice was imported (image below).
# Ran the following SQL query (all invoices in the json file are greater than 350:
## {noformat}select strInvoiceNumber, strInvoiceOriginId
from tblARInvoice
where strInvoiceOriginId like '35%'{noformat}
Which returned this:
## !pastedImage_d123423_0.png|height=79,width=238!
# List of invoices found in the json:
## 350-1
353-1
354-1
355-1
356-1
357-1
*Issue:* 355-1, 356-1 and 357-1 were not imported. If the FOE invoice number doesn't exist in the strInvoiceOriginId field then it should be imported. It appears that the code is rejected the entire file if one of the invoices already exist. It should not work that way, every invoice should be evaluated.
Also, need to make sure that the i21 user is able to delete the i21 invoice and re-import it.
!pastedImage_d123423_1.png|height=185,width=572!
!pastedImage_d123423_2.png|height=244,width=854!
!pastedImage_d123423_3.png|height=257,width=851!
|