Skip to main content

Clipboard Import

Clipboard Import allows users to import master and transaction data by simply copy and paste from Excel. It supports both inserting new records and updating existing ones.

Prerequisite

  1. Download Excel Template
  2. Maintain Master Data

Download Excel Template

Click this link: Template

Maintain Master Data

Go to Tools and maintain all necessary tables required for a smooth import process. For example, when importing Sales Invoices with agent field, you must first set up these entries in Maintain Agent. Otherwise, the import will fail with errors.

1

tip

Always import Master Data first, then import Transactions.

About Excel Template

  1. In the Excel, there are tabs at the bottom. Each tab is named according to which table it should be imported into.

    2

  2. The first row is field name and number inside the bracket is the field size. Field that starts with '_' (underscore) represents the detail table.

    3

    warning

    Do not modify the field name. Modifying them may result in import errors.

Usage

Import Steps

  1. Select and Copy (Ctrl + C) the table in Excel, including with field name

    4

  2. Go to File > Import > Clipboard Excel Import and select the table

    5

  3. Click Paste from Clipboard

    6

  4. Validate the imported data

    7

  5. The status will show New, Update or Error

    8

    info

    New: Inserts master and detail records.
    Update: Udpates the master table and appends the detail records.
    Error: You can edit the grid then Select All and click Validate again or use Quick Fix.

  6. Click Import

    warning

    During the import process, it is advisable to wait patiently until the import is complete. Performing other actions may cause the application to become unresponsive

    9

Quick Fix

Quick Fix helps you automatically fix errors, such as missing values. It can create missing items (like Agent or Area) or let you select a default value for empty field.

  1. After Validate, record with Error status will be unticked. Click Select All or tick records that need to be fixed

    tip

    Quick Fix only works for records with an Error status.

    10

  2. Click Quick Fix

    11

  3. For empty value error, select a default value

    12

  4. Error is fixed

    13

Auto Generate DocNo

Use <<New>>n in the DocNo field for each set where n is a number

14

Additional Information

  1. Customer / Supplier branch's detail will be updated when BranchName already exist.

  2. First customer / supplier branch type is Billing. Ensure billing details always in the first record during import.