Reference Number Calculation Setup

To calculate Invoice Reference Number:

1. Go to Setup > Customization > Localization Settings.

2. Open the record for your subsidiary.

3. Check Invoice Reference Number Enabled box to enable the Invoice reference number creation on Sales Orders, Invoices and Credit Memos.

4. In order to retain existing reference number on imported invoices, check Exclude imported invoices from reference number creation box.

5. (Optional) You can set Field ID on Exclude from reference number calculation if content in field (field scriptID) field to identify custom or standard NetSuite field which invoices should retain old reference number (in case invoices are entered from UI).

6. Reference number can be calculated using the following options:

   • Document Number

   • Transaction Number (additional number available)

   • Document Number + Customer ID

   • Transaction Number + Customer ID

   • Customer ID

7. Any suffix or prefix characters must be excluded from the reference number calculations. Enter the number of prefix and suffix characters which are excluded in the respective fields. For example, if the Invoice number is INV00003, enter 3 in the Length of Document Number Suffix.

   Open

   

The calculated Invoice Number is set under the eInvoice tab in the transactions and is exposed in the Swedish Invoice Layout when it is displayed.

If invoice has a flag in Invoice for Factoring field:

• Reference Number is calculated using the Document Number as the basis. This is a hard-coded condition which takes precedence over the Localization Settings.

• The Factoring Seller Identification is used, which is multiplied by 1,000,000,000

Example 1. Invoice Reference number

Formula: (Factoring Seller Identification * 1,000,000,000) + Document Number. At the end of the number, the check digit is appended (no arithmetical action).

Factoring Seller Identification = 49711

Document Number = 8701

Check digit – 9

Invoice Reference Number without last digit = 49711 * 1,000,000,000 + 8701 = 49711000008701

Final reference number = 497110000087019 (having appended 9)

Invoice Reference Number is calculated upon saving an Invoice, under eInvoice tab.