Re-order report

(0) Share

Report

Posted on by David Lawton

A couple of questions from a newbie.

1. Can anyone tell me how I can run a report to show me at HQ, what I need to order for each of my 5 stores to take them back up to the Re-order point. I want a report to work with in Excel not a purchase order.

2. The stock valuation uses the store item cost price - we use Weighted Average costing at the stores. If I run a valuation report of store stock at HQ it uses the HQ cost price (Last cost) and this is not the average cost (and accurate value) at the shops. Is it possible to pick up the other (Store cost) field? I know that it is there on the stock record card.

We were hoping that we could centralize all aspects of the merchandising system, but so far, RMS is falling short.

Thanks in advance

*This post is locked for comments

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report

Re: Re-order report

Your solution is in one report (Item) "Snapshot Store Quantity list",
I do not remember the default RMS report design, try to have reorder poit, cost, restock level coulmns at this report.

Thank you
Mohammed El Qadi
http://www.fact.fm/viewforum.php?f=30