Viewing Balances with Cost Analyzer Inquiry
Access the Work With Cost Analyzer Balances form.
- View Number
Enter a number from 1 to 10 that specifies how the system posts records from the Account Ledger table (F0911) to the Cost Analyzer Balances table (F1602). This number also specifies which managerial accounting posting code (PM01 - PM10) in the F0911 table to update as posted.
For example, if the view number is 1, then the system updates PM01 with P when the F0911 record is marked as being posted.
- Century/Fiscal Year
Enter a number that represents the century concatenated with the fiscal year, such as 2008.
- Ledger Type
Enter a user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.
- Account Number
Enter a value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:
Standard account number (business unit.object.subsidiary or flex format).
Third GL number (maximum of 25 digits).
Account ID number. The number is eight digits long.
Speed code, which is a two-character code that you concatenate to the AAI item SP. You can then enter the code instead of an account number.
The first character of the account number indicates its format. You define the account format in the General Accounting constants.
- Item
Enter an inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows:
Item Number (short): An eight digit, computer-assigned item number.
2nd Item Number: The 25 digit, free-form, user defined alphanumeric item number.
3rd Item Number: Another 25 digit, free-form, user defined alphanumeric item number.
- Cost Object/Type 1
Enter cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify the cost object type. This field functions the same and is validated the same as the subledger field, but the system does not post the data in the cost object code field to the Account Balances file (F0902).
- Subledger/type
Enter a code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an address book number. If you enter a subledger, you must also specify the subledger type.
- Original Posting 01
Enter a number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last day of the period.
- Original Posting YTD and Ending Balance YTD
Enter the sum of all net postings from the first day of the current fiscal year to the last day of the current month or period.
The system uses the period totals from the Account Balances table (F0902) to calculate the YTD period end total.
- Ending Balance 01
Enter a number that represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost Analyzer Balances (F1602) from the Account Ledger (F0911), plus any amounts that are applied to this balance, minus any amounts that are assigned from this balance. You assign amounts through Cost Assignments Calculate (R1610) program.