Hi, 


I am going to create an auto-generated transaction number with the following format: NN-DDMMYYYY-AA-BB


NN: transaction ID (auto-increment, reset every month)

DDMMYYYY: transaction date

AA: type of transaction (for example: SA for sales, PU for purchase; the type of transactions are stored in Static Entity TransactionType)

BB: transaction status (for example: 01 for new transaction, 02 for updated transaction; also stored in Static Entity TransactionStatus)


Does anyone have a suggestion how to do this? Thanks


Hi,

Can you check this:

https://www.outsystems.com/forums/discussion/31668/custom-id-number/ 

and 

 https://www.outsystems.com/forums/discussion/56191/i-want-to-auto-generate-id-in-the-format-ida201912000001/ 


you can create an action in logic which return formatted transaction id to you when you pass your inputs (NN: transaction ID,DDMMYYYY: transaction date,AA: type of transaction, BB: transaction status)


Hi,


I'll give it a try. Thanks!

Hi,

One would like you to think about one thing, you wrote

NN: transaction ID (auto-increment, reset every month) 

If if it needs to Auto-increment on each transaction number you are limited to 99 transactions per month.

Regards,

Daniel