Missing Department Entries (how to locate) CDV
Accounting & Taxes
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 |