Setup Example

In this example, you’ll get to know how to set up the localization document numbering to comply with the required format by adding a prefix and setting the minimum digits for the sequence number to the Receivables transaction number.

Assumptions

Here are the assumptions:

Receivables transaction number format is ABCD-00001
Transaction type created for Invoices is Invoice_CO
Regional Localization has been enabled for Colombia
Enable Document Numbering for Colombia under Localization System Options has been enabled

Setup Details

To create the required format for the Receivables transaction number, follow these steps:

Create a standalone document sequence category to be assigned to the Receivables document sequence name for the localization document numbering setup.

Application	Receivables
Category Code	COINV
Category Name	Colombia Invoices Doc Seq Category
Module	Receivables
Table	RA_CUSTOMER_TRX_ALL
Description	Invoice Document Sequence Category for Colombia

Create the document sequence for the Create Document Numbering spreadsheet and assign it to the standalone document sequence category you created.

Document Sequence

Document Sequence Name	Colombia Invoices
Application	Receivables
Module	Receivables
Type	Gapless
Determinant Type	Legal entity
Start Date	1/1/2020
End Date	blank

Document Sequence assignment

Document Sequence Category Name	Colombia Invoices Doc Seq Category
Method	Manual
Start Date	1/1/2020
End Date	blank
Legal Entity Value	Vision Colombia LE1

Download the Create Document Numbering spreadsheet for Colombia.

Using the Create Document Numbering spreadsheet, assign the Receivables document sequence to the relevant transaction type. Enter the prefix and minimum digits based on the required format. Enter the start date and click Upload to save the changes.

Transaction Type	Invoice_CO
Sequence Name	Colombia Invoices
Prefix	ABCD
Suffix	blank
Minimum Digits	5
Separator	-
Start Date	1/1/2020
End Date	Blank