How To Set Up Prepayments in Microsoft Business Central

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.

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.

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 VAT identifier.

 
To add prepayment accounts to the general posting setup

• Choose the search icon, enter General Posting Setup, and then choose the related link.

• On the General Posting Setup page, for the relevant lines, fill in the following fields:
  1. Sales Prepayments Account

   

  1. 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

• Choose the search icon, enter Sales & Receivables Setup, and then choose the related link.

• On the Sales & Receivables Setup page, on the Number Series FastTab, fill in the following fields:
  • Posted Prepmt. Inv. Nos.

   

  • Posted Prepmt. Cr. Memo Nos.

   

• Choose the search icon. icon, enter Purchases & Payables Setup, and then choose the related link.

• On the Purchases & Payables Setup page, on the Number Series FastTab, fill in the following fields:
  • Posted Prepmt. Inv. Nos.

   

  • Posted Prepmt. Cr. Memo 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.

• Choose the search icon, enter Items, and then choose the related link.

• Select an item, and then choose the Prepayment Percentages action.

• 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.

• Choose the search icon, enter Customers, and then choose the related link.

• Open the card for a customer.

• Fill in the Prepayment % field.

• 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:

• A prepayment percentage for the item on the line and the customer that the order is for.

• A prepayment percentage for the item on the line and the customer price group that the customer belongs to.

• A prepayment percentage for the item on the line for all customers.

• 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.

• Choose the search icon, enter Sales & Receivables Setup, and then choose the related link.

• 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 prepayment amounts. If you turn on the Check Prepmt. when Posting toggle, Business Central will prevent people from posting orders with outstanding prepayment amounts.

• Choose the search icon, enter Job Queue Entries, and then choose the related link.

• 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.