Re: Accounting_quantity_diff <-- Item variance

[Paul Foxworthy <pa...@cohsoft.com.au>]

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 <in...@wolfix.at> 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:jacopo.cappellato@hotwaxsystems.com]
> Gesendet: Mittwoch, 26. April 2017 08:21
> An: user@ofbiz.apache.org ML <us...@ofbiz.apache.org>
> 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 <in...@wolfix.at>
> 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:jacopo.cappellato@hotwaxsystems.com]
> > Gesendet: Dienstag, 18. April 2017 14:49
> > An: user@ofbiz.apache.org ML <us...@ofbiz.apache.org>
> > 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
> > <in...@wolfix.at>
> > 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: info@coherentsoftware.com.au