Reports on Inventory PLEASE HELP!!

Ok I admit it I have waited to the last minute to try and learn the report features of RMS. I have been doing some of the online course on Customer Source but I haven't found what I need yet.

I am needing two reports if possible on that runs a report by the item description that list the cost of the item, the number sold during the year, and the quanity on hand currently.

The second report I need to run is by supplier, listing the item description, cost of the item, the number of items sold and the quanity on hand.

Lastly is it possible to run a report that lists the "avg" cost if we received the item in at different prices throughout the year?

Any help on these report would be greatly appreciated and do you all have suggestions at were in customer source to brush up on how to do reports?

Reply to
Lisa
Loading thread data ...

Ok I admit it I have waited to the last minute to try and learn the report features of RMS. I have been doing some of the online course on Customer Source but I haven't found what I need yet.

I am needing two reports if possible on that runs a report by the item description that list the cost of the item, the number sold during the year, and the quanity on hand currently.

The second report I need to run is by supplier, listing the item description, cost of the item, the number of items sold and the quanity on hand.

Lastly is it possible to run a report that lists the "avg" cost if we received the item in at different prices throughout the year?

Any help on these report would be greatly appreciated and do you all have suggestions at were in customer source to brush up on how to do reports?

Reply to
CptSoft

report. Drag the Item column to the left , so its the first column. Right click on the body of the report, Show/Hide Columns, add the Cost, On Hand and Supplier columns. Maybe get rid of the Department and Category column. Ok it and then Collapse All Groups icon on the top, (8th one over).

displayed on the Items | General tab and Pricing tab.

tab | Cost Update Method section | select Average Cost

Reply to
Lisa

Hi Lisa,

Retail Analytics from Professional Advantage is designed to help retailers manage their business by delivering analytical reporting on business performance. Easily identify trends, buying patterns, seasonality, and other key performance indicators for your business.

The report that you are looking for is easily created using Retail Analytics. We offer demonstrations of the product on client's RMS data at no cost. If this is something that you would be interested in, please let me know.

Thanks,

Jen snipped-for-privacy@profad.com

"Lisa" wrote:

Reply to
Jen Losch

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.