Home     Preactor®     riteTIME     Sage User Network     REPorts for Sage     WO Receipts     Sage Reporting Services     SQL Reporting Services     Std Costing     Downloads     Blog      
Blog              View and comment here: sl-ect blog
 
 
 

Some things you can do with the Sage system

14 Things You Can Do With Sage ERP 1000 / Line 500

     1) View all the main Full Stock Details and Stock Status fields on one page

     2) Show the TIME of a transaction in Stock History. 

     3) Find all the products that are expected to have stock below zero (or the ROL) at some point in the future.  

     4) Use an MRP recommendations report that can be edited in Excel, with a drill down to Predict Future Stock. 

     5) View what you have spent with a supplier by year / period.

     6) List which data tables were added to by doing a transaction - to know where to look for the data.

     7) Track who has changed a standard cost, when they did it, and the before and after values to find the change in stock value. 

     8) Report on all changes and additions to Sales Order lines.  

     9) Report on all changes and additions to Purchase Order lines. 

   10) Explode a BOM to all levels and view this in Excel. 

   11) Enter a top level (sales) product and quantity, then explode the BOM to find the longest cumulative lead time

         and check stock availability. From which you can estimate a promise date for a new sales order. 

   12) Force WO Completions to take component stock ONLY from specified "backflush bins".  

   13) Automate the entry of timesheets to get real time labour hours and WIP Tracking data. 

   14) Stop all those "Bring PO forward" MRP recommendations by driving the MRP from an achievable production plan

For full details click here 

Preactor Version 11 is now available!

Including the all new Material Explorer.
Watch the video here: http://sl-ect.co.uk/preactor.aspx 
  

Tip: Add notes to a PO after calling the supplier

If you need to put a note (eg. latest info from the supplier) against a PO line, use the “F3-Text” button to get 5 text lines.

Preactor Case Study for Universal Products is now available!

The new case study for Preactor at Universal Products Ltd can be found here:

http://www.preactor.com/Case-Study/Case-Studies/Universal-Products-(Lytham)-Manufacturing-Ltd-(UPL.aspx

Take a look!

Forward versus Backward scheduling – What’s the difference?

Forward Scheduling

A Preactor system will NOT plan jobs in the past. So a forward schedule starts at TODAY and takes each job by priority and puts it on the planning board in the first available slot. Depending on the availability of machines due shift patterns and other more important jobs already planned on the required machine.

So a forward plan tells you:

  • The earliest time that you can finish an order
  • How long you can keep a machine constantly running (as long as there is feed of materials from earlier processes / purchasing)

The resulting schedule Gantt chart will show jobs bunched up to the left hand side of the timeline.

So it tends to increase WIP. And makes it difficult to get sensible promise dates for new orders because just adding them onto the schedule could result in the new order being late and an order placed weeks ago being very early. Maybe the orders have the same required date and BOTH could be on time if the whole system is re-planned!

 

Backward Scheduling

The Sage 1000 MRP program is a backward schedule!

It works back from the top level required date on a Sales order or forecast, calculating start / end dates for each level of BOM, using the lead times.

Often this suggests start dates that are in the past, even though the MRP program has no restriction on machine / people capacity.

 

With a Preactor finite capacity schedule this could be even “worse”. Preactor only lets one job be planned on each machine at a time, so if there is a long bottleneck on a resource then it too will try to plan things in the past. But Preactor deals with this in a different way to MRP, because it refuses to schedule the operations that would need to run before today on a backward schedule.

Leaving the planner to do something about them.

The resulting schedule Gantt chart will show jobs more to the right hand side of the timeline, and you will be able to see gaps in the middle where new orders can be placed without affecting the expected dates of existing orders.  

 

A Good Compromise

Just one idea, there are others:

  • Run a FORWARD schedule
  • Let Preactor highlight the EARLY operations
  • Un-schedule the early orders (or those more than say 5 days early)
  • Re-schedule them with a BACKWARD run

If the ops were EARLY on a FORWARD, they are bound to still FIT on a BACKWARD, without going into the past!

The end result being a plan where urgent or potentially late orders are planned to run ASAP, the rest are planned to finish when they are needed.

So they don’t start until they really need to , so WIP is reduced and MRP for purchasing can be set to only bring material in on dates where it is actually needed.

Reducing stock holding costs and freeing up cash and warehouse space!

The plan will also show gaps where new orders can be added.

Week Number for pivot tables on Sage ERP data

Here’s how to how to convert any date into a week number.
For example, you could create a SQL View on the stkhstm table and then convert the movement date field to a week number.
Then pull the data into an Excel pivot table for instant totalling of quantity or value with week numbers going across the page.
Download a SQL Function slectrep_ISOweek.sql from here: http://sl-ect.co.uk/downloads.aspx
Then put this into your SQL code:  LEFT(scheme.slectrep_ISOweek(scheme.stkhstm.dated), 7) AS yy_wk
Uses the ISO system so it should get it right even if 30th December this year is actually week 1 of next year!
We use it in our Predict Future Stock screen and other REP reports: http://sl-ect.co.uk/REP.aspx
 

Reporting Services or Qlikview???

Which is the better tool for Sage ERP 1000 companies? Qlikview or SQL Server Reporting Services (SSRS) ?
We have a report pack for Sage using SSRS (Download more info here: http://sl-ect.co.uk/REP.aspx
Should we convert to Qlikview or maintain 2 sets of reports to support both bits of software?
Has anyone used both tools and can offer some pros and cons?

Sage Line 500 User Login Name

Problem: There is no field in users table (usermastm) to hold a name.

Solution: But the “fast menu” field is obsolete now, so use that for a person’s name and see it in the F2 browse!

 

RE: Master Production Schedule anybody?

Just posted this question on the Sage User Network forum, so I’ll ask it here too……

I’m trying to find some good 3rd party MPS software. Maybe it would create the sales forecast from history and sales person knowledge and promotional activity. But more importantly it needs to turn this into a MPS, taking into account the current stocks, production plans and firm sales orders. There should be an easy to use interface (we’re competing with Excel here!) where the planner can modify the (system) calculated production plan as he/she sees fit. This should then be able to be published as an Available To Promise (ATP) enquiry for sales dept to use. The final MPS would also be pushed into Sage to drive MRP for the lower BOM levels. And it should be able to accept back a true forward scheduled plan (maybe from Preactor) so that the dates used in the ATP and the next MPS represent a realistic capacity constrained plan of what you will be making in the short term.
As you might imagine, this is very suitable for FMCG companies. Which reminds me – it should be able to cope with minimum stock levels expressed in terms of "days cover" rather than just a fixed stock quantity.
Anyone know of such a thing??

 

 

Preactor & Sage PDF (1.3MB): Flyer

Sage Interface PDF (1.1MB): Flyer

Testimonials & Case Studies: Link


 

Sage MRP Reports? Predict Future Stock? Auditing reports? Supplier Spend?

More Info

Slideshow

 


It's 3:00pm TUESDAY. Your factory is running at an efficiency of 68%.

Do you want to find out NOW or next MONDAY?

Now includes Preactor "Mid-Batch Updates" to show real-time activity inside Preactor.

More....

 

News: On February 22nd we demonstrated riteTIME at the Sage User Network meeting. This included an integration with Sage ERP 1000 / Line 500.

View our slide show: Click here