Description |
*Database: CR2, 01, 02, 03, LT, NC, CR, RO, MC*
02:34:57 PM - Error SQL72014: .Net SqlClient Data Provider: Msg 209, Level 16, State 1, Procedure uspMFUndoPallet, Line 598 Ambiguous column name 'intWorkOrderId'.
02:34:57 PM - Error SQL72045: Script execution error. The executed script:
02:34:57 PM - ALTER PROCEDURE uspMFUndoPallet
02:34:57 PM - @strXML NVARCHAR (MAX)
02:34:57 PM - AS
02:34:57 PM - BEGIN TRY
02:34:57 PM - DECLARE @idoc AS INT, @ErrMsg AS NVARCHAR (MAX), @intWorkOrderId AS INT, @intLotId AS INT, @intUserId AS INT, @strBatchId AS NVARCHAR (40), @intTransactionId AS INT, @strTransactionId AS NVARCHAR (50), @dblQuantity AS NUMERIC (38, 20), @intItemId AS INT, @intBatchId AS INT, @ysnForceUndo AS BIT, @intTransactionCount AS INT, @intItemUOMId AS INT, @dblPhysicalCount AS NUMERIC (18, 6), @intLocationId AS INT, @ACCOUNT_CATEGORY_OtherChargeExpense AS NVARCHAR (30) = 'Other Charge Expense', @ACCOUNT_CATEGORY_OtherChargeIncome AS NVARCHAR (30) = 'Other Charge Income', @ACCOUNT_CATEGORY_Inventory AS NVARCHAR (30) = 'Inventory', @OtherChargesGLAccounts AS dbo.ItemOtherChargesGLAccount, @intItemId1 AS INT, @strItemNo1 AS NVARCHAR (50), @intRecipeItemUOMId AS INT, @intItemLocationId AS INT, @INVENTORY_PRODUCE AS INT = 9, @dtmDate AS DATETIME, @intTransactionDetailId AS INT, @strLotTracking AS NVARCHAR (50), @intSpecialPalletLotId AS INT, @strLoca
|