[
https://issues.apache.org/jira/browse/OFBIZ-6763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15052322#comment-15052322
]
Michael Powacht commented on OFBIZ-6763:
----------------------------------------
Many thanks for your clarification Jacopo, I understand.
Which product type would you suggest to be assigned to regular physical
products for resale?
The following product types don't classify in my opinion:
Raw Material: Used as input materials for Mfg.
Finished Good: The finished output from Mfg.
Subassembly: Semifinished ouptput from Mfg.
Assigning resale products to product type Finished Goods could lead to wrong
requirements generated by MRP, i.e. internal requirements (and production runs)
instead of product requirements in the form of proposed purchase orders or will
that only happen if a BOM
is defined for a Finished Good Product?
Thanks,
Michael
> 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)
