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
 
23 June

Preactor Version 11 is now available!
Including the all new Material Explorer.
Watch the video here:
 
 


06:01 GMT  |  Read comments(0)

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.


05:58 GMT  |  Read comments(0)

26 April

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!



02:51 GMT  |  Read comments(0)

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.



02:27 GMT  |  Read comments(0)

10 April

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?


02:26 GMT  |  Read comments(1)

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
 


02:46 GMT  |  Read comments(0)

16 March

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!

 


05:20 GMT  |  Read comments(0)

08 March

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??

 



13:34 GMT  |  Read comments(0)

05 March

Sage Fin & Ops tip - today's date
On any Sage 1000 Fin and Ops or Line 500 date field you can add today's date just by typing an equals = sign and then enter!
Try it - especially useful if your products have traceability  = F and you have to keep entering Inspection Date = ??/??/??
 


06:16 GMT  |  Read comments(0)

Anyone understand FORWARD and BACKWARD scheduling?
Will post some more later.......


05:35 GMT  |  Read comments(0)

The first sl-ect blog.......
In time we will be ading tips and advice, helpful links, slide shows etc etc for anyone with an interest in Sage ERP 1000, Sage Line 500, Preactor, SQL Reporting Services and more. 
 


04:15 GMT  |  Read comments(1)

 

 

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

Do you want to know NOW or next MONDAY?

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