How do I associate a nominal code with a supplier?

When a purchase line is created the associated nominal code comes from one of the following sources and in that order:-

  1. Supplier value for default.
  2. Material record.
  3. System value for default.

The relevant default (see the Processes+Show defaults menu) is in the MC module and called Material Buying Nominal Code.

So for example, to always associate a particular nominal code with a supplier (regardless of the material) create an instance of the default for that supplier.

You can do that by going into the detail of the supplier, clicking the Defaults button and then creating a supplier instance with the New button. The Selected Default will be as above. Set the value as required

How do I make specifying an expiry date mandatory when booking in?

Materials can be specified to have a shelf life by clicking the Set Size Profile button from the detail of any material record, then clicking on the Usage tab and entering the shelf life in days.

Each batch of that material will then automatically have an associated expiry date, based on the day it was booked in and the associated material shelf life.

If the expiry date is not always based on the associated material shelf-life, a PO default called User must specify expiry date can be set to Yes – meaning that Match-IT will not set expiry dates automatically as above, rather, the user must specify one when booking in materials with a specified shelf life. From the help text of the default:-

When set and the product being booked in has a shelf life the
user must specify an expiry date. When not set Match-IT
automatically uses the shelf-life to estimate an expiry date.

Defaults have system level values but can be overridden on a per user, work-station, site or customer/supplier basis. In the context of this default that is probably most useful when considering suppliers.

Match-IT auto-expires batches during the auto-scheduling process by giving them a state of dead, exactly as if they had been used up in the normal way. You can get a list of expired batches by using the options in the stock list browse or by dragging msiView:failures onto a ribbon menu from the Processes+GoAnywhere menu.

How do I unlock the scheduler?

Sometimes the scheduler can remain locked because a machine has crashed or the overnight schedule was interrupted. When this happens you will get messages that the scheduler is locked when you try and use it.

To manually unlock the scheduler in such circumstances, follow these steps:-

  1. From the menu bar at the top of Match-IT, select Processes and Go Anywhere.
  2. Scroll down to the TR module (see column 1) or type TR+Enter to auto locate to it.
  3. Select the line called Facility Locks.
  4. Click Execute.
  5. Select the Scheduler lock line (as per the Name column).
  6. Click Unlock.

Alternatively, go into the re-scheduler and use the buttons in the Tools tab.

How do I unapprove an exported invoice?

After an invoice (sales or purchase) has been exported to accounts, Match-IT does not allow that invoice to be unapproved.

If you go into the invoice detail and select the Audit tab, you can clear the Exported On date; after which Match-IT will allow you to unapprove the invoice.

i.e. You are manually taking responsibility for the potential inconsistency of an invoice in accounts and now potentially removable in Match-IT.

We protect the unapprove action like this to conform to BS/ISO requirements.

How do I choose between Legacy and Contemporary batch scan order?

In very early versions of Match-IT the stock allocator was very simple and allocated stock on the basis of first-come-first-served and it allocated physical stock first and when that ran out allocated in-production stock or scheduled more production.

Intuitively that sounds correct, but in practice it leads to delivery compromises. Consider this simple situation using this legacy scheme:

  1. You have 100 widgets in stock.
  2. It takes 2 weeks to make a batch of widgets.
  3. An order arrives for 100 widgets due for delivery in 4 weeks time.
  4. The 100 widgets in stock are allocated to this order – you can meet the delivery date

Everything is fine so far. But, now consider what happens if another order is received for delivery next week. There is no physical stock left because the prior job has it, so a new batch has to be made and that takes 2 weeks, making this new job late!

With modern versions of Match-IT its stock allocator is far more sophisticated and can accommodate this scenario without compromising either job. It does this by treating physical stock as precious. What that means is that it tries to hang on to physical stock for as long as possible, leaving it available to allow you to be more agile. In the above example the allocator does as before when there is only the one order, but when the new order arrives this happens:

Pass 1

  1. Physical stock is allocated to order 1 – its on-time.
  2. A new batch is scheduled for production for order 2 – its late.

Pass 2

  1. The allocator notices that the new batch is on-time for order 1 so uses it, leaving the physical stock in place – its still on-time.
  2. The physical stock is still available for order 2, so its allocated – order 2 is on-time as well now.

You might ask “What happens if there are delays in production?” Could that cause order 1 to be compromised? The answer is no. The reason is that the scheduler is continually monitoring the situation and as soon as it notices that the batch in production is going to be too late for order 1, it will grab the physical stock back because it has priority. This means the lower priority order 2 job is compromised instead – as it should be.

This is a very simple example. Things can get far more complex when you are dealing with large assemblies with lots of common parts across different sub-assemblies. The stock allocator can cope with that too. Here’s a real life example that triggered the development of this new allocator (many years ago now):

This is what would happen with the legacy allocator:-

  1. You have a large contract due for delivery in 6 months, in that there are large numbers of sub-assemblies all needing lots of special bolts that take 3 months to make – the bolts are the critical path, the whole job can be made in 3 months once the bolts arrive.
  2. You have sufficient bolts in stock to meet this job (just).
  3. This large contract is very important so it has top priority.
  4. The stock allocator allocates the physical stock to this job – exhausting it.
  5. The next priority job also wants some of these bolts, but there are none in stock so has to order more, and wait 3 months for them to arrive.
  6. And the next..
  7. And the next….

So all short term jobs are compromised for the lack of a few bolts!

The modern allocator prevents this.

To use the modern allocator set the Use legacy batch scan order default to No. This default is in the XP module.

Why do I get “access denied” sometimes when repairing a file?

Sometimes when trying to recover a damaged file windoze will report an “Access Denied” error and not let the repair happen.

The most likely reason for this is that a file lock has been left in-place from some other session. A useful trick to force Windows to relinquish such file locks, is to temporarily remove the network share that other stations are using to access Match-IT.

So, for example, if other stations are accessing Match-IT through a mapped drive M: that is mapped to something like \\server\match-it, go to the physical location of that folder on the server, you will see a ‘hand’ symbol under the folder name to indicate it is being shared, right-click on it, select Security and sharing, then un-check the share this folder option. Windows will warn you that you are forcing users off – good, that is what is required. Confirm it, do the repair, then re-share it again afterwards.

Make sure when you re-share that you give everyone full control (use the Permissions button).

If you are using remote desktop and terminal services to run Match-IT this technique will not work because there will (usually) be no mapped drive to un-share. In this situation it may be that there are stopped sessions on the server holding file locks. The brutal way to deal with this is to bring up the task manager on the server and stop all processes with the name match_go.exe.

How do I run Match-IT as an administrator?

Match-IT needs to configure various Windows components at times including the registry and firewall settings. Even if you are logged into Windows as Admistrator or have administrative privileges, Windows will sometimes refuse to cooperate and you will get a message asking you to “Run Match-IT as Adminstrator” or words to that effect.

To do this, close Match-IT and then right-click on the Match-IT icon and select the menu item that says Run Match-IT as Administrator. Then log in to Match-IT in the usual way. If you received the original message after performing a specific operation, please try again and this time the Windows configuration Match-IT was attempting should succeed. In the case of firewall based original messages, it’s best to leave Match-IT logged in in this way for at least 15 minutes while performing your usual tasks.

 

How do I add an extra line to a purchase invoice?

By extra line we mean a line that is not associated with a purchase order and/or does not have a material code. For example a carriage or handling charge.

While in the purchase invoice detail:-

  • Click New to add a new line.
  • Tick the Extra line checkbox.
  • Click on the Extra line tab (tab 3) and add a description.

You can optionally link to a PO line but it is not necessary.

Choosing Between Outlook 32 or 64 bit

Reblogged from Slipstick Systems.

A popular question on many forums goes something like this

Outlook isn’t recognized by [application_name]. The error is “Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default client.” When I check the Default Programs, Microsoft Outlook is the default for everything.

First and foremost, when you receive this message with Outlook 2010 or Outlook 2013 64-bit, try the 32-bit version of Office. While some applications and addins work with the 64-bit version, not all do. Unless you need to open large (2 GB) Excel and Access files, you won’t benefit the 64-bit version. Wanting to use the 64-bit version because you use a 64-bit operating system isn’t enough reason to use it, if you need compatibility between different applications, you’ll need to stick with the 32-bit build.

Click here to read more.

How to get an accumulating estimated cost breakdown

When you calculate the estimated costs of a material there is an option to get a cost breakdown.  By default the resulting list shows inclusive sub-module costs hierarchically, which means that the columns cannot be accumulated to the total because of the hierarchy.

Often a cost breakdown that shows accumulating costs is needed.

To do this go into the Options tab and tick the options as below:-

cost1

Then go back to the Detail tab and click the Expand button.

The Contrib cost and 1-off cost columns now show the component costs in a non-hierarchical manner and they will accumulate to the total.

cost2

click image to enlarge

Note that while the contributing and 1-off total costs are accurate, being built up from fractional sub-costs while scheduling,  there may be some rounding errors because of the component costs having to be itemised out.

click image to enlarge

If the Constraints column shows Minimum constraints applied it means that Match-IT has had to purchase or make a minimum quantity (more than needed) the remainder of which will be available for use other orders.  In the example shown, 200 sheets of material needed to be bought as a minimum from the supplier.