Invoice sequence id in a multiple POS environment

[Deyan Tsvetanov]

Hello,  


I've reached the following problem:

We have multiple POS Ofbiz instances running. Each uses a local
database.
Each OFBiz instance has a seqnenced-id-prefix set for the default
delegator .
Each product store has a order id prefix set.

However it seems that no such mechanism is provided for the invoices.
Invoices could be prefixed on per organization basis
( party_acct_preference ).
This creates problems when syncing the data from the local POS databases
into the main one. Is there any solution for that ?
Or I should very quickly add a per store invoice ID prefix this
night ? :)

Thanks in advance,
Deyan

[Deyan Tsvetanov]

Probably creating a new party_group for each product store  ?


-----Original Message-----
From: Deyan Tsvetanov <[hidden email]>
To: [hidden email]
Subject: Invoice sequence id in a multiple POS environment
Date: Sun, 11 Oct 2009 12:30:03 +0300

Hello,  


I've reached the following problem:

We have multiple POS Ofbiz instances running. Each uses a local
database.
Each OFBiz instance has a seqnenced-id-prefix set for the default
delegator .
Each product store has a order id prefix set.

However it seems that no such mechanism is provided for the invoices.
Invoices could be prefixed on per organization basis
( party_acct_preference ).
This creates problems when syncing the data from the local POS databases
into the main one. Is there any solution for that ?
Or I should very quickly add a per store invoice ID prefix this
night ? :)

Thanks in advance,
Deyan

[Jacques Le Roux]

Hi Deyan,

How did you solve this issue finally ?

TIA

Jacques

From: "Deyan Tsvetanov" <[hidden email]>

> Probably creating a new party_group for each product store  ?
>
>
> -----Original Message-----
> From: Deyan Tsvetanov <[hidden email]>
> To: [hidden email]
> Subject: Invoice sequence id in a multiple POS environment
> Date: Sun, 11 Oct 2009 12:30:03 +0300
>
> Hello,  
>
>
> I've reached the following problem:
>
> We have multiple POS Ofbiz instances running. Each uses a local
> database.
> Each OFBiz instance has a seqnenced-id-prefix set for the default
> delegator .
> Each product store has a order id prefix set.
>
> However it seems that no such mechanism is provided for the invoices.
> Invoices could be prefixed on per organization basis
> ( party_acct_preference ).
> This creates problems when syncing the data from the local POS databases
> into the main one. Is there any solution for that ?
> Or I should very quickly add a per store invoice ID prefix this
> night ? :)
>
> Thanks in advance,
> Deyan
>