We are on GP 2010. We accumulate unposted sales invoices in a batch named CTR HOLD. Each day we move the prior days unposted invoices, ONE AT A TIME, to a sale batch named COUNTER. We reconcile the activity in the COUNTER batch and then post, which is the reason behind two batches. I want a way to move all invoices from the CTR HOLD sales batch to the COUNTER sales batch based on a certain date to speed this up.Thanks in advance for any ideas or suggestions.
*This post is locked for comments
I believe Willoware's Mass Batch Change will do this: willoware.com/.../gp-powerpack.
Gary Letter
NextLevel Business Systems
While Access and/or SQL queries can do the job in multiple steps.....there IS a third party application that will do this easily and allows the user to select a range of documents in one batch to move to the other. It is provided by either Ethotech or Merrit, I can't remember which.
Glenn,
It was easy solution.. no need to spend money on verticals. Make sure you will add in New "COUNTER" Batch Totals and substract from "CTR HOLD" .
I am glad solution work for you.. cannot wait for posting status.
Thanks
Sandip
Sandip,
I essentially implemented your answer using three Access queries:
Thanks again to all.
Glenn
Glenn,
I understand we cannot run "CheckLink" while users are working on SOP transactions screen.. I was thinking let GP rectify batch Total. But while doing SOP10100 Update we can Update SY00500 table (BatchActivity) only two field is updating while we save transaction in existing Batch i.e. "NumofTrx" and "BachTotal" that will resolve your all issue.
Hope that will help to create your own utility..!!!
Thanks
Sandip
210.440.9855
Sandip,
I gave it a go and it works on paper. the practical issue is reconcile cannot be run on the Sales Work tables while sales order screens are open. At our offices, there might be ten people with sales orders open at any given time. I cannot possilby ask these people to close a window while I run reconcile. However, I appreciate your efforts in trying to provide a solution.
I have asked our Reseller to opine on a solution and will post a summary if I opt to pursue their solution(s).
Best regards,
Glenn
Sandip,
I will try it out and let it you know how it goes. Give me a day or two to put it all together.
Thanks,
Glenn
Glenn,
In Dynamics GP-->Maintenance-->Check Links Select "Sales" Series insert "Sales Work" table. I just did small testing updating SOP10100 batch field and it did work perfectly. Try it in Test Company before working on Production.
THanks
Sandip
Hi Everyone,
Thanks for the suggestions, I appreciate everyone taking the time to give me some guidance.
I have not asked my reseller, but I am thinking about it.
Sandip, I could do what you described with the SOP10100 table via odbc and an update query in Access. Simply have the query ask for the document date and let it execute the update from the sales batch CTR HOLD to the sales batch COUNTER. However, I am unclear as to what table(s) to run Check Links on afterwards, could you clarify?
Thanks,
Glenn
Glenn,
If you check SOP10100 Table it has BACHNUMB field update that field to new batchID and then run checklink. A simple .net applicaiton which will display Invoice Header base on Batch Or date criterial .
e.g.
Invoiceno, Date,Customer No,Name, OldBatchID, NewBatchID
0001,09/01/2011,ABC,ABCDE,CTR HOLD, COUNTER
0002 ,09/02/2011 XYZ, ZZZZ,CTR HOLD, COUNTER.
Update...
Run checklink to rectify Batch Total. Let us know how it goes or which logic you used.
Thanks
Sandip
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156