[jira] [Commented] (OFBIZ-6330) The invoiceTaxTotal value is missing from createAcctgTransForPurchaseInvoice service

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-6330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16106349#comment-16106349 ]

Paul Foxworthy commented on OFBIZ-6330:
---------------------------------------

Hi all,

If you apply the OFBIZ-6330_TaxAccountingOnPurchasesAndReturns_inline.patch and run the above test script, the GL entries now balance - in other words the accounts payable amount is tax-inclusive. However the sales tax entry does not have a GL Account Type or Account Code. I will look into that now.

Cheers

Paul

> The invoiceTaxTotal value is missing from createAcctgTransForPurchaseInvoice service
> ------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-6330
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6330
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting
>    Affects Versions: Trunk
>            Reporter: Kongrath Suankaewmanee
>            Assignee: Paul Foxworthy
>              Labels: tax, vat
>         Attachments: GeneralLedgerServices.patch, OFBIZ-6330_TaxAccountingOnPurchasesAndReturns-alternative.patch, OFBIZ-6330_TaxAccountingOnPurchasesAndReturns_inline.patch, OFBIZ-6330_TaxAccountingOnPurchasesAndReturns.patch, OFBIZ-6330_TaxAccountingOnPurchasesAndReturns.patch, pic01.PNG, pic02.png
>
>
> Hi All,
> Scenario: The sum of debit and credit in InvoiceAcctgTransEntriesPdf of purchase invoice are not equal.
> Question: I'm not sure why the createAcctgTransForPurchaseInvoice service did not call the method to get invoiceTaxTotal.
> {code}
> <call-class-method method-name="getInvoiceTaxTotal" class-name="org.ofbiz.accounting.invoice.InvoiceWorker" ret-field="invoiceTaxTotal">
>     <field field="invoice" type="GenericValue"/>
> </call-class-method>
> {code}
> And the invoiceTaxTotal value needs to add to totalAmountFromInvoice via code below:
> {code}
> <calculate field="totalAmountFromInvoice" type="BigDecimal" decimal-scale="${ledgerDecimals}" rounding-mode="${roundingMode}">
>     <calcop operator="add">
>         <calcop operator="get" field="totalAmountFromInvoice"/>
>         <calcop operator="get" field="invoiceTaxTotal"/>
>     </calcop>
> </calculate>
> {code}
> That it should work like the createAcctgTransForSalesInvoice service of the sales invoice.

--
This message was sent by Atlassian JIRA
(v6.4.14#64029)