ERP integration

Sage keeps customer, order and invoice. Linetrack keeps the schedule.

For machine builders, Sage comes in two sizes: Sage 100 with inventory management and production for smaller mid-sized companies, and Sage X3 for larger manufacturers with an international footprint. For Linetrack the difference is small. In both cases your Sage partner or a middleware calls the REST API, and the order becomes a project with design, manufacturing and assembly.

Via the REST APISage 100 & Sage X3Order becomes projectHours for post-calculation

Sage website ↗

In short

Sage 100 and Sage X3 are connected through the Linetrack REST API, set up by your Sage partner or through a middleware such as Make, n8n or Power Automate. An order in Sage becomes a Linetrack project built from a template, and customers and suppliers join it as project partners with their numbers. Planned hours and an hours report with planned, actual and remaining hours go back to Sage, for post-calculation for example. To get started, task lists and contacts can also be imported from Excel.

Data flow

What Sage stays in charge of and what Linetrack takes over

Sage remains the system for quotation, order, purchasing and invoicing. Linetrack receives what scheduling needs and returns hours and project status. Of the six building blocks, you use only the ones your process actually needs.

Order

An order line becomes a project

When sales confirms an order for a special-purpose machine in Sage, the interface creates the project in Linetrack. Order and line number, customer and project manager come along, and your template supplies the phases. The interface finds the project again later by its Sage number.

  • Order number
  • Line number
  • Part number
  • Customer
  • Project manager
  • Template
  • Start date
Custom fields

Cost centre and budget on the project

Whatever Sage keeps on the order that planning should see becomes a custom field on the project, such as cost centre, calculated budget or machine type. You set up the fields once in Linetrack, and the interface fills them for every new order.

  • Cost centre
  • Budget
  • Machine type
  • Yes/No
  • Number
  • Text
  • Link
Master data

Customers and suppliers from Sage

Customer and supplier master data stay in Sage. The interface sends the partners that appear in projects, with number and contacts. Whoever confirms the date for the frame parts at the paint shop is then listed right on the project.

  • Customer number
  • Supplier number
  • Contacts
  • Project assignment

Where in Linetrack: project partners

Resources

Employees and machines

New employees arrive by personnel number, and machines such as a test bench or machining centre as virtual resources. If you keep staff data in a system other than Sage, this part is better fed from there.

  • Personnel number
  • First name
  • Last name
  • Virtual resources

Where in Linetrack: resource view

Return path

Hours report for post-calculation

Per order or per task, Linetrack returns planned, actual and remaining hours, plus the planned hours per resource. In Sage they sit next to material and subcontracted work when the order is post-calculated.

  • Planned
  • Actual
  • Remaining
  • Planned hours per task
  • Planned hours per resource
Return path

Utilisation per department and month

For sales and management, Linetrack supplies net capacity, planned hours and the difference per resource group and month. That lets you check a delivery date in a quotation against the actual utilisation of design and assembly.

  • Resource group
  • Month
  • Net capacity
  • Planned hours
  • Over/under capacity

Examples

Three situations from everyday order handling

The delivery date in the quotation

A customer asks for a second filling line, delivery in the autumn. Before sales sends the quotation from Sage, they check the monthly figures for electrical design from Linetrack. August is overbooked for that group, so the quotation says October.

One order, several sub-systems

An assembly line consists of conveyors, two robot cells and a test station, each a separate line on the Sage order. If you want, each line becomes its own project in Linetrack, with order and line number. In the KPIs, controlling then sees which sub-system is behind plan.

Post-calculation without chasing timesheets

After acceptance at the customer, costing post-calculates the order in Sage. The hours from Linetrack are already there, per task with planned, actual and remaining hours. Why commissioning took longer than calculated can be answered task by task.

Approach

How we set up the connection with your Sage partner

  1. 1

    Agree what flows

    In one meeting with you and your Sage partner we decide which order types become projects, which template they get and which fields come along as custom fields.

  2. 2

    Set up the call

    Your partner uses the interface tools of your Sage version or a middleware such as Make, n8n or Power Automate. It calls the Linetrack API with its own API key, when an order comes in or on a schedule.

  3. 3

    Connect the return path

    Finally, a scheduled run fetches the hours report and KPIs from Linetrack and writes them to Sage, every night for example. Every call is logged in Linetrack.

FAQ

Frequently asked questions

Any questions?

Book a call with our team.

Is Linetrack a better fit for Sage 100 or for Sage X3?

Both. The Linetrack REST API is the same; what differs are the tools on the Sage side that make the call. Your Sage partner knows best which ones apply to your version. We coordinate directly with them.

What happens to the connection when Linetrack or Sage is updated?

The Linetrack REST API is versioned: in version v1 fields are only added, existing ones are never renamed or removed. A Linetrack update therefore does not interrupt your connection. If a Sage update changes a field, your Sage partner only adjusts the mapping on their side.

We already use project management in Sage 100. Why add Linetrack?

In Sage 100, project management mainly serves the commercial side, up to post-calculation. Linetrack plans dates and capacity across all projects: who works on which design in which week and where assembly is overbooked. The order number links the two.

Can we start without an interface?

Yes. You import the first project plan into Linetrack from Excel, and the contacts of customers and suppliers as well. The ongoing connection to Sage follows once it is clear which fields you really need.

The platforms and brands mentioned belong to their respective owners. Mentioning them describes the technical connection and does not imply a partnership or certification.