Skip to main content

Assigning Accounts

Assign accounts to a row or column to print monetary or statistical account balances. You assign accounts by entering one or more account ranges.
Typically you assign accounts to rows. However, if you enter accounts for both rows and columns, FSG only reports on intersecting accounts.
Note: If you assign accounts to a row or column, you cannot define a calculation for that same row or column. You can do one or the other, but not both.
To assign accounts to a row or column:
1. From the Rows or Columns window, choose Account Assignments.
2. Select a mathematical Sign ( + or - ) to tell FSG whether to cumulatively add or subtract the balances for each account in the specified account range. To use this feature, each segment in the range must be defined with a display type of T (Total). See step 4 below.
3. Enter a range of accounts by specifying the Low and High accounts in the range.
Additional Information: To specify just one account rather than a range, enter the same account as the Low and High.
If you leave a segment blank, FSG will process all values for that segment.
4. Enter a Display type for each account segment.
Note: You must use a display type of T (Total) for each segment if you assign:
Accounts to a column.
Multiple account ranges to a row.
5. Check the Summary checkbox if you want to report only summary balances for the accounts in the specified range.
Note: The profile option, FSG:Expand Parent Value, controls the expansion of parent values when requesting summary balances.
6. Select an Activity type (Dr, Cr or Net) to specify the types of balances to use for the accounts in each account range.
For example, enter Dr or Cr if you want to define a cash flow report or a statement of changes in financial position. For these types of reports, you may need separate rows or columns for debit and credit amounts.
7. (Optional) For each account range being assigned, enter a Set of Books from which FSG will derive account balances. If you do not enter a value, FSG will use the current set of books.
You can enter a different set of books for each account assignment if the sets of books share the same chart of accounts and calendar as your current set of books. When using different sets of books you should use Net as the Activity type.
8. Save your work.


Row Set Display Types
You can assign one of three display types to your account segments in an account assignment. You can override these display types with a content set.
E: (Expand) Expand the range and display all segment values, creating multiple rows from a single row definition. If you enter a parent segment value for your range, FSG displays all child values for that parent. Do not select summary reporting to display all the child values in your report.
Note: Use the profile option FSG:Expand Parent Value to control the expansion of parent values when requesting summary balances.
T: (Total) Total the range and display only a total balance for the segment values, limiting the number of rows that appear on your report. If you enter a parent segment value for your range, FSG totals all of the child values for that parent.
Note: If you assign accounts to a column, you must use a display type of T (Total) for each segment. You must also specify a display type of T for all segments if you assign multiple account ranges to a row. Do not enter multiple account ranges for a row containing display types other than T.
B: (Both) Expand and total the range and display all segment values and a total balance for the segment values. This option lets you display both detail rows and total rows. If you enter a parent segment value for your range, FSG totals all of the child values for that parent. Do not select summary reporting to display all the child values in your report.

Amount Types

General Ledger provides the following amount types, which can be specified in the Balance Control region of a FSG row or column definition:
BAL-Actual (FY Start): Balance sheet balance at start of fiscal year
EOD: End-of-day balances
PATD: Period Average-to-date balances
PJTD: Project-to-date
PTD-Actual: Period-to-date actual balances
PTD-Budget: Period-to-date budget balances
PTD-Encumbrance: Period-to-date encumbrance balances
PTD-Variance: Period-to-date variance (budget - actual)
PTD-Variance%: Period-to-date variance percentage (variance/budget)
Project-Actual: Project-to-date actual balances
Project-Budget: Project-to-date budget balances
Project-Encumbrance: Project-to-date encumbrance balances
Project-Variance: Project-to-date variance (budget - actual)
Project-Variance%: Project-to-date variance percentage (variance/budget)
QATD: Quarter Average-to-date balances
QTD-Actual: Quarter-to-date actual balances
QTD-Budget: Quarter-to-date budget balances
QTD-Encumbrance: Quarter-to-date encumbrance balances
QTD-Variance: Quarter-to-date variance (budget - actual)
QTD-Variance%: Quarter-to-date variance percentage (variance/budget)
YATD: Year Average-to-date balances
YTD-Actual: Year-to-date actual balances
YTD-Budget: Year-to-date budget balances
YTD-Budget (FY End): Budget for full fiscal year. You should first budget to all periods in your fiscal year, including an adjustment period if you have defined one.
YTD-Encumbrance: Year-to-date encumbrance balances
YTD-Encumbrance (FY End): Encumbrance balances for full fiscal year.
YTD-Variance: Year-to-date variance (budget - actual)
YTD-Variance%: Year-to-date variance percentage (variance/budget)

Comments

  1. Nanfor IbéricaFebruary 14, 2021 at 12:10 AM

    Hi, This is a great article. Loved your efforts on it buddy. Thanks for sharing this with us. MB-200: Microsoft Power Platform Dynamics 365 Core

    ReplyDelete

Post a Comment

Popular posts from this blog

Applying Prepayments to Invoices

You can apply the available amount of Item type distributions from a Temporary type prepayment to one or more invoices to offset the amount you pay on the invoice(s). If you entered the prepayment as a Permanent type and want to apply it, you can query the prepayment in the Invoices window and change the Prepayment Type to Temporary. If you use Automatic Offsets then your setting for the Prevent Prepayment Application Across Balancing Segments Payables option controls whether you can apply a prepayment to an invoice or expense report with a different balancing segment. Prerequisites The invoice type is Standard, Mixed, or Expense Report. Today's date is on or after the Settlement Date of the prepayment. The invoice date is on or after the date of the prepayment. The prepayment is type Temporary, fully paid, validated, not cancelled, has no active holds, and has not already been fully applied. The prepayment has the same supplier, invoice currency and payment currenc...
1 comment
Read more

Overview of Encumbrance Accounting

With General Ledger you can record pre-expenditures commonly known as encumbrances. The primary purpose of tracking encumbrances is to avoid overspending a budget. Encumbrances can also be used to predict cash outflow and as a general planning tool. To use the full capabilities of encumbrance accounting, you must enable the budgetary control flag for a set of books. When you enable the budgetary control flag, the system automatically creates encumbrances from requisitions, purchase orders and other transactions originating in feeder systems such as Purchasing and Payables. When you do not enable the budgetary control flag, you can still enter manual encumbrances via journal entry, but you cannot generate encumbrances from requisitions and purchase orders. You have two options for using encumbrance data to monitor over-expenditure of a budget: After actuals and encumbrances have been posted, you can generate reports to show over-expenditures. You can also can use funds checking to preve...
Post a Comment
Read more

Apply/Unapply Prepayments Window Reference

Payables provides two ways to apply prepayments to an invoice. You can do either of the following: i-> Create or query an invoice and apply one or more prepayments to the invoice. ii-> Create or query the prepayment and apply it to one or more invoices. Selecting an Invoice and Applying it to a Prepayment When you select an invoice and choose the Apply/Unapply Prepayment option in the Invoice Actions window, the Apply/Unapply Prepayments window opens. It automatically displays all prepayments that have been applied to the invoice, and all available Prepayment distributions that you can apply to the invoice. Payables displays prepayment item type distributions that meet the following criteria: same supplier, and invoice currency as the invoice. The prepayment's Settlement Date is on or before today's date. The prepayment's date is on or before the date of the invoice. The prepayment is type Temporary with a status of Available. If you use Automatic Offsets, you can se...
Post a Comment
Read more