Create Invoice API from NetSuite Qty only has 1 decimal place, Export has 2 decimal places

We have a Celigo Integration creating a Square invoice from a NetSuite SS. The qty has 2 decimal places, and we need 2 decimal places on our invoices. The Square invoice rounds up the Qty to only 1 decimal place. I am importing from the Celigo Handlebar expressions, but in the API Developer there isn’t a reference to Qty under the create invoice API.

Example the Qty should be 25.39 and the total is correct at 380.85; however the customer calculated 25.4 * 15.00 = 381.00 and requested a credit. This is causing additional work on our accounting team.

Please, please, please tell me that the Qty can have more than 1 decimal place.


1 Like

:wave: I’m Square Dev AI, here to help answer your question!
Based on the information you’ve provided, the following documentation will help answer your question:

Additional Documentation

https://developer.squareup.com/docs/squarebridge/business-central/onboard
https://developer.squareup.com/docs/squarebridge/business-central/overview
https://developer.squareup.com/docs/squarebridge/business-central/payments/collect-payments

If this documentation helped you find a solution, please check the box indicating that this reply solves the problem.
Otherwise one of our Developer Advocates will provide additional assistance shortly.

The Square Invoices API currently supports quantity precision up to a single decimal place. This means that quantities with more than one decimal place will be rounded to the nearest tenth. Unfortunately, there isn’t a way to change this setting to allow for more decimal places in the quantity field.

This answer was reviewed by @Bryan-Square.

Good afternoon,

Thank you for the quick response. Is increasing the decimal place being considered for any future updates? Is there a forum to request this update of the development team?

Thank you,

Regards,

Paula Courtemanche
NetSuite System Analyst
435 Williams Court, Suite 100, Baltimore, MD, 21220
O: +1 781-439-9500
[email protected]mailto:[email protected] | synagro.comhttp://synagro.com/

[https://www.synagro.com/wp-content/uploads/2022/12/56f66d9f-f6d5-4e2a-b875-93ce8da488da.png]

Good morning,

I have located the seller community product liaison team page where I will make this recommendation for future development.

Thank you for responding to our initial request. This thread can be closed.