Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

cash receipts import

(0) ShareShare
ReportReport
Posted on by 135

I am looking for a module that will allow us to import the cash receipts from a customer file (*.txt, etc.) so we can post automatically by looking up the document number.  We have a high-volume transaction scenario that would greatly benefit being able to import the cash receipt data.  Thanks for any help.

*This post is locked for comments

  • callen Profile Picture
    callen 4,595 on at
    Re: cash receipts import

    There is a module called EFT for Receivables Management. If you have GP Professional, you can buy it if you don't own it. If you have GP Advanced Management, you already own it. If you have GP Standard or Business Essentials, your best bet is to use Integration Manager or perhaps the lockbox module. I haven't used the latter item so I can't comment on it.

  • Dan Sionov Profile Picture
    Dan Sionov 75 on at
    Re: cash receipts import

     That should still be OK.  It's just expecting a text file.  It will let you configure the field mapping to be able to import the file.

  • Gloria Gillespie Profile Picture
    Gloria Gillespie 135 on at
    Re: cash receipts import

    We are not using a traditional lockbox.  The deposits are being made via EFT.  We get a separate remittance advice directly from our customer.  Could that file be imported in this lockbox feature?  Thanks for your help!

  • Dan Sionov Profile Picture
    Dan Sionov 75 on at
    Re: cash receipts import

    The Lock Box feature in Dynamics GP will be able to do this for you.  It's typically used when a bank collects your cash receipts and sends you a text file.  You would then import this text file and automatically apply to the open invoices.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans