Eliminate manual payment entry
Import PM manual payments from a CSV file instead of keying them one transaction at a time.
Accounts Payable
AP Payment and Apply Import
Import manual AP payments from CSV and apply them to open invoices in Dynamics GP.
Importing AP manual payments and applying them to open invoices is one of the most repetitive jobs in Dynamics GP accounts payable. AP Payment and Apply Import turns that work into a file import.
Prepare your payments and applications as CSV files, set a few options, and the application creates the manual payments in Dynamics GP and applies them to the open vouchers — across multiple company databases, in one step or two.
The challenge
Entering AP manual payments into Dynamics GP and applying each one to the right open vouchers is slow and error-prone, especially at high volume or across several company databases. A lockbox file, a third-party payment system, or a spreadsheet of payments can turn into hundreds of manual transactions.
How AP Payment and Apply Import helps
AP Payment and Apply Import reads your payment and application data from CSV files, creates the PM manual payments in Dynamics GP, and applies them to the open vouchers — together in one step or as two separate steps. It works across multiple GP company databases, supports several payment methods, and can split a large import into multiple batches by batch size.
Benefits
What you get
Apply payments automatically
Apply imported payments to the correct open vouchers from a CSV file, with the payment import or as a separate step.
Work across multiple companies
Import into multiple GP company databases by reading a database field in the data file.
Control your batches
Set the payment batch ID in the application, and automatically split the import into multiple batches based on batch size.
Support several payment methods
Handles Check, Credit Card, Cash, and EFT payment methods (version 3 and higher).
Support Multi-Entity Management
Works with Binary Stream Multi-Entity Management (MEM) for manual payments and applications.
Features
How it works in detail
CSV import for payments and applications
Reads comma separated value files for both the manual payments and the applications. Import them together or separately.
Payments or credit memos
Imports either manual payments or credit memos in a single import process.
Batch control and splitting
Specify the payment batch ID, and split the import into multiple batches automatically based on a batch size.
Built on eConnect
Uses Microsoft Dynamics GP eConnect to create the transactions, so imported payments follow standard Dynamics GP validation.
Getting started
How to put it to work
-
Prepare your CSV files
Export your payments and, optionally, your applications to CSV files in the documented format.
-
Set the import options
In the application, choose the company, payment method, and batch ID, and set the batch size if you want to split the import.
-
Import and apply
Run the import to create the manual payments and apply them to open vouchers — together or as separate steps.
-
Review in Dynamics GP
The unposted payments and applications are ready in the payment batch for your normal review and posting.
Requirements
Compatibility and requirements
Supported: Dynamics GP 2016 through 18.x.
What you need
- Microsoft .NET Framework 4.5.1
- Microsoft Dynamics GP eConnect, with the eConnect Windows service running
- An eConnect domain user account with the proper access in SQL Server
- The 'sa' SQL login for the first launch of the application
- A registration key (trial or permanent)
Good to know
- Does not apply posted payments or credit memos.
- Does not support multi-currency payments or applications.
- Does not support checkbooks that allow duplicate check numbers.
- Does not support applying a single payment to invoices that use different Accounts Payable accounts.
FAQ
Common questions
Is there a trial?
Yes. The application includes a free 30 day trial. A registration key, trial or permanent, is required to run it.
Which Dynamics GP versions are supported?
Dynamics GP 2016 through 18.x.
Does it post the payments?
No. It creates unposted manual payments and applications in a batch. You review and post them in Dynamics GP as usual. Post Master can automate the posting step.
Does it support Multi-Entity Management?
Yes. It supports Binary Stream Multi-Entity Management (MEM) for manual payments and applications.
Related