NO-00003 Customer and vendor payment formats
This task walks you through setting up and maintaining Norwegian payment IDs.
A payment identification (ID) is a unique identifier for customer payments that are settled electronically. It can be divided into different parts, such as the customer account number, invoice number, prefix, suffix, and external reference. When you receive a payment from a customer, the payment ID identifies the payment transaction for a sales invoice that is received from a bank.
This task was created using the demo data company DEMF with the country/region of legal entity primary address updated to be Norway.
Set up payment IDs
- Go to Accounts receivable > Payments setup > Payment ID.
- Click New.
- In the Payment ID type field, type a value.
- In the Name field, type a value.
- In the Payment ID length field, enter a number.
- In the Account from position field, enter a number.
- In the Account to position field, enter a number.
- In the Invoice from position field, enter a number.
- In the Invoice to position field, enter a number.
- In the Modulo field, select 'Modulo 10'.
- Select the modulo check method to calculate the check number. The last digit of a payment ID is reserved for the check number to verify that the payment ID is valid. The following options are available: - Modulo 10 – The total length of the payment ID is divided by 10. The remainder is the check number. - Modulo 11 – The total length of the payment ID is divided by 11. The remainder is the check number. - (None) – No check number is calculated.
- Click Save.
- After saving the record, you can preview the selected payment ID in the Payment ID test field.
- Go to Accounts receivable > Payments setup > Payment ID per country/region.
- Click New.
- In the Country/region field, enter or select a value.
- In the Payment ID type field, enter or select a value.
- Click Save.
Attach the payment ID
- Go to Accounts receivable > Customers > All customers.
- Use the Quick Filter to find records. For example, filter on the Account field with a value of 'DE-010'.
- In the list, click the link in the selected row.
- Expand the Payment defaults section.
- Click Edit.
- In the Payment ID type field, enter or select a value.
- Click Save.
- Go to Accounts receivable > Payments setup > Methods of payment.
- Use the Quick Filter to find records. For example, filter on the Method of payment field with a value of 'ELECTRONIC'.
- Click Edit.
- Expand the Payment control section.
- In the Payment ID type field, enter or select a value.
- Click Save.
- Go to Accounts receivable > Setup > Customer groups.
- Click Edit.
- In the Payment ID type field, enter or select a value.
- Click Save.
Update the payment ID
- Go to Accounts receivable > Periodic tasks > Update invoice payment ID.
- Select the Delete payment ID check box to delete the payment ID information from all documents
- This option should be used only when you want to remove or update Payment IDs for documents that got Payment IDs assigned. You will be offered a dialog to delete Payment ID from specific type of documents.
- Select Yes in the Update invoice payment ID field.
- Click OK.
- Click Yes.
- Click Yes.
- Click Yes.
- Click Yes.
View the payment ID
- Go to Accounts receivable > Inquiries and reports > Invoices > Invoice journal.
- Click Show filters.
- Apply the following filters: Enter a filter value of "" on the "Payment ID" field using the "is not" filter operator.