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) / Dynamics GP 2018R2 - E...
Microsoft Dynamics GP (Archived)

Dynamics GP 2018R2 - Errors on every transaction window i select after upgrade to R2

(0) ShareShare
ReportReport
Posted on by Rennecia Barran

Hello,

After upgrading to 2018R2, I keep getting these error messages when clicking on a transaction window.

-A get/change operation on table 'SY_Posting_Journal_Settings' failed accessing SQL data.

The more info button produces this: [Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid column name 'TRXPostingThruGL'.

Then when i get into the window and click on a lookup I get this other message below:

-A get/change operation on table 'Batch_Headers' failed accessing SQL data.

The more info button produces this: [Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid column name 'UseLastDayofMonth'

Please help!

*This post is locked for comments

I have the same question (0)
  • Rennecia Barran Profile Picture
    Rennecia Barran on at

    Strange is - the errors are only on the production company. Not on the test company. The test company is a copy of the live company as of GP2018 which is before the upgrade to GP2018R2 was done.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    These errors point to a table missing columns it should have, that the procedure is looking for but not finding.

    The best way to determine exactly would be to run a dexsql..log of the error message, to see what script or procedure is causing 'invalid column name' message, then look at that procedure to see what table(s) it is looking in for the column in the error.

    From what I can determine, in GP 2018 R2, the SY02300 table has this 'TRXPostingThruGL' column in it, per company database, and the 'UseLastDayofMonth' column is found in the SY00500 table, per company database.

    As the SY02300 is the 'Posting Settings' table and SY00500 is the 'Posting Definitions Master' table, it would make sense you're seeing these errors when clicking transaction windows, if these columns are missing from these tables.

    Let me know if you have any questions.

    Thanks

  • Rennecia Barran Profile Picture
    Rennecia Barran on at

    I will try this and let you know the outcome.

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