Automating AP electronic Payment Numbers in Dynamics 365 Finance
Clients have asked if there is a way, we can auto-generate a number for a Vendor ACH electronic payment in the payment reference field in Dynamics 365 Finance.
Instead of trying to manually come up with a numbering scheme and remembering the next number every time you do a new payment batch, it would be nice to have the system generate those numbers for you.
This blog will show you how automate electronic payment numbers in Dynamics 365 Finance version 10.0.18.
Required Setup:
Step 1: Go to Accounts payable->Setup->Accounts payable parameters->Settlement options->Enable electronic payment number
Step 2: Go to Accounts payable->Setup->Accounts payable parameters->Number sequence options->Electronic payment number->select View details on number sequence code column
Step 3: Number sequence setup:
The below is just an example, you can set it up however you like.
Step 4: Setup a Method of Payment for ACH
Accounts payable->Payment setup->New
Step 4.a: Select Payment specification (Top menu) add information
Step 5: Vendor must have a Bank Account setup in the Vendor master
Processing payments
Create a Vendor payment journal:
After Generating payments:
The Electronic payment number and Payment reference fields are populated with the number sequence
Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.
Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.