Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Rennecia Barran Profile Picture
    Rennecia Barran on at
    RE: Dynamics GP 2018R2 - Errors on every transaction window i select after upgrade to R2

    I will try this and let you know the outcome.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Dynamics GP 2018R2 - Errors on every transaction window i select after upgrade to R2

    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
    RE: Dynamics GP 2018R2 - Errors on every transaction window i select after upgrade to R2

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans