Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

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

Posted on by 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

  • Suggested answer
    Gary Letter Profile Picture
    Gary Letter 1,267 on at
    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 Profile Picture
    Richard Whaley 25,195 on at
    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 Profile Picture
    sandipdjadhav 18,265 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    Re: HOW TO MOVE SALES INVOICES FROM ONE BATCH TO ANOTHER FOR POSTING

    Sandip,

    I essentially implemented your answer using three Access queries:

    1. 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.
    2. Get batch totals for Number of Transactions and a total for all the documents (ORDOCAMT) for all batches in the SOP10100 table.
    3. 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 Profile Picture
    sandipdjadhav 18,265 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    sandipdjadhav 18,265 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    sandipdjadhav 18,265 on at
    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

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans