Locating Missing Department Entries using a Custom Data View
We have created a Custom Data View report that will show you transactions where no department was selected. You may wish to locate and correct these so that you can have fully departmentalized financial statements and other reports. Tip: When you run the CDV, you can double-click on and transaction to open it. Report Type: Custom Data View (CDV) 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 |
