I am looking for a script to push in data to create a check batch... or if someone knows the table(s) involved I can go from there and create myself.
*This post is locked for comments
Hello TSearl
You are most welcome to the community,
Can you please provide us with further details on your inquiry ? You may share a sample data set of the type of details you are looking for, and we will provide you with the script or tables accordingly
Looking forward to hearing from you
We have a program that we capture invoices and all the data is pushed into GP. All housed in a SQL database. So I have all the information like Company Code, Voucher, Amount Remaining of payable, Etc. The desire is to be able to select the payables in this program and run a stored procedure to create a check batch without having to manually key into GP. It would save time as our payables are quite extensive. Then the payables clerk only has to print the checks for sending out.
Hope this helps expand what I am looking to achieve.
Tom
Now we are clear about your requirements, this should not be done this way. It is not applicable to build a stored procedure which will read the invoices and create a batch.
Since you have already built the integration layer for the invoices, and your invoices are being migrated from another system to Dynamics GP, you already know the correct path.
In case the integration with Dynamics GP is built using eConnect, then you can simply achieve this requirements by passing the cash amount "with" the invoices and GP will create fully paid invoices (invoice and cash receipt). Otherwise, you may tell us how your invoices are currently integrated.
In several cases, such as POS which is integrated with Dynamics GP, it is not applicable to integrate invoices without being paid, you integrate invoices with the full cash amount, and they are created on GP as fully paid invoiced.
Your feedback is highly appreciated,
Should have said the invoices are not paid same day... we are pushing in the AP into a batch and once checked is it posted into GP AP...
from other system the Management team can go in and select the invoices they wish to have paid... from that I wanted to create the batch instead of having someone go in and selecting 100's of vouchers to be paid... I assumed like the way I create the batch to input the invoices to payables I could do the same and create the check batch...
Okay then,
There are a variety of method to pay several hundred of invoices as a bulk, I am afraid it is not quite possible to perform this task through a stored procedure on the data base level. Of course, you may be able to retrieve all the open invoice through an SQL view, and then automatically import all these invoices to be paid either through Macro or integration Manager.
You may get started from the following SQL view for all unapplied Receivables transactions in Dynamics GP
I am not quite sure of the thorough details of your business case, but I may propose schedule payments to be considered in case it fits. You can schedule your payments and post them all at once. Take a look at it Scheduling, Scheduling, Scheduling Payments in Dynamics GP
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 Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
