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

Accounting_quantity_diff <-- Item variance

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Trunk
    • Fix Version/s: 16.11.02
    • Component/s: accounting
    • Labels:
      None

      Description

      1. Shipment Receipt: 1 Piece for 15$ (Facility --> Receive Inventory)
      2. Item Variance: 1 Piece (via physical inventory on inventory item -1 ATP, -1 QOH) - item lost

      Step 1

      • increases the ACCOUNTING_QUANTITY --> ACCOUNTING_QUANTITY_DIFF = 1
      • creates an accounting transaction --> INVENTORY +1 (15$ Credit)
        Step 2
      • ACCOUNTING_QUANTITY no change
      • creates an accounting transaction --> INVENTORY -1 (15$ Debit)

      Therefore the ITEM VALUATION report still shows 15$ / 1 Accounting Quanity sum after step two.

      Inventory variance should affect the accounting quantity.

        Activity

        Hide
        jacopoc Jacopo Cappellato added a comment -

        Fixed in rev. 1792609
        Ingo Wolfmayr thanks for your detailed report, it was really useful. It would be great if you could perform further tests and confirm if it works for you.

        Show
        jacopoc Jacopo Cappellato added a comment - Fixed in rev. 1792609 Ingo Wolfmayr thanks for your detailed report, it was really useful. It would be great if you could perform further tests and confirm if it works for you.
        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        Hi Ingo, Jacopo,

        I guess once confirmed this should be backported, right?

        Show
        jacques.le.roux Jacques Le Roux added a comment - Hi Ingo, Jacopo, I guess once confirmed this should be backported, right?
        Hide
        jacopoc Jacopo Cappellato added a comment -

        Backported to 16.11 in rev. 1795165

        Show
        jacopoc Jacopo Cappellato added a comment - Backported to 16.11 in rev. 1795165
        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        Hi Jacopo, should we not close?

        Show
        jacques.le.roux Jacques Le Roux added a comment - Hi Jacopo, should we not close?

          People

          • Assignee:
            jacopoc Jacopo Cappellato
            Reporter:
            iwolf Ingo Wolfmayr
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development