Trouble with Batch Activity Table

(0) Share

Report

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

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

RE: Trouble with Batch Activity Table

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.
Community Member on at

Like (0)

Report

RE: Trouble with Batch Activity Table

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?
soma 24,410 on at

Like (0)

Report

RE: Trouble with Batch Activity Table

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!!!