MB4000 Payroll importing

Steps on how to import data into MB4000 for Time and attendance from an Agrigistics export file

Login

Login to the "Personnel" module of MB4000

Setup

This is only required when setting up the imports. After initial setup is completed skip ahead to importing.

Overview screen

1. Click on the "Setup" button -> "System settings"

Data imports setup screen

1. Navigate to "Data Imports" and click on "New" to set up a new import template.

Example template setup

1. Enter a name for the import

2. Select the file to be imported after click on the the 3 dots next to the file name input.

   1. This file needs to be a .csv format

      1. If for example the Employee Overview, Export Totals report is being used it needs to be saved in the .csv format

3. "Header lines" -> 1

4. "Table" -> "Attendance"

5. "Values" -> "Replace"

6. Map input columns

   1. Each input that being imported from Agristics needs to be mapped to a specific input on MB4000

   2. For example in this image the inputs of the Employee Overview, Export Totals report are mapped to the following:

      1. Column 1 -> "EmployeeNumber"

      2. Column 3 -> NormalHours

      3. Column 4 -> Overtime1

7. Click "OK"

Import data

​Data imports setup screen

1. Click on the "Setup" button -> "System settings"

2. Navigate to "Data imports" and click on "Import"

   1. Make sure that the correct "Import File" is specified

   2. If there are any issues with the importing, error messages will be displayed

      1. Most often it is new employees on Agrigistics that have not yet been setup on MB4000

         1. To fix this, the farmer must add the employees on MB4000 and retry the import

3. Do not delete the original file when prompted

4. All of the data should be successfully imported

Process and validate

Employee attendance overview screen

1. Click on the bottom left button "Calculate Pay"

2. All of the inputs that have been setup should automatically be populated with the corresponding values from the import file

Employee attendance detail screen

1. Double click on an employee to view their detailed screen

2. All of the hours will be imported for the last day in the pay run

   1. Scroll down in the input list to view this