You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Ingo Wolfmayr <in...@wolfix.at> on 2017/04/18 12:00:33 UTC
Accounting_quantity_diff <-- Item variance
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
Re: Accounting_quantity_diff <-- Item variance
Posted by 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
AW: Accounting_quantity_diff <-- Item variance
Posted by Ingo Wolfmayr <in...@wolfix.at>.
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
> >
>
Re: Accounting_quantity_diff <-- Item variance
Posted by Jacopo Cappellato <ja...@hotwaxsystems.com>.
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
> >
>
AW: Accounting_quantity_diff <-- Item variance
Posted by Ingo Wolfmayr <in...@wolfix.at>.
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
>
Re: Accounting_quantity_diff <-- Item variance
Posted by Jacopo Cappellato <ja...@hotwaxsystems.com>.
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
>