You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Rene Scheibe <re...@tngtech.com> on 2010/08/31 17:43:32 UTC
Handling negative inventory quantities
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
How is it possible in OFBiz to handle negative inventory quantities?
It should be possible to sell goods even if the quantity in the
inventory is not sufficient and gets negative after an order.
If I try to sell a product (ProductB) without any inventory entry,
OFBiz does some strange things in the database.
It inserts 3 entries: decreasing the ATP, increasing the ATP and
decreasing the ATP again.
For a product (ProductA) with positive ATP everything is fine.
- -- initial data fill
- -- ProductA
inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId:
0001, quantityOnHandDiff: 300,0, availableToPromiseDiff: 200.0]
inventory_item[ inventoryItemId: 9000, productId:
ProductA, quantityOnHandTotal: 300.0,
availableToPromiseTotal: 200.0]
- -- order (5x ProductA, 2x ProductB)
- -- ProductA
inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId:
10002, quantityOnHandDiff: 0.0, availableToPromiseDiff: -5.0]
inventory_item[ inventoryItemId: 9000, productId:
ProductA, quantityOnHandTotal: 300.0,
availableToPromiseTotal: 195.0]
- -- ProductB
inventory_item_detail[inventoryItemId: 10000,
inventoryItemDetailSeqId: 10001, quantityOnHandDiff: 0.0,
availableToPromiseDiff: -2.0]
inventory_item_detail[inventoryItemId: 10000,
inventoryItemDetailSeqId: 10003, quantityOnHandDiff: 0.0,
availableToPromiseDiff: 2.0]
inventory_item_detail[inventoryItemId: 10001,
inventoryItemDetailSeqId: 10004, quantityOnHandDiff: 0.0,
availableToPromiseDiff: -2.0]
inventory_item[ inventoryItemId: 10000, productId:
ProductB, quantityOnHandTotal: 0.0,
availableToPromiseTotal: 0.0]
inventory_item[ inventoryItemId: 10001, productId:
ProductB, quantityOnHandTotal: 0.0,
availableToPromiseTotal: -2.0]
I have seen balancing services in InventoryServices.xml (eg.
"balanceInventoryItems") but I don't how the details.
Any suggestions?
Regards,
Rene
- --
René Scheibe * rene.scheibe@tngtech.com * +49-176-62192936
TNG Technology Consulting GmbH, Betastr. 13a, 85774 Unterföhring
Geschäftsführer: Henrik Klagges, Gerhard Müller, Christoph Stock
Sitz: Unterföhring * Amtsgericht München * HRB 135082
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkx9IyQACgkQUXs9EHvIuCoqxgCeOa5op2dr5Opa7nm1szmqmryG
G3cAn1fgTI3UHT3PgrZqi48C8ZIy0Egs
=/aRL
-----END PGP SIGNATURE-----
Re: Handling negative inventory quantities
Posted by Jacques Le Roux <ja...@les7arts.com>.
Well tried :o) Unfortunately, but reasonably enough, the Apache MLs don't support HTML at all
Jacques
From: "Rene Scheibe" <re...@tngtech.com>
> Maybe it's better to read the example as HTML-formatted email.
>
> -- initial data fill
> -- ProductA
> inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId:
> 0001, quantityOnHandDiff: 300,0, availableToPromiseDiff: 200.0]
> inventory_item[ inventoryItemId: 9000, productId:
> ProductA, quantityOnHandTotal: 300.0,
> availableToPromiseTotal: 200.0]
>
> -- order (5x ProductA, 2x ProductB)
> -- ProductA
> inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId:
> 10002, quantityOnHandDiff: 0.0, availableToPromiseDiff: -5.0]
> inventory_item[ inventoryItemId: 9000, productId:
> ProductA, quantityOnHandTotal: 300.0,
> availableToPromiseTotal: 195.0]
>
> -- ProductB
> inventory_item_detail[inventoryItemId: 10000, inventoryItemDetailSeqId:
> 10001, quantityOnHandDiff: 0.0, availableToPromiseDiff: -2.0]
> inventory_item_detail[inventoryItemId: 10000, inventoryItemDetailSeqId:
> 10003, quantityOnHandDiff: 0.0, availableToPromiseDiff: 2.0]
> inventory_item_detail[inventoryItemId: 10001, inventoryItemDetailSeqId:
> 10004, quantityOnHandDiff: 0.0, availableToPromiseDiff: -2.0]
> inventory_item[ inventoryItemId: 10000, productId:
> ProductB, quantityOnHandTotal: 0.0,
> availableToPromiseTotal: 0.0]
> inventory_item[ inventoryItemId: 10001, productId:
> ProductB, quantityOnHandTotal: 0.0, availableToPromiseTotal:
> -2.0]
>
> On 08/31/2010 05:43 PM, Rene Scheibe wrote:
>> -- order (5x ProductA, 2x ProductB)
>>
>> -- ProductA
>>
>> inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId:
>> 10002, quantityOnHandDiff: 0.0, availableToPromiseDiff: -5.0]
>>
>> inventory_item[ inventoryItemId: 9000, productId:
>> ProductA, quantityOnHandTotal: 300.0,
>> availableToPromiseTotal: 195.0]
>>
>>
>> -- ProductB
>>
>> inventory_item_detail[inventoryItemId: 10000,
>> inventoryItemDetailSeqId: 10001, quantityOnHandDiff: 0.0,
>> availableToPromiseDiff: -2.0]
>>
>> inventory_item_detail[inventoryItemId: 10000,
>> inventoryItemDetailSeqId: 10003, quantityOnHandDiff: 0.0,
>> availableToPromiseDiff: 2.0]
>>
>> inventory_item_detail[inventoryItemId: 10001,
>> inventoryItemDetailSeqId: 10004, quantityOnHandDiff: 0.0,
>> availableToPromiseDiff: -2.0]
>>
>> inventory_item[ inventoryItemId: 10000, productId:
>> ProductB, quantityOnHandTotal: 0.0,
>> availableToPromiseTotal: 0.0]
>>
>> inventory_item[ inventoryItemId: 10001, productId:
>> ProductB, quantityOnHandTotal: 0.0,
>> availableToPromiseTotal: -2.0]
>>
>
> --
> René Scheibe * rene.scheibe@tngtech.com
> TNG Technology Consulting GmbH, Betastr. 13a, 85774 Unterföhring
> Geschäftsführer: Henrik Klagges, Gerhard Müller, Christoph Stock
> Sitz: Unterföhring * Amtsgericht München * HRB 135082
>
Re: Handling negative inventory quantities
Posted by Rene Scheibe <re...@tngtech.com>.
Maybe it's better to read the example as HTML-formatted email.
-- initial data fill
-- ProductA
inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId:
0001, quantityOnHandDiff: 300,0, availableToPromiseDiff: 200.0]
inventory_item[ inventoryItemId: 9000, productId:
ProductA, quantityOnHandTotal: 300.0,
availableToPromiseTotal: 200.0]
-- order (5x ProductA, 2x ProductB)
-- ProductA
inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId:
10002, quantityOnHandDiff: 0.0, availableToPromiseDiff: -5.0]
inventory_item[ inventoryItemId: 9000, productId:
ProductA, quantityOnHandTotal: 300.0,
availableToPromiseTotal: 195.0]
-- ProductB
inventory_item_detail[inventoryItemId: 10000, inventoryItemDetailSeqId:
10001, quantityOnHandDiff: 0.0, availableToPromiseDiff: -2.0]
inventory_item_detail[inventoryItemId: 10000, inventoryItemDetailSeqId:
10003, quantityOnHandDiff: 0.0, availableToPromiseDiff: 2.0]
inventory_item_detail[inventoryItemId: 10001, inventoryItemDetailSeqId:
10004, quantityOnHandDiff: 0.0, availableToPromiseDiff: -2.0]
inventory_item[ inventoryItemId: 10000, productId:
ProductB, quantityOnHandTotal: 0.0,
availableToPromiseTotal: 0.0]
inventory_item[ inventoryItemId: 10001, productId:
ProductB, quantityOnHandTotal: 0.0, availableToPromiseTotal:
-2.0]
On 08/31/2010 05:43 PM, Rene Scheibe wrote:
> -- order (5x ProductA, 2x ProductB)
>
> -- ProductA
>
> inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId:
> 10002, quantityOnHandDiff: 0.0, availableToPromiseDiff: -5.0]
>
> inventory_item[ inventoryItemId: 9000, productId:
> ProductA, quantityOnHandTotal: 300.0,
> availableToPromiseTotal: 195.0]
>
>
> -- ProductB
>
> inventory_item_detail[inventoryItemId: 10000,
> inventoryItemDetailSeqId: 10001, quantityOnHandDiff: 0.0,
> availableToPromiseDiff: -2.0]
>
> inventory_item_detail[inventoryItemId: 10000,
> inventoryItemDetailSeqId: 10003, quantityOnHandDiff: 0.0,
> availableToPromiseDiff: 2.0]
>
> inventory_item_detail[inventoryItemId: 10001,
> inventoryItemDetailSeqId: 10004, quantityOnHandDiff: 0.0,
> availableToPromiseDiff: -2.0]
>
> inventory_item[ inventoryItemId: 10000, productId:
> ProductB, quantityOnHandTotal: 0.0,
> availableToPromiseTotal: 0.0]
>
> inventory_item[ inventoryItemId: 10001, productId:
> ProductB, quantityOnHandTotal: 0.0,
> availableToPromiseTotal: -2.0]
>
--
René Scheibe * rene.scheibe@tngtech.com
TNG Technology Consulting GmbH, Betastr. 13a, 85774 Unterföhring
Geschäftsführer: Henrik Klagges, Gerhard Müller, Christoph Stock
Sitz: Unterföhring * Amtsgericht München * HRB 135082