How TAPP Finance integrated with the Payment Days of Microsoft Dynamics 365 Finance / FSCM

This feature allows companies to align customer payment collections with fixed weekdays or dates (e.g., every Thursday or the 15th of each month), rather than relying solely on invoice due dates.

How It Works

You can define a Collection Day for each customer using the existing Payment Day field in Dynamics 365 Finance and Operations.

Steps to Configure:

1. Navigate to: Accounts receivable > Customers > All customers
2. Select the customer and open the Payment defaults FastTab.
3. Set the Payment day field (e.g., “Friday” or “15th of the Month”).

Example:

• Payment Day: 15th of the Month
• Invoice Due Date: 13th of the Month
  
  The system will schedule the Collection Date as the 15th, based on the Payment Day.

System Logic (During Payment Journal or Direct Debit Runs):

1. The system checks the Payment Day field in the following order of precedence:
   a. Invoice Level – which is inherited from the customer.
2. If no Payment Day is set at invoice level:
   • The system checks if a Payment offset (in days) is configured on the customer.
   • It adds this offset to the Invoice Date to determine the collection date.
3. If none of the above fields are configured:
   • The system defaults to using the Invoice Due Date as the Planned Collection Date.

Summary of Field Precedence for Collection Date:

1. Payment Day on Invoice
2. Invoice Date + Payment Offset (Customer)
3. Invoice Due Date