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

Automatic invoice numbering

Accepted answer
84
Views
5
Comments

Summary:

Generatic TRX_NUMBER automatically for Receivables and for Project

Content (required):

Our need is to insert automatically a value in TRX_NUMBER, from manual transaction inserted directly.

We should insert into TRX_NUMBER value of DOC_SEQUENCE_VALUE with "year" suffix.

Example:

DOC_SEQUENCE_VALUE = 191

TRX_DATE = 10/2/2023

TRX_NUMBER should be valued, automatically: 191/2023

Is it possibile?

The user should not be able to modify TRX_NUMBER.

Thanks in advance

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications

23B (11.13.23.04.0)

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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