Microsoft Dynamics 365 Business Central

Prepayments

A prepayment is an amount paid in advance by a customer to a merchant for an order. It is invoiced and posted to a sales order before final invoicing.

For example, a customer orders the custom-made furniture, which will be produced according to his or her requirements, like materials, parameters, color, design and so on. In this case, a merchant can ask for a payment in advance to make sure that when the furniture is finally made, a customer will definitely buy it.

 NOTE

Prepayments are available to B2B customers and sales orders only. For quotes, prepayments will result in working as Full amount paid on account payment type.

When a B2B customer creates an order in the Sana webshop and a prepayment % is available for this customer in Microsoft Dynamics 365 Business Central, he or she will see a prepayment amount that must be paid in advance on the Payment information step of the checkout process.

Limitations

Here are some limitations that you need to know if you are going to use prepayments.

1. If there is a service charge set up for a customer and a customer prepays the order from the Sana webshop, Dynamics 365 Business Central will fail to process this prepayment correctly.
2. The lines of the sales order must have the matching VAT percentage, otherwise the prepayment will not be processed correctly by Dynamics 365 Business Central. For example, a customer prepays an order which contains two items and for one item there is a 15% VAT set in Dynamics 365 Business Central and for another one 20% VAT, the prepayment will not work. All items must have the matching VAT percentage.

Enable prepayments in Sana

In Sana Admin click: Setup > Ordering & checkout > Ordering and in the Online order payments field for B2B customers, select the Amount based on prepayment rules payment type.

If Amount based on prepayment rules option is selected in Sana Admin, then a B2B customer will pay the order partially, according to the prepayment % set for this customer in Dynamics 365 Business Central.

If Full amount paid online option is selected in Sana Admin, then a B2B customer will pay full order amount online, even if a certain prepayment % is set for this customer in Dynamics 365 Business Central.

In case with the B2C customers, they always pay full amount online.

Set up prepayments in Microsoft Dynamics 365 Business Central

In Microsoft Dynamics 365 Business Central you can set up a prepayment percentage for a customer. In this case it will be calculated for all items purchased by this customer. You can also set up a prepayment % for an item.

 NOTE

If a prepayment percentage is available to a customer and an item, the prepayment percentage from the item will be used.

When B2B customers pay based on prepayment percentage set in Microsoft Dynamics 365 Business Central, the following rules are used:

• If prepayment % equals to 0, then a customer will not pay online, but on account instead.
• If prepayment % equals to 100, then a customer will pay full order amount online.
• If prepayment % equals to 20 for example, then a customer will pay 20% of the total order amount online. The way B2B customers pay the remaining amount depends on the agreements they have with a merchant.

To specify prepayment percentage for a customer in Microsoft Dynamics 365 Business Central:

On the Customer Card, on the Payments FastTab enter the prepayment percentage in the Prepayment % field.

This prepayment percentage will be used for all items purchased by this specific customer.

To specify prepayment percentage for an item in Microsoft Dynamics 365 Business Central:

Step 1: On the Item Card, on the Navigate tab, click Prepayment Percentages.

Step 2: In the Sales Type field, select whether the prepayment should be applied to the specific customer, customer price group or to all customers.

If the prepayment percentage should be applied to the specific customer, you must select the customer account in the Sales Code field.

Step 3: Enter the Prepayment % for the item.

When the B2B customer pays the order based on the prepayment rules, the prepayment percentage and amount will be stored in the sales order in Microsoft Dynamics 365 Business Central.

Post Prepayment Invoice

If a prepayment % is set for a B2B customer in Dynamics 365 Business Central and a customer pays an order online in the Sana webshop, an accountant must post the prepayment before invoicing the order.

A prepayment invoice can be also automatically posted in Dynamics 365 Business Central by Sana. To post prepayments automatically, select the option Auto Post Prepayments on the Webshop Card.

B2C customers always pay full amount online. Thus, if you enable automatic posting of prepayments, then when a B2C customer pays an order online in the Sana webshop, a prepayment invoice with the total order amount will be automatically posted in Dynamics 365 Business Central.

You can also create and post payment journals for prepayment invoices automatically. To do this, select the option Post Pmt. Journal for Online Pmt. on the Webshop Card.

To post payment transactions, Sana uses a journal template and journal batch that are selected in the Payment Processing section.

Field	Description
Journal Template Name	The journal template and the journal batch are used to create the appropriate journal in Dynamics 365 Business Central, when a customer pays the invoice, and to post the payment transaction to a certain account set in the journal batch. Any type of journal can be used to post payment transactions.
Journal Batch Name
Auto Post Prepayments	Select this option, if you want to post prepayment amount for the order automatically in Dynamics 365 Business Central, when customers pay their orders. If the checkbox Auto Post Prepayments is not selected, then when a customer pays the order online in the Sana webshop, an accountant should manually post the prepayment amount for the order.
Post Pmt. Journal for Online Pmt.	Applies to: Sana 9.3.3 Select this option, if you want to create and post payment journals for the prepayment invoices automatically in Dynamics 365 Business Central. Thus, the invoice payment will be automatically settled with the prepayment transaction, meaning that the order has been paid by the customer. This can be a partial payment based on the prepayment %, for example 50%, or full amount (100%) paid online. In both cases Sana can automatically create and post the payment journal with the reference to the prepayment invoice. If the Post Pmt. Journal for Online Pmt. option is not selected, then once a prepayment amount for the order is posted and prepayment invoice is created, an accountant should manually create a payment journal with the reference to the prepayment invoice and post it. You can enable the option Post Pmt. Journal for Online Pmt. only if the Auto Post Prepayments option is selected.

You should also set up number series for the prepayment invoices. It is necessary for the prepayment invoices creation. In Microsoft Dynamics 365 Business Central click on the  and enter Sales & Receivables Setup.