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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Voucher and Adjustment Entry: SQL Server Message 8144

(0) ShareShare
ReportReport
Posted on by 977

Our system is on SL 2018 CU4 and they recently applied the year end update prior to the start of the Christmas Holiday.  This week they've resumed using the system and when entering vouchers are getting the following message: 

pastedimage1609298067659v1.png

Any thoughts as to what the message is and how to resolve.  Please advise.  Thank you.

I have the same question (0)
  • SL_GP_BC_123 Profile Picture
    977 on at

    Looks like the issue was the ApprovalHist_Latest stored procedure.  The latest update drops the procedure down to two parameters.  Replaced with the procedure from SL2018CU3 which had three parameters.  

    Once done the batch released OK.

  • CFROTON Profile Picture
    4,710 on at

    Dear JG,

    Thank you for your heads up. We will look at the issue. My Cu4 without the updates have 3 parameters.

    Best Regards,

    Jana MacDonald

  • LsmithWipfli Profile Picture
    148 on at

    I'm having the same issue at one of my clients. Where can I get the Cu3 stored proc?

  • Verified answer
    SL_GP_BC_123 Profile Picture
    977 on at

    I had an installed instance of CU3 and took it from there.  For reference this is the original 3 parameter SP:

    Create Proc [dbo].[ApprovalHist_Latest] @parm1 varchar ( 10), @parm2 varchar ( 10), @parm3 varchar ( 10) as

               SELECT * FROM ApprovalHist WHERE BatNbr = @parm1 and ScreenNbr = @parm2

    and refnbr like @parm3

                       Order by ApprovalHist.statdatesort desc

    GO

  • LsmithWipfli Profile Picture
    148 on at

    Thank you for the new stored proc. It seems there is an issue with the AP voucher screen after the YE update is applied. Support gave me a new 03010 screen to copy to the AP folder which resolved the issue.

  • Laura Profile Picture
    460 on at

    Jana MacDonald - How do others get the new stored procedure and new 03010 screen?

  • Laura Profile Picture
    460 on at

    I see the additional information in the download files - sorry for the question!

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans