· web viewfscm>general ledger>general reports>ledger activity can typically be run to...

14
FSCM>GENERAL LEDGER>GENERAL REPORTS>TRIAL BALANCE

Upload: others

Post on 26-Apr-2020

3 views

Category:

Documents


0 download

TRANSCRIPT

Page 1:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD

FSCM>GENERAL LEDGER>GENERAL REPORTS>TRIAL BALANCE

Page 2:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD

Unit: Defaults to your BU

Ledger: Defaults to ACTUALS

Fiscal Year: Fiscal year you wish to report on

Period: Enter the period to which you would like to see data

Currency Option: Defaults to Base

Currency: Leave blank

Display Full Numeric Field box should be checked

Adjustment Period: Enter adjustment period(s) to include in report

1. Select Parameters

2. Make Chartfield Selections

Page 3:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD
Page 4:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD
Page 5:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD
Page 6:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD
Page 7:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD
Page 8:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD

FSCM Reporting Tools>FSCM Schedule Query

Page 9:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD

Specify Parameters

Page 10:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD
Page 11:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD
Page 12:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD
Page 13:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD
Page 14:  · Web viewFSCM>General Ledger>General Reports>Ledger Activity Can typically be run to csv format and opened in Excel without much “clean up” Public queries: TN_GL65_ASSET_ENTRIES_PD

TO RESEARCH UNUSUAL BALANCES:

FSCM>General Ledger>General Reports>Ledger Activity

Can typically be run to csv format and opened in Excel without much “clean up”

Public queries:

TN_GL65_ASSET_ENTRIES_PD

TN_GL66_LIABILITY_ENTRIES_PD

(For those of you who were around in the legacy days, these generally mimic the STARS 816 and 818 reports)