Get Dynamic - Microsoft Dynamics GP

 

GP Users: How to Import Your Cash Receipts Without an Integration Tool

Mar 25, 2019

By Debbie Knoebl

Even if you don’t use a lockbox, you can still import your cash receipts into Microsoft Dynamics GP using the Lockbox Entry.

You can find the Lockbox Maintenance window under the Sales Cards (Cards/Sales/Lockbox). Lockbox mapping can be done on multiple checkbooks, and the setup allows you the flexibility to auto apply your payments to invoices or map to specific invoices based on the source data.

In the example below, the import will auto apply the payment to the oldest invoice based on the due date. Note that the format is set as a single line. You will have one line per check received, and GP will apply the payment to invoices, beginning with the oldest and continuing until the payment is fully applied.

In this simple source file, the map picks up the customer ID, amount of the check, date of the deposit and the check number. The check is then auto applied to the customer’s open invoices beginning with the oldest due date.

GP Users: Import Your Cash Receipts Without an Integration Tool

Here is an example of a multi-line map that applies to specific invoices. The first row of the source file will contain the header record with the overall check information.

Dynamics GP Import Your Cash Receipts Without an Integration Tool

And the second line will contain the apply information.

Dynamics GP Import Your Cash Receipts Without an Integration Tool

When you go to the Lockbox Entry window, you will use your Lockbox setup to create a batch.

Dynamics GP Import Your Cash Receipts Without an Integration Tool

When you click on the transactions button, it displays the results of your import. In the screen shot below, you can see my total check amount and the indicator that it was fully applied. Simply click on “Create Batch,” and your check will be imported and applied as directed.

Dynamics GP Import Your Cash Receipts Without an Integration Tool

This is a great feature of Microsoft Dynamics GP that users can take advantage of to streamline processes and increase efficiency. If you have any questions about Lock Box Import, or to learn about other features you may not be leveraging, reach out to your GP manager at Wipfli.

Comments

*User Name field is required.

(will not be published)

*Real Name field is required.

(will not be published)

*A valid email is required.

*Company field is required.

*Comment field is required.
Dynamics GP blog
Subscribe to Get Dynamic - Microsoft Dynamics GP

Submit

Microsoft Dynamics 365 Business Central