Type: Custom Data View
Data View: Missing Department Entries
Customer: Aptora
Public: Yes
Reports Included: No
Description: List of all transaction line entries which are missing a department in the register for Income Statement accounts.
Drill Down: Yes, opens transaction type
Columns and data for the Missing Department Entries Custom Data View are outlined below:
Column Name | Form | Field | Notes |
Tran No | Transaction | Number/Reference | |
Tran Date | Transaction | Date | |
Tran Type | Form Type | ||
Items Name | Transaction Items Grid | Associated Item Name | |
Account Name | Transaction Line | Associated Line Account Selection | |
Register Amount | General Journal | ****** | Value of debit/credit impact for Chart of Account |
Qty | Transaction Line | Quantity | |
Cost | Transaction Line | ****** | Unit cost for line items with an item selected. When only an account is entered, the cost is the amount to be debited or credited. |
Total Cost | Transaction Line | Calculated Field | Qty times Cost |
Price | Transaction Line | ***** | Unit Price Ea for line items with an item selected. When only an account is entered, the price is the amount to be debited or credited. |
Amount | Transaction | Calculated Filed | Qty times Price |
Line Item Description | Transaction | Department | Line description/memo |
Tran Date Created | Transaction | Transaction Security Label | |
Tran Date Revised | Transaction | Transaction Security Label | |
From Mobile? | Transaction | Calculated Field | Indication of whether transaction was created from Aptora Mobile II. (Invoices Only) |
Cust:Job Name | Transaction Line | Associated Customer:Job Name | |
Cust:Job Display Name | Transaction Line | Associated Customer:Job Display Name | |
TranID | Transaction | Table ID of Transaction | |
AccountID | Transaction | Table ID of Chart of Account | |
CustID | Transaction | Table ID of Customer:Job |
