Voucher and Adjustment Entry: SQL Server Message 8144

(0) Share

Report

Posted on by JGarcia123

604

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:

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

All responses (7)

Answers (1)

Laura 460 on at

Like (0)

Report

RE: Voucher and Adjustment Entry: SQL Server Message 8144

I see the additional information in the download files - sorry for the question!
Laura 460 on at

Like (0)

Report

RE: Voucher and Adjustment Entry: SQL Server Message 8144

Jana MacDonald - How do others get the new stored procedure and new 03010 screen?
LsmithWipfli 148 on at

Like (0)

Report

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 604 on at

Like (0)

Report

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 148 on at

Like (0)

Report

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 4,710 on at

Like (0)

Report

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 604 on at

Like (0)

Report

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.