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.
