GL Mapping Import

 

Account mapping is a tool that is used to link the MTech cost centers and accounts to the ERP financial system accounts. The process is a one-time exercise that is required to create interfaces to transfer account balances between the systems. Import mapping must be defined for each cost center and account in ERP to cost center and account in MTech. Export mapping must be defined for each cost center and account in MTech to cost center and account in ERP.

 

Other than Account No and GL Account  No, all other fields are optional depending on the account coding structure in the ERP. Most often Cost Center is also used as many ERP systems have cost centers or departments defined for the expenses to be coded.

Create GL Mapping Import

  1. In Admin>Business>General>Chart of Accounts Definition, select GL Mapping Import.

  2. Select the button to create a new record.

  1. Select the Product Type. Available options are: Animal, Eggs, Embryo, Feed Formula, Field Products, Freight, Ingredients, Instructions, Medication, Miscellaneous, Pricing Method, Semen, Service and Vaccination.
  2. From Product No, select the required product. The list will be filtered based on the selected Product Type.
  3. Product Name will default in from Product No.
  4. Select the Sub Product No, if applicable.
  5. Sub Product Name will default in from Sub Product No.
  6. Select the Product Category No, if applicable.
  7. Product Category Name will default in from Product Category No. Product Category No cannot be selected if the Product No is selected.
  8. Select the Cost Center No, if applicable.
  9. Cost Center Name will default in.
  10. GL Type can be used to select the type of account such as Expense, Inventory, AP, AR.
  11. Division Name will default in based on the selected cost center.
  12. Select the Account No.
  13. Account Name will default in.
  14. Enter the GL Account No that exists in the ERP system..
  1. Select the Customer No, if applicable.
  2. Customer Name will default in.
  3. Select the Vendor No, if applicable.
  4. Vendor Name will default in.
  5. Enter  the GL Cost Center for the cost center that is required in the financial system..