Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales Doc ID exists bu...
Microsoft Dynamics GP (Archived)

Sales Doc ID exists but I can't find it - where did it go???

(0) ShareShare
ReportReport
Posted on by Bruce B 295

Imported some sales transactions via integration manager.  Posted the Sales batch that contained them.  Post Through GL was NOT checked so a GL batch was created for the posted sales transactions. 

Wanted to removed all record of this stuff so I...

Deleted the GL batch manually using the application.

Used Tools-Maintenance-Clear to remove the sales transactions.  Removed the Logical name so I assumed this would remove records from all the necessary tables.

Now when I re-import the same transactions I get error saying the document ID already exists.

But I can't find the document anywhere.  Use Transaction Inquiry by Customer which reveals nothing.  Queries on the SOP tables reveals nothing.  (altleast the ones I thought to check)

 So where could this document ID be residing?  I really don't think the sales transaction is somewhere, I think some table is holding the IDs that have been used.

But if I am wrong then maybe the sales transaction is somewhere and I just can't find it.

So which is it?

Thanks

*This post is locked for comments

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Sales Doc ID exists but I can't find it - where did it go???

    The problem is that you posted.  This places pieces in many tables, including decreasing inventory quantities for the sales posted!  "Clear" just will not do this.

    Since you did not say which tables you cleared, it would be difficult to tell you which tables you missed.  You might try running first CheckLinks (which will remove lots of pieces) and then Reconcile (which will reset some quantities and totals) on the sales tables, the inventory tables, the receivables tables as a minumum.

    In the future, if you are going to delete the effects, either delete the sales batch before posting or make a backup before running your integration so you can do a restore.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans