Blog
Blog

How to Set Up and Manage Prepayments in Microsoft Dynamics 365 Business Central

Posted on 22-Jan-2025 by Rajanroy Rajbhar

Prepayment

Prepayment is used when, you require your customer to submit payment before you ship an order to them, or your vendor requires that you make the payment before you receive the order from them.

Set up prepayments

Before doing any prepayment invoice, we must do setup for the prepayment account in general posting setup and setup no. series for prepayment document.

You can also define default prepayment % for an Item, customer or vendor. You can also prioritize the prepayment %, to determine which prepayment % has the priority.

To add prepayment accounts to the General Posting setup

Search results in Dynamics 365 Business Central showing General Posting Setup used for configuring prepayment accounts

Choose the icon , look for General Posting Setup and select the related link.

On the General Posting Setup select the Sales Prepayments Account and Purchase Prepayments Account.

General Posting Setup page in Business Central showing Sales Prepayments Account configuration

To add prepayment no. series for Prepayment documents

Choose the icon , look for Sales & Receivable setup and select the related link.

Tell Me search in Dynamics 365 Business Central showing Sales and Receivables Setup for prepayment number series

On the Sales & Receivable page, On the no series fasTab select the Posted Prepmt. Inv. Nos. and Posted Prepmt. Cr. Memo Nos.

Sales and Receivables Setup page showing Posted Prepayment Invoice and Credit Memo number series

Choose the icon , look for Purchase & payable setup and select the related link.

Tell Me search in Dynamics 365 Business Central showing Purchases and Payables Setup for prepayment configuration

On the Purchase & Payable page, On the number series fasTab select the Posted Prepmt. Inv. Nos. and Posted Prepmt. Cr. Memo Nos.

Purchases and Payables Setup page showing Posted Prepayment Invoice and Credit Memo number series

To setup prepayment % for Item, Customer and Vendor.

To an item you define prepayment % for all the customers, a specific customer or a customer price group.

Choose the icon , look for Item and select the related link.

Tell Me search in Dynamics 365 Business Central showing Items list for defining prepayment percentages

Select the item and choose the Prepayment percentages action. In case of sales, go to sales action and in case of purchase go to purchase action.

Item card in Dynamics 365 Business Central showing Prepayment Percentages option under Purchases and Sales actions

Prepayment Percentages page in Dynamics 365 Business Central showing predefined prepayment percentage for items

On the prepayment page, add prepayment percentages

Tell Me search showing Purchase Orders list in Dynamics 365 Business Central

Create prepayment invoices

You can start prepayment process when you create a sales order or purchase order.

To create prepayment invoices

Choose the icon , look for purchase order and select the related link.

Purchase Order page in Dynamics 365 Business Central with prepayment percentage entered at line level

Select the vendor and when you will select the item prepayment % will automatically appear.

Purchase Order line in Dynamics 365 Business Central showing calculated prepayment amount excluding VAT

After adding quantity and unit price, you can see prepayment amount will automatically get calculated.

Purchase Order in Dynamics 365 Business Central with multiple lines showing applied prepayment percentage

If you have multiple lines and you want apply the prepayment % to all the lines, you can add prepayment % in the prepayment FasTab.

Prepayment statistics page in Dynamics 365 Business Central showing prepayment amount including VAT

To view the total prepayment amount, choose the Statistics action and check the prepayment FasTab.

Purchase Order actions menu in Dynamics 365 Business Central highlighting the Post Prepayment Invoice option

To post the prepayment invoice, choose the prepayment action and choose post prepayment invoice action.

Confirmation dialog in Business Central asking to post prepayments for the selected purchase order

When you click on the post button you will get popup of to confirm the posting. Click on the yes button and invoice will get posted.

Purchase Order page in Business Central showing Prepayment Invoices navigation option

Now you can see the posted prepayment invoice. Click on the prepayment invoice button.

Sales Order actions menu in Dynamics 365 Business Central showing Post Prepayment Invoice option under PrepaymentGeneral Ledger Entries in Business Central showing accounting impact of posted prepayment invoice

If check the G/L account, the prepayment account will be debited and sundry account will be credited.

general ledger entries

At the vendor level we can see the liability.

Vendor Card in Dynamics 365 Business Central showing vendor balance after posting prepayment invoice

Prepayments are used in various scenarios to manage cash flow and ensure financial efficiency.

For example:

Supplier Deposits: When businesses need to pay suppliers in advance to secure raw materials or products.

Progress Payments: For long-term contracts where payments are made based on the progress of work completed by the vendor.

Prepayment process in sales order is same as purchase order. In case of sales order, we define default prepayment % for the customers and create a sales order. The prepayment % field is available at the sales line level. After selection of item, the prepayment % appear automatically in the field and prepayment amount get calculated.

Purchase Order line in Business Central showing prepayment percentage and calculated prepayment line amount excluding VAT

 Same as purchase order, you can also define prepayment % at the header level.

Purchase Order header in Business Central with prepayment percentage enabled at document level

Same as purchase order, we can also see the prepayment amount in the statistics.

Sales Order statistics page in Business Central displaying total prepayment amount including VAT

To post, click on the post prepayment invoice button and document will get posted.

Purchase Order actions menu in Business Central showing Post Prepayment Invoice option

Now, we can check the posted prepayment invoice.

Purchase Order related menu showing Prepayment Invoices navigation option in Business Central

Posted Sales Prepayment Invoice page in Business Central showing prepayment invoice details

On the customer page we can see the balance for the prepayment.

General Ledger Entries in Business Central showing accounting impact of posted sales prepayment invoice

If look at the G/L entry of the prepayment, prepayment account is credited and customer account is debited.

Prepayments are used in various scenarios to manage cash flow and ensure financial efficiency.

For example:

Advance Payments: When customers are required to pay a portion of the total invoice amount before the goods or services are delivered.

Milestone Payments: For projects or contracts where payments are made at specific milestones or stages of completion.


Post a Comment

Your email address will not be published. Required fields are marked (*)

Captcha
can't read? refresh

WhatsApp Now