GL Mapping Export

 

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 Export

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

  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. Product Category No cannot be selected if the Product No is selected.
  7. Product Category Name will default in from Product Category No.
  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.
  12. Select the Account No.
  13. Account Name will default in.
  14. Select the GL Account No.
  15. Select the GL Off Set Account No.
  1. Select the GL Cost Center.
  2. Select the Customer No, if applicable.
  3. Customer Name will default in.
  4. Select the Vendor No, if applicable.
  5. Vendor Name will default in.