WebAPI - APInvoiceBatches, DUE DATE is invalid

Posted By jfabel 9 months ago

Hi,

With Sage 2022 PU3, we send an AP invoice in Sage using the endpoint APInvoiceBatchList.

According to the documentation the DUEDATE is optional(DueDate (string, optional),).

If we don't put a due date, it gives the error "Due date is invalide".

If we put an empty string it gives "Cannot convert the literal '' to the expected type 'Edm.DateTimeOffset'"

I want Sage to determine the Due Date based on the vendor informations. How can we achieve this?

Here's what I use as exemple:

{
"BatchNumber": 0,
"BatchDate": "2023-07-06T19:01:57.980Z",
"BatchType": "Entered",
"BatchStatus": "Open",
"InvoiceType": "Summary",
"ICTRelated": "No",
"ProcessCommandCode": "UnlockBatchResource",
"Invoices": [
{
"VendorNumber":"100006",
"DocumentNumber":"975779",
"DiscountPercentage":0,
"DiscountDate":"2023-04-28",
"DocumentType":"Invoice",
"DocumentDate":"2023-04-28",

"DueDate":"2023-04-30",
"DocumentTotalIncludingTax":2920.37,
"TaxAmount1":127,
"TaxAmount2":253.37,
"PostingDate":"2023-04-28",
"TaxAmountControl":"Distribute",
"InvoiceDetails":
[
{"DistributedAmount":636.26,"GLAccount":"1010-112015","Comment":"","DistributionDescription":"F)","TaxAmount1":0,"TaxAmount2":0,"TaxAmount3":0,"TaxAmount4":0,"TaxAmount5":0},{"DistributedAmount":403.74,"GLAccount":"1010-112015","Comment":"C","DistributionDescription":"Frais de transport ","TaxAmount1":0,"TaxAmount2":0,"TaxAmount3":0,"TaxAmount4":0,"TaxAmount5":0},{"DistributedAmount":1500,"GLAccount":"1010-112015","DistributionDescription":"Frais de livraison - OUT (ch)","Comment":"","TaxAmount1":0,"TaxAmount2":0,"TaxAmount3":0,"TaxAmount4":0,"TaxAmount5":0}
]
}
]
}

0 Vega 9 months ago

Don't you need to set the terms on the vendor?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jfabel 9 months ago in reply to Vega

Hi,

The terms are already set in the vendor. I also add the terms to the invoice with the same result. It still ask for a DUEDATE if I don't explicitly add it to the payload.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kkyle2 9 months ago

You need to include the due date on AP invoices via API. Sounds silly, I know but I went through this and even reached out to support. You don't need to set it in a manual entry in the UI, you don't need to set it in an import file but with the API you do. I was very frustrated by this as it was almost like there is a different business logic layer in the API. It doesn't seem to care that the AP terms code is set at the vendor level or even in the payload, you need to run the calculation in your code and set the due date in the JSON to Sage. And, it needs to be formatted correctly, I don't have that format on hand but if you use Swagger to capture an invoice you will see the format needed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kkyle2 9 months ago in reply to kkyle2

Think I found the format from some testing, "DueDate": "2023-05-24T00:00:00Z",
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jfabel 9 months ago in reply to kkyle2

Hi KKYLE2,

yeah, that's what I was affraid of... the model in the webapi documentation is not accurate. It is saying "DueDate (string, optional)".

For the format this is working fine:

"DueDate":"2023-04-30",

Thank you,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kkyle2 9 months ago in reply to jfabel

Agreed, the documentation is not accurate, there were other fields in the integration I worked on that had to be included where in the UI or an import they do not need to be. Weird.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

WebAPI - APInvoiceBatches, DUE DATE is invalid

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING