[ 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)