Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Ensure DFF value for sequential number is unique — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Ensure DFF value for sequential number is unique



Content (required):

We have created a DFF on the expense report header for a sequential number for the report. There is one DFF that uses SQLto select the next number available and another DFF that utilizes that number to concatenate a prefix. So the report header displays the DFF as ex. XYZ9000001, XYZ9000002, etc. We've discovered that when multiple users create expense reports at the same time, the number can be duplicated. Assuming this is due to the report not being saved so the value is not commited to the database. Is there a way to ensure the DFF for

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!