Hi Jacopo, in fact that's the case.
Shipment receipt creates 2 entries. Second adjusts the ACOUNTING_QUANTITY colums. Item variance creates 1 entry. ACOUNTING_QUANTITY colums are empty. I create a jira https://issues.apache.org/jira/browse/OFBIZ-9324. Ingo -----Ursprüngliche Nachricht----- Von: Jacopo Cappellato [mailto:[email protected]] Gesendet: Dienstag, 18. April 2017 14:49 An: [email protected] ML <[email protected]> Betreff: Re: Accounting_quantity_diff <-- Item variance Hi Ingo, could you please check and confer that, during step #2, the ACCOUNTING_QUANTITY is not changed for any InventoryItem? In fact, there is no guarantee that the system will change the ACCOUNTING_QUANTITY on the same InventoryItem for which the ATP and QOH are changed: however it should be changed in one item. If it doesn't happen then there we will have to enable it for item variances. Jacopo On Tue, Apr 18, 2017 at 2:00 PM, Ingo Wolfmayr <[email protected]> wrote: > Hi everybody, > > I have a question regarding ACCOUNTING_QUANTITY_DIFF and inventory > shrinkage. I created the following case: > > > 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. Shouldn't the physical inventory change > also have an effect on the ACCOUNTING_QUANTITY, or do I misinterpet something? > > Done on current trunk. > > Best regards, > Ingo >
