Reference Number Calculation
Calculation of the Invoice Reference Number (FIK in Denmark) on the Invoice, which matches open invoices to payments. The calculation uses the modulus 10 algorithm.
To calculate Invoice Reference Number:
-
Go to Setup > Customization > Localization Settings.
-
Click the Edit link of the record of the applicable subsidiary.
-
To enable the Invoice reference number creation on Sales Orders, Invoices, and Credit Memos, check the Invoice Reference Number Enabled box.
-
To retain existing reference number on imported invoices, check the Exclude imported invoices from reference number creation box.
-
(Optional) You can set Field ID in the 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).
-
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
-
-
Any suffix or prefix characters must be excluded from the reference number calculations. Enter the number of prefix and suffix characters excluded in the respective fields. For example, if the Invoice number is INV00003, enter 3 in the Length of Document Number Suffix.
The calculated Invoice Number appears on the eInvoice subtab and is exposed in the Danish Invoice Layout when displayed.
If an invoice has a flag in the 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.
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. It appears on the eInvoice subtab.