REP Campaign

REP: Reports and Enquiries Pack for Sage™ 1000 / Line 500

REP has been designed for easy access to your Sage™ data, delivering information to the people making decisions in your business.

Have you ever asked yourself any of the following.....

“Why can’t I have a MRP recommendations report that drills down to Predict Future Stock?”

“How do I find all the products that are expected to have stock below zero if we don’t take action?”

“Why is it so hard to browse for a product and then find the future POs or past receipts from suppliers?”

“Where can I find out what we spent with a supplier this year?”

“Which data tables were added to by doing that transaction?”

“Who changed that standard cost?”

REP can answer these questions!

Integrated drill-downs allow users to quickly switch screens, without having to write down the code and key it into another menu option.

Think of it as a set of new enquiries, which can be printed if you wish. Or exported to various formats such as Excel or PDF.

And all reports can be added to a schedule for delivery by email to a group of recipients at a specific time.

To arrange a demonstration either reply to this email OR register your interest online: Here

Latest News: Stock Search has been re-designed. Click once to view screens for Status, Costing, MRP fields etc.

Plus a drill down added to view the Stock Audit of standard cost changes.

www.sl-ect.co.uk/REP_StockSearch.aspx

Pack Contents

MRP and Supply-Demand

MRP Summary. View Think of it as Predict Future Stock turned on its side in the style of a pivot table. Therefore many products can be easily viewed at once. Or the report can shrink to show only the "hotspots" where the future stock balance is negative. Considers supply and demand for all warehouses of a given product, although QA warehouses can be excluded on a system key. Features a drill down to PFS.

Run it just after Sage™ MRP processing and use it as an alternative to the standard MRP analysis report. There will be at most 6 lines per product, leading to a much more concise report. The drill to PFS shows the full detail if needed. Predicted stock balance is calculated twice - once including the effect of MRP recommendations, once without to show the underlying problems.
Use it in between MRP runs to view products that have suddenly gone into a negative balance, perhaps because of a stock adjustment or changes to firm orders.
Supplier Forecast / Vendor Schedule for the next 12 months: extend your Sales Forecast or MPS to cover a longer period, run MRP and then use this report to project the future demands per supplier.

PFS. View A "predict future stock" style screen. Again multi warehouse. With a coloured bar to indicate whether each order is inside the lead time or not. With week numbers, sales order allocations, drill to WO Trial Kit, a 2nd balance column to show the effects of MRP recommendations, and MRP recommendations have colour coding and a human readable description.
WO Trial Kit (Single WO). View Enter a WO number to see whether it can be kitted from stock. Each material line shows a summary of the future supply and demand and has a drill down to PFS in order to easily see who to call to try and bring the supply forward. Takes into account earlier demands for common materials.
WO Trial Kit Shortages. As per to WO Trial Kit above, but this is for ALL WOs up to a cut off date. The screen only shows items that can't be kitted, taking into account earlier demands for common materials.
BOM Critical Path. Enter a top level (sales) product and quantity, then expand all levels of the BOM to find the longest cumulative lead time and check stock availability. From which you can estimate a rough-cut promise date for the order.

Purchasing

PO List. View List all Purchase Orders, open for receipts, open for invoicing or closed, for a supplier or product. Include archived orders. PPV calculation.

· PO Search. Wildcard search through PO lines - especially useful if you use generic service codes and overtype the PO line long description. E.g. enter "%safety boots%" to find recent suppliers and prices

PO Pivot. View Find POs per supplier / product / week in a pivot table style. Drill down to PO List.
PO Receipts. A list of recent receipts per PO or product, avoiding the need to pick them out from the Stock History screen. Drill to it from other reports.
PO Invoices. A list of recently entered POP invoices. Drill to it from other reports.
PO Details Audit - Value Changes. Uses Sage™ Auditing to track all changes to a PO that have affected the value. Or lines added at zero price.
PO Enquiry. Concise PO information, with drill downs to see the receipt and invoice details.
Supplier Search. View List all suppliers that match the entered wildcard string. Drill down to PO List or Supplier Spend.
Supplier Spend. View View year on year totals of quantity and value per supplier. Expand to show individual products within the supplier.

Supplier Spend by Product. As above but by product with expansion to supplier detail. Find the last supplier or last price.
Supplier Forecast / Vendor Schedule. A simplified version of the MRP Summary that can be sent to each supplier and used as a vendor schedule.

Stock / SOP / System

Table Row Count. View Find which Sage™ data tables have the highest record counts so that you can monitor which tables need archiving. Or run a Sage™ transaction and use this to see which tables get more / less records - very useful for report writing.
Stock Search / Status. View List all products that match the entered wildcard string. Eg. %RAM% will find all RAMP and FRAME related products. Searches through various fields such as product, descriptions, alpha, supplier info etc. Find a product and click to drill to other reports such as PFS, Stock Batches, Stock History, Stock Audit and PO List. View Stock Status and the other Full Stock Details pages fields with one click.
Stock Batches. View stock batches per warehouse / bin for any product. Only shows those batches with Qty > 0. Drill to it from PFS and Stock Search.
Stock History + Time. Regular stock history, and if Auditing added it can show the time of the transaction and the program used. Drill to it from Stock Search.
Stock Audit - Costs. Track changes to standard costs, and the associated change in stock value.
REP Links. Used to present all the reports and their drill downs, but can actually be used as a menus system for the reports.
Report Usage. This tracks who has run which reports in the entire SSRS report server (not just REP screens). Also shows the date/time, whether the run failed or not, the time taken and the parameters.
SO Details Audit - Value Changes. Uses Sage™ Auditing to track all changes to a Sales Order that have affected the value.