Dax365FO

Making the invisible visible




Architectural perspective

Globally, two alternative methodologies exist to post a vendor prepayment: 1-directly post an advance payment or 2-post the prepayment invoice. Each company chooses the best path based on fiscal and business requirements present in its own localization. Below, we can find a quick description of the two alternatives.


Prepayment invoice

In some countries, receiving a prepayment without an invoice document is illegal. That because:

  1. The invoice legally certifies and legitimizes the due amount. In other words, in case of contestation, it’s the document to present to the court to certify that a debit was not played.
  2. The sales tax should be applied already in the prepayment process. So, it’s considered tax evasion to do a pre-payment without an invoice

Furthermore, from the accountant’s perspective, we usually want to separate the prepayment balance account from the current one. Here is the presentation of the accounting matrix related to this case:

EventMain accountTypeDebitCredit
Prepayment invoiceVendor advance paymentBalance sheet 122
Prepayment invoicePrepaymentBalance sheet100 
Prepayment invoiceSales tax receivableBalance sheet22 
PrepaymentVendorBalance sheet122 
PrepaymentBankBalance sheet
122
Prepayment compensationVendorBalance sheet122
Prepayment compensationVendor advance paymentBalance sheet 122
Vendor invoiceVendorBalance sheet 510
Vendor invoiceCostProfit and loss500 
Vendor invoicePrepaymentBalance sheet 100
Vendor invoiceSales tax receivableBalance sheet110 
Vendor paymentVendorBalance sheet510 
Vendor paymentBankBalance sheet 510

In Dynamics 365FO, the out-of-the-box function is more adequate for the business process, where we want to track a prepayment related to a specific purchase order. Indeed, we consider the prepayment to be dedicated to a specific order, so it’s mandatory to have the purchase order inserted into the system.

We can see this link for a deep-dive dynamics solution explanation: https://daxmsdynamics365.wordpress.com/2024/03/22/vendor-prepayment-invoice-feature/


Advance payment

In some countries, you are allowed to make a prepayment without the invoice. Fiscally speaking, it’s enough to declare the sales tax in the current invoice. The business can adopt this process because it’s leaner and faster than the prepayment invoice.

Furthermore, as for the prepayment invoice case seen previously from the accountant’s perspective, we usually want to separate the prepayment balance account from the current one. Here is the presentation of the accounting matrix related to this case:

EventMain accountTypeDebitCredit
PrepaymentVendor advance paymentBalance sheet100 
PrepaymentBankBalance sheet 100
Vendor invoiceVendorBalance sheet 610
Vendor invoiceCostProfit and loss500 
Vendor invoiceSales tax receivableBalance sheet110 
Vendor compensationVendorBalance sheet100 
Vendor compensationVendor advance paymentBalance sheet 100
Vendor paymentVendorBalance sheet510 
Vendor paymentBankBalance sheet 510

In Dynamics 365FO, we recommend that the process be more adequate for the business process where we do a generic prepayment but do not know the purchase order explicitly involved. In a second moment, we will match the prepayment with the purchase order inserted. In other words, the presence of a purchase order is not mandatory.

We can see this link for a deep-dive dynamics solution explanation: https://daxmsdynamics365.wordpress.com/2024/03/21/vendor-direct-advance-payment/

Leave a comment