web
You’re offline. This is a read only version of the page.
close
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) / Setting up a new matri...
Microsoft Dynamics RMS (Archived)

Setting up a new matrix item in RMS Retail

(0) ShareShare
ReportReport
Posted on by Ivor Williams 65

I am very new to RMS Retail and I need to set up a large number of matrix stock items which have  56 colours*16 different sizes, to use the system with both items in the matrix would mean 1 item X 56 Colours X16 Sizes (Big Data Base)?
Please also can someone advise the best way in setting up these items.

Also how do I do the following:-
1.How can i set these up so that the stock on hand reads zero on them all.
2.How can i set up the selling commision on each item.
3. I also need to set up a different cost price and selling price for sizes over
18 to 20 and sizes 22 to 28 how can i do this using the same master item
number.
4. I am new to this system, so am I setting up my stock items correclty, we
have a style reference for each gowns, these them have 56 different colours
and 16 different sizes. i am using the style ref from the supplier for quick
ref and then we are setting up the Component items as follows Dimension(1)
Colour, Dimension(2) Sizes, which is given us 1 master and 896 single items, this will take me forever to adjust stock on hand and other fixed information.eg Photo, sizes,colour,commsion rate the list goes on.
Any bright ideas, would be greatly appreciated.

PLEASE ANYONE
Ray Williams

*This post is locked for comments

I have the same question (0)
  • Lori Penor [MSFT] Profile Picture
    Lori Penor [MSFT] on at

    Hi Ray -

    Thank you for posting to the forums and using Microsoft Dynamics RMS. We're excited to have you as a customer! Since you are new to RMS, I would suggest speaking with your partner who may be able to provide guidance for your specific business and requirements. However, please find my answers to your questions inline below.

     1. I may not understand your question and may need some more details here. When you create a new matrix item, it automatically sets Quantity on Hand to 0. Are you seeing something different?

    2. To set up selling commissions, you must open the Item properties page and then choose the Commissions tab. If you wish to bulk edit the items, I would suggest working with your partner to utilize a T-SQL statement that will modify the database directly. However, anytime you edit the database directly, you must be very careful. As mentioned earlier, I would recommend working with your partner on this.

    3. On the master item, choose the Component Items tab. In the lower left, choose Filter, and then select only the appropriate sizes you wish to adjust. This will now filter the Component items grid. Next, select the Choose Columns button. From here, add the Cost field and any Price fields you wish to adjust and select OK. You can now edit the component items in the grid.

     4. As in 2. above, your only option would be to utilize a T-SQL statement to modify your database directly. Again, I would strongly encourage you to work with your partner on this. Additionally, you could work with your partner for an add-in that may assist you in this setup.

    I will also post this in your previous message, but I would suggest you post "how to" questions in our community boards where you'll find others asking similar questions: http://www.microsoft.com/BusinessSolutions/Community/NewsgroupLanding.aspx

    I hope this helps.

    Lori Penor

     

  • Eugenio Leijten Profile Picture
    Eugenio Leijten 5 on at

     You could always consider looking at an Add-In like RTL Matrix or RTL Matrix Pro.

     

     

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November 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