HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (12)

Answers (1)

Suggested answer

Gary Letter 1,267 on at

Like (0)

Report

Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

I believe Willoware's Mass Batch Change will do this: willoware.com/.../gp-powerpack.

Gary Letter
NextLevel Business Systems
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

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.
sandipdjadhav 18,265 on at

Like (0)

Report

Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

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
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report
Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

Sandip,

I essentially implemented your answer using three Access queries:

Moves any Invoices or Returns to a sales batch named COUNTER from the sales batch COUNTER HOLD, based on document date, i.e. an update query on table SOP10100.

Get batch totals for Number of Transactions and a total for all the documents (ORDOCAMT) for all batches in the SOP10100 table.

Lastly, a Select query on SY500 which I can then quickly type in the totals from the 2nd query and I am ready to go. This step is necessary so GP will let you post the batch.

Thanks again to all.

Glenn
sandipdjadhav 18,265 on at

Like (0)

Report

Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

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
Community Member Microsoft Employee on at

Like (0)

Report

Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

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
Community Member Microsoft Employee on at

Like (0)

Report

Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

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
sandipdjadhav 18,265 on at

Like (0)

Report

Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

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
Community Member Microsoft Employee on at

Like (0)

Report

Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

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
sandipdjadhav 18,265 on at

Like (0)

Report

Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

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

HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Community AMA December 12th

New! Quick response templates⚡

Leaderboard

Featured topics

Product updates

HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Community AMA December 12th

New! Quick response templates⚡

Subscribe to

Leaderboard

Featured topics

Product updates