CBX Query: Subsidiary Monthly Expenses
Screen Overview
There are three subsidiary canned queries:
-
Monthly Expense - Prepaid Items - Tool #541 Monthly Prepaid Expenses (FAITM/FAITM2)
-
Monthly Expense - Accrued Expenses - Tool #538 Monthly Accrued Expenses (FAITM/FAITM2)
-
Monthly Expenses - Fixed Assets - Tool #539 Fixed Asset Esp. (FAITM/FAITM2)
All of these Queries are used to view history on the monthly expenses generated by subsidiary items.
Specifications
File(s) used by this Query: FAITM, FAITM2
Sample Conditions
Below are some conditions which may be helpful when performing this inquiry.
|
Description |
Field |
Test |
Value |
|
Display only items with a Category number of “112.” |
CATG |
EQ |
112 |
|
Display only items for branch (location) number 2. |
BRN# |
EQ |
2 |
|
Display only items where accumulated depreciation was posted to G/L account number 775.00 (when running the Fixed Assets Query). |
ADEPGL |
EQ |
77500 |
For complete instructions on navigating the “Display Report” screen and using the available buttons, see Displaying a Custom Report as an Online Inquiry.