SOP Batch - Unable to Recover/Post

(0) Share

Report

Posted on by Jim Lines

Greetings,

I have two SOP Invoice batches that I cannot post. The message I am receiving is “Transaction not completed at initiating scripts exit, implicitly rolled back.” I feel like I’ve had this problem in the past and was able to resolve it with the steps below, but all of my efforts have failed.

Here’s what I’ve tried so far:
- Update SY00500 (MKDTOPST = 0, BCHSTTUS = 0)
- Clear all tables with users logged out (dex_lock, dex_session, SY00800, SY00801)
- UPDATE SOP10100 SET PSTGSTUS = 0 (for both docs)
- Check Links on Sales Work
- Reconcile SOP

My batch edit lists are error free, but when I post, the progress errors at 50% and returns the message stated above (and screen shot).

Any suggestions on what I can try next? Thanks in advance!

Jim

(If you're a GPUG member I just posted this there too...)

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Tim Foster on at

Like (0)

Report

RE: SOP Batch - Unable to Recover/Post

A SQL Profiler Trace or Trace with GP Power Tools would help.

Tim Foster
Tristan Clores on at

Like (0)

Report

RE: SOP Batch - Unable to Recover/Post

Any modifications on the Sales Transaction Entry window?
Thomas Newcomb on at

Like (0)

Report

RE: SOP Batch - Unable to Recover/Post

Hi Jim!

How many transactions are in the SOP Batch. I looked up the error message that is in the screenshot however, it seems to be caused by a damaged transaction. Were these transactions imported into GP at all?

Please let me know!

~Thomas Newcomb

------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights
Jim Lines on at

Like (0)

Report

RE: SOP Batch - Unable to Recover/Post

Tim - Good idea. I'll do that.

Tristin - Form is modified, but I doubt that would have an impact in this situation.

Thomas - 2 batches, 1 trx each. I've done plenty of research myself and most of the suggestions were to follow the steps I outlined above. I think I had resolved the issue in the past using those methods, but I may have to start combing through the records to see what is out of place.

Thanks guys!

Community site session details

SOP Batch - Unable to Recover/Post

Helpful resources

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates