Notifications
Announcements
No record found.
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
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.
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?
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?
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.
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.
Thanks so much Frank. Integration Manager is the way to go for this company. My email is ereidich@encompass.tv. Really appreciate your help.
On it's way to you. You're welcome!
Answered by Frank Hamelly. Thank you.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
