SOP transaction is missing in SOP history tables

(0) Share

Report

Posted on by Alaa Ramadan

4,130

A sales batch got interrupted during posting. it seems it was partially posted but still showing as unposted. when I attempt to open It I got the message that this document already exist.

The transaction exist in all RM tables and SOP10100/SOP10200 but missing in SOP30200 and SOP30300

Is there any way to populate these 2 history tables or to clear the transaction from RM tables and then post it again?

Thanks

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Richard Wheeler 75,852 Moderator on at

Like (1)

Report
Copy link

Link copied!

Under Inquiry->Sales->Sales Documents does this invoice show as being in unposted or history? Have you tried Tools->Utilities->Sales->Reconcile-Remove Documents to move this document to history? Is this does not work you will need to SSMS to move this document to history.

Was this reply helpful? Yes No
Alaa Ramadan 4,130 on at

Like (0)

Report
Copy link

Link copied!

Yes it shows under inquiry as an open and upon clicking on it a message with '' this document has been removed from SOP history'

Reconcile/remove utility did not help.

I guess my only option is to add this invoice into SOP30200/SOP30300 manually then remove the unposted batch

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Check out this note first. There may be an issue with quantities on this invoice.

https://community.dynamics.com/gp/b/dynamicsgp/posts/how-to-use-sql-to-troubleshoot-a-sop-order-that-did-not-move-to-history-when-it-was-fully-invoiced

Was this reply helpful? Yes No
Nicole Hellerud 1,712 on at

Like (0)

Report
Copy link

Link copied!

Hey Alaa,

Thank you for your post!

Thank you as well Richard for your fantastic feedback.

Alaa, have you been able to continue with the direction noted by Richard?

Please let us know, if the issue is now resolved, we'd love feedback on what your solution was and if possible you could verify Richard's answer.

Wishing you and yours healthy and happy days ahead.

Nicole Fiskum

Support Engineer

Microsoft Dynamics

Was this reply helpful? Yes No
Verified answer

Alaa Ramadan 4,130 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately it is not exactly the same scenario. I ended up clearing the reference to the subject transaction from the open tables and then repost it.

Was this reply helpful? Yes No