Technical

Import Document Details

This powerful optional utility allows a user to import data from a CSV file into an EBMS document. The following EBMS documents can import data directly from a CSV file using the Document Details import utility:

  1.  All journal entry dialogs including G/L journals, sales journals, labor journals, etc.  

  2. Sales order or sales invoice

  3. Purchase order or expense invoice

  4. Proposal or quote

  5. Job transfer

  6. Warehouse transfer

Complete the following steps to import journal transactions from a CSV file:

  1. Open a new journal by selecting Financials >  New Journal Entry from the main EBMS menu to open the following journal entry dialog:

  2. Select Process > Import Detail from File from the journal menu as shown above:

  3. Select the CSV file from Open dialog. EBMS will NOT import a CSV UTF-8 file.

  4. The following dialog will attempt to match the columns within the CSV file with the EBMS Table.   The import tool expects the CSV file to contain the field names as shown below.

    The field names within an Excel or CSV file appear on row one of the spreadsheet. The name of an EBMS entry field can be found by completing the following steps:

    1. Open the entry screen that you wish to import such as the journal screen shown above.

    2. Right-click on the desired entry field or column to show the following context menu:

    3. Hold the <Shift> and <Ctrl> keyboard buttons while selecting the What's This? option from the context menu:
      .

    4. The What's This dialog will show the database File and Field names.

  5. Click OK to complete the import process.