Online Invoice Payments

Sana Commerce Cloud allows business customers to pay outstanding invoices online using a credit or debit card through a payment service provider directly from a webshop. Business customers can pay multiple outstanding invoices at the same time. Online payments of the open invoices from a Sana webshop are seamlessly integrated with the sales order processing and cash management modules of Microsoft Dynamics 365 Business Central.

For more information about how to pay invoices from a Sana webshop and online invoice payments setup, see Online Invoice Payments.

How It Works

Payments from customers must be registered in Dynamics 365 Business Central. There is a cash receipt journal, which can be used to post payment transactions to G/L, bank, customer, vendor, and fixed assets accounts.

If you allow your business customers to pay their invoices with automatic payment journal creation, then when a customer pays the invoice, the record in the cash receipt journal will be created automatically in Dynamics 365 Business Central, and the payment will be registered on the required account set in the journal setup. If a customer pays several invoices at once, for each invoice a separate record will be created in the cash receipt journal in Dynamics 365 Business Central.

A business customer can have a related bill-to customer account in Dynamics 365 Business Central. It may be that the order is created by one customer and shipped to this customer, but the invoice should be sent to a different customer. In this case the payment journal will be posted to the bill-to customer account.

When the cash receipt journal has been created, an accountant can post the journal in Dynamics 365 Business Central, or it can be posted automatically to capture the payment in the journal against the invoice.

Set Up Invoice Payments

To accept invoice payments from a Sana webshop in Microsoft Dynamics 365 Business Central, click on the search button and enter Webshops. Open the relevant webshop card. On the General FastTab, select the required Journal Template and Journal Batch.

The journal template and the journal batch are used to create a cash receipt 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.

Enable the Auto Post Inv. Payments option, if you want payment journals to be posted automatically in Dynamics 365 Business Central when the customers pay their invoices.

In Microsoft Dynamics 365 Business Central click on the search button and enter Cash Receipt Journals.

In the Cash Receipt Journal window, you can see all payment journal records created for invoices paid by the customers from a Sana webshop, and you can post payment transactions to the required account or payment journals can be posted automatically, if the option Auto Post Inv. Payments is enabled on the Webshop Card. Only when the cash receipt journal is posted in Dynamics 365 Business Central, the payment status of the invoice in the Sana webshop will be set to Already paid.

If you allow your business customers to pay their invoices with manual payment journal creation, then when a customer pays the invoice, an accountant should manually handle such payments and create a record in the cash receipt journal in Dynamics 365 Business Central.

An invoice can have a due date in Microsoft Dynamics 365 Business Central. It is calculated based on the payment term set on the Customer Card, on the Payments FastTab. If you have entered the payment terms code on the customer card, Dynamics 365 Business Central will use the appropriate payment term when you invoice the customer. If the invoice is not paid within the due date, it will expire. The status of this invoice will change to Document is overdue in the invoice history in the webshop.

You can decide whether or not customers should be able to pay overdue invoices in the Sana webshop. To do this, in Sana Admin click: Setup > Ordering > Payment. Use the Allow overdue invoice payment option.

Payment Reference

NOTE

Applies to: Sana Commerce Cloud 10.0.43 and higher in Microsoft Dynamics 365 Business Central.

A payment reference is a piece of information that is used to easily identify a payment transaction. There are three components – the Sana webstore, your Dynamics 365 Business Central system, and the payment service provider that you use to accept online payments from your customers. When a customer creates an order and pays an invoice online in the Sana webshop, the order will be saved to Dynamics 365 Business Central and the payment transaction will be created in the payment system you use for online payments. To find the required payment transaction in your payment system, you need some information, such as the payment transaction ID, the number or name of the customer who created the order, or the order ID. It may differ depending on the payment service provider you use.

Using the Payment Reference field on the Webshop Card, you can choose what information you want to store in the customers’ payment journals so that it can help you easily find the necessary payment transactions in your payment system.

The available options are:

  • Empty: If you leave the Payment Reference field empty, then when a customer pays an invoice in the Sana webshop the Microsoft Dynamics 365 Business Central system will generate the default payment reference and it will be saved to the customer’s payment journal. This payment reference is generated automatically according to the default ERP business rules.

  • Document No.: The sales order ID is saved to the customer’s payment journal.

  • PSP Reference: The payment transaction ID of a sales order is saved to the customer’s payment journal.

  • Customer No.: The ID of a customer who paid an invoice is saved to the customer’s payment journal.

When a customer pays an invoice online in the webshop, Sana Commerce Cloud will store the payment reference you specified in the webshop settings in the customer’s payment journal in Dynamics 365 Business Central.

To see the payment reference stored in the customer’s payment journal, in Microsoft Dynamics 365 Business Central open the Customer Card and click: Customer > Ledger Entries. Check the Description field.

Payment Discount

Payment discounts are used to encourage customers to settle their debts as soon as possible. It can be granted when customers pay their invoice prior to the due date.

In Microsoft Dynamics 365 Business Central click on the search button and enter Payment Terms.

The table below provides the description of the fields necessary to set up a payment term.

Field

Description

Code

Enter an ID of a payment term.

Due Date Calculation

Specify the formula that is used to calculate the date that a payment must be made.

For example, if the payment must be made in one installment after two weeks, enter 14D.

Discount Date Calculation

Specify the formula that is used to calculate the date that a payment must be made in order to obtain a discount.

Discount %

Enter a discount percentage which will be applied to an invoice, if a customer pays for it on time according to the payment term.

You must add a payment term to the customer on the Payments FastTab, in the Payment Terms Code field.

If the payment discount is calculated for the invoice, the customer will see two different invoice amounts in the invoices history - the total amount without the payment discount and the outstanding total amount with the payment discount.

The information about the payment discount and its date is shown on the posted invoice details page in the Sana webshop.