By using our site you are agreeing that cookies may be stored. Find out more here.

MRP/ERP Software Development Kit (SDK)

View as PDF

See the software

Next event in:
D :H :M : S

Attend free

The Software development Kit (SDK) provides a common 'gateway' enabling external applications to communicate safely with 123insight.

SDK can be used to link many applications such as websites, EDI's and CAD Programs, and is also a requirement for 123mobile.

You can create and update the majority of transactions using external sources.



Include live stock levels to your online store, generate sales orders or create/modify customer records within 123insight from your website.

CAD Software

Import and update Bills of Materials and Routings directly from your CAD software.

Test Results

Record test results from various sources and associate them with products as they travel through the production process.

Weigh Scales

Issue the correct number of components by weight to Works Orders using scales.

The kit consists of a suite of SQL Stored Procedures and comprehensive supporting documentation.

It covers all expected parameters and error handling that a systems developer would need to use when linking their application to 123insight. By using the SDK you remove the risk of direct links breaking when either 123insight or your 3rd party application(s) are upgraded. You can be confident that any links you build will rarely need to be reworked in the future.

Examples of areas covered

  • Commercial
    • Adding and updating Companies and key Company details
    • Adding and updating Projects
  • Sales
    • Adding and updating Sales Orders
    • Adding and updating Quotations
  • Purchase
    • Adding and updating Purchase Orders
    • Adding, updating and approving Purchase Requisitions
  • Shop Floor
    • Booking Operations
    • Inputting test results (for serial numbers)
    • Rework Serial Numbers
    • Book in adhoc operations
  • Production
    • Adding Works Orders
    • Adding Works Order Routings and Bills of Materials
  • Stores
    • Despatch and Booking Goods In
    • All stock check controls
    • Issuing Components to Works Order and Works Order receipt
    • Stock Movements
    • Receive returns from the customer
    • Book goods in
  • Accounts
    • Adding Sales Invoices and Credits
    • Matching Purchase Invoices
  • Structures
    • Adding Parts
    • Adding Routings and Bills of Materials
    • Create Customer cross-reference in the production database

SQL (Full): £100 per month
SQL Express: £40 per month

View as PDF

Manufacturing Industry Awards

Green IT Awards
Manufacturing Management
The Manfacturer Awards
Green IT Awards
IT Europa Awards
The Manufacturer Awards