Decimal Values Accuracy Issue on Invoices

Jerwin Ollica Plaquia
Jerwin Ollica Plaquia Member Posts: 50
edited September 2020 in Reckon One
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."

image

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.

image

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

Comments

  • Simon Hutchinson
    Simon Hutchinson Alumni Posts: 155
    edited February 2017
    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
    Jerwin Ollica Plaquia Member Posts: 50
    edited February 2017
    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
    Jerwin Ollica Plaquia Member Posts: 50
    edited September 2020
    Hello,

    Any updates on this one?

    Thanks.
  • Jerwin Ollica Plaquia
    Jerwin Ollica Plaquia Member Posts: 50
    edited March 2017
    Bump!.

    Hope I can get any response for this issue.

    Thanks.
  • Rav
    Rav Administrator Posts: 12,632 Community Manager Community Manager
    edited March 2017
    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
    Jason Hollis Reckon Staff Posts: 541 ✭✭
    edited March 2017
    Our technical team are taking over on this one Jerwin as the issue is not obvious to us. 
  • Jason Hollis
    Jason Hollis Reckon Staff Posts: 541 ✭✭
    edited March 2017
    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
    Simon Hutchinson Alumni Posts: 155
    edited March 2017
    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