PRINT POSTED TRANSACTIONS DETAIL

Use this screen to print posted details for one, a range of, or all account/ organization/ project combinations, fiscal year/period/ subperiod combinations, and asset/item numbers. The Posted Transactions Detail Report prints the selected contents of the Fixed Assets Posting Detail table for depreciation expense, disposals, and/or depreciation adjustment entries, and includes the detail for all Fixed Assets accounts (that is, Asset, Depreciation Expense, Accumulated Depreciation, and Gain/Loss accounts). You can sort the report by fiscal year/period, account, organization, project, account/org, or asset/item number.

Note: Because the Fixed Assets Posting Detail table may potentially contain a very large number of records, you can limit the data printed in each report by carefully choosing the selection parameters. If you print this report for ranges of accounts, organizations, projects, and asset/item numbers, rather than for all accounts, the grand total of debits and credits may not equal zero because data may be included only for a portion of the Fixed Assets entries.

Print this report any time after posting to review historical data contained in the Fixed Assets Posting Detail table.

Select Accounts

Use the fields in this group box to select records for a range of asset ("ownership") accounts. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)

Selecting any of the checkboxes in the Select Entry Type group box may modify which records from the selected account range are actually included in the report.

Range Option

The default option for this field is "Range." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All, "One," "Range," "From Beginning," and "To End."

If you save the print parameters for this report, the selected Range Option, as applicable, will be stored in the Query table in the Account Range column.

From

Enter the beginning account number in this field or use Lookup to select one. Because this is a standard Lookup to the ACCT table, you may find that you have selected an account number for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected From value, as applicable, will be stored in the Query table in the Account From column.

To

Enter the ending account number or use Lookup to select one. Because this is a standard Lookup to the ACCT table, you may find that you have selected an account number for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the Account To column.

Select Organizations

Use the fields in this group box to select records for the report from a range of asset ("ownership") organizations. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)

Range Option

The default option for this field is "Range." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All, "One, "Range," "From Beginning," and "To End."

If you save the print parameters for this report, the selected Range Option, as applicable, will be stored in the Query table in the Org Range column.

From

Enter the beginning organization in this field or use Lookup to select one. Because this is a standard Lookup to the ORG table, you may find that you have selected an organization for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected From value, as applicable, will be stored in the Query table in the Organization From column.

To

Enter the ending organization in this field or use Lookup to select one. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected an organization for which posted transactions do not exist or do not meet your other selection criteria.  In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected To value, as applicable, will be stored in the Query table in the Organization To column.

Select Post Sequence No

Use the fields in this group box to choose a range of posting sequence numbers for the report. The system assigns the same posting sequence number to all entries posted in the same session. If you limit the data in your report to a range of posting sequence numbers, you should also print the report for only one fiscal year and period. Because posting sequence numbers are renumbered at the beginning of every period, if you print the report for a range of periods and a specified sequence number (3, for example), all entries assigned that sequence number in all the selected periods will print on the report. Therefore, if you select Periods 1-4, all entries assigned Sequence Number 3 in Period 1 will print, as well as all entries assigned Sequence Number 3 in Periods 2, 3, and 4.

Range Option

The default option for this field is "All." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All," "One," "Range," "From Beginning," and "To End."

If you save the print parameters for this report, the selected Range Option, as applicable, will be stored in the Query table in the Post Seq Range column.

From

Enter the beginning sequence number for the range. Be careful with your entry because you may find that you have entered selection criteria for which posted transactions do not exist or do not meet your other selection criteria.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected From value, as applicable, will be stored in the Query table in the Post Seq From column.

To

Enter the ending sequence number for the range. Be careful with your entry because you may find that you have entered selection criteria for which posted transactions do not exist or do not meet your other selection criteria.

If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected To value, as applicable, will be stored in the Query table in the Post Seq To column.

Select Projects

Use the fields in this group box to select records for the report from a range of asset ("ownership") projects, as applicable. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)

Range Option

The default option for this field is "Range." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All," "One," "Range," "From Beginning," and "To End."

If you save the print parameters for this report, the selected Range Option, as applicable, will be stored in the Query table in the Project Range column.

From

Enter the beginning project in this field, if applicable, or use Lookup to select a project from those displayed. Because this is a standard Lookup to the PROJ table, you may find that you have selected a project for which posted transactions do not exist or do not meet your other selection criteria.  In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected From value, as applicable, will be stored in the Query table in the Project From column.

To

Enter the ending project in this field, if applicable, or use Lookup to select a project from those displayed. Because this is a standard Lookup to the PROJ table, you may find that you have selected a project for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected To value, as applicable, will be stored in the Query table in the Project To column.

Select Time Periods

Use the fields in this group box to select records for the report from a range of fiscal years, periods, and subperiods.

Range Option

The default option for this field is "Range." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All," "One," "Range," "From Beginning," and "To End."

The FY drop-down boxes display only those fiscal years already set up in the G/L's Fiscal Years screen in descending order, beginning with latest fiscal year.  (Fiscal years set up in the General Ledger should always match those set up in Fixed Assets in the Maintain FA Fiscal Years screen.) Because the display in the FY drop-down boxes is a standard Lookup to the FY table, you may find that you have selected a fiscal year for which posted transactions do not exist or do not meet your other selection criteria.  In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

The Pd drop-down boxes display only those accounting periods already set up the Accounting Periods screen in the General Ledger module for the fiscal year specified in the FY drop-down box. (Accounting periods set up in the General Ledger should always match those set up in Fixed Assets in the Maintain FA Accounting Periods screen.) Because the display in the Pd drop-down boxes is a standard Lookup to the ACCTING_PD table, you may find that you have selected a period for which posted transactions do not exist or do not meet your other selection criteria.  In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

If you save the print parameters for this report, the selected Range Option, as applicable, will be stored in the Query table in the Time Period Range column.

Hint:  If you want to limit the data in your report to a range of posting sequence numbers, print the report for only one fiscal year and period.

From

Enter the beginning fiscal year, period, and subperiod for the range, or select a fiscal year, period, and subperiod from the drop-down lists in each field.

If you select "All" or "From Beginning" in the Range Option field, these fields will be inactive.

If you save the print parameters for this report, the selected From value(s), as applicable, will be stored in the Query table in the FY From, Period From, and Subperiod From columns.

To

Enter the ending fiscal year, period, and subperiod for the range, or select a fiscal year, period, and subperiod from the drop-down boxes in each field.

If you select "All," "One," or "To End" in the Range Option field, these fields will be inactive.

If you save the print parameters for this report, the selected To value(s), as applicable, will be stored in the Query table in the FY To, Period To, and Subperiod To columns.

Select Asset/Item Numbers

Use the fields in this group box to select a range of asset/item numbers for the report. If you enter a specific asset number, you must also enter a corresponding item number before you can run the report. Selecting any of the checkboxes in the Select Entry Type group box may modify which records from the selected asset/item number range are actually included in the report.

Range Option

The default option for this field is "Range." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All," "One," "Range," "From Beginning," and "To End."

If you save the print parameters for this report, the selected Range Option, as applicable, will be stored in the Query table in the Asset/Item Range column.

From

Enter the beginning asset/item number for the range or use Lookup to select an asset/item number. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

If you select "All" or "From Beginning" in the Range Option field, these fields will be inactive.

If you save the print parameters for this report, the selected From value(s), as applicable, will be stored in the Query table in the Asset From and Item From columns.

To

Enter the ending asset/item number for the range or use Lookup to select an asset/item number. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.

If you select "All," "One," or "To End" in the Range Option field, these fields will be inactive.

If you save the print parameters for this report, the selected From value(s), as applicable, will be stored in the Query table in the Asset To and Item To columns.

Sort Options

In this group box, you can select the way the system organizes the data for the report. Note, however, that the report always prints in the same format, regardless of the sort option you select. (The sort option determines how data should be ordered within this format.)

Posting FY/Pd

This radio button is the system default. Select this radio button to organize the report by fiscal year/period. Within this primary sort category, data will be further sorted by subperiod, sequence number, entry type, and asset/item number, respectively.

If you select this radio button and save the print parameters for this report, "FY/PD" will display in the Sort Option column in the Query table.

Account

Select this radio button to sort the report by account. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and asset/item number, respectively.

If you select this radio button and save the print parameters for this report, "ACCT" will display in the Sort Option column in the Query table.

Organization

Select this radio button to sort the report by organization. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and asset/item number, respectively.

If you select this radio button and save the print parameters for this report, "ORG" will display in the Sort Option column in the Query table.

Project

Select this radio button to sort the report by project. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and asset/item number, respectively.

If you select this radio button and save the print parameters for this report, "PROJ" will display in the Sort Option column in the Query table.

Acct/Org

Select this radio button to sort the report by the account/organization combination. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and asset/item number, respectively.

If you select this radio button and save the print parameters for this report, "ACCT/ORG" will display in the Sort Option column in the Query table.

Asset/Item No

Select this radio button to sort the report by asset/item number. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and account, respectively.

If you select this radio button and save the print parameters for this report, "ASSET" will display in the Sort Option column in the Query table.

Page Break

Select this checkbox if you want a page break each time the selected sort parameter changes. For example, if the information is sorted by Fiscal Year/Period, you should select the Page Break checkbox if you want data for each fiscal year/period combination to print on a separate page. (Note that this checkbox is disabled if you have selected to sort by Asset/Item No.)

If you select this checkbox and save the print parameters for this report, "Y" will display in the Page Break column in the Query table.

Select Entry Type

Use the options in this group box to select the type(s) of posting entries to include in the report. Select as many checkboxes as desired. You must select at least one checkbox to run the report.

DEPR

Select this checkbox to include depreciation expense entries within the range of entries selected for the report. This checkbox is selected by default. If this checkbox is unchecked, the system automatically excludes all depreciation expense entries.

If you select this checkbox and save the print parameters for this report, "Y" will display in the Include Depreciable Records column in the Query table.

DISP

Select this checkbox to include disposal entries within the range of entries selected for the report. This checkbox is unchecked by default. If this checkbox is unchecked, the system automatically excludes all disposal entries.

If you select this checkbox and save the print parameters for this report, "Y" will display in the Include Disposal Records column in the Query table.

DADJ

Select this checkbox to include depreciation adjustment entries associated with disposals within the range of entries selected for the report. This checkbox is unchecked by default. If this checkbox is unchecked, the system automatically excludes all depreciation adjustment entries.

If you select this checkbox and save the print parameters for this report, "Y" will display in the Include Depr Adj Records column in the Query table.

RDEP

Select this checkbox to include reversing depreciation expense entries within the range of entries selected for the report. This checkbox is unchecked by default. If this checkbox is unchecked, the system automatically excludes all reversing depreciation expense entries.

If you select this checkbox and save the print parameters for this report, "Y" will display in the Include Reversing Depr Records column in the Query table.

RDIS

Select this checkbox to include reversing disposal entries within the range of entries selected for the report. This checkbox is unchecked by default. If this checkbox is unchecked, the system automatically excludes all reversing disposal entries.

If you select this checkbox and save the print parameters for this report, "Y" will display in the Include Reversing Disp Records column in the Query table.

RDAD

Select this checkbox to include reversing depreciation adjustment entries associated with disposals within the range of entries selected for the report. This checkbox is unchecked by default. If this checkbox is unchecked, the system automatically excludes all reversing depreciation adjustment entries.

If you select this checkbox and save the print parameters for this report, "Y" will display in the Include Reversing Depr Records column in the Query table.

TRF

Select this checkbox to include transfer entries within the range of entries selected for the report. This checkbox is unchecked by default. If this checkbox is unchecked, the system automatically excludes all transfer entries.

If you select this checkbox and save the print parameters for this report, "Y" will display in the Include Transfer Records column in the Query table.

Reminder:  Although transfers are currently posted in the same Post Fixed Assets Journal screen as depreciation and disposals, you cannot perform reversing transfer entries. To achieve the same effect as a "reversal" of a transfer entry previously made in the current period, you must change the data back to its "pre-change" status in the Asset Acct/Org/Proj/Ref1/Ref2 fields and/or the Accum Depr Acct/Org/Proj/Ref1/Ref2 fields (via the Accum Depr Acct Code), either manually in the Asset Master screens or via the Global Change functions.  Because change details are stored in the ASSET_AUDIT_LOG table, posting a second transfer entry in this manner effectively creates a "reversing" transfer entry.

Note:  If you want to keep these parameters but want to run a slightly different report, you can use Clone to copy the parameters and make minor changes to the parameters without changing your saved parameters. To use Clone, go to the File menu or select [F4]. The Clone window will display on the screen. Enter the parameters ID you want to clone, or select Execute to display and select from a list of parameter IDs. When you choose the Select pushbutton, the system makes a copy of the parameters that you can edit as needed.

You can save your sort options and selection criteria for this report with or without printing. After making your selections, select the Save button on the toolbar or go to Save in the File menu. Enter an alphanumeric identifying code and a short description to help you recognize the report parameters and select OK. Later, you can run Find or Query from this screen to access the print parameters you created, and run the same report without having to enter all the selection screen information again. Stored report parameters are especially useful if reports are to be run through Process Manager.

Table Information

This report accesses data in the FA_POSTING_DETL (Posting Detail) table.

Lookups and drop-down boxes, as applicable, access the following tables: