Purchase history and projected usage

On a somewhat related note, I have a hard time determining when I need to place an order with a supplier of matrix items. Since each size/color is actually a seperate item in the database, it is hard to see sales and inventory level as a group. For example, I sell rubber boots in 10 different sizes. I am not going to place an order with my supplier just because I am low on size 6 boots, but if I know collectively that I sold 400 total boots in the last month and I have only 200 remaining, I obviously need to place an order.

How can I do an inventory movement report on matrix items (HQ environment)?

hi i have already develop the solution of your worries these reports i have develop for runningcompany.com of kris and he paid me money too for this. let me know if you need this and what exactly are your requirement I will do this for you.

"Jas> On a somewhat related note, I have a hard time determining when I need to

Hi there,

Professional Advantage has the Retail Analytics and Merchandise Planning (RAMP) product available for RMS HQ customers. Are you currently using HQ? RAMP delivers the information required to analyze and effectively manage the inventory and buying processes. The system suggests store transfers and purchase orders that can be analyzed and fine-tuned by the buyer. Once the buyer approves these activities they are generated as transactions in the Microsoft Retail Management System.

If you have any other questions or would like more information, please feel free to contact me at snipped-for-privacy@profad.com.

Thanks,

Jen Losch Professional Advantage

note, I have a hard time determining when I need to

We have this in version 2.0 of our RMS add-in, Savitas Advanced Reports for RMS.

We are just about ready to release version 2.0, if you would like a beta copy we may be able to arrange this.

With one of our reports, you can analzye a time period, and based on those sales and your days of inventory setting, it will tell you how much excess or short inventory you have. Of course you can also use this for planning. If you would like more input parameters for analytical calculations in the report we can arrange that too, or customize the report for your installation.

Contact us for more details

Jamieson Gill snipped-for-privacy@savitas.net