[
https://issues.apache.org/jira/browse/OFBIZ-6763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15050959#comment-15050959 ]
Michael Powacht commented on OFBIZ-6763:
----------------------------------------
Thanks for your prompt action Rupert.
Will check it out tomorrow.
Sent from my Samsung Galaxy smartphone.
-------- Original message --------
From: "Rupert Howell (JIRA)" <
[hidden email]>
Date: 12/10/2015 19:30 (GMT+07:00)
To: Michael Powacht <
[hidden email]>
Subject: [jira] [Commented] (OFBIZ-6763) Wrong purchase invoice item type for product type IDs RAW_MATERIAL, GOOD
[
https://issues.apache.org/jira/browse/OFBIZ-6763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15050910#comment-15050910 ]
Rupert Howell commented on OFBIZ-6763:
--------------------------------------
Hi Michael
It appears that there is some seed data missing.
The below data will add a new invoice item type and map raw materials to the correct account.
<InvoiceItemType description="Invoice Raw Material(Purchase)" hasTable="N" invoiceItemTypeId="PINV_RPROD_ITEM" parentTypeId="PINV_PROD_ITEM"/>
<InvoiceItemTypeMap invoiceTypeId="PURCHASE_INVOICE" invoiceItemMapKey="RAW_MATERIAL" invoiceItemTypeId="PINV_RPROD_ITEM"/>
<InvoiceItemType invoiceItemTypeId="PINV_RPROD_ITEM" defaultGlAccountId="214000"/>
GOOD is already mapped however so that should be picking up PINV_FPROD_ITEM
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
> Wrong purchase invoice item type for product type IDs RAW_MATERIAL, GOOD
> ------------------------------------------------------------------------
>
> Key: OFBIZ-6763
> URL:
https://issues.apache.org/jira/browse/OFBIZ-6763> Project: OFBiz
> Issue Type: Bug
> Components: accounting
> Affects Versions: Trunk
> Reporter: Michael Powacht
> Assignee: Pierre Smits
> Priority: Minor
> Fix For: Trunk
>
> Attachments: OFBIZ-6763-AccountingData.patch, screenshot-1.png
>
>
> Hi there,
> system incorrectly derives invoice item type INV_FPROD_ITEM (instead of PINV_FPROD_ITEM, for example) in purchase invoices for purchase orders with products of type RAW_MATERIAL and GOOD. As a result, the GL account derivation is incorrect as well where a revenue GL account gets debited instead of GL "Uninvoiced Shipment Receipts".
> The incorrect accounting entry posted is:
> DR Revenue (as a result of invoice item type INV_FPROD_ITEM)
> CR A/P
> The correct entry should be:
> DR Uninvoiced Shipment Receipts (derived from PINV_FPROD_ITEM)
> CR A/P
> It seems the above is caused by missing entries in table invoice_item_type_map where
> INVOICE_ITEM_MAP_KEY should contain RAW_MATERIAL and GOOD and/or PRODUCT_ORDER_ITEM.
> The above symptom does not affect the Goods Receipt Transactions, which gets correctly posted as:
> DR Inventory
> CR Uninvoiced Shipment Receipts
> Any help is appreciated.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
Locked
