Decimal Values Accuracy Issue on Invoices

Jerwin Ollica Plaquia

Hi Guys,

As my title says, I am having a problem with regards to decimal values, please see screenshots below.

1) Here is the data I am sending with the issue on the decimal values. As you can see they all have 4 decimal places, but when I try sending them on the Reckon API Portal, I am encountering an "Tax for line 1 is incorrect." and "Discounted tax amount for line item 1 is incorrect."



But when I tried using the data as per second screenshot below. I was able to create the Invoice fine. Please note that the "AmountExTax" field is a 4 decimal place value as well.



Hoping for your quick response.
Thanks for reading.
Good day.

Simon Hutchinson_8164484

Hi Jerwin,

There are two ways you can try and handle this.

The first way is to add AmountAccuracy: 4, to the LineItems array

alternately if you add TaxIsModified: true to the line items array you will also be able to get around this.

Thanks

Simon

Jerwin Ollica Plaquia

Hi Simon,

Sorry for the very late response.

Thanks for this, however I tried both and unfortunately the error still occurs, I am still unable to create an Invoice. Please note that I am creating the Invoice on the API Previewer.

Here is the data I am sending on the Previewer that has the error.

{ 
"CustomerId": "5fe78d7e-b2a9-4db2-9e45-51cb0a410a8e",
"AmountTaxStatus": 2,
"InvoiceAmount": 50.0000,
"InvoiceTax": 4.5500,
"TemplateId": "1b3962ca-d8f7-4da7-b44a-26f1aa83503c",
"InvoiceDate": "2/27/2017 12:00:00 AM",
"InvoiceDiscountAmount": 50.0000,
"InvoiceDiscountPercentage": 50.00,
"DueDate": "2/27/2017 12:00:00 AM",
"Reference": "AUD19769",
"LineItems": [{
"BillableId": null,
"DiscountAmountExTax": null,
"DiscountAmountTax": null,
"DiscountPercent": null,
"Amount": 100.0000,
"InvoiceDiscountedAmountExTax": 45.4546,
"InvoiceDiscountedTaxAmount": 4.5455,
"AccountId": "116b86a5-34b8-4a32-a3a0-a066754bc06b",
"LineNo": 1,
"Description": "FOM-0061 - The Original Cool Dry Polo 2 - Black",
"Quantity": 1,
"TaxGroupId": "ae9400f7-cbea-4985-81a5-c968b7c1e5b0",
"TaxAmount": 9.0909,
"AmountExTax": 90.9091,
"TaxIsModified": true
}]
}

And here is the data that is working fine with the following VALUES modified.

{ 
"CustomerId": "5fe78d7e-b2a9-4db2-9e45-51cb0a410a8e",
"AmountTaxStatus": 2,
"InvoiceAmount": 50.0000,
"InvoiceTax": 4.54,
"TemplateId": "1b3962ca-d8f7-4da7-b44a-26f1aa83503c",
"InvoiceDate": "2/27/2017 12:00:00 AM",
"InvoiceDiscountAmount": 50.0000,
"InvoiceDiscountPercentage": 50.00,
"DueDate": "2/27/2017 12:00:00 AM",
"Reference": "AUD19769",
"LineItems": [{
"BillableId": null,
"DiscountAmountExTax": null,
"DiscountAmountTax": null,
"DiscountPercent": null,
"Amount": 100.0000,
"InvoiceDiscountedAmountExTax": 45.46,
"InvoiceDiscountedTaxAmount": 4.54,
"AccountId": "116b86a5-34b8-4a32-a3a0-a066754bc06b",
"LineNo": 1,
"Description": "FOM-0061 - The Original Cool Dry Polo 2 - Black",
"Quantity": 1,
"TaxGroupId": "ae9400f7-cbea-4985-81a5-c968b7c1e5b0",
"TaxAmount": 9.09,
"AmountExTax": 90.9091,
"TaxIsModified": true
}]
}

Please note of the values on the following, these are the fields that I modified to successfully create an invoice on the Previewer.
a) InvoiceDiscountedAmountExTax
b) InvoiceDiscountedTaxAmount
c) TaxAmount
d) InvoiceTax

Hoping for you quick response.
Thanks.

Jerwin Ollica Plaquia

Hello,

Any updates on this one?

Thanks.

Jerwin Ollica Plaquia

Bump!.

Hope I can get any response for this issue.

Thanks.

Rav

Hi Jerwin,

Our API folks are a little tied up at the moment but will get back to you on this ASAP.

Apologies for the delay!

Jason Hollis

Our technical team are taking over on this one Jerwin as the issue is not obvious to us. 

Jason Hollis

Actually... when you add the invoice discounted amount and the invoice discounted tax it does not match the $50 the invoice price is set for.

Simon Hutchinson_8164484

Hi Jerwin

It's because the invoicediscountedamount plus the invoicediscountedtaxamount does not match up to the amount you have set for the invoice overall amount, whereas in the second one it does match

Cheers