Setting up a new matrix item in RMS Retail

Last post 05-16-2008 11:24 AM by Lori Penor [MSFT]. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-08-2008 3:17 AM

    Setting up a new matrix item in RMS Retail

    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

  • 05-16-2008 11:24 AM In reply to

    Re: Setting up a new matrix item in RMS Retail

    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

     

Page 1 of 1 (2 items)