• Select the entry in the Date Selection window.
• Click the remove button. The entry is removed from the list and not included in the extraction criteria.

Journal Source From/To
Enter the first and last Journal Source codes to create a journal source range that limits the extraction to transactions in that range.
Provisional Transactions (Rough Book)
Enter the code to include, exclude or use rough transactions only. The default entry is Include Provisional Transactions (Rough Book). However, when a new report is defined in Vision Executive and a Budget Ledger (not Actual Ledger) has been defined as a Data Warehouse in Vision Budget Management, the default Provisional Transactions (Rough Book) setting will be changed to Exclude Provisional Transactions (Rough Book) for the Data Warehouse ledgers.
Amount Type
Enter the Amount Type to apply to the extraction. The default entry is Base Amount. For Vision version 5.1-1 and subsequent releases, there are four Amount Types: Base Amount, Transaction Amount, 2nd Base/Reporting Amount and Memo Amount to accommodate SunSystems 5.1 Dual Base Currency functionality.
You can select two currencies for revaluation, using Rates 1-6. The other currencies displayed are both currencies other than the pivot currency defined in the Business Unit. For example, if the pivot is the Transaction currency then Base and 2nd Base/Reporting Amount can be revalued using Base Rate 1-6 and Reporting Rates 1-6 against the pivot currency.
Conversion Code From/To
Enter the first and last Conversion Codes to limit the extraction to transactions in that range. Click the Conversion Code assist button to display the Conversion Definitions dialog box and begin a Conversion Code entry. If you leave this field blank, all conversion codes are used. The partial list option is available on this dialog box.
Asset Indicator
Enter an Asset Indicator to identify the asset value to apply to the extraction. The default entry is to include all asset indicators.
Debits/Credits
Enter the Debits/Credits code to extract both debits and credits, credits only, debits only, suppress credits, suppress debits, suppress credits by account or suppress debits by account. The default entry is Both.
Debits Only
Extracts only those transactions that have a D Debit/Credit marker.
Credits Only
Extracts only those transactions that have a C Debit/Credit marker.
Suppress Credits
Extracts transactions with both debit and credit markers and then evaluates the result of the extraction. If the result is a debit, it prints the result of the extraction. If the result is a credit, it prints 0 (zero). For example, in a Balance Sheet report the sum of all bank accounts should only be included in the asset section if the result is a debit. Therefore, defining bank accounts with suppress credits would only print the result if there was a debit balance.
Suppress Debits
Extracts transactions with both debit and credit markers and then evaluates the result of the extraction. If the result is a credit, it prints the result of the extraction. If the result is debit, it prints the 0 (zero). For example, in a Balance Sheet report the sum of all bank accounts should only be included in the liability section if the result is a credit. Therefore, defining bank accounts with suppress debits would only print the result if there was a credit balance.
Suppress Credits by Account
Only extracts accounts with a debit balance and ignores accounts that have a credit balance. For example, a range of 5 accounts might have 2 accounts with a debit balance and 3 accounts with a credit balance. The result would be the sum of the 2 accounts with the debit balance.
Suppress Debits by Account
Only extracts accounts with a credit balance and ignores accounts that have a debit balance. For example, a range of 5 accounts might have 2 accounts with a debit balance and 3 accounts with a credit balance. The result would be the sum of the 3 accounts with the credit balance.
Primary Locked
Select this check box to inhibit re-extraction of selected cells on a primary worksheet or clear the check box to allow re-extraction of selected cells on a primary worksheet. Using this function reduces extraction time. You can override this function in the Query dialog box when Extracting Primary Worksheets, by clicking the Extract Locked Values check box.
Breakout Fixed
Select this check box to inhibit break out on the selected cells or clear the check box to allow break out on the selected cells.
Definition Form Tab4
Use tab 4 to add a Custom Drill to any cell using an external program from within Vision Executive.
Click here to see a screenshot
For example, you can link scanned images to a transaction reference in SunSystems or to Ledger Analysis Codes (T-Codes). Custom Drills display in the Custom Drill window. You can attach multiple Custom Drills to a single Vision Executive cell.
Custom Drill
Custom Drills display in the Custom Drill window. Click the assist button to display the Custom Drill dialog box and begin a Custom Drill definition. Select the Custom Drill you want to remove and click the minus ‘-‘ sign.
The finished workbook looks like this:
Click here to see a screenshot
Now you are ready to execute this workbook and manipulate with the extracted information in many possible ways.