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
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
Answered by Frank Hamelly. Thank you.
On it's way to you. You're welcome!
Thanks so much Frank. Integration Manager is the way to go for this company. My email is ereidich@encompass.tv. Really appreciate your help.
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.
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.
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?
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,
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.