ERP User GuideMicrosoft Dynamics AX

Microsoft Dynamics AX

Sana Commerce 9.2
Your connector

Online Invoice Payments



Sana allows to accept payments on open invoices through a payment provider directly from a web store. Business customers can pay multiple outstanding invoices at the same time. Online payments of the open invoices from a Sana web store 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 web store and online invoice payments setup, see 'Online Invoice Payments'.

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 web store 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 to capture the payment in the journal against the invoice.

To accept invoice payment from a Sana web store, 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
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.
Offset-transaction text Select a description for the offset journal entry.
Payment method code Select the payment method that is used for payment transactions.

When a customer pays an invoice from a Sana web store, 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 web store, and you can post payment transactions to the required account.

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 web store.

Only when the payment journal is posted in Microsoft Dynamics AX, the payment status of the invoice in the Sana web store 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.

A sales 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.

ERP User GuideMicrosoft Dynamics AX