Hello Andrei,

There is a configuration file available
(accounting/config/arithmetic.properties:29). Here you can configure
invoice.decimals and other related configurations.
HTH.

--

Best Regards,
Suraj Khurana
Senior Technical Consultant


On Thu, Mar 11, 2021 at 11:55 PM Andrei Stan <[email protected]>
wrote:

> Hello,
>
> When trying to import some of my PAID invoices in OFBiz, i expect to have
> Outstanding Amout "0" (paid), but i see that is "-0.04".
>
> It can be tested by import the following into OFBIZ:
>
> <entity-engine-xml>
> <Invoice invoiceId="TestInvoice" invoiceTypeId="SALES_INVOICE"
> partyIdFrom="Company" partyId="DemoCustCompany" statusId="INVOICE_PAID"
> invoiceDate="2020-11-06 15:26:25.000" dueDate="2020-11-13"
> currencyUomId="RON"/>
>   <InvoiceItem invoiceId="TestInvoice" invoiceItemSeqId="1" uomId="RON"
> quantity="74.45" amount="121.8675" description="Consultancy services"/>
>   <Payment amount="9073.04" statusId="PMNT_RECEIVED"
> partyIdFrom="DemoCustCompany" actualCurrencyAmount="44228.3489"
> currencyUomId="RON" paymentId="TestInvoice" actualCurrencyUomId="RON"
> partyIdTo="Company" paymentTypeId="CUSTOMER_PAYMENT"/>
>   <PaymentApplication paymentApplicationId="2021-Services"
> paymentId="TestInvoice" invoiceId="TestInvoice" amountApplied="9073.04"/>
> </entity-engine-xml>
>
> The problem here i think is this:
>
> - Invoice Total = quantity * amount (same as Unit Price from the
> InvoiceItem entity) = 74.45 * 121.8675
>
> - the above operation, in the "Invoices List" page is calculated (not as
> expected):
>
>     - 74.45 * 121.*867 *(only three decimals - can be seen in the
> "Invoice Overview" page) = to 9,072.99815, wich is rounded to 9,073.00
>
>     - the expected result is 74.45 * 121.*8675* (with four
> decimals)=9,073.035375 wich rounded = 9,073.04
>
> - Invoice Total - Payment Applied = 9,073.00 - 9,073.04 = -0.04 ( the
> issue that i got)
>
> How can i set OFBiz to use more that 3 decimals in calculations?
>
> Thanks.
>

Reply via email to