SECTIONSRun or Schedule Generate Sequences Job
Ensure the following:
- Generate Sequences must be set up.
- If Generate Sequences is not visible in the Scheduled Jobs list in Foundations Setup, you must enable the Scheduled Jobs feature in Feature Console.
- Run the Transaction - Company Name scheduled job in Foundations.
When set up, this adds a generated sequence number for the transaction, allowing you to order transactions by company.
|
Transaction |
Company |
Sequence Number |
|---|---|---|
|
TRN00000000 |
Company 1 |
SEQTRN00000000 |
|
TRN00000001 |
Company 1 |
SEQTRN00000001 |
|
TRN00000002 |
Company 1 |
SEQTRN00000002 |
|
TRN00000003 |
Company 1 |
SEQTRN00000003 |
|
TRN00000004 |
Company 2 |
SEQTRN00000000 |
|
TRN00000005 |
Company 2 |
SEQTRN00000001 |
|
TRN00000006 |
Company 2 |
SEQTRN00000002 |
|
TRN00000007 |
Company 2 |
SEQTRN00000003 |
|
TRN00000008 |
Company 3 |
SEQTRN00000000 |
|
TRN00000009 |
Company 3 |
SEQTRN00000001 |
|
TRN00000010 |
Company 3 |
SEQTRN00000002 |
|
TRN00000011 |
Company 3 |
SEQTRN00000003 |
Special Considerations for France
- When building the sequence format for the Generate Sequences job in Foundations the default prefix is SEQTRN. You can edit this default, but never change it in the middle of a fiscal year. You must use the same prefix for an entire fiscal year.
- When building the sequence format for the Generate Sequences job in Foundations you must ensure the Number Length field has a value of 1 or more.
- Before generating an audit file you must run a Generate Sequences job. The transaction order is then determined by the Sequential Transaction Number field on each transaction. If you do not do this your transactions will not be in sequential order.
- If not required, the following fields are the only ones that can be left empty:
- CompAuxLib
- CompAuxNum
- Idevise (only required when the document currency is different to the home currency)
- Montantdevise (only required when the document currency is different to the home currency)