Monday, 23 May 2016

Splitting a dispense or issue between multiple jobs

It is sometimes desirable to take a dispense or issue that has been booked against one job and re-allocate part of it against a different job, for instance if there is material left in a press sump that you want to allocate to the next job to run.

Below are instructions to carry out this action:

There are two different options to split a Dispense or Issue.

Split to matched jobs

Will only allow splitting to jobs that have the formulation that was in the dispense or issue.


Will allow booking to any job even if it does not contain the dispensed formulation.

 Clicking either option will summon the below dialog:

You click the Add button to add the jobs and screens that you wish to split the dispense between.

There are 3 options for splitting

Manual – User enters how much should go in each job.

Estimated – Set the weight for each job to the remaining estimated for that job.

Weighted Estimate – Allocate the dispense between selected jobs proportionally based on the estimated requirements for each job.


to remove a job from the dialog.

Friday, 29 April 2016

Changing a Return’s Vessel

By default when you book back a return, the return takes the vessel from the original dispense. In some situations this is not practical, so there is now a feature on CPC that allows you to select the vessel during the return booking in process.

While on the return booking in screen (R003), there is a new button on the left side which allows the operator to cycle through the available dispense vessels, from smallest capacity to largest capacity. The current vessel capacity is displayed at the top of the screen. The selected vessel will be saved as the return’s vessel when pressing the save button.

This feature is available from version 1.9.20, upgrade is free for all customers with a remote support contract. Contact Rexson to arrange an update.

Wednesday, 5 August 2015

Reporting On Low Stock Levels

To be able to create a report and be warned when a material is low on stock, a material attribute is needed.

Creating the minimum stock level attribute

To be able to create a low stock attribute, you must be an administrator, Go to Admin | Configuration | Edit Attributes as shown below.

Choose the material type as the entity type by using the drop down box.

Click add new to add a new attribute.

Change the name of the new attribute to Minimum stock level, change the group to Stock, change the type to Decimal Number, tick the show in list box and change the unit hint to kg so the new attribute should look like this:

Click save to save the new attribute. To have more detailed information on attributes, click here.

Setting the Minimum stock level for materials

Click on materials as shown below:

Right click on column headings and select Minimum stock level to display this attribute in the material list.

Right click on the material you want to change the low stock level and select open.

Click add attribute.

Select Minimum stock level and click the right arrow and close the dialog box with the small cross in the top right corner of the dialog box.

Enter the minimum stock level in the minimum stock level box.

Click save to save the minimum stock level.

Creating A Potential Stock Report

Click on reports and select Potential Stock Report (all materials).

This is a report on the stock of all materials. Materials highlighted on red are below the minimum stock level as shown below.

Thursday, 18 December 2014

Creating Custom Attributes


ColorPoint has built in fields for many common data requirements, e.g. material cost, job run lengths. Sometimes you may need to attach additional data to an entity in ColorPoint that isn’t part of the main application. To do this you need to use attributes.

What is an Attribute?

An attribute is a piece of custom data that you can attach to any of the main data entities in ColorPoint. The entities that we can define attributes for are: Material, Formula, Design, Job, Return, Dispense, Supplier, Customer, Address, Contact, Cylinder, Downtime Event, Machine, Substrate, Material Batch, VOC Area, VOC Type, and Campaign.

Creating an Attribute

To create an attribute, you must be an administrator. Go to Admin | Configuration | Edit Attributes as shown below.


Select the entity you are adding the attribute to.


The existing attributes for your entity will be shown.


Click “Add New” to create a new attribute. The following fields are available:

  • Name – The display name of the attribute
  • Group – A selection from predefined group names. You can define new groups if required. All attributes in the same group will be displayed together.
  • Type – To enable validation of data entered into attributes, the type is specified. Types available are:
    • Text – Any text
    • Whole Number – Only whole numbers, e.g. 1, 2, 3
    • Decimal Number – e.g. 1.234
    • True/False
    • Date
    • Email
    • There are a few more types used internally with special meaning.
  • Optional – If this attribute is added, whether it can be left blank or not. If it is not optional, the user will not be allowed to save a record without entering a valid value.
  • Protected – Only users with permission may edit this attribute.
  • Filterable – Can this attribute be used in the filter panel. Enabling filterable on a large number of attributes may impact performance.
  • Shown in list – Is the attribute shown in the main list as a column.
  • Priority – Where the attribute is displayed on the entry page.
  • Unit Hint – An optional unit that shows next to the attribute when you enter data to hint to the user what value they are entering.

As an example, we will create a new attribute on Materials, called SAP Code.


The name is SAP Code. The Group is “General”. The Type is Text. It is not optional (must be entered), and not protected. It is Filterable and Shown in list.

Using Attributes

Below you can see the SAP Code in use.


The SAP Code is a first class data member and can be filtered as shown below.


Tuesday, 25 November 2014

Using prompted mode for manual additions


When performing manual additions requiring very precise small amounts of material, it is possible that the movement of the scale to get to the bucket causes the weight to alter before adding any material.

To keep the process as accurate as possible, prompted mode was introduced.

When the next item to be dispensed is a manual addition, the user is prompted to pull out the scale, then press continue when the weight is stable.


This ensures the starting weigh of the manual addition is recorded after the scale has been moved.

The manual addition then proceeds as normal.


Once complete the operator is presses continue to register the amount dispensed.


If the next material is manual then the process repeats. If it is to be dispensed from a valve then the user is prompted to push the scale back in.


Once the scale is in, the operator presses continue and the next material is dispensed automatically.

Friday, 14 November 2014

Setting Dispense Vessel Parameters



ColorPoint checks that the correct dispense vessel is on the scale before starting as dispense. To aid detecting that the correct vessel is on the scale, a number of parameters are set for each vessel size.

Below is an example of a dispense vessel:

  • Capacity: 20 Kg
  • Volume: 20 l
  • Minimum Empty Weight: 0.8 Kg
  • Maximum Empty Weight: 1.0 Kg
  • Nominal Weight: 0.85 Kg
  • Lid Weight: 0.1 Kg
  • Default Vessel for Head



The maximum weight the vessel can hold. This is also used to identify your vessel, and for overflow calculations.


The maximum volume your vessel can hold. This is used for overflow calculations.

Minimum and Maximum Empty Weight

The minimum and maximum weight a vessel of this type should weigh. This is used to detect that the vessel you have selected to use is the vessel on the scale. If an empty 20 Kg vessel is placed on the scale, it must weigh between 0.8 and 1.0 Kg, otherwise the “Wrong Vessel On Scale” icon will be displayed:


It is important that the range of weight between the minimum and maximum empty weight is kept as small as possible, as this makes handling the vessel more accurate. It is also important the vessels weight ranges do not overlap, e.g. a 25 Kg vessel with a weight range of 0.9 to 1.1 kg could be confused with the 20 Kg vessel and incorrectly detect the 20 Kg capacity as 25 Kg, allowing the user to potentially overfill the vessel.

Nominal Weight

The nominal weight defaults to the mid-point between the minimum and maximum empty weight, but may be different. It should be set to the value that you expect a brand new empty vessel to weigh. This value is used as the vessel weight in situations where the original empty vessel weight is unknown, e.g. booking in a return without the original dispense data.

Lid Weight

This value helps to accurately determine the weight of returned ink in a vessel. The lid weight is used if returns are booked in with the lid on. If returns are booked in before the lid is put on, set the value to 0 Kg.

Default Vessel For Head

This setting is only used on multi head dispensers where the scale size differs between heads, e.g. 300 Kg on Head 1 and 35 Kg on head 2. It is used to override the vessel selection when a vessel to large for the scale is selected. Setting this in other situations has no effect and it can be ignored.


Other Useful Information

No vessel on scale

When the scale weight is below 0.1 Kg the no vessel on scale warning icon will be shown.


If you see this icon and there is a vessel on the scale, it is possible that the scale was zeroed while the vessel was on the scale, especially if the vessel was on the scale when the system was started.

Unknown Vessel On Scale

If the vessel on the scale does not match the weight range of any know vessel, the unknown vessel icon is displayed.


This often indicates the the vessel on the scale is not empty, and that the top-up function should be used.

Vessel Overfill

This icon indicates that the amount selected is too large for the vessel selected.


This often indicates the the vessel on the scale is not empty, and that the top-up function should be used.

Tuesday, 19 August 2014

Import Validation Tool

The tool can be downloaded from here
The Excel template can be downloaded from here
The layout of the tool can be seen as follows:
This tool includes features listed below:
  • Validation of Materials and Formulas in CSV files.
  • Automated validation of Materials and Formulas in Excel files.
  • Detailed error description of invalid records.
  • Generate blank Material and Formula template.
  • Export valid data to CSV files from Excel files.
The list of error messages are listed below:
  • Code missing or too long (maximum 25 characters)
  • Name missing or too long (maximum 50 characters)
  • Missing materials from formulas

Validate from CSV

Press ‘Choose File’ button and choose the CSV file you want to validate. First choose a Material file and the records will be automatically registered. If the materials are not valid then error messages will be displayed. If the materials are all valid then continue the operation pressing the ‘Choose File’ button again to choose the Formula file.
Valid records are displayed in the table ‘Valid Records’ and invalid records are displayed in the table ‘Invalid Records’. When going through the rows of Invalid Record table, you will be able to see the detailed error description underneath the same.

Validate from Excel

Click ‘Choose File’ button and choose the Excel file. This will check if all the records are valid. Valid records are displayed in the table ‘Valid Records’ and Invalid records are displayed in the table ‘Invalid Records’. When an invalid record is selected from the table, you will be able to see the detailed error description below the table.
When all the records are valid, it will ask you to save the Materials and Formulas to a CSV file. Press save to save them in your preferred directory.

Generate File

If you want to create a CSV file with the Materials and Formula file template, click ‘Generate File’ button and save them in your preferred directory.