hqclient running 401

Aug 10, 2005 2 Replies

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


What RMS version are you on? There was a hot fix quite some time ago that stopped HQ from updating every Global Customer on every 401. I believe that all customers will be transferred on the first 1 or 2 worksheets anyway - but that's sort of an initial sync and should not continue.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required