There are two ways to migrate data to Axacute which are:
- Restful API
- Import from Excel or Text File
Restful API
User may perform operation in Axacute via Restful API such as extract listing, read master data by ID, create, edit, and delete master/transactional data by using the HTTP verbs (GET, POST, PUT, and DELETE).
The primary and recommend format for the API is ‘JSON’. You may refer to the link below for the API Documentation.
Overview Of Balance Migration Via API
The master and transaction files which can be add and update via API is as below:
INVENTORY MODULE | PRODUCTION MODULE | ||
---|---|---|---|
Master Files | Transaction Files | Master Files | Transaction Files |
Product Codes | Purchase Orders | Employees | Job Orders |
UOMs | Customer Order | Machines | Job Routes |
Items | Transfer Orders | Work Centers | Job Materials |
UOM Conversions | Indirect Tasks | ||
Customers | Reason Codes | ||
Vendors | |||
Employees | |||
Warehouses | |||
Locations | |||
Item Locations | |||
Item Lot Locations | |||
Reason Codes |
Import From Excel Or Text File
Axacute offers an easier way to enter data into the system. The user can import the Master and Transaction data to Axacute using the template provided in Excel or text file format. The system will run the import function as background task. User can check the status and log file from the Background Task. The system also records the import action in the Import Log.
FILE IMPORTATION RULE | DESCRIPTION |
---|---|
Allowed File Types |
|
Maximum File Size | 500 KB |
Maximum Records per File | 1,000 lines per uploaded file |
Note: Visit here and download the file "04-Import Templates" to import data. Please do not change the column name and sequence of the templates when import. Please check the status for the import in the Background Task and click on View Log file to check the reason when import failed.
Migration Best Practices
There are some important practices when you perform the migration:
- Set the cut-off date to get the latest balances at the midnight of the cut-off date.
- Perform inventory count to ensure the quantity on hand are accurate.
- Verify the contents of the opening balance with the project team members before migration.
- Migrate only outstanding orders.
- After migration, verify and ensure the numbers and orders are correct.