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 |
|