Mailing-List: contact notifications-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ofbiz.apache.org
Date: Sun, 30 Jul 2017 06:03:00 +0000 (UTC)
From: "Paul Foxworthy (JIRA)" <jira@apache.org>
To: notifications@ofbiz.apache.org
Message-ID: <JIRA.12827234.1430818813000.45458.1501394580229@Atlassian.JIRA>
In-Reply-To: <JIRA.12827234.1430818813000@Atlassian.JIRA>
References: <JIRA.12827234.1430818813000@Atlassian.JIRA> <JIRA.12827234.1430818813386@jira-lw-us.apache.org>
Subject: [jira] [Commented] (OFBIZ-6330) The invoiceTaxTotal value is
 missing from createAcctgTransForPurchaseInvoice service
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sun, 30 Jul 2017 06:03:06 -0000


    [ 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._

Catalog
Edit Product With Product ID: SV-1000 
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProduct?productId=SV-1000

click on Suppliers

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

_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" 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)