Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-6763

Wrong purchase invoice item type for product type IDs RAW_MATERIAL, GOOD

    Details

    • 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
    • Labels:
      None

      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.

        Attachments

        1. OFBIZ-6763-AccountingData.patch
          3 kB
          Pierre Smits
        2. screenshot-1.png
          63 kB
          Michael Powacht

          Activity

            People

            • Assignee:
              jacques.le.roux Jacques Le Roux
              Reporter:
              mpowacht Michael Powacht
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: