hqclient running 401

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

Reply to
MarkD
Loading thread data ...

Reply to
MarkD

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.

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.