[
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
> 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
> Priority: Minor
> Fix For: Trunk
>
> Attachments: 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)
