Skip to content

Paint materials and mixing machine data

If your location receives paint mixing machine data from your paint provider, Nexsyis pulls in the actual paint costs and calculates margins from real usage. This page shows how to set it up and how the data appears in the GP Analyzer and on folder reports.

Supported paint providers:

  • AkzoNobel
  • BASF Automotive Solutions
  • PPG
  • Sherwin-Williams
  1. In Preferences:

    1. Set GPAnalyzerPaintMaterialCost to 1.
    2. Set PaintPercentNonLiquid to the percentage of paint materials sales to allocate to non-liquid materials.

    The GPAnalyzerPaintMaterialCost and PaintPercentNonLiquid preferences

    For example, if it’s set to 30, 30% of the paint materials sales on the estimate go to non-liquid materials and 70% go to liquid materials.

  2. On the location’s Profile tab, set the percentage of cost distributed to non-liquid materials.

When mixing machine data is turned on, paint materials split into three categories. Each one is costed differently.

Category Where the cost comes from How gross profit is calculated When you see it
Paint Materials - Liquid Actual data from your paint provider’s mixing machine From the real usage cost Locations and folders with mixing machine data
Paint Materials - NonLiquid The percentage set on the location Profile tab Expected GP %, not actual data All locations and folders, with or without mixing machine data
Paint Materials Expected GP % from the location Profile tab Expected GP %, not actual data Folders with no mixing machine data

When you choose a date range in the GP Analyzer and mixing machine data exists, paint materials show on three lines: Paint Materials - NonLiquid, Paint Materials - Liquid and Paint Materials.

Paint Materials - NonLiquid, Paint Materials - Liquid and Paint Materials lines under Sales Class: Charges

Double-click any paint materials line to see the GP amount for each folder in that date range.

When you analyze one folder that has mixing machine data, you see two lines:

  • Paint Materials - NonLiquid: cost calculated from the expected GP % for the location.
  • Paint Materials - Liquid: actual cost from the mixing machine.

When a folder receives mixing machine data, the Paint Materials Costs report is available on the folder print screen.

  1. Open the folder print screen.

  2. Under Folder Reports, select Paint Materials Costs.

    Paint Materials Costs in the Folder Reports list

The report shows the paint materials used on that folder, with the product, units and amount for each.

The Paint Material Detail report

You can also open the report from the GP Analyzer: right-click a folder and select Print Mixing Machine Data.

Print Mixing Machine Data on the folder right-click menu

If a folder has no mixing machine data, a message tells you so. You can spot these folders in the GP Analyzer because their GP % equals the expected GP % for paint materials.

The message There is no Mixing Machine Data for this folder