Decimal Values Accuracy Issue on Invoices

Jerwin Ollica PlaquiaJerwin Ollica Plaquia Member Posts: 50
edited September 7 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 HutchinsonSimon Hutchinson Reckon Staff 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 PlaquiaJerwin 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 PlaquiaJerwin Ollica Plaquia Member Posts: 50
    edited September 7
    Hello,

    Any updates on this one?

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

    Hope I can get any response for this issue.

    Thanks.
  • RavRav Administrator Posts: 10,906 Administrator
    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 HollisJason Hollis Reckon Staff Posts: 615 ✭✭
    edited March 2017
    Our technical team are taking over on this one Jerwin as the issue is not obvious to us. 
  • Jason HollisJason Hollis Reckon Staff Posts: 615 ✭✭
    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 HutchinsonSimon Hutchinson Reckon Staff 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
Sign In or Register to comment.