Microsoft Dynamics 365 for Finance and Operations

Online Invoice Payments

Sana allows to accept payments on open 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 accounts receivable modules of Microsoft Dynamics 365 for Finance and Operations.

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 for Finance and Operations. There is a payment journal, which can be used to post payment transactions to ledger, bank, customer, vendor, project 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 payment journal will be created automatically in Dynamics 365 for Finance and Operations, and the payment will be registered on the required account set for the webshop in Dynamics 365 for Finance and Operations. If a customer pays several invoices at once, for each invoice a separate line will be created in the payment journal in Dynamics 365 for Finance and Operations.

A business customer can have a related invoice account in Dynamics 365 for Finance and Operations. 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 customer's invoice account.

When the payment journal has been created, an accountant can post the journal in Dynamics 365 for Finance and Operations, 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 Dynamics 365 for Finance and Operations click: Modules > Webshop > Common > Webshops. Select the webshop and set up the Payment processing settings. These settings are used to create a payment journal in Dynamics 365 for Finance and Operations, when a customer pays the invoice, and to post the payment transaction to a certain account.

Field	Description
Customer payment journal	Select the customer payment journal. The selected payment journal is used for all invoices paid by the customers from the Sana webshop. Only journals of the Customer payment type are shown in this field.
Offset company	Select the legal entity where the payment transactions on open invoices will be offset.
Offset account type	Select the account type for the offset transaction to the customer payment. This is typically the Bank account type for customer payment journal lines.
Offset account	Select the account for the selected offset account type.     Applies to: Sana 9.3.3 Offset account can be set up for a payment journal, a webshop and a payment method. The system uses the necessary offset account for the payment transaction according to the priority. See the explanation below.
Offset transaction text	Select a description for the offset journal entry.
Payment method code	Select the payment method that is used for payment transactions.
Post invoice payments automatically	Select this checkbox, if you want payment journals to be posted automatically in Dynamics 365 for Finance and Operations when the customers pay their invoices. If this checkbox is not selected, the accountant will need to post payment journals manually.

When a customer pays an invoice from a Sana webshop, and a record is created in the payment journal in Dynamics 365 for Finance and Operations, all values of the payment processing settings from the Webshops window will be automatically copied to the payment journal.

To see open customer invoices, in Dynamics 365 for Finance and Operations click: Modules > Accounts receivable > Invoices > Open customer invoices.

To see invoice payments that you receive from customers, in Dynamics 365 for Finance and Operations click: Modules > Accounts receivable > Payments > Payment journal. Here you can see all payment journals 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 Post invoice payments automatically is enabled in the Webshops window.

Select the payment journal and click Lines. In the Customer payments window, you can see the payments received from the customer that are registered on the same account which is set for the webshop.

Only when the payment journal is posted in Dynamics 365 for Finance and Operations, 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 payment journal in Dynamics 365 for Finance and Operations.

An invoice can have a due date in Dynamics 365 for Finance and Operations. It is calculated based on the terms of payment set in the Customers window, on the Payment defaults FastTab. If you have entered the terms of payment for the customer, Dynamics 365 for Finance and Operations will use the appropriate payment term when you invoice the customer. If the invoice is not paid within the due date, it will expire, meaning that a customer will not be able to pay this invoice.

Offset accounts

In Dynamics 365 for Finance and Operations you can set up offset account for a payment journal, a webshop and for a payment method.

When a customer pays for the invoice in the Sana webshop, the offset account that will be used for a payment is based on priority.

If the offset account is set up for a payment journal selected in the webshop settings and the option Fixed offset account is enabled, then an offset account from a payment journal is used for a payment transaction.

In case the option Fixed offset account is not enabled, then an offset account set for a webshop is used for a payment transaction.

If the option Fixed offset account is not enabled in the settings of a payment journal and offset account is not set up for a webshop, then an offset account from a payment method set in the Payment processing settings of the webshop is used for a payment transaction.

So, the priority is the following: Payment journal offset account (Fixed offset account option is enabled) > Webshop offset account > Payment method offset account. 

Payment journal approval

All payment journals for customers' invoice payments can be automatically approved by the Microsoft Dynamics 365 user that is used for connection between Sana and Dynamics 365 for Finance and Operations. This user is specified in the ERP connection settings in Sana Admin.

To approve payment journals automatically, the Microsoft Dynamics 365 user should be associated with the appropriate person (user relations) and should be added to the group set on the payment journal you are using in Dynamics 365 for Finance and Operations and that is authorized to approve payment journals.

Step 1: Open the details of a payment journal set for your webshop. In the Approval section, select the Active option and make sure that your Microsoft Dynamics 365 user is added to the group selected in the Approve field.

Step 2: In Dynamics 365 for Finance and Operations click: System administration > Users > Users. Open the Microsoft Dynamics 365 user you are using. Assign the appropriate Person to the Microsoft Dynamics 365 user.

If the Microsoft Dynamics 365 user is correctly set up, then all payment journals for the invoices paid from a Sana webshop will be automatically approved by this user and you can see it on the History tab of the payment journal.

Payment method status

All payment journals for the invoices paid from a Sana webshop have a payment status in Dynamics 365 for Finance and Operations. Sana uses the payment status from the payment method set on the Webshops form.

You can see the payment status of a payment journal for an invoice in the payment journal lines.

Cash discount

Cash discounts are used to encourage customers to settle their debts as soon as possible. It can be granted when a customer pays his or her invoice prior to the due date.

To set up a cash discount, in Dynamics 365 for Finance and Operations click: Accounts receivable > Payment setup > Cash discounts.

For more information, read the official Dynamics 365 for Finance and Operations documentation "Cash discounts".

You can add a cash discount to the customer on the Payment defaults FastTab, in the Cash discount field.

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

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