Uploaded image for project: 'iDempiere'
  1. IDEMPIERE-3910

M_Cost=>Current Cost/Costing Qty not updated due to matched PO posting by accounting engine

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects versions: 5.1, 6.1, 6.2
    • Fix versions: iDempiere HEAD
    • Components: Accounting
    • Labels:
      None
    • Sprint:

      Description

      Costing method=Average PO

      M_Cost=>Current Cost and Costing quantity are not being updated in the following situations:

      SCENARIO 1 (MR Reversal followed by vendor invoice):

      1. PO Product Qty=10
      2. MR-1 Product Qty=10
      2.1 Matched PO document created
      2.2 Matched PO document posted by accounting engine and costing record updated =>OK
      3. MR Reverse/Correct Product Qty=1
      3.1 Matched PO document for reversal created
      3.2 Matched PO document for reversal posted by accounting engine and costing record updated=>OK
      4. Invoice (vendor) Product Qty=10
      4.1 Matched PO document created
      4.2. Matched PO document posted by accounting engine=> not OK (see step5)
      5. MR-2 Product Qty=10
      5.1 MR-2 matched with matched PO document created in step 4
      5.2. Matched PO in step 4.1 does not get posted anymore because it was already posted during invoice (vendor).
      5.3 M_Cost Current Cost/Costing quantity not updated because matched PO was posted at the time of invoice (4.2) not at he time of MR-2.

      SCENARIO 2 (MR followed by vendor invoice with qty < MR)
      1. PO Product Qty=3
      2. MR-1 Product Qty=2
      2.1 Matched PO document created
      2.2 Matched PO document posted by accounting engine and costing record updated=>ok
      3. Invoice (vendor) Product Qty=1
      3.1 Matched PO document created
      3.2 Matched PO document posted by accounting engine=>not OK (see step 4)
      4. MR-2 Product Qty=1
      4.1 MR-2 matched with matched PO document created in step 3.1
      4.2 Matched PO in step 3.1 does not get posted anymore because it was already posted during invoice (vendor).
      4.3 M_Cost Current Cost/Costing quantity not updated because matched PO was posted at the time of invoice (3.2), not at the time of MR-2.

      Scenario 1 and 2 are similar in that the problem is caused by invoice matched PO documents being posted followed by an MR with the same qty being matched to the already posted matched PO document.

        Attachments

          Activity

            People

            • Assignee:
              hengsin Heng Sin Low
              Reporter:
              mpowacht Michael Powacht
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: