Microsoft Dynamics NAV

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 NAV, 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.

• If there is a service charge set up for a customer and a customer prepays the order from the Sana webshop, Microsoft Dynamics NAV will fail to process this prepayment correctly.
• The lines of the sales order must have the matching VAT percentage, otherwise the prepayment will not be processed correctly by Microsoft Dynamics NAV. For example, a customer prepays an order which contains two items and for one item there is a 15% VAT set in Microsoft Dynamics NAV 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 Microsoft Dynamics NAV.

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 Microsoft Dynamics NAV.

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

Set up prepayments in Microsoft Dynamics NAV

In Microsoft Dynamics NAV 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 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 NAV, 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, 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 NAV:

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

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

To specify prepayment percentage for an item in Microsoft Dynamics NAV:

Step 1: At the top of the Item Card click: Related Information > Sales > Prepayment Percentages.

Step 2: In the Sales Type field, select whether 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 NAV.

Post Prepayment Invoices

If a prepayment % is set for a B2B customer in Microsoft Dynamics NAV 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 Microsoft Dynamics NAV by Sana. To post prepayments automatically, select the checkbox 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 Microsoft Dynamics NAV.

You can also create and post payment journals for prepayment invoices automatically. To do this, select the Post Pmt. Journal for Online Pmt. checkbox 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 Microsoft Dynamics NAV, 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 checkbox, if you want to post prepayment amount for the order automatically in Microsoft Dynamics NAV, 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 checkbox, if you want to create and post payment journals for the prepayment invoices automatically in Microsoft Dynamics NAV. 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. checkbox 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 checkbox is selected.

You should also set up number series for the prepayment invoices. It is necessary for the prepayment invoices creation. In Microsoft Dynamics NAV click: Financial Management > Receivables > Administration > Sales & Receivables Setup.