Reference Number Calculation

Calculation of the Invoice Reference Number (OCR in Sweden) on the Invoice, which matches open invoices to payments. The calculation uses the modulus 10 algorithm.

To calculate Invoice Reference Number:

1. Go to Setup > Customization > Localization Settings.

2. Click Edit on the applicable subsidiary record.

3. To enable the Invoice Reference Number creation on Sales Orders, Invoices, and Credit Memos, check the Invoice Reference Number Enabled box.

4. 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 the Exclude from reference number calculation if content in field (field scriptID) field to identify a custom or standard NetSuite field which invoices should retain old reference number (in case invoices are entered from UI).

6. The 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 a 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 field.

The calculated Invoice Number is set on the eInvoice subtab in the transactions (Transactions > Sales > Create Invoices) and is exposed in the Swedish Invoice Layout when it is displayed.

If an invoice has a flag in the Invoice for Factoring field:

• The 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

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, on the eInvoice subtab.

Related Topics:

• Country-Specific Invoice Layout
• VAT Detailed Summary

General Notices