Hi Ingo, See our discussion from January at http://ofbiz.135035.n4.nabble.com/AccountingQuantity-COGS-method-and-inventory-valuation-td4700867.html .
I agree tracking of accounting quantity is flawed at present. Cheers Paul Foxworthy On 27 April 2017 at 04:13, Ingo Wolfmayr <[email protected]> wrote: > Hi Jacopo, > > thanks a lot for your effort. I have just added myself to the dev-mailing > list. > > Ingo > > -----Ursprüngliche Nachricht----- > Von: Jacopo Cappellato [mailto:[email protected]] > Gesendet: Mittwoch, 26. April 2017 08:21 > An: [email protected] ML <[email protected]> > Betreff: Re: Accounting_quantity_diff <-- Item variance > > Hi Ingo, > > in rev. 1792609 I have committed a fix for the issue you have reported. > However there are some use cases that may still not be covered well but in > order to enhance the system we need to discuss some design before; if you > are interested we could continue this conversation in the dev list. > > Jacopo > > On Tue, Apr 18, 2017 at 3:59 PM, Ingo Wolfmayr <[email protected]> > wrote: > > > 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 > > > > > > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: [email protected]
