We are testing the 401 worksheet and it seems to be downloading all global customers every time we run the 401.
here is the code that it seems to be running every time we do a 401 even though there have been no changes to global customers or sales.
UPDATE [Transaction] SET CustomerID = CustomerID WHERE CustomerID = 1693775
UPDATE [TransactionHold] SET CustomerID = CustomerID WHERE CustomerID 1693775
UPDATE [AccountReceivable] SET CustomerID = CustomerID WHERE CustomerID 1693775
UPDATE [Order] SET CustomerID = CustomerID WHERE CustomerID = 1693775
UPDATE [Payment] SET CustomerID = CustomerID WHERE CustomerID = 1693775
UPDATE [Journal] SET CustomerID = CustomerID WHERE CustomerID = 1693775
UPDATE [TransactionEntry] SET ItemID = ItemID
FROM [TransactionEntry] INNER JOIN [Transaction]
ON [TransactionEntry].TransactionNumber = [Transaction].TransactionNumber
WHERE [Transaction].CustomerID = 1693775
SELECT @@ROWCOUNT AS RecordsAffected thanks mark