| Description |
Customer: MCP
Company: 01 (please include 97 98 and 99)
Upgrading from 18.3.0708.84 to 18.3.0710.88
Database:
[ftp://ftp.i21server.com/databases/mcp/mcp07102018.zip]
\\fileserver\d$\PROJECTS\i21\Databases\MCP - mcp07102018
Error SQL72014: .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Procedure uspAPCreateVoucherDetailDirectInventory, Line 96 Invalid column name 'intLoadDetailId'.
Error SQL72045: Script execution error. The executed script:
CREATE PROCEDURE [dbo].[uspAPCreateVoucherDetailDirectInventory]
@voucherId INT, @voucherDetailDirect [VoucherDetailDirectInventory] READONLY
AS
SET QUOTED_IDENTIFIER OFF;
SET ANSI_NULLS ON;
SET NOCOUNT ON;
SET XACT_ABORT ON;
SET ANSI_WARNINGS OFF;
BEGIN TRY
DECLARE @detailCreated AS Id;
DECLARE @voucherIds AS Id;
DECLARE @transCount AS INT = @@TRANCOUNT;
IF @transCount = 0
BEGIN TRANSACTION;
INSERT INTO tblAPBillDetail ([intBillId], [intAccountId], [intItemId], [strMiscDescription], [intUnitOfMeasureId], [dblQtyOrdered], [dblUnitQty], [dblQtyReceived], [dblDiscount], [intCostUOMId], [dblCost], [dblCostUnitQty], [int1099Form], [int1099Category], [intLineNo], [intTaxGroupId], [intContractDetailId], [intContractHeaderId], [intLoadDetailId], [intLoadId], [intScaleTicketId])
OUTPUT inserted.intBillDetailId INTO @detailCreated
SELECT @voucherId AS [intBillId],
dbo.[fnGetItemGLAccount](A.intItemId, loc.intItemLocationId, 'AP Clearing') AS [intAccountId
|