Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • 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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans