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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Item Cost per store va...
Microsoft Dynamics RMS (Archived)

Item Cost per store values

(0) ShareShare
ReportReport
Posted on by Antonijo Todorovik 4,025

Hi everyone.

I have notices a strange issue in an RMS HQ environment: the cost per store values, in the Item properties (Store Cost tab), are shown in strange format, alphanumerical value, where it should be decimal, double or is same cases integer… The values have formats like “2o0e2” or “12o0e30” or similar…

I’ve tried changing the global Item cost configuration in RMS HQ and RMS Store Ops, but no results…

The information stored on SQL level, ItemDynamic table, is correct. I have double-checked this with a personal report I have done.

Is this a known issue or I’m missing something?

Regards, A.

*This post is locked for comments

I have the same question (0)
  • Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Item Cost per store values

    Hi Shawn.

    Done that, different machines with RMS HQ, but same incorrect values, no changes. Also, I've re-installed RMS HQ and the same... I'm trying something new, by changing the regional settings of the database server and SQL collation, to see if it works... When I have the results, will publish it here...

  • Shawn Meade Profile Picture
    Shawn Meade on at
    RE: Item Cost per store values

    Hello Antonijo,

    I would recommend checking the other machines using HQ Manager to see if that has the same issue.  If the problem is with the application on one machine, then you should try to re-install Headquarters.  Otherwise, restore a backup of the database and see if the issue persists.  

    Best Regards,

    Shawn with Microsoft Retail Support.

  • Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Item Cost per store values

    Hi Jeff,

    Thanks for the reply. I have tryed what you have suggested, step by step, just in case done everything twice, but no results...

    I think the problem is a bug in RMS, in the Item property form, as the value in the SQL table is correct and it's updated correctly each time I make a cost change in the store...

    Any other ideas?

    Regards, A.  

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    RE: Item Cost per store values

    Has the database ever been opened in Excel? One should never use the live database.

    To fix, I would start by re-indexing and run a database check at HQ and the Store(s), then at HQ, do a 501 for each store and then run a 190 task to update the info at HQ.

    Also make sure that you are on the same version of RMS on all machines in the enterprise.

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans