Set Up Prepayments

If you require your customers to submit payment before you ship an order to them, or if your vendor requires you to submit payment before they ship an order to you, you can use the Prepayment functionality. The prepayments functionality enables you to invoice and collect deposits required from customers or to remit deposits to vendors, to ensure that all partial payments are posted against an invoice. For more information, see Create Prepayment Invoices.

Before you can post prepayment invoices, you have to set up the posting accounts in the general ledger, and you have to set up number series for prepayment documents. You must specify an account for prepayments related to sales and an account for prepayments related to purchasing. You can specify the same posting accounts to be used for all prepayments related to all general business posting groups or general product posting groups, or you can specify specific accounts for specific posting groups for sales and purchasing, respectively. This depends on your company's requirements for tracking prepayments.

You can define the percentage of the line amount that will be invoiced for prepayment, for a customer or vendor, for all items or selected items. After you complete the setup, you can generate prepayment invoices from sales and purchase orders. You can use the default percentages for each sales or purchase line, or you can change the amounts on the invoice as needed. For example, you can specify a total amount for the entire order.

Note

We recommend that you do not use a prepayment percentage of 100 in the following cases:

  • If you are located in North America. Due to how taxes are calculated, a prepayment percentage of 100 can lead to issues with prepayment invoices.
  • In all regions, if you manually deduct a payment discount from the invoice. A prepayment percentage of 100 will not automatically leave an amount from which to deduct the discount.

Also, when you're using prepayment percentage of 100, Business Central might need to create off-setting rounding entries. When that happens, you will need to choose a G/L account in the Invoice Rounding Account field on the Customer Posting Groups page. This is true even if you have not turned on the Invoice Rounding toggle on the Sales & Receivables Setup page. If you do not specify an account you you will not be able to post prepayment invoices.

Because the prepaid amount belongs to the buyer until they have received the goods or services, you need to set up general ledger accounts to hold the prepayment amounts until the final invoice is posted. Sales prepayments must be recorded in a liabilities account until the items are shipped. Purchase prepayments must be recorded in an assets account until the items are received. In addition, you must set up a separate general ledger account for each GST identifier.

Important

Depending on your country or region, additional setup may be required. For more information, see the list of related articles in the See Also section.

To add prepayment accounts to the general posting setup

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter General Posting Setup, and then choose the related link.

  2. On the General Posting Setup page, for the relevant lines, fill in the following fields:

    • Sales Prepayments Account
    • Purch. Prepayments Account

Tip

If you cannot see the fields in the General Posting Setup page, then use the horizontal scroll bar at the bottom of the page to scroll to the right.

If you have not already set up general ledger accounts for prepayments, you can open the G/L Account List page from the relevant account field.

To set up number series for prepayment documents

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Sales & Receivables Setup, and then choose the related link.

  2. On the Sales & Receivables Setup page, on the Number Series FastTab, fill in the following fields:

    • Posted Prepmt. Inv. Nos.
    • Posted Prepmt. CR/Adj Note Nos.
  3. Choose the Lightbulb that opens the Tell Me feature. icon, enter Purchases & Payables Setup, and then choose the related link.

  4. On the Purchases & Payables Setup page, on the Number Series FastTab, fill in the following fields:

    • Posted Prepmt. Inv. Nos.
    • Posted Prepmt. CR/Adj Note Nos.

Note

You can use the same number series for prepayment invoices and regular invoices, or you can use different number series. If you use different series, they must not overlap because there must not be any numbers that exist in both series.

To set up prepayment percentages for items, customers, and vendors

For an item, you can set up a default prepayment percentage for all customers, a specific customer, or a customer price group. If you do not want to apply the same prepayment percentage to all customers, you must specify which customers or which customer price groups the prepayment percentage applies to.

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Items, and then choose the related link.
  2. Select an item, and then choose the Prepayment Percentages action.
  3. On the Sales Prepayment Percentages page, fill in the fields as necessary. Hover over a field to read a short description.

For a customer or vendor, you can set up one default prepayment percentage for all items and all types of sales lines. You enter this on the customer or vendor card. The following procedure shows how to specify a prepayment percentage for a customer, but similar steps apply to vendors.

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Customers, and then choose the related link.
  2. Open the card for a customer.
  3. Fill in the Prepayment % field.
  4. Repeat the steps for other customers or for vendors.

Tip

You can also access the Sales Prepayment Percentages page from the customer or vendor card.

To determine which prepayment percentage has first priority

An order may have a prepayment percentage on the sales header, and a different percentage for the items on the lines. To determine which prepayment percentage applies to each sale line, the system looks for the prepayment percentage in the following order and will apply the first default that it finds:

  1. A prepayment percentage for the item on the line and the customer that the order is for.
  2. A prepayment percentage for the item on the line and the customer price group that the customer belongs to.
  3. A prepayment percentage for the item on the line for all customers.
  4. The prepayment percentage on the sales or purchase header.

In other words, the prepayment percentage on the customer card will only apply if there is no prepayment percentage set up for the item. However, if you change the contents of the Prepayment Percentage field on the sales or purchase header after you create the lines, the prepayment percentage on all of the lines will be updated. This makes it easy to create an order with a fixed prepayment percentage, regardless of the percentage set up on items.

To automatically release sales orders when prepayments are applied

You can save time by setting up a job queue entry that will automatically release sales orders that require prepayment after payments are applied. Automating the process saves you the step of releasing the sales order.

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Sales & Receivables Setup, and then choose the related link.
  2. In the Prepmt. Auto Update Frequency field, specify how often you want the job queue entry to run.

Tip

While you're here, consider adding a safeguard against shipping or invoicing sales orders that have unpaid premayment amounts. If you turn on the Check Prepmt. when Posting toggle, Business Central will prevent people from posting orders with outstanding prepayment amounts.

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Job Queue Entries, and then choose the related link.
  2. Set up the Upd. Pending Prepmt. Sales job queue entry, for example, by using the settings on the Recurrence FastTab to schedule how often you want it to run. For more informaiton, see Use Job Queues to Schedule Tasks.

See also

Invoicing Prepayments
Walkthrough: Setting Up and Invoicing Sales Prepayments
Calculate Goods and Services Tax on Prepayments in Australia
Calculate Goods and Services Tax on Prepayments in New Zealand
Understanding the General Ledger and the COA
Finance
Work with Business Central

Find free e-learning modules for Business Central here