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

(0) Share

Report

Posted on by Community Member

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 have the same question (0)

All responses (12)

Answers (1)

Mike Smith 6,840 on at

Like (0)

Report

I'm not aware of an out-of-the-box routine/process that carries this out but I imagine this should be a pretty straightforward and relatively quick DEX customization. Have you contacted the reseller that you work with in regards to this?

Was this reply helpful? Yes No
Brian Marszalek on at

Like (0)

Report

Hello Glenn,

I'm also unaware of anything out of the box that does this, but another option that may do the same thing for you is a macro. MIke's suggestion of contacting your reseller is a good one.

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
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

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates