Skip to main content

AutoCount Migrator Plugin User Guide

Learn how to use the AutoCount Migrator Plugin to change supported master codes in batches, import general and stock maintenance data, and import Item Bill of Materials (BOM) records in AutoCount Accounting.

User Guide Version 2.2.25.34

Before you begin

Before using the Migrator Plugin, make sure the required user permissions have been assigned. Prepare the source spreadsheet and check the data before copying it into an import screen.

Source: Migrator Plugin User Guide, Version 2.2.25.34. The instructions on this page follow the supplied user guide. Available functions may depend on the installed plugin build and assigned permissions.

  • Confirm that you have the required Show, Open, Apply, or Import rights.
  • Prepare the relevant spreadsheet rows before using Paste from clipboard.
  • For Item BOM imports, copy the column headers together with the BOM rows.
  • Review the displayed Status values before importing.
  • Enable Overwrite/Update Existing Data only when matching existing records should be updated.
Important: Review the selected records and imported data carefully before applying a batch code change or completing an import.

1. Configure Migrator Plugin access rights

Administrators assign Migrator Plugin permissions before users can open or apply a batch-change or import function.

1Open Access Rights and expand PlugIns > Migrator Plugin.

AutoCount Access Rights menu showing Migrator Plugin permissions

2Assign the applicable Show, Open, and Apply rights for each Batch Change Code function the user needs.

3Assign the applicable Show, Open, and Import rights for each Import Tools function the user needs.

Migrator Plugin access rights selection for user groups

4Save the changes. A user without the assigned right cannot use the related protected action.

Confirmation after saving Migrator Plugin access rights

2. Batch Change Code

Batch Change Code functions replace a selected code throughout the supported records. The available functions include Account Number, Area Code, Branch Code, Currency Code, Item Code, Item UOM, Member Code, Payment Method, Purchase Agent, Sales Agent, and User ID.

1Open Migrator Plugin > Batch Change Code and select the required change screen.

AutoCount Migrator Plugin Batch Change Code menu

2Select the existing code or record to change, then select or enter the replacement value shown by the screen.

3Review the selected records and the replacement value before applying the change.

Batch Change Code screen showing selected records and replacement value

4Click Apply. The function updates the records only when the user has the matching Apply right.

AutoCount confirmation after applying a batch code change

3. Import General Maintenance Data

The plugin provides clipboard import screens for General Maintenance records. The available screens are Import Area Type, Import Creditor Type, Import Debtor Type, Import Price Category, Import Purchase Agent, Import Sales Agent, Import Sub Project, Import Top Level Project, and Import User.

1Open Migrator Plugin > Import Tools and select the required General Maintenance import screen.

Migrator Plugin Import Tools menu with General Maintenance import options

2Copy the prepared rows from the source spreadsheet to the clipboard.

Example General Maintenance spreadsheet rows prepared for import

3Click Paste from clipboard and review the imported rows and their Status values.

General Maintenance import screen after pasting clipboard data
Pasted General Maintenance records and their import status

4Select Overwrite/Update Existing Data only when existing matching records should be updated.

5Click Import and review the Successed and Status results for each row.

General Maintenance import process and result screen

4. Import Stock Maintenance Data

Stock Maintenance import screens use the same clipboard workflow for stock-related master data. The available screens are Import Item Brand, Import Item Category, Import Item Class, Import Stock Group, Import Stock Item Type, and Import Location.

1Open Migrator Plugin > Import Tools and select the required Stock Maintenance import screen.

Migrator Plugin menu showing Stock Maintenance import options

2Copy the prepared spreadsheet rows to the clipboard and click Paste from clipboard.

Stock Maintenance spreadsheet data and Migrator Plugin paste screen

3Review the imported rows, including the displayed Status for each row.

4Select Overwrite/Update Existing Data only when a matching existing record should be updated.

Overwrite or update existing Stock Maintenance data option

5Click Import and confirm the resulting Successed and Status values.

Stock Maintenance import result and completion screen

5. Import Item BOM

Import Item BOM imports item bill-of-material information from the selected source spreadsheet.

1Open Migrator Plugin > Import Tools > Import Stock Item BOM.

AutoCount Migrator Plugin menu path to Import Stock Item BOM

2In the source spreadsheet, prepare the required columns and copy the column headers together with the BOM rows.

The example in the guide uses ItemCode, SubItemCode, qty, CostFraction, OverheadCost, and AssemblyCost.

Example Item BOM spreadsheet with column headers and BOM rows

3Click Paste from clipboard and review the imported rows and their Status.

4Enable Overwrite/Update Existing Data only when an existing BOM should be replaced with the imported BOM details.

Item BOM import screen with Overwrite or Update Existing Data option

5Click Import. Correct any rows marked Error and import again when required.

Item BOM import completed confirmation message

Troubleshooting: checks before contacting support

These checks are based on the documented Migrator Plugin permissions and import workflows. If an issue remains unresolved, review the installed plugin build, account book and affected records before contacting support.

  • The Migrator Plugin function is not visible: ask an administrator to check the Show and Open rights under PlugIns > Migrator Plugin.
  • Apply is unavailable: confirm that the user has the relevant Apply right for the selected Batch Change Code function.
  • Import is unavailable: confirm that the user has the relevant Import right for the selected Import Tools function.
  • Rows show an error: review the pasted data and its Status values. For Item BOM, make sure the column headers are copied together with the BOM rows.
  • Existing records should not be overwritten: leave Overwrite/Update Existing Data disabled unless updating matching records is intended.

Frequently Asked Questions

What does the AutoCount Migrator Plugin do?

It provides batch code-change functions and clipboard import tools for selected General Maintenance data, Stock Maintenance data, and Item BOM records in AutoCount Accounting.

Can I import data directly from an Excel file?

The user guide describes a clipboard-based workflow. Prepare the data in a spreadsheet, copy the required rows, and click Paste from clipboard in the relevant import screen.

Which General Maintenance records can be imported?

Area Type, Creditor Type, Debtor Type, Price Category, Purchase Agent, Sales Agent, Sub Project, Top Level Project, and User.

Which Stock Maintenance records can be imported?

Item Brand, Item Category, Item Class, Stock Group, Stock Item Type, and Location.

Can the plugin change codes in batches?

Yes. The available functions cover Account Number, Area Code, Branch Code, Currency Code, Item Code, Item UOM, Member Code, Payment Method, Purchase Agent, Sales Agent, and User ID.

Does the plugin support Item BOM import?

Yes. Open Import Tools > Import Stock Item BOM, then paste the prepared column headers and BOM rows from the source spreadsheet.

When should I enable Overwrite/Update Existing Data?

Enable this option only when matching existing records should be updated. For Item BOM, enable it only when an existing BOM should be replaced with the imported BOM details.

Related resources and technical support

Continue exploring AutoCount or get assistance with the steps in this guide.

Explore Migrator Plugin

Review the features and business workflows supported by AutoCount Migrator Plugin.

View plugin features

Browse the Knowledge Base

Find practical instructions for other AutoCount functions, modules and plugins.

Browse user guides
Technical support

Need help with Migrator Plugin?

Send the details below so our team can understand the issue and review the relevant import or code-change workflow.

Contact technical support

Have these details ready

  • AutoCount and Migrator Plugin versions
  • Function or import screen being used
  • Relevant item code or record type
  • Exact error message or import Status result

Before sharing a screenshot: hide customer details, passwords and other sensitive information.