Localization Document Numbering Setup with Sequence End Value Example

In this example, you’ll get to know how to set up the localization document numbering with sequence end value.

The invoice number format varies per country. It can be composed of numbers only or a combination of letters and numbers. For some countries, the invoice number format must include a prefix along with the actual invoice sequence number whereas for other countries, it must even include a suffix. You can configure the Receivables transaction number format using the localization document numbering feature.

Example Applicable Only for Columbia

Here are the assumptions:

• Receivables transaction number format is ABCD-00001.
• Maximum value for the document sequence is 3.
• Transaction type created for Invoices is Invoice_CO.
• Regional Localization is enabled for Colombia.
• Enable Document Numbering for Colombia under Localization System Options has been enabled.

Setup Details

Follow these steps:

1. Create a standalone document sequence category to be assigned to the Receivables document sequence name that you will use in 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

2. Create the document sequence that you will use in 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

3. Download the Create Document Numbering spreadsheet for Colombia.
4. Using the Create Document Numbering spreadsheet, assign the Receivables document sequence to the relevant transaction type. Enter the prefix, sequence end value, and minimum digits based on the required format and maximum value for the document sequence. Enter the start date and click Upload to save the changes.

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

5. Create three Receivables transactions using the transaction type, Invoice_CO. Note the last transaction number.
6. Create another transaction using the transaction type, Invoice_CO, and try to complete it. The application blocks the transaction from being completed and shows an error message because the transaction type is associated with a document sequence where the sequence end value is used.
7. Create a new localization document numbering setup for the relevant transaction type with the assumption that the prefix for the sequence is EFGH.

   Transaction Type	Invoice_CO
   Sequence Name	Colombia Invoices
   Prefix	ABCD
   Sequence End Value	3
   Suffix	Blank
   Minimum Digits	5
   Separator	-
   Start Date	1/1/2021
   End Date	4/15/2021

8. After creating a new localization document numbering setup, create and complete transactions for the relevant transaction type.