Users - duplicate inventoryitem receiving po

[Fred Forester-2]

Hi all,

I've recently imported our product inventory. the keyrange for my
imports is 10001-24985. now when I receive inventory for a PO I get
duplicate inventory error where the new key is 10001 then 10002 then 10003.

do I have to somehow change the starting point for these keys?


Thanx
Fred



 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Ray Barlow]

Take a look at the "SequenceValueItem", it controls the allocation of
unique Ids. You may need to restart after modifying it as it buffers in
blocks of 5 or 10.

Ray


Fred Forester wrote:

>Hi all,
>
>I've recently imported our product inventory. the keyrange for my
>imports is 10001-24985. now when I receive inventory for a PO I get
>duplicate inventory error where the new key is 10001 then 10002 then 10003.
>
>do I have to somehow change the starting point for these keys?
>
>
>Thanx
>Fred
>
>
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
>  
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Jacopo Cappellato]

Hi Fred,

yes you have to update the row in the SequenceValueItem entity that
stores the last id for the InventoryItem entity.

Jacopo

Fred Forester wrote:

> Hi all,
>
> I've recently imported our product inventory. the keyrange for my
> imports is 10001-24985. now when I receive inventory for a PO I get
> duplicate inventory error where the new key is 10001 then 10002 then 10003.
>
> do I have to somehow change the starting point for these keys?
>
>
> Thanx
> Fred
>
>
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Fred Forester-2]

thanx a bunch guys.

  but now that I see it I may have to change more than that one :)

Thanx again.
Fred

Jacopo Cappellato wrote:

> Hi Fred,
>
> yes you have to update the row in the SequenceValueItem entity that
> stores the last id for the InventoryItem entity.
>
> Jacopo
>
> Fred Forester wrote:
>
>>Hi all,
>>
>>I've recently imported our product inventory. the keyrange for my
>>imports is 10001-24985. now when I receive inventory for a PO I get
>>duplicate inventory error where the new key is 10001 then 10002 then 10003.
>>
>>do I have to somehow change the starting point for these keys?
>>
>>
>>Thanx
>>Fred
>>
>>
>>
>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users