web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Uploaded SOP Invoices ...
Microsoft Dynamics GP (Archived)

Uploaded SOP Invoices with the wrong account

(0) ShareShare
ReportReport
Posted on by Zeph Levin 100

Hello, 

I've got a user who uploaded a couple hundred documents using Integration manager to the wrong Account. 

I would like to either

 - Void the whole batch

 - Update the account in bulk

But i can't find any information on either. Are either of these options possible? 

 

Thanks in advance!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Tim W Profile Picture
    Tim W 2,925 on at

    If it was Orders integrated not invoices then it's a pretty easy back end (SQL) fix to one table (SOP10200).  If these are Invoices than it's a bit tougher as you also would have to fix the distribution table.  Assuming invoices and the sales account as the account needing change you would need to determine the account index for the correct account and update SOP10200 and SOP10102 for the bad records.  Easy enough if you have the experience with these tables.

    If you are not comfortable with that approach I would simply delete the batch and then re-integrate.

     

  • Zeph Levin Profile Picture
    Zeph Levin 100 on at

    I'm sorry I omitted that detail. I also can't delete the batch, I get a message

    "Some documents in this batch could not be deleted" and nothing is deleted.

    Is there a setup option to allow deletion?

  • Tim W Profile Picture
    Tim W 2,925 on at

    That message is more an issue of other documents in the batch that have been partially transacted.  Typically you get this message when you have partially transferred an order  to invoice and then try and delete the batch.

    I would run a smart list on this batch and see what else besides my 200 bogus invoices are in the batch and then move them to a different batch.  There is a setting to control deletes by document id's (Sales -> Setup -> Sales Order Processing ) but I think you would have got that message instead of the above.

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans