Skip to content

Mintsoft Sample Integration

Integration between Mintsoft OMS and Sage 50 UK. The integration will export Order and ASN information data from Mintsoft and import into Sage 50 as Sales Orders and Goods Despatched Notes.

The integration will also export Invoice information from Mintsoft and import these into Sage 50 as Sales Invoice Transactions.

  1. Download Sales Orders from Mintsoft.
  2. Map the data into the Sage 50 Sales Order format
  3. Import Sales Orders into Sage 50 UK
  4. Export ASNs from Mintsoft
  5. Map the data into the Sage 50 UK Goods Despatched Notes format
  6. Import Goods Despatched Notes into Sage 50 UK
  7. Export Invoices from Mintsoft
  8. Map the data into the Sage 50 UK Transactions Format
  9. Import Sales Invoice Transactions in Sage 50 UK

Prerequisites

  • Install of Zynk Workflow with either a Paid or Trial license.
  • Account with Mintsoft
  • Install of Sage 50 UK

First Steps

Once the workflow has been imported you will need to set the connections for Mintsoft and Sage 50 UK to be able to import and export data.

Create Mintsoft Connection

  • Open the Mintsoft & Sage 50 workflow
  • Select the Export Mintsoft Orders task, then the Mintsoft Connection setting
  • In the connection menu select New
  • Set a Name for the connection and Next
  • Set the Username and Password then Finish
  • Select the Export Mintsoft Orders task, then the Mintsoft Connection setting
  • In the connection menu select the connection you just created

Note

See Connecting to Mintsoft for further details

  • Please make sure the account you use to authenticate with Zynk has administrator permissions in Mintsoft otherwise some areas of the integration may not work.

Create Sage 50 UK Connection

  • Open the Shopify & Sage 50 workflow
  • Select the Import Sales Orders task, then the Sage 50 Connection setting
  • In the connection menu select New
  • Set a Name for the connection and Next
  • Choose your Company, enter the required Username and Password, then Finish

Note

See Connecting to Sage 50 UK for further details

Sales Order Mapping

Sales Order Parameters

The Sales Order mapping document contains the following Parameters you can use to customise the data:

Parameter Usage
BankAccount The Bank Account to use for Payments
TaxCode The Tax Code to use on Items
CarriageTaxCode The Tax Code to use on Carriage
  • If no value is provided for BankAccount, no Payments will be created with Sales Orders.
  • If no TaxCode/Carriage TaxCode are specified, the defaults from Sage will be used.
Mintsoft Sage 50
ID* N/A
ClientID* N/A
ClientCode AccountReference
OrderNumber CustomerOrderNumber
OrderDate SalesOrderDate
Currency/Code Currency
OrderNumber PaymentRef
TotalOrderGross PaymentAmount
  • ID and ClientID* - The ID and ClientID field are not shown in Sage 50 but are used by Zynk to track the records it has processed to prevent duplicate data being imported.

Sales Order Address

Mintsoft Sage 50
FirstName Forename
CompanyName Company
Address1 Address1
Address2 Address2
Town Town
Postcode Postcode
Country/Name Country
Phone Telephone
Email Email

Sales Order Delivery Address

Mintsoft Sage 50
FirstName Forename
CompanyName Company
Address1 Address1
Address2 Address2
Town Town
Postcode Postcode
Country/Name Country
Phone Telephone
Email Email

Sales Order Items

Mintsoft Sage 50
SKU Sku
QuantityOrdered QtyOrdered
UnitPrice UnitPrice

Carriage

Mintsoft Sage 50
OrderNameValues/OrderNameValue/Value Name
1* QtyOrdered
ShippingTotalExcludingVAT UnitPrice
  • 1* - QtyOrdered on Carriage is hard coded to 1

ASN Mapping

ASN Header

Mintsoft Sage 50
ID* n/a
PurchaseOrderReference CustomerOrderNumber
  • ID* - The ID field is not shown in Sage 50 but is used by Zynk to track the records it has processed to prevent duplicate data being imported.

ASN Item Lines

Mintsoft Sage 50
ID* n/a
GoodsDespatchedNote* Type
EstimatedDelivery Date
SKU Sku
QuantityBooked Quantity

  • ID* - The ID field is not shown in Sage 50 but is used by Zynk to track the records it has processed to prevent duplicate data being imported.

  • GoodsDespatchedNote* - The Type field is hardcoded to GoodsDespatchedNote

Invoice Mapping

Invoice Parameters

The Invoice mapping document contains the following Parameters you can use to customise the data:

Parameter Usage
TaxCode The Tax Code to use on Sales Invoice Transactions
CalculateAsVATInclusive Set to "true" to treat the total value as Vat Inclusive
Mintsoft Sage 50
ID* n/a
SalesInvoice* TransactionType
Client/Code AccountReference
Date TransactionDate
Name Reference
Name Details
TotalValue* NetAmount
Date TaxCode
  • SalesInvoice* - The TransactionType field is hardcoded to SalesInvoice
  • TotalValue* - The TotalValue field is the sum of the following fields:
  • AdminFee
  • PickingCost
  • ShippingCost
  • VatExemptShipping
  • ReworkCost
  • PackagingCost
  • AdditionalInvoiceItemsCost
  • CollectionsCost
  • ReturnsCost
  • GoodsInCost
  • StorageCost

Default Mapping File

Mappings in Zynk are handled using XSLT 1.0 (https://www.w3.org/TR/xslt-10/), and we provide XSLT Builder available from the Extensions menu in Zynk for building mappings. You can create and customise mappings using either XSLT Builder or any text editor. Transactional data supports limited customisation so the defaults should work, but mappings can be customised per install.