web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Customer purchase hist...
Small and medium business | Business Central, N...
Answered

Customer purchase history not being updated in HQ

(0) ShareShare
ReportReport
Posted on by eBank 84

I have a customer that looks at HQ Customers and some of the things under "Purchase History" don't populate like they do on the local DB.

Reference, Item Lookup Code, and Description are all black in HQ.

I tried running a 402 and setting the date back to '17 to see if it would pull that information.  It didn't.

Any suggestions?

TIA!

-Cris :)

I have the same question (0)
  • Verified answer
    ToddB Profile Picture
    ToddB on at
    RE: Customer purchase history not being updated in HQ

    Hi Cris,

    If the Item Lookup Code and Description are blank in HQ my guess is there were items created at the store; and data for items created at the store will not sync up to HQ.

    However, you could try running a backdated 401 (Request Data Upload) instead of a backdated 402 (Request Journal Upload) to see if that makes any difference.

    ________________________________

    Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:

    https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

    https://support.microsoft.com/en-us/lifecycle/search?alpha=dynamics%20retail%20management%20system

    .pastedimage1596231551666v1.png

    This is less than 12 months from now; and you can continue using RMS after this date but technical support will not be available.

    I would recommend checking with your partner in regard to what they may recommend as a replacement system after the extended support end date.

    Please let me know if this answers your question

  • eBank Profile Picture
    eBank 84 on at
    RE: Customer purchase history not being updated in HQ

    Thanks, Todd!  I'll give that a go...

  • eBank Profile Picture
    eBank 84 on at
    RE: Customer purchase history not being updated in HQ

    This worked (a bit).  I might need to do it year by year to get it all to sync.  Some things were still missing, but I will rerun to see if more data syncs each time.

    Appreciate the help!

  • ToddB Profile Picture
    ToddB on at
    RE: Customer purchase history not being updated in HQ

    Hi Cris,

    Thank you for the update.

    If you run the below query at the store, and there are any results, any transaction history related to the items returned will not be uploaded to Headquarters no matter which worksheet is run.

    select * from item where HQID = 0

    It indicates the items were created locally, at the store, instead of being created in Headquarters and sent to the store.

    Hopefully this helps.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,160

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,943

#3
Sumit Singh Profile Picture

Sumit Singh 2,823

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans