Microsoft Dynamics AX

Online Invoice Payments

Sana 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 accounts receivable modules of Microsoft Dynamics AX.

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 Microsoft Dynamics AX. 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 Microsoft Dynamics AX, and the payment will be registered on the required account set for the webshop in AX. If a customer pays several invoices at once, a separate line will be created for each invoice in the payment journal in Microsoft Dynamics AX.

A business customer can have a related invoice account in Microsoft Dynamics AX. 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 Microsoft Dynamics AX, 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 AX click: Webshop > Common > Webshops. Select the webshop and set up the Payment processing settings. These settings are used to create a payment journal in Microsoft Dynamics AX, 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 accounts	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 Microsoft Dynamics AX 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 Microsoft Dynamics AX, all values of the payment processing settings from the Webshops form will be automatically copied to the payment journal.

To see open customer invoices, in Microsoft Dynamics AX click: Accounts receivable > Common > Customer invoices > Open customer invoices.

To see invoice payments that you receive from customers, in Microsoft Dynamics AX click: Accounts receivable > Journals > 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 on the Webshops form.

Select the payment journal and click Lines. On the Journal voucher form, 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 Microsoft Dynamics AX, 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 Microsoft Dynamics AX.

An invoice can have a due date in Microsoft Dynamics AX. It is calculated based on the terms of payment set on the Customers form, on the Payment defaults FastTab. If you have entered the terms of payment for the customer, AX 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 Microsoft Dynamics AX 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 checkbox Fixed offset account is selected, then an offset account from a payment journal is used for a payment transaction.

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

If the checkbox Fixed offset account is not selected 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 checkbox is selected) > Webshop offset account > Payment method offset account. 

Payment journal approval

 NOTE

Applies to: Sana 9.3.1 and higher

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

To approve payment journals automatically, the AX user should be associated with the appropriate worker (user relations) and should be added to the group set on the payment journal you are using in Microsoft Dynamics AX 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 checkbox and make sure that your AX user is added to the group selected in the Approve field.

Step 2: In Microsoft Dynamics AX click: System administration > Common > Users > Users. Select the AX user you are using and click Relations. Assign the appropriate Worker to the AX user.

If the AX 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

 NOTE

Applies to: Sana 9.3.1 and higher

All payment journals for the invoices paid from a Sana webshop have a payment status in Microsoft Dynamics AX. 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 Microsoft Dynamics AX click: Accounts receivable > Setup > Payment > Cash discounts.

For more information, read the official Microsoft Dynamics AX documentation "About cash discounts" and "Cash discounts (form)".

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.