Different No. Series for different users

Vijaykumar

Hi Everybody,
I don't know, whether this problem is addressed earlier, as I am new to this forum. But still if you all can help me out......
I have 4 to 5 users entering the same data at a time, for e.g. "General Journal" and even though I have created different batch names for them, they all get the same document no. when they insert a new record.
Is it possible that, all of them get different document no.s. What settings are to be changed so that they get different doc. nos.
thanks in advance
Vijay

Albertvh

HI Vijaykumar,

We have done a similar thing for some of our clients, but the change you will need to do is to modify some objects.
We added fields to the user setup table 91 and then added logic wherever
the document no comes from add code after to move the users document no series to the setup no series.

example lets say sales table 36
oninsert trigger you have the following code

SalesSetup.GET;
.
.
etc

After the SalesSetup.get add the following

IF UserSetup.GET(USERID) THEN BEGIN
UserSetup.TESTFIELD(UserSetup."Sales Order No."); SalesSetup."Order Nos." := UserSetup."Sales Order No."; UserSetup.TESTFIELD(UserSetup."Sales Invoice No.");
SalesSetup."Invoice Nos." := UserSetup."Sales Invoice No.";
UserSetup.TESTFIELD(UserSetup."Sales Credit No.");
SalesSetup."Credit Memo Nos." := UserSetup."Sales Credit No.";
UserSetup.TESTFIELD(UserSetup."Posted Invoice No.");
SalesSetup."Posted Invoice Nos." := UserSetup."Posted Invoice No.";
UserSetup.TESTFIELD(UserSetup."Posted Sales Cr. No");
SalesSetup."Posted Credit Memo Nos." := UserSetup."Posted Sales Cr. No";
UserSetup.TESTFIELD(UserSetup."Sales Quote");
SalesSetup."Quote Nos." := UserSetup."Sales Quote";
UserSetup.TESTFIELD(UserSetup."Posted Sales Ship");
SalesSetup."Posted Shipment Nos." := UserSetup."Posted Sales Ship";
UserSetup.TESTFIELD(UserSetup."Finance Charge");
SalesSetup."Fin. Chrg. Memo Nos." := UserSetup."Finance Charge";
UserSetup.TESTFIELD(UserSetup."Posted Finance Charge");
SalesSetup."Issued Fin. Chrg. M. Nos." := UserSetup."Posted Finance Charge";
END;

As I said earlier you will have to add code.
Hope this helps

Regards

Albert

Savatage

If you're just talking about Journals, you will see when you create the different batch names a choice to enter a default Balance Account, No. Series, etc.

Create a new No Series for each person and assign it to their batch.

ex/
Bob Jones - BJ000001 to BJ9999999
Sue Jones - SJ000001 to SJ9999999
Zak Jones - ZJ000001 to ZJ9999999

or whatever

it's not automatically set upon a users login & they have to remember to use "their" batch.

Vijaykumar

Thanks all..........