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

Notifications

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) / Trouble with Batch Act...
Microsoft Dynamics GP (Archived)

Trouble with Batch Activity Table

(0) ShareShare
ReportReport
Posted on by Community Member

GP 2013 SP2 - I have a couple of users reporting an error when posting Bank Transactions - the Bank Posting Journal prints OK, but before the GL batch is posted, they receive the SQL error 'Cannot insert NULL into column 'TRXSOURC', table 'DYNAMICS.dbo.SY00800'; column does not allow nulls.  INSERT fails.'

Not sure if this may be security related to the SY00800 table? The reason I say that is because we had an issue with SY00800 the other day that required us to delete all records from it.

Any help would be greatly appreciated!

*This post is locked for comments

I have the same question (0)
  • soma Profile Picture
    soma 24,410 on at

    Please follow below link to clear the user/batch activity and try again.

    community.dynamics.com/.../user-id-batch-id-stucks-while-posting-reconciling-deleting-etc-in-dynamics-gp.aspx

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member on at

    Hi Soma,

    We tried what you suggested and we are still seeing this error. Any other ideas on what we could do to solve this issue?

  • Community Member Profile Picture
    Community Member on at

    UPDATE:

    I found the below previous post which seems to be the problem I'm having:

    community.dynamics.com/.../66344.aspx

    I can ask the newtork admin to disable IPS as recommended, but I thought it was strange that I'm not able to post the affected batches logged in as sa using the GP client installed on the actual GP SQL server.  Could IPS still be the issue if I am still having the issue on the actual SQL server?

    Any additional suggestions would be greatly appreciated.

    P.S.  We are currently running GP 2013 SP2, recently migrated to a brand new SQL server coming from GP 2010.  I'm attempting to collect as much info as I can with regards to what kind of batches they have the problem with, and when the issues started coming up with relation to the migration.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans