Hi All,
I would like to ask if there is a formula or method in the report designer that allows a random number to be generated each time a report is run. For example, when generating a customer statement, I would like the report to display a unique number each time it is executed.
Is this possible, could you please guide me on how to implement it?
Thank you in advance for your support.
Best answer by praveenpo
Hi
If you want to add a unique number to a report each time it’s generated, there are some practical workarounds:
For example, you can create a calculated field that combines parts of the current date/time to create a pseudo-unique number.
In Report Designer, add a calculated field like:
=Format('{0:yyyyMMddHHmmss}', Now())
In some newer versions of Acumatica, the expression language might support:
=NewGuid()
+3Hi
If you want to add a unique number to a report each time it’s generated, there are some practical workarounds:
For example, you can create a calculated field that combines parts of the current date/time to create a pseudo-unique number.
In Report Designer, add a calculated field like:
=Format('{0:yyyyMMddHHmmss}', Now())
In some newer versions of Acumatica, the expression language might support:
=NewGuid()
+11Hi
In Acumatica Report Designer. Try using the Now() or Today() function to create a series of numbers Year/Month/Day/Hour/Minute/Second that will not be duplicated when opening the report.
For example: =Year(Now()) * 10000000000 + Month(Now()) * 100000000 + Day(Now()) * 1000000 + Hour(Now()) * 10000 + Minute(Now()) * 100 + Second(Now())
Result
Best Regards,
NNT
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
