[ 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)" <j...@apache.org> Date: 12/10/2015 19:30 (GMT+07:00) To: Michael Powacht <michael.powa...@zi-th.com> 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)