Share via

Customer Posting Group Table

Defines links between customers and the general ledger with customer posting groups.

Important

You must set up the necessary accounts in the Chart of Accounts window before you set up posting groups.

In the Customer Posting Group table you specify the accounts to which the program will post transactions involving customers in each posting group. You can specify accounts for:

  • Receivables

  • Service charges

  • Payment discounts

  • Invoice rounding

  • Additional fees

  • Interest

You use this table to assign a code to each customer posting group. You can then enter the code in the Customer Posting Group field on each customer card. After this, when you post orders, invoices, credit memos, payments, and so on, the program will use the information represented by the code to post to the accounts you specified.

You can also assign general business posting groups to your customers. The business group code is then used in combination with a general product posting group code in the General Posting Setup table to specify the accounts to which certain transactions are posted.

List of Fields in the Table

The following table lists the fields in this table.

Field Location
Non-Taxable Field, Customer Posting Group Table New Zealand Local Functionality
Discted. Bills Acc. Field, Customer Posting Group Table Spain Local Functionality
Bills Account Field, Customer Posting Group Table Spain Local Functionality
Bills on Collection Acc. Field, Customer Posting Group Table Spain Local Functionality
Factoring for Collection Acc. Field, Customer Posting Group Table Spain Local Functionality
Factoring for Discount Acc. Field, Customer Posting Group Table Spain Local Functionality
Rejected Bills Acc. Field, Customer Posting Group Table Spain Local Functionality
Finance Income Acc. Field, Customer Posting Group Table Spain Local Functionality
Rejected Factoring Acc. Field, Customer Posting Group Table Spain Local Functionality
Free Invoice Account Field, Customer Posting Group Table Italy Local Functionality
PIT Difference Acc. Field, Customer Posting Group Table India Excise
Interest Account Field, Customer Posting Group Table Sales and Receivables
Payment Tolerance Credit Acc. Field, Customer Posting Group Table Sales and Receivables
Service Charge Acc. Field, Customer Posting Group Table Sales and Receivables
Invoice Rounding Account Field, Customer Posting Group Table Sales and Receivables
Credit Curr. Appln. Rndg. Acc. Field, Customer Posting Group Table Sales and Receivables
Credit Rounding Account Field, Customer Posting Group Table Sales and Receivables
Code Field, Customer Posting Group Table Sales and Receivables
Debit Rounding Account Field, Customer Posting Group Table Sales and Receivables
Payment Disc. Credit Acc. Field, Customer Posting Group Table Sales and Receivables
Payment Tolerance Debit Acc. Field, Customer Posting Group Table Sales and Receivables
Debit Curr. Appln. Rndg. Acc. Field, Customer Posting Group Table Sales and Receivables
Additional Fee Account Field, Customer Posting Group Table Sales and Receivables
Payment Disc. Debit Acc. Field, Customer Posting Group Table Sales and Receivables
Receivables Account Field, Customer Posting Group Table Sales and Receivables
Description Field, Customer Posting Group Table Russia Local Functionality
Prepayment Account Field, Customer Posting Group Table Russia Local Functionality
Description Field, Customer Posting Group Table Russia Local Functionality
Prepayment Account Field, Customer Posting Group Table Russia Local Functionality
Interest Account Field, Customer Posting Group Table Sales and Receivables
Payment Tolerance Credit Acc. Field, Customer Posting Group Table Sales and Receivables
Service Charge Acc. Field, Customer Posting Group Table Sales and Receivables
Invoice Rounding Account Field, Customer Posting Group Table Sales and Receivables
Credit Curr. Appln. Rndg. Acc. Field, Customer Posting Group Table Sales and Receivables
Credit Rounding Account Field, Customer Posting Group Table Sales and Receivables
Code Field, Customer Posting Group Table Sales and Receivables
Debit Rounding Account Field, Customer Posting Group Table Sales and Receivables
Payment Disc. Credit Acc. Field, Customer Posting Group Table Sales and Receivables
Payment Tolerance Debit Acc. Field, Customer Posting Group Table Sales and Receivables
Debit Curr. Appln. Rndg. Acc. Field, Customer Posting Group Table Sales and Receivables
Additional Fee Account Field, Customer Posting Group Table Sales and Receivables
Payment Disc. Debit Acc. Field, Customer Posting Group Table Sales and Receivables
Receivables Account Field, Customer Posting Group Table Sales and Receivables
Non-Taxable Field, Customer Posting Group Table New Zealand Local Functionality
Discted. Bills Acc. Field, Customer Posting Group Table Spain Local Functionality
Bills Account Field, Customer Posting Group Table Spain Local Functionality
Bills on Collection Acc. Field, Customer Posting Group Table Spain Local Functionality
Factoring for Collection Acc. Field, Customer Posting Group Table Spain Local Functionality
Factoring for Discount Acc. Field, Customer Posting Group Table Spain Local Functionality
Rejected Bills Acc. Field, Customer Posting Group Table Spain Local Functionality
Finance Income Acc. Field, Customer Posting Group Table Spain Local Functionality
Rejected Factoring Acc. Field, Customer Posting Group Table Spain Local Functionality
Free Invoice Account Field, Customer Posting Group Table Italy Local Functionality
Description Field, Customer Posting Group Table Russia Local Functionality
Prepayment Account Field, Customer Posting Group Table Russia Local Functionality

See Also

Reference

Customer Posting Groups

Other Resources

How to: Set Up Customer Posting Groups

  • Last updated on