Missing Department Entries

By |2021-07-26T16:15:34-05:00January 8th, 2021|Comments Off on Missing Department Entries

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

Share This Story, Choose Your Platform!

About the Author:

HVAC Electrical Plumbing Software

Aptora delivers a true All-In-One services software solution including CRM, accounting, payroll, inventory, vendors, sales, marketing, dispatch, flat rate pricing, and more. NO 3rd party plugins or integrations required. Created by contractors for contractors, we know what it takes to grow your services-based businesses.

Newsletter

Sign-up to get the latest news and update information. Don’t worry, we won’t send spam!

Thank you for your message. It has been sent.
There was an error trying to send your message. Please try again later.
Go to Top