ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Foxworthy (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-6330) The invoiceTaxTotal value is missing from createAcctgTransForPurchaseInvoice service
Date Sun, 30 Jul 2017 06:03:00 GMT

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

Paul Foxworthy commented on OFBIZ-6330:

Hi all,

I now have a script to demonstrate this on the demo site.

_Add a supplier for service product SV-1000._

Edit Product With Product ID: SV-1000 

click on Suppliers

In Add Product Supplier, enter Last Price of 100 and Supplier Product Id of SV-10000. Click

_Enter an order of the service product_

Order-Order Entry (https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry)

Select Supplier of Acct Big Supplier, click Continue on Purchase Order screenlet
Click Continue again
Choose Product SV-1000
Click Finalize Order
Click Continue multiple times, then Create Order
Click Approve Order

_Because this is a service, no shipment is necessary. Order status will be set to Completed,
and an purchase invoice will be created. If you do this with the initial demo data, the invoice
will have an ID of 10000.

Click on link from Order to Invoice
Click on "Status To Ready"

_In Transactions, the GL entries don't balance. The item and tax are there, but the accounts
payable amount should be $101, not $100._
_The GL entries have been added to the suspense journal because they don't balance._

> 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"
>     <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}"
>     <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

View raw message