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

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-6763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15052299#comment-15052299 ]

Jacopo Cappellato commented on OFBIZ-6763:
------------------------------------------

Thanks for your work [~mpowacht]. As regards the type named "GOOD", it is a special type that is not supposed to be used in orders; in fact it is an "abstract" type that is parent type for several other types including physical and non physical items like "raw materials", "subassembly", "digital goods" etc..
In my opinion a better fix would be that of preventing to assign this type to a product directly: the check could be done when the product data is created/updated and when the product is added to an order (to catch wrong product data imported into the system with external tools).

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