Set up customer posting profiles
Customer posting profiles control the posting of customer transactions to the general ledger. Customer posting profiles enable you to assign general ledger accounts and document settings to all customers, a group of customers, or a single customer.
Posting profiles are common throughout all modules. In Accounts receivable posting profiles, the summary accounts are defined for customers. Summary accounts are temporary accounts where all invoices are posted to and offset when the customer pays. Assign posting profiles to the following:
- Single customers (Account code value = Table)
- Groups of customers (Account code value = Group)
- All customers (Account code value = All)
When you post a customer transaction automatically, finance and operations searches for the ledger accounts in this sequence.
For example, if you are using posting profiles, the following scenarios might occur:
- When posting a profile line for the customer, the line specified for the customer is used.
- If no posting profile line exists for the customer, the line specified for the customer group that the customer is attached to is used.
- If neither the posting profile line for the customer or the customer group exists, the posting profile line for all customers is used.
In the Customer posting profiles page, you can set up many customer posting profiles. If all customer transactions are processed together, set up only one posting profile for all customers.
These settings will be used when you create sales orders, free text invoices, cash payments, collection letters, and interest notes. For some transactions, you can select a posting profile that differs from and takes precedence over the posting profiles that are set up for transactions in Customer posting profiles page.
The default posting profile is defined in the Ledger and Sales Tax FastTab on the Accounts receivable parameters page. The default posting profile is then included automatically on the header of new documents where you can change it to a different posting profile if needed.
You can also associate posting definitions with transaction posting types in the Transaction posting definitions page. Posting definitions control the posting of customer transactions to the general ledger instead of posting profiles.
If you want all customer transactions to have the same posting profile, set up only one posting profile with All in the Account code field. Specify the following field values to set up your posting profile:
- Posting profile - Enter a code for the posting profile. For example, you could create two posting profiles to obtain one account for customer balances in the national currency and another for customer balances in a foreign currency. You could call one account National and the other Foreign.
- Description - Enter a description of the posting profile. This is only used to better identify the posting profile when you view it in this page.
- Account code - Specify whether the posting profile applies to a
single customer, a group of customers, or all customers.
- Table - The posting profile applies to a single customer. Select the customer account in the Account/Group number field.
- Group - The posting profile applies to a customer group. Select the customer group in the Account/Group number field.
- All - The posting profile applies to all customers. Leave the Account/Group number field blank.
- Account/Group number - If Table is selected in the Account code field, select the account number of the customer who is associated with the posting profile. If Group is selected, select the customer group. If All is selected, leave this field blank.
- Summary account - Select the ledger account that will be used as the customer summary account for the customers who are associated with the posting profile.
- Settle account - Select the liquidity ledger account that is used for cash flow forecasts. This field will only appear if cash flow forecasts are enabled.
- Sales tax prepayments - Select the account for sales tax for
payments that are received in advance.
- Note: Use the Accounts receivable parameters page to specify the posting profile to use when a payment is selected as a prepayment.
- Liabilities for discount account - Select the ledger account for liabilities of discount.
- Collection letter sequence - Select the identifier of the collection letter sequence to use for customers to whom the posting profile is assigned.
- Interest code - Select the interest code to use for the calculation of interest for customers to whom the posting profile is assigned.
Table restrictions
For transactions that have the selected posting profile, specify whether transactions will be settled automatically, interest will be calculated, and collection letters will be issued. You can also select the account that is used when transactions that have the selected posting profile are closed.
Specify the following field values to set up your posting profile:
- Settlement - Select this toggle to enable automatic settlement of transactions that have this posting profile. If this toggle is cleared, you must manually settle transactions by using the Settle open transactions page or the Enter customer payments page.
- Interest - Select this toggle if interest should be calculated on outstanding balances for customer accounts that use this profile. If this toggle is cleared, interest will not be calculated for these customers.
- Collection letter - Select this toggle if collection letters should be generated for customer accounts that use this profile. If this toggle is cleared, collection letters will not be generated for these customers.
- Close - Select a posting profile to change to when transactions that have this posting profile are closed. A transaction is regarded as closed when it has been settled in full.
You can have different interest codes and collection letter sequences for each entry in the customer posting profile.
After the posting profile is created, you need to go to Accounts receivable parameters and default the posting profile under the Ledger and sales tax tab.