[
https://issues.apache.org/jira/browse/OFBIZ-6763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15052531#comment-15052531 ]
Michael Powacht commented on OFBIZ-6763:
----------------------------------------
Thanks Jacopo! That's very useful information.
> 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: Jacques Le Roux
> Priority: Minor
> Fix For: Trunk, 14.12.01, 13.07.03
>
> 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
