Automated Synchronization: To Configure a New Automation Schedule

The following activity will walk you through the process of creating an automation schedule from scratch. To gain greater familiarity with the process, you will create two automation schedules: one that starts data preparation, and one that starts data processing for the customer data.

Story

Suppose that as an implementation consultant helping SweetLife to set up integration with BigCommerce, you want to configure continuous synchronization of entities. As part of the setup, you need to configure the system to synchronize new and updated customers between MYOB Acumatica and the BigCommerce store once a day (at night). Because MYOB Acumatica does not provide any predefined automation schedules for the Customer entity, you will need to create two automation schedules from scratch. The first schedule will prepare the customer data for processing, and the second schedule will start the processing of the prepared data.

Process Overview

You will do the following:

1. On the Prepare Data (BC501000) form, define the conditions for preparing data of the Customer entity.
2. On the Automation Schedules form, create an automation schedule to start data preparation for the Customer entity once a day.
3. On the Process Data (BC501500) form, define the conditions for processing data of the Customer entity.
4. On the Automation Schedules form, create an automation schedule to start data processing for the Customer entity once a day.

System Preparation

Before you perform the instructions of this activity, do the following:

1. Make sure that the following prerequisites have been met:
   • The BigCommerce store has been created and configured, as described in Initial Configuration: To Set Up a BigCommerce Store.
   • The connection to the BigCommerce store has been established and the initial configuration has been performed, as detailed in the steps in Initial Configuration: To Establish and Configure the Store Connection.
2. Sign in to the MYOB Acumatica instance with the U100 dataset preloaded by using the following credentials:
   • Username: gibbs
   • Password: 123

Step 1: Scheduling of the Automatic Data Preparation for Customers

To configure an automation schedule that will start the data preparation process for the Customer entity once every night, do the following:

1. Open the Prepare Data (BC501000) form.
2. In the Summary area of the form, specify the following settings:
   • Store: SweetStore - BC
   • Prepare Mode: Incremental

     With this option selected, only data that has been modified since the previous data synchronization will be placed in the processing queue.

3. In the table, select the Selected check box in the row of the Customer entity.
4. On the form toolbar, click Schedules > Add to open the Automation Schedules (SM205020) form.
5. In the Description box, type Prepare Customers.

   In the Summary area, the system has inserted Prepare Data in the Screen ID box and Prepare All in the Action Name box. Notice that the Active check box has been selected.

   On the Filter Values tab, the system has added the settings summarized in the following table, which correspond to the selections you have made in the Selection area of the Prepare Data form earlier in this step.

   Active	Field Name	Value
   Selected	Store	SweetStore - BC
   Selected	Prepare Mode	Incremental

   On the Conditions tab, the system has added the conditions summarized in the following table, which also correspond to the settings you have made on the Prepare Data form. The action specified in the Action Name box of the Summary area of the Automation Schedules form will be executed for the entities on the Prepare Data form that meet these conditions.

   Field Name	Condition	Value
   Connector	Equals	BigCommerce
   Store	Equals	SweetStore - BC
   Entity	Equals	Customer

6. On the Details tab, specify the additional settings of the schedule as follows:
   • In the Starts On box, leave the default value, which is the current business date.
   • Select the No Execution Limit check box.
7. On the Schedule tab, specify the execution dates and times as follows:
   1. In the Schedule Type section, select the Daily option button.
   2. In the Execution Time section, in the Starts On box, select 11:30 PM.

      With these settings, the schedule execution will be started every day at 11:30 PM.

8. On the form toolbar, click Save & Close to save the changes to the automation schedule.

Step 2: Scheduling of the Automatic Data Processing for Customers

To configure an automation schedule that will start data processing for the Customer entity once a day, do the following:

1. Open the Process Data (BC501500) form.
2. In the Summary area of the form, specify the following settings:
   • Store: SweetStore - BC
   • Entity: Customer
3. On the form toolbar, click Schedules > Add to open the Automation Schedules (SM205020) form.
4. In the Description box, enter Process Customers.

   In the Summary area, the system has inserted Process Data in the Screen ID box and Process All in the Action Name box. Notice that the Active check box has been selected.

   On the Filter Values tab, the system has added the settings summarized in the following table, which correspond to the selections you have made on the Process Data form earlier in this step.

   Active	Field Name	Value
   Selected	Store	SweetStore - BC
   Selected	Entity	Customer
   Selected	Processing Limit (Rows)	No Limit

5. On the Details tab, specify the additional settings of the schedule as follows:
   • In the Starts On box, leave the default value, which is the current business date.
   • Select the No Execution Limit check box.
6. On the Schedule tab, specify the execution dates and times as follows:
   • In the Schedule Type section, select the Daily option button.
   • In the Execution Time section, in the Starts On box, select 12:30 AM.

     With these settings, the schedule execution will be started every day at 12:30 AM.

7. On the form toolbar, click Save & Close to save your changes to the automation schedule.

You have configured two automation schedules for the Customer entity. Now the first automation schedule will start the data preparation process every night at 11:30 PM to retrieve the changed data if any changes have occurred in customers in MYOB Acumatica since the previous data preparation, and will place it in the processing queue. The second schedule will start the data processing for the Customer entity to process the synchronization records that are out of sync. During data processing, the system will also attempt to synchronize the customer synchronization records that could not be processed before (that is, the synchronization records that have the Failed status).