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 466

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.

  • Laura Profile Picture
    Laura 450 on at
    RE: Voucher and Adjustment Entry: SQL Server Message 8144

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

  • Laura Profile Picture
    Laura 450 on at
    RE: Voucher and Adjustment Entry: SQL Server Message 8144

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

  • LsmithWipfli Profile Picture
    LsmithWipfli 144 on at
    RE: Voucher and Adjustment Entry: SQL Server Message 8144

    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.

  • Verified answer
    JGarcia123 Profile Picture
    JGarcia123 466 on at
    RE: Voucher and Adjustment Entry: SQL Server Message 8144

    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
    LsmithWipfli 144 on at
    RE: Voucher and Adjustment Entry: SQL Server Message 8144

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

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Voucher and Adjustment Entry: SQL Server Message 8144

    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

  • JGarcia123 Profile Picture
    JGarcia123 466 on at
    RE: Voucher and Adjustment Entry: SQL Server Message 8144

    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.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans