No Series

RS8 wrote:

Hi,

I want to generate No series in Invoice Form, by default based on certain condition on pressing F3, is it possible to chk in on Insert trigger.
eg : if type = cash then it should generate CS001.
if type = Ncash then it should generate NCS001. is it possible to check while creating new item, can any one guide me.

The number field is a part of the primary key in the case of Invoice and in case of Item it is the primary key. So the only way to control is to customize the insertion of primary key through a separate table/form with the required conditions.

RS8 wrote:

Hi,

I want to generate No series in Invoice Form, by default based on certain condition on pressing F3, is it possible to chk in on Insert trigger.
eg : if type = cash then it should generate CS001.
if type = Ncash then it should generate NCS001. is it possible to check while creating new item, can any one guide me.

Your question is bit confusing. You wanted to generate No Series in Invoice Form. But, again you say you wanted "when creating a new item" ??

If you don't want it a more complicated work (using coding), try using the existing functionality of assigning more than one No Series with relationship and uncheck "Default No." and enable "manual No." .

The user while creating an invoice can select the desired No series manually!