Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Store is not uploading...
Microsoft Dynamics RMS (Archived)

Store is not uploading data to HQ

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I am running one HQ with multiple stores. Last Saturday there was some problem in HQServer.exe and almost all the stores have several transaction which are not being uploaded to HQ database, causing discrepancies like sales, customer balance etc. Transactions are are available in store database but not being uploaded in HQ.     Missing transaction only relate to single day [Saturday].

I have tried Worksheet Style 401 [Request Data Upload] and 402 [Request Journal Upload] but no luck.

Any Help??????

Thanks and Regards

Abdul Razak

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store is not uploading data to HQ

    Abdulrazak,

    For MGordan's reply, it might work and might not, according to the problem cause, so try it first for one store and see if it succeeds, simply create a 401 with one day 'From' date ealier.

    The reply of J.arun is useful but u need to consider more tables, the purpose of thises queries is to increase the timestamp value which will force the missing records even if the 401 is not backdated.

    U need to consider the Batch, TaxEntry, DailySales as well, I think more tables should be considered, so I will look in my old files to find the fix script I wrote long time ago and post it to your shortly

    A Nashat

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store is not uploading data to HQ

    Run below SQL in your store database and then run a 401 as usual.

    Update [Transaction] set storeID = StoreID where [Time] between '2015-02-28 00:00:01.000' and '2015-02-28 23:59:59.000'

    Update [TransactionEntry] set storeID = StoreID where [TransactionNumber] in

    (Select [TransactionNumber] from [Transaction] where [Time] between '2015-02-28 00:00:01.000' and '2015-02-28 23:59:59.000')

    Update [TenderEntry] set storeID = StoreID where [TransactionNumber] in

    (Select [TransactionNumber] from [Transaction] where [Time] between '2015-02-28 00:00:01.000' and '2015-02-28 23:59:59.000')

    I hope the date which I used in the SQL is correct. (Missing date), if not, do correct it first before executing.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store is not uploading data to HQ

    Thanks MGordon,  Du you want me to run 401 for all stores in backdate? Please explain.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Store is not uploading data to HQ

    Backdate a 401

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans