Decimal Values Accuracy Issue on Invoices

  • 1
  • Question
  • Updated 3 years ago
  • (Edited)
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.
Photo of Jerwin Ollica Plaquia

Posted 3 years ago

  • 1
Photo of Simon Hutchinson

Simon Hutchinson, Employee

  • 2,502 Points 2k badge 2x thumb
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
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.
Hello,

Any updates on this one?

Thanks.
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,278 Points 10k badge 2x thumb
Our technical team are taking over on this one Jerwin as the issue is not obvious to us. 
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,278 Points 10k badge 2x thumb
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.
Photo of Simon Hutchinson

Simon Hutchinson, Employee

  • 2,502 Points 2k badge 2x thumb
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
Bump!.

Hope I can get any response for this issue.

Thanks.
Photo of Rav

Rav, Community Manager

  • 91,492 Points 50k badge 2x thumb
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!