Sales And Receivables Setup

Principles

In the Sales & Receivables Setup table, you can specify how you want the program to work with customers, such as numbering rules, and so on.

MS regularly updates the documentation for this setting area. Documentation valid for BC22 is available at the following link:

Overview of Tasks to Configure Sales Processes - Business Central | Microsoft Learn

CZ localization documentation valid for BC22 is available at this link:

Core Localization Pack for Czech - Business Central | Microsoft Learn

In this documented area, the important field settings for each tab are described.

Table Sales & Receivables Setup can be found in the Manual Setup list or by using the magnifying glass search.

Dependencies and assumptions

Additional dial settings may be required to complete.

Description of the documented area

Sales and Receivables Setup – General Tab

Setting fields:

• Invoice Rounding

  • Specifies whether amounts are rounded for sales invoices. The rounding is applied as specified in the Rounding Precision (LCY) field in the General Ledger Setup window.

• Copy Customer Name to Entries

  • Specifies whether you want the name on customer cards to be copied to customer ledger entries during posting.

• External Document No. Required (Ext. Doc. No. Mandatory)

  • Specifies whether it is mandatory to enter the external document number in the External Document No. field on the sales header or on the general journal line. In most cases, the need for an external number is not set for sales.

• Appln. between Currencies

  • Specifies whether it is allowed to settle customer payments in different currencies.

    • None: All entries included in a settlement must be in the same currency.

    • EMU (EMU): You can apply entries in euros and one of the old national currencies (for EMU countries/regions) to each other.

    • All: You can apply entries in different currencies to each other. Items can be in any currency. When you apply entries in different currencies to each other, there may be small rounding differences. In order for the program to account for these rounding differences, you can use the Ok.Alignment Accuracy (Appln. Rounding Precision) in the Currency table and the Ok.Alignment Accuracy (Appln. Rounding Precision) in the General Ledger Setup table. It is recommended that you set up application of entries in the same currencies.

  • If the Prepayments module is turned on, then "None" must be set

• Logo Position on Documents

  • Determines the position of your company logo on business letters and documents. The logo itself is uploaded in the Company Information table.

• Default Posting Date

  • Specifies how to use the Posting Date field on sales documents. You can choose from the following options: Work Date – when creating a sales document, the system pre-fills the working date of the user creating the document; No Date – The posting date will be blank in new documents.

• Multiple Interest Rates

  • Specifies the use of multiple interest rates when generating finance charge memos

  • When the flag is enabled, the system does not use the interest rate specified on the finance charge terms code when generating finance charge memos, but from the multiple interest table. If the flag is disabled, the system will use the interest rate from the finance charge condition (applies only to SK/CZ).

• Allow VAT Difference

  • Specifies whether to allow manual adjustments to VAT amounts on sales documents. It is not recommended to allow this for sale.

• Archive Quotes and Orders

  • Specifies whether to automatically archive sales quotes or sales orders when a sales quote/order is deleted. For example, it will be deleted after it has been invoiced.

• Allow Alter Posting Groups

  • Allows you to use multiple posting groups for one customer. The default posting group of the customer is set on the Customer Card, this posting group can then be changed on the sales document if this substitute posting group is set in the Refunds code list. It is recommended to enable it.

• Automatic Advance Payment Posting tax. Automatic Adv. Invoice Posting

  • Specifies this option for posting automatic prepayment invoices when matching a payment with an advance invoice.

• Ignore Updated Addresses

  • Specifies whether address changes made to sales documents are copied to the Customer Card. By default, the changes are copied to the Customer Card.

• Copy Line Descr. to G/L Entry

  • Specifies that descriptions from document lines of the account type are transferred to the resulting ledger entries.

  • If it is turned off, the system accumulates multiple lines of the sales document into one general ledger entry when posting. The cumulation takes place in the buffer based on the match in the fields:

    • Type

    • G/L Account

    • General Bus. Posting Group (Gen. Bus. Posting Group)

    • Gen. Prod. Posting Group

    • VAT Bus. Posting Group)

    • VAT Prod. Posting Group

    • Tax Area Code

    • Tax Group Code

    • Tax Liable

    • Excise Tax (Use Tax)

    • Dimension Set ID

    • Job No.

    • Fixed Asset Line No. (Fixed Asset Line No.)

    • Accrual Code

    • Additional Grouping Identifier

• Document Default Line Type

  • Specifies the default value of the Type field on the first line in new sales documents. If necessary, you can change the value on the line. We recommend that you set the value of the G/L Account option

• Allow Alter Posting Groups

  • Allows you to use multiple posting groups for one customer. The default posting group of the customer is set on the Customer Card, this posting group can then be changed on the sales document if this substitute posting group is set in the Refunds code list. It is recommended to enable it.

Sales and Receivables Setup – Dimensions Tab

In the Dimensions tab, you can set the Customer Group Dimension Code and the Salesperson Dimension Code by selecting from the dimension overview.

Sales and Receivables Setup – No. Series Tab

On the Number Series tab, you can specify a default number series that will be used for customers, sales documents, reminders, finance charge memos, advance invoices, and advance tax documents by selecting from the No. Series table.

For invoices and credit memos, both fields must always be set. If you don't want to differentiate between number sequences for unposted and posted documents, set up the same number sequence in both related fields.

Sales and Receivables Setup – Posting Tab in the Background

Description of field settings:

• Post with Job Queue

  • Specifies whether the job queue job is used to post sales documents, including orders, invoices, refunds, and credit memos

• Post & Print with Job Queue

  • Specifies whether your business process uses a job queue to post and print sales documents

• Job Queue Category Code

  • Specifies the code for the project task category that you want to associate with background posting

• Notify On Success

  • Specifies whether a notification is sent when posting and printing are completed successfully.

Sales and Receivables Setup – Archiving Tab

On the Archiving tab, you can set how sales quotes and orders will be archived.

Sales and Receivables Setup – VAT Tab

• Default VAT Date

  • Specifies the default VAT date type for sales documents (options: Posting Date, Document Date, Blank) that will be prefilled when new sales documents are created. A Posting Date is recommended.

Customer Posting Groups

The Customer Posting Group defines the accounts associated with posting transactions per customer. Set up these accounts on the Customer Posting Groups.

Posting groups can be set in the overview and use the Show All Accounts button to set up all accounts for posting to the given posting group.

Alternatively, you can use the Edit button to display the Customer Posting Group Card and set up accounts in each field on the card. However, not all fields are available in it as in the report itself.

To set up important fields:

• Code

  • Enter a custom code for the customer's posting group. This code is then assigned to the Customer Card in the Invoicing tab.

• Description

  • Enter any description for the customer's posting group.

• View All Accounts on Lookup

  • Specifies that all possible accounts will be displayed when searching from the box. If the check box is cleared, only accounts related to that account category will be displayed.

• Receivables Account

  • Specifies the general ledger account that is used when posting customer receivables.

• Advance Account

  • Specifies the general ledger account for posting the payment for sales prepayments.

• Fee Account (Service Charge Acc.)

  • Specifies the general ledger account that is used when posting service charges for customers in this posting group.

• Payment Disc. Debit (Credit) Acc.)

  • Specifies the general ledger account that is used when posting the discount discount granted to customers in this posting group.

• Interest Account

  • Specifies the general ledger account that is used when posting interest on reminders and finance charge memos for customers in this posting group.

• Additional Fee Account

  • Specifies the general ledger account that is used when posting additional fees from reminders and finance charge memos for customers in this posting group.

• Invoice Rounding Account

  • Specifies the general ledger account that is used when posting amounts that result from invoice rounding when posting transactions for customers.

• Debit (Credit) Curr. Appln. Rndg. Acc.)

  • Specifies the general ledger account that is used when accounting for rounding differences. These differences can occur if you are applying items in different currencies to each other.

• Debit (Credit) Rounding Account

  • Specifies the general ledger account that is used when posting rounding differences on the remaining amount.

• Payment Tolerance Debit (Credit) Acc.)

  • Specifies the general ledger account that is used in payment variance and sales payment posting. This is true for this particular combination of a business group and a group of goods.

Posting Group – Refunds

If, for example, you need to have multiple variants set up for posting receivables for a domestic customer, it is necessary to set up multiple Codes for a domestic customer and then change the Customer Posting Group in individual accounting documents. In order to make this change, you must first set up the link using Subst. Customer Posting Group. This feature is available from the Customer Posting Groups – > Related – > Posting Group – > Substitutions overview. By selecting the corresponding codes, you can set the option to "replace" these posting groups on the documents. Next, in the Sales & Receivables Setup table, set the Allow Alter Posting Groups field to Yes.