Global Elements and Utilities

Basic Navigation and Data Entry

Table vs Fullscreen Modes

Notes and Attachments

Exporting and Importing Data

Overview

Exporting data enables you to use other software for data analysis and presentation purposes. Importing data can be an important time saver and can be done in many screens. If there is a specific screen to which you would like to add an import, let us know and we will see if the request can be accommodated.

Considerations

The 'Errors only' checkbox is used to only show rows that need to be corrected.

Exporting

  1. Press the [Export] button in the screen's Block Toolbar to export data.

  2. A spreadsheet will be created.

Importing

  1. Press the [Import] button in the screen's Block Toolbar to import data.

  2. In the Data Import pop-up window, download the template by clicking on the down arrow () in the [Upload New] button.

  3. Fill out the template.

  4. When pasting data, use Control-v and not right-click to paste, as that method will not work.

  5. If you prefer to upload the file itself, use the [Upload New] button, which will launch the Upload New File pop-up window.

  6. Choose the file to be imported. Once you have selected the file, press [Upload] in the Upload New File pop-up window. When using this method, do not remove or change the header/column titles from the spreadsheet and make sure to keep the file in CSV format.

  7. Data must be validated before being imported. Press the [Validate and Import File] button to validate the data.

  8. If a record is determined to be valid, the record is set to green. If validation fails, the status is red and the validation error is displayed below the data area.

  9. You have the option of validating the current line, which is a way to save time. Alternatively, press [Validate and Import File] if you would prefer to try importing all data.

  10. If there were invalid records, you can make the corrections directly on this screen. Records can be manually added or removed. When corrections are completed, press [Validate and Import File] to re-import. Once the data is successfully imported, exit the pop-up and refresh the screen.

Creating a Business Partner

Creating a Vendor or Customer from existing Business Partners

Basic Creation

Bulk Creation

Vendor and Customer Default Values

LiteEditor

Customizing Fields and Screens

Adding Fields to Screens

Adding New Custom Fields

Customizing Table Mode