Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Worksheet 501 being cr...
Small and medium business | Business Central, N...
Suggested answer

Worksheet 501 being created randomly

(0) ShareShare
ReportReport
Posted on by Shane O' Malley 380

Hi,

We are finding that a 501 is being created sometimes when a user is working on a 250.  Does not seem to happen all the time but has become more frequent since we installed Update CU5 to bring us to 2.0.2000

Happened 3 times this morning and twice yesterday.   

Used to be maybe once a month so not worth chasing down.  

The worksheet says that it was created by Item Dynamic Fix which i understood to be a feature on one of our Retail Realm products but it happens when we are creating the 250 directly within HQ.

Appreciate any ideas you might have as it freezes up the system when the 501 is running through the stores. (It also seems to be automatically approved. It is not just created waiting for approval)

Thanks

Shane

  • Shane O' Malley Profile Picture
    Shane O' Malley 380 on at
    RE: Worksheet 501 being created randomly

    Thanks Kevin,

    Read that list before. Thanks for doing it up as it was very relevant and helpful.

    Very interesting to see the number of companies using HQ struggling to find a suitable replacement. Lots of basic POS systems out there but it is the order, stock management, analytics that we need.

    Something like cloud retailer sounds great but the lack of bulk management tools is an big issue and i have not seen any localisation for the EU/Ireland market.

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,645 on at
    RE: Worksheet 501 being created randomly

    Hi Shane - thanks for sharing the resolution to the 501 issue!  I'm not sure how much this helps since this is only based on RMS users in the US that have contacted me but I've been trying to keep a log of what other RMS users are doing regarding RMS/HQ end of life: www.pospondering.com/.../what-other-microsoft-rmshq-users-are.html

  • Shane O' Malley Profile Picture
    Shane O' Malley 380 on at
    RE: Worksheet 501 being created randomly

    Not Sure.   Budget constraints have meant we did not do the move a year ago and the aim then was SAP Business 1 but reassessing now.

    Putting some options together again and hopefully will get sign off on the budget before the end of the year.

    We seem to fall between systems. Retail Hero is not a step forward as far as i can tell but SAP Business One and Microsoft Dynamics Retail seems overkill.  

  • Nishaan Profile Picture
    Nishaan 35 on at
    RE: Worksheet 501 being created randomly

    Hi Shane ,

    That is great news. What system will yourl be migratting to?

    Kind Regards

    Nishaan

  • Suggested answer
    Shane O' Malley Profile Picture
    Shane O' Malley 380 on at
    RE: Worksheet 501 being created randomly

    Actually found the cause of this behaviour.   It is caused by Retail Realm HQ Utilities and a function in that called Item Dynamic Fix.  It is a check to ensure that a product that is being amended (Say through a 250) exists in the Item Dynamic table. I am not sure why this function exists but seems to have been activated on our system for more years than i have been here so dont want to turn it off. If the item does not exist it creates a 501 (predating the 250) so that a entry is created in the Item.dynamic table.

    The fix for us is to wait after setting up a product for an hour or two until the 250 has been run in all stores and a 401 has been completed afterwards (We run them every 15 min)  We tested the solution and it seems to work.  

    Would be interested to know the reason for the Item.Dynamic.Fix in the first place but since we are probably only 6 months left on this system there is probably no good reason to change things.

    Thanks

    Shane

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,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans