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