|
<< Click to Display Table of Contents >> Data Import |
![]() ![]()
|
The AccountMate Enterprise Data Import feature is especially designed to facilitate importing of data into specific AccountMate Enterprise tables. This feature provides convenience for users and an option to enter values into the system. It allows you to create numerous entries in your source file and enter them altogether into the system in one go. This feature is also a good control for reducing keystroke errors.
The Data Import feature is fairly easy to use. It also lets you control which tables and data fields get imported.
Supported Tables
The Data Import feature currently supports the importation of data into various AccountMate Enterprise tables.
You may refer to the discussion page of the following individual supported table below to download each of the corresponding sample import file. Alternatively, you may click this link to download all the available sample import files in one compressed file.
oAccount Balance
This refers to the account balances to certain GL accounts. The Import Account Balance function allows you to import GL entry batches and their corresponding details. Refer to the Account Balance Import Parameters discussion for the data import details. |
oAccount Group
Account Groups are used to designate how a GL Account ID will be presented in the company's financial statements. It also determines how the GL Account ID balance will be processed during fiscal year-end closing and account consolidation using the Consolidated Ledger module. The Import Account Group function allows you to import account groups and their respective information. For the data import details, refer to the Account Group Import Parameters discussion. |
oBill of Materials
This refers to the list of component and production information for an item which are used in manufacturing the master or subassembly items. The Import Bill of Materials function allows you to import information relevant to a bill of materials, its routing steps, labor and machine information, components, and remnants. Refer to the Bill of Materials Import Parameters discussion for the data import details. |
oChart of Accounts
The chart of accounts is a means of organizing financial data to generate the information needed in making business and management decisions. It records the effects of various transactions, classified, summarized and presented into reports to give helpful information to key decision makers. The Import Chart of Accounts function allows you to import GL account IDs, its details and account group code. For the data import information, refer to the Chart of Accounts Import Parameters discussion. |
oCurrency Exchange Rate
This refers to the conversion rates you can set up and maintain based on the currencies you activated to use in the system. In AccountMate Enterprise, you can set up and maintain as many currency exchange rates for a particular currency as may be needed by your company. The Import Currency Exchange Rate function allows you to import the conversion rates for an activated currency in the system. For the data import details, refer to the discussion on Currency Exchange Rate import parameters. |
oCustomer Address
This refers to the address code(s) you want to assign to customer records. Address codes hold important information regarding business office, stores or warehouse locations of customers. The Import Customer Address function allows you to import address information for your customers. For the data import details, refer to the Customer Address Import Parameters discussion. |
oCustomer Contact
This refers to the contact information for the vendor such as phone number, fax number, email addresses, etc. The Import Customer Contact function allows you to import contact information for your customers. For the data import details, refer to the discussion on Customer Contact Import Parameters. |
oCustomer Inventory
This refers to your item inventory that you cross-reference to your customer's item information effectively allowing you to use the customer's item number instead of your own when creating transactions for the customer. The Import Customer Inventory function allows you to import customer's item information with cross-referencing to your own inventory items. For the data import details, refer to the discussion on Customer Inventory Import Parameters. |
oCustomer Master
This refers to a customer master record which includes basic customer information. This record must be set up prior to creating any customer-related transactions as certain data from this record serve as default values in the Transaction functions in various modules. The Import Customer Master function allows you to import the details required for setting up customer records in AccountMate. Refer to the Customer Code Import Parameters discussion for more data import details. |
oInventory Master
This refers to an inventory item record that includes details of the inventory item and controls for how the item record can be used in various transactions. The Import Inventory Master function allows you to import information required for setting up inventory item records in the system. For more details, refer to the Inventory Master Import Parameters discussion. |
oInventory On-hand Quantity
This refers to the inventory's quantity on-hand. You can specify in the import file the warehouse or location to which you want to update an item's on-hand quantity. The Import Inventory On-hand Quantity function allows you to import information updating an item's on-hand quantity and unit cost. Refer to the Inventory On-hand Quantity Import Parameters discussion for the import details. |
oInventory Price
This refers to the inventory item's basic price. You can specify in the import file an item's new price. The Import Inventory Price function allows you to import information updating an item's price. Refer to the Inventory Price Import Parameters discussion for the import details. |
oInventory Warehouse Bin
This refers to the warehouse and bin records assigned to an inventory item. You can specify in the import file the bins in a specific warehouse that you want to assign to an inventory item record. The Import Inventory Warehouse Bin allows you to import the bin information assigned to an inventory item. Refer to the Inventory Warehouse Bin Import Parameters discussion for the data import details. |
oLabor
This refers to the labor resource represented by an individual worker who will be working in production. These records serve as the source of labor usage information in the Manufacturing module. The Import Labor allows you to import labor resource information and import multiple work centers for each labor code. Refer to the Labor Import Parameters discussion for the data import details. |
oLabor Grade
Labor grade in AccountMate Enterprise refers to the type of labor required at a particular step in the manufacturing process. The Import Labor Grade allows you to import the labor grade information to create labor grade records in the company. Refer to the Labor Grade Import Parameters discussion for the data import details. |
oMachine Code
A machine code refers to the company's machine resources used in manufacturing. You can specify in the import file the the rate and rate type that you want to assign to a machine record. The Import Machine allows you to import machine resource information assigned to your company. Refer to the Machine Import Parameters discussion for the data import details. |
oMiscellaneous Code
Miscellaneous codes refers to the various codes maintained in the system to complement existing maintenance records and to further enhance the ability to store important information about transactions recorded in the system. The Import Miscellaneous Code function allows you to import these miscellaneous codes which you can use in the system. Refer to the Miscellaneous Code Import Parameters discussion for the data import details. |
oSalesperson
This refers to the sales staff member records you set up and maintain in the system. Each salesperson record includes information specific to the sales staff person. The Import Salesperson function allows you to import personal details and contact information for each salesperson you want to maintain in the system. For the data import details, refer to the discussion on Salesperson Import Parameters. |
oSegment Value
Account Segment values are numbers or alphanumeric values that, when put together, make up a GL Account ID. The number of account segments that comprise the GL Account ID and each segment's description (ID), length, and type are initially defined during the creation of the company. The Import Segment Value function allows you to import segment values in to the system. For more details, refer to the Segment Values Import Parameters discussion. |
oSpecification Code
This refers to the codes you set up for each specification type you create in the system. The specification codes are then assigned to specification type records. The Import Specification Code functions allows you to import specification codes and its corresponding details. Refer to the Specification Code Import Parameters discussion for the data import details. |
oSpecification Type
This refers to the categories of inventory specifications that are of the same nature you assign to inventory items with specifications. Examples are color, size, and type. The Import Specification Type functions allows you to import specification types and its corresponding details. For the data import details, refer to the discussion on Specification Type Import Parameters. |
oStatistical Code
Statistical Codes are used to record non-financial information such as usage of an asset or number of employees. These codes are used as basis for distributing an expense among multiple GL accounts. The Import Statistical Code function allows you to import statistical code data in to the system. For additional information, refer to the Statistical Code Import Parameters discussion. |
oSubstitute Inventory
This refers to item inventory that is considered as a substitute when the original item ordered is in short supply. You can set up an unlimited substitute inventory to an item record. The Import Substitute Inventory function allows you to import substitute inventory information for an item. Refer to the Substitute Inventory Import Parameters discussion for the data import details. |
oTeam Code
In AccountMate Enterprise, a team represents a group of labor resources that have the same work shifts, assigned to the same work center and works on the same product assembly or sub-assembly. You can set up an unlimited team code in the company. The Import Team Code function allows you to import information for a team record. Refer to the Team Code Import Parameters discussion for the data import details. |
oVendor Address
This refers to the address code(s) you assign to vendor records. Address codes hold important information regarding business office, stores or warehouse locations of vendors. The Import Vendor Address function allows you to import address information for the vendor records maintained in the system. For the data import details, refer to the Vendor Address Import Parameters discussion. |
oVendor Authorized Reference Account
This refers to the account(s) to which portions of the AP invoice totals billed by the vendor are to be distributed. The Import Vendor Authorized Reference Account function allows you to import GL account IDs that you assign to your vendors as authorized reference accounts. Refer to the discussion on the Vendor Authorized Reference Account Import Parameters for the data import details. |
oVendor Contact
This refers to contact information for vendors maintained in the system such as phone number, fax number, email addresses, etc. The Import Vendor Contact function allows you to import contact details for your vendors. For the data import details, refer to the discussion on Vendor Contacts Import Parameters. |
oVendor Default Distribution
This refers to the percentage of the AP invoice total that you want to be distributed to the vendor's reference account(s). The total of the percentages for all of the reference accounts must sum up to 100% in order to balance the amounts going to the payable account; otherwise, you cannot proceed with the import process. The Import Vendor Default Distribution function allows you to import the percentage distribution for your vendors' reference GL accounts. Refer to the discussion on the Vendor's Default Distribution Import Parameters for the data import details. |
oVendor Inventory
This refers to your item inventory that you have cross-referenced to your vendor's item information effectively allowing you to use the vendor's item number instead of your own when creating transactions for the vendor. The Import Vendor Inventory function allows you to import vendor's inventory information with cross-referencing to your own inventory items. For the data import details, refer to the discussion on Vendor Inventory Import Parameters. |
oVendor Master
A vendor master refers to a vendor master record maintained in the system. You must set up a vendor record before you can record AP invoices for a vendor. The Import Vendor function allows you to import the details required for setting up vendor records in AccountMate. For the data import details, refer to the discussion on Vendor Master Import Parameters. |
oWarehouse Bin
This refers to the bins assigned to a specific warehouse. You can set up unlimited bins in a warehouse as needed by your company. The Import Warehouse Bin allows you to import bin information and warehouse assignment. You can refer to the Warehouse Bin Import Parameters discussion for the data import details. |
oWork Center
This refers to the locations or areas in the shop floor where production is on-going. You can set up unlimited work center records as needed by your company. The Import Work Center allows you to import company's work center related information. You can refer to the Work Center Import Parameters discussion for the data import details. |
|
The following are the limitations of the data import feature:
Not all AccountMate Enterprise tables or data fields are currently supported. This means that you still need to run other Maintenance functions in AccountMate for those records not supported by the import function. Listed below are the limitations of the data import feature:
1.If the Inventory Control module is activated, special items can be imported EXCEPT kit items.
2.If there are problems with the source file or if errors are encountered during data validation of the import process, nothing will be imported into the system.
3.You cannot import bin on-hand quantity for lot-controlled items, kit items, and items with specifications.
© 2023 AccountMate Software Corporation