Accounting_quantity_diff <-- Item variance

[iwolf]

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

[Jacopo Cappellato-5]

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 <[hidden email]>
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
>

[iwolf]

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:[hidden email]]
Gesendet: Dienstag, 18. April 2017 14:49
An: [hidden email] ML <[hidden email]>
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 <[hidden email]>
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
>

[Jacopo Cappellato-5]

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 <[hidden email]>
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:[hidden email]]
> Gesendet: Dienstag, 18. April 2017 14:49
> An: [hidden email] ML <[hidden email]>
> 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 <[hidden email]>
> 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
> >
>

[iwolf]

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:[hidden email]]
Gesendet: Mittwoch, 26. April 2017 08:21
An: [hidden email] ML <[hidden email]>
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 <[hidden email]>
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:[hidden email]]
> Gesendet: Dienstag, 18. April 2017 14:49
> An: [hidden email] ML <[hidden email]>
> 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
> <[hidden email]>
> 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
> >
>

[Paul Foxworthy]

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 <[hidden email]> 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:[hidden email]]
> Gesendet: Mittwoch, 26. April 2017 08:21
> An: [hidden email] ML <[hidden email]>
> 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 <[hidden email]>
> 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:[hidden email]]
> > Gesendet: Dienstag, 18. April 2017 14:49
> > An: [hidden email] ML <[hidden email]>
> > 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
> > <[hidden email]>
> > 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: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]