[OFBIZ-6763] Wrong purchase invoice item type for product type IDs RAW_MATERIAL, GOOD

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Trunk
• Fix Version/s: Trunk, 14.12.01, 13.07.03
• Component/s: accounting
• Assignee: Jacques Le Roux
• Reporter: Michael Powacht
• Created: 10/Dec/15 12:03
• Updated: 11/Dec/15 09:44
• Resolved: 10/Dec/15 15:20

Description

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.