Mabuhay!
Hi! Is there anyone here experiencing no sales record being uploaded on HQ? We have Intel(R) Xeon(R) CPU e5-2630 @ 2.4GHz and 128GB Installed Memory and 112GB Database and we run Worksheet 401 for the month of July 2017 but no sales being reflected on our Headquarters Manager. Is there any possible solution that we can gather sales from store using HQ CLient by means of Worksheet 51 so I can get at least sales from their database?
Thanks
Chris
*This post is locked for comments
yes nosebleed here XD
Yes, i run that code on our storedb and no error after we run.
Emailed you the result for HQ.
Thanks
hmm.. thats odd.
Where did you execute the code i have given you? storedb or hq?
For stores that throws an error in data upload, can you query the following and email me the result.
in storedb,
Select Max(Servertime)
from Timestamplog
in hq,
Select Storeid,Max(Servertime)
from Timestamplog
group by Storeid
Mabuhay!
Yes, update inventory and inventory transfer are fine but on 401 completed with error
can you verify if the problem is on worksheet 401? Are the other worksheets functioning properly?
Mabuhay!
DECLARE @lastsuccessfulsync as DATE
SET @lastsuccessfulsync = '2017-06-01'
DELETE FROM Timestamplog
WHERE [Servertime] > @lastsuccessfulsync
The code i run :)
It should work. Can i have the exact query you executed?
Hi,
Wow thank you for your reply ;)
I encounter this error after i run the script on store and run worksheet 401 on HQ.
An error occurred while attempting to process the worksheet. Or I dont need to run 401 for this step? It will automatically generated?
Thanks
Chris
Hi,
Ok, pls follow these steps.
1. Backup your database. This query is for special cases only. Do not execute when not needed.
2. On your store db, execute the ff query:
Note: Pls change the '2017-07-19' to your last successful sync date with the given format.
Example:
If you specify 2017-07-01, the sync will reupload all data, modified/created, from july 01, 2017 and after.
DECLARE @lastsuccessfulsync as DATE
SET @lastsuccessfulsync = '2017-07-19'
DELETE FROM Timestamplog
WHERE [Servertime] > @lastsuccessfulsync
Hi Maam :)
Heheh so kulit here. Yes weve done 401 and set the date to June 2017 but still after our store connect, we cant see any HQ Sales from reports.
Any other possible solution? How to update timestamp is that From date/time tab on HQ Server?
Thanks
hi,
As i said, worksheet 51 isnt for uploading sales data. You can reupload your sales again by issuing 401 and change the date to your reference date (last successful sync). Tell me if this approach suits your needs, if not, we can update the timestamp of your sales data so that 401 can pick it up.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (