Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Open Receivables

(0) ShareShare
ReportReport
Posted on by 195

I want to match open receivables outside of GP to a bank file I am getting daily and then upload records to close or reduce an open receivable (invoice).  Is this possible?

*This post is locked for comments

  • Verified answer
    Elaine Reidich Profile Picture
    195 on at
    RE: Open Receivables

    Answered by Frank Hamelly.  Thank you.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Open Receivables

    On it's way to you.  You're welcome!

  • Elaine Reidich Profile Picture
    195 on at
    RE: Open Receivables

    Thanks so much Frank.  Integration Manager is the way to go for this company.  My email is ereidich@encompass.tv.  Really appreciate your help. 

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Open Receivables

    You have at least 3 options Elaine - Integration Manager, Scribe, and SmartConnect.  Integration Manager is a GP tool, Scribe and SmartConnect are 3rd party integration tools.  If you send me an email through the forum, I'll send you a template defining the required fields to import and apply sales invoice payments.

  • Elaine Reidich Profile Picture
    195 on at
    RE: Open Receivables

    Unfortunately, no. I can match on some of the client names and amounts but very few lines of the bank file come in with invoice number.  The database to be built will have screens set up for the staff to click buttons to match.  Is there someplace online where I can look to see how uploading the necessary data can be done?  Thanks.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Open Receivables

    Hi Elaine, this can certainly be done, but perhaps without the intermediate step of downloading from GP, depending on the data fields coming from the bank.  Is the bank file supplying at minimum the Customer ID, Invoice Number and Invoice Amount being paid?

  • Elaine Reidich Profile Picture
    195 on at
    RE: Open Receivables

    I have a download from GP with all the open invoice (receivables) info from a SmartList report.  I am going to build a database to match these records to a daily file from the bank with all the incoming revenue.  I then want to upload the matched records to GP to close out or reduce the open invoice amounts.  This will replace staff going into the GP screens to enter manual information (date of check or wire, reference number, amount, etc.).  Can this be done?

  • babubaskaran@outlook.com Profile Picture
    10 on at
    RE: Open Receivables

    Hi Elaine,

    Are you asking to generate the receivable data without login to GP, if you can elaborate what you are looking for will be good to answer your question.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans