Export by Scenario
Form ID: (SM207036)
You can use this form to select an export scenario and prepare and export the data in accordance with the selected scenario. On the form, you can review the prepared data if the export has failed and view the history of processing for the scenario. You can create scenarios for export by using the Export Scenarios (SM207025) form. Export is performed to the file uploaded to the MYOB Acumatica website or to the third-party application specified in the export provider.
Form Toolbar
The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.
Command | Description |
---|---|
Clear Data |
Clears both the history of scenario execution and the prepared data. Clicking this button does not reverse records that have already been exported. The system deletes records somewhat differently depending on the tab that is open when you click this button:
|
Export |
Exports the prepared data. The system tries to export the records that have the Active check box selected. |
Get Latest Version |
Downloads the latest file attached to the selected scenario. If you export data to a file, during export, the system creates a new version of the file attached to the form. |
Prepare |
Prepares the data for export by uploading it on the form. The system performs all modifications defined by the scenario at this step and uploads the modified data on the form. You can view the data on the Prepared Data tab of the form. |
Prepare & Export |
Prepares and exports the data. |
Upload File Version |
Opens the Upload New Revision dialog box, which you can use to update an already uploaded file. |
Summary Area
In this area, you can select an export scenario and view information about the selected scenario.
Element | Description |
---|---|
Name |
The name of the export scenario. You first select the scenario you want to work with, and then you can view information about it. |
Screen Name |
A read-only box showing the name of the MYOB Acumatica form whose functionality is used to perform data export. |
Status |
A read-only box showing the status of the selected scenario, which is automatically assigned during the processing. The box can contain one of the following:
|
Number of Records |
A read-only box that displays the number of records prepared or exported to the target file or application. |
Discard Previous Result |
A check box that indicates (if selected) that the system will clear any prepared data before the data preparation and export. That is, if you click the Prepare & Export button on the form for the export scenario or if the export scenario is executed based on a schedule, the system does the following, depending on whether the check box is selected:
The default state of this check box is the state of the Discard Previous Result check box on the Export Scenarios (SM207025) form for the export scenario. If you change the state of this check box on the current form, the new state will be used only for the next execution of the scenario on the form. The state on the current form is changed back to the default state after each execution of the scenario or each refresh of the form. |
Prepared Data Tab
On this tab, you can review the data prepared for export and view any errors that have occurred. The actual list displays the processed data, with as many columns as there are external fields mapped to the internal data.
Button | Description |
---|---|
Toggle Activation |
Reverses the value in the Active column in the selected line, and updates the rest of the lines with this value. |
Clear Activation until Error |
Clears the check boxes in the Active column for the lines before the line with an error. If there are no errors, clears all the check boxes in the Active column. |
Toggle Processing |
Reverses the value in the Processed column in the selected line, and updates the rest of the lines with this value. |
Clear Errors |
Clears the error messages in the Error column. |
Column | Description |
---|---|
Number |
The number of the record in the list of records for export. |
Active |
A check box that indicates (if selected) that this record is active and will be exported. |
Processed |
A check box that indicates (if selected) that the information in the row was exported. |
Error |
The error message, if an error occurred for this row. |
History Tab
On this tab, you can view the history of processing for the selected scenario.
The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
Column | Description |
---|---|
Status Date |
The date when the status of the data had changed as a result of processing being performed. |
Status |
The status of the data as a result of the processing being performed. |
Number of Records |
The number of records processed. |
Version |
The version of the exported file. If export was successful, the system creates a new version. |
Details Tab
On this tab, you can view additional information about the selected scenario.
Element | Description |
---|---|
Provider |
A read-only box that displays the data provider that is used in the export scenario. To view the details about the provider, click the button to the right of the box to open the Data Providers (SM206015) form. |
Sync Type |
A read-only box that shows the type of synchronization for the selected scenario. The box can contain one of the following:
|
Prepared On |
A read-only box displaying the date when the data was prepared or the export was performed. |
Completed On |
A read-only box that shows the date and time when the export was completed. |
Element | Description |
---|---|
Skip Headers |
A check box that you select to not export the titles of the elements on the form. You specify this option for a particular execution of a scenario. That is, the selected value is discarded after each execution of the scenario or each refresh of the page. |