Error on 19.1 Prod Deployment

Issue No: SC-2776
Created 5/21/2019 7:39:40 PM
Type Bug-QC
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 19.1
Description 2019-05-21T15:52:46.2806788Z Error SQL72014: .Net SqlClient Data Provider: Msg 209, Level 16, State 1, Procedure uspSCGenerateVoucherDetails, Line 571 Ambiguous column name<---   2019-05-21T15:52:46.2806886Z   2019-05-21T15:52:46.2806974Z ---> (Inner Exception #15) System.Management.Automation.RemoteException: 'dblCostUnitQty'.   2019-05-21T15:52:46.2807038Z Error SQL72045: Script execution error. The executed script:   2019-05-21T15:52:46.2807110Z ALTER PROCEDURE [dbo].[uspSCGenerateVoucherDetails]   2019-05-21T15:52:46.2807191Z @VoucherDetailReceipt VoucherDetailReceipt READONLY, @VoucherDetailReceiptCharge VoucherDetailReceiptCharge READONLY, @voucherDetailDirect [VoucherDetailDirectInventory] READONLY   2019-05-21T15:52:46.2807295Z AS   2019-05-21T15:52:46.2807340Z SET QUOTED_IDENTIFIER OFF;