You’re offline. This is a read only version of the page.
This is my first query in this forum.
I tried to run multiple reports from the RMS headquarters(store operations manager) machine and the reports are not pulling data.
To give a background we have multiple stores connected to headquarters(central server). I should be able to fetch the consolidated reports but unfortunately reports are not pulling data. When I go to each store and corresponding report I am getting data. Why the combined report not coming from headquarter ? I can able to view all the items in the database.
Alternatively I do want to write a sql query to do this. Do you know what tables I need to query in order to get the data for a particular item sales for the last three months ?
Appreciate the responses.
*This post is locked for comments
What is the table name ?
The query will depend on what you want.But the simplest query is
select * from x x being your query table
Data is already in Headquarters database. But reports are not coming from the reports utility within the Headquarters Store Operations manager.
If I need to fetch the report directly from database what is the query should I use ?
You can issue worksheet 401 to upload data from store to HQ
Hi SriniAB
Is all the data upload done?
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 (