We created the items at HQ level and to transfer the items to the stores run the worksheet no 250 and approved. Even though the HQ client run successfully without any errors still items not transferred from HQ to Stores. Could I know what is the problem.
Regards
Damodar
*This post is locked for comments
Hi Gerald
Actually what i observed is when running the worksheet 250 after selecting the items there will be a screen open with General,Content and History tabs.In the general tab of screen at lower right it is showing the store name multiple times.So after approving the worksheet if go the Admin--> worksheet there its not showing that worksheet is approved(not in blue color) and also store name is missing and if we go and check contentts tab no items displaying.If i run the HQ client items not updating at sores.
So what i have done is when running the worksheet instead of click Approve button i just click the OK button.Then i go to Admin-->worksheet open the properties of the 250 worksheet in the general tab i will select the store name and also in contents tab i will also select the items manually, after that if i click on Approve button.Its showing as Approved worksheet(Blue color).Now if i run the HQ client now items updating at stores.
we have only one stores.
what i have done is we have taken backups from HQ and stores and restored the same checked worksheets showing as approved and store name not showing as multiple times and also transferring items.
What is the problem , if i uninstall and install the HQ manager will it solve the problem.
Please let me know for any solution its a very serious problem.Not at all getting any solution.
Thanks & Regards
Damodar
You guys are not listening. Damodar says his uploads are good but his downloads are not. So what, then. Permissions> Firewalls? Ports?
If you check File | Configuration in HQ Client are you able to successfully 'Test Database Connection"?
This is kind of a shot in the dark, but did you enable enable openrowsetand openrowsource support in the surface area configurations at the store levels?
Thanks Jerry,
Really it is interesting to me also . I am trying to explain the process what i am doing to transfer the data from HQ to Stores. Now i created 10 Items at Head Office . So i need to transfer the data from HQ to Stores.
we have One store only
a) HQ Manager - > Worksheets - > Click on the Worksheet Update Inventory - Items
b) System open the screen with default store name and Click Next
c) Again Click Next
d) Here i selected the Options All ( because what ever the items i created it should effect.
e) Click Finish
f) Now I can able to view the screen with Strores ID in the General tab and in the Contents Tab All Items ( because i selected the ALL option)
g) Now I will approve the worksheet , then the work sheet status colour will become blue.
h) Now i will run the HQ Client at store level , data has not transfered.
j) Now Go to Admin - > Click Worksheets - > Select the 250 work sheet - > Click properties.
here i could not able to view the store ID in the General Tab and Items also disappearing in the Contents tab.
This is problem what i am facing .
I request you to please share the problem or mistake what we are doing.
That is interesting. I understand the worksheet process pretty well, as I had to write a number of automated ones. Could you explain to, step by step, the process when it fails? You do a manual sheet, fire off the client manually, it works, right? So when does it fail?
Thanks,
-Jerry
Thanks Jerry,
Generally if we add any new items/ Suppliers / Tenders and run the respective worksheet with status approved . Then if you run the HQ client system will transfer that newly created data to stores.
The above process is genral process.
when it comes to our system One more thing what i obseved is if i add the items / suppliers / tenders to the contens tab of respecitve worksheets manully and approve the worksheet . Then if user run the HQ client that Masters data is updating at store level.
If the user add the newly created data manually to worksheet then data is transfering to stores.
Could i know why this happening like this ?
One more thing -- check your incoming permissions on your local firewalls & routers, maybe you are blocking port 34202 somewhere.
Well, let me say you should run the client in debug mode and that might help tell you what is going on, along with event logs in the local and server. you might have write permission issues on the local machines.
You could try syncing the local and hq with a 101 worksheet.
Keep us posted and good luck!
-Jerry
jerry@jrdata.us
Thanks Jerry ,
That worksheet 401 runs successfully and transfer the transaction data from store to HQ . This worksheet 401 runs for every 6 hours. The problem with rest of the worksheets like i mentioned above.
Please help me to comeout from this problem.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,289
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
