Data Sync Control

Use this form to synchronize data from the Native ERP system to Factory Track. The Data Sync Control form is the overall form used to submit a request to perform the synchronization, selecting the types of data that must be synchronized in this particular run. This form can also be used to view the results of the synchronization and to initiate the various stages of the process. This feature is developed for Syteline purpose only.

The form consists of two tabs:

• Control: This record is the overall control record for the synchronization process. User can view these fields:
  1. Create work groups from Departments: If this check box is selected, the form creates work group in Department synchronization.
  2. Alternative: SL must schedule alternate for holiday type of download.
  3. Apply Defaults After Download: If this check box is selected, defaults are applied to the Staging table (to populate fields not available in the native ERP system).
  4. Auto Post: If this check box is selected, data is posted to Factory Track Master Files.
  5. Batch Number: The iteration to process the record.
  6. Download: In this section, user can select the type of download for the selected batch number to be processed.

  Two tabs (Load Parameters and Submit Batch) are displayed on this section of the form for processing the data synchronization run.

• Results: The Results tab consists of two section as defined below:

  The upper row provides these details:

  1. Batch Number: The iteration number that generated this record.
  2. Download Time/Date: The time and date of the download process is displayed.
  3. User Name: The user name of the processor.
  4. Download Status: The status of download activity is displayed. The possible values are:
     • Started
     • Finished Normal
     • Error
  5. Create work groups from Departments: The work group used in Department synchronization is displayed.
  6. Alternative: SL must schedule alternate for holiday type of download.
  7. Apply Defaults After Download: Displays the defaults that are applied to the Staging table (to populate fields not available in the native ERP system).
  8. Auto Post: Displays the data that is posted to Factory Track Master Files.

  Two tabs (Apply Defaults and Post Batch) are displayed on this section of the form for updating the downloaded data.

  The bottom row provides these details:

  1. Record Type: A control record is created that records information from the down load. This is created when the download starts and updated when it is finished.
  2. Download Status: The status of download activity is displayed. The possible values are:
     • Started
     • Finished Normal
     • Error
  3. Post Status: The status of record after the defaults are applied and posted.
  4. Download: The number of records downloaded from the ERP.
  5. Posted: Number of records successfully posted.
  6. New: Number of new employee created.
  7. Updated: Status of the download update
     • Waiting/not requested
     • Started
     • Finished Normal
     • Error
  8. Unchanged: Displays the number of records that remain unchanged during the download process.
  9. Errors: Error status if error records are finished.
  10. Download Time/Date: The date and time of download is displayed.

  In the View Details section the type of download status is displayed on clicking the listed tabs:

  • All
  • Errors
  • New
  • Update
  • Posted