1. Using Financials for the Americas
  2. Localization Document Numbering Setup with Sequence End Value Example

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.
  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.
  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.
  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.
  8. After creating a new localization document numbering setup, create and complete transactions for the relevant transaction type.