Example: Exclude Payroll and Fringe Benefit Forward Accruals from Facilities and Administration Reports
This example illustrates how to exclude journal lines generated from payroll and fringe benefit forward accruals from a facilities and administration (F&A) report.
You want to report on F&A transactions that originated from direct spend transactions and not from payroll and fringe benefit forward accruals. First, you create a custom report for F&A journal lines that enables you to exclude journal lines from specific originating journal sources. Then, you run the report and select
payroll forward accrual
and fringe benefit forward accrual
as the journal sources to exclude.- Access theCreate Custom Reporttask.
- Enter these values:FieldValueReport NameF&A Transactions - No Payroll and Fringe Benefit Forward AccrualsReport TypeAdvancedData SourceJournal Lines
- ClickOK.
- On theColumnstab, add 7 new rows to the grid with these values:Business ObjectFieldJournal LineJournalJournal LineJournal Entry TypeJournal LineJournal LineJournal LineJournal StatusJournal LineOriginating Spend Journal Source for Facilities and Administration CostsJournal LineJournal SourceJournal LineLedger/Budget Debit AccountJournal LineLedger/Budget Credit Account
- On theFiltertab, add a row to theFilter on Instancesgrid with these values:FieldOperatorComparison TypeOriginating Spend Journal Source for Facilities and Administration Costsnot in the selection listPrompt the user for the value and ignore the filter condition if the value is blank
- On thePromptstab, add a row in thePrompt Defaultsgrid, and select these values:FieldLabel for PromptOriginating Spend Journal Source for Facilities and Administration CostsExclude Journal Lines from These Originating Spend Journal Sources
- ClickOK.
- Test run the custom report by entering these values:FieldValueJournal SourcesSelectFacilities and Administration Expense.CompanyYour organization name.YearThe year of payroll costing.Exclude F&A Journal Lines from These Journal SourcesSelect these check boxes to exclude transactions from payroll and fringe benefit forward accruals:
- Fringe Benefit Forward Accrual
- Payroll Forward Accrual
When you don't select the check boxes, the report returns all F&A transactions, including those from payroll and fringe benefit forward accruals.TheOriginating Spend Journal Source for Facilities and Administration Costscolumn in the results only contains values when you select theFacilities and Administration Expensejournal source.
You can report on F&A transactions on payroll and fringe benefit accruals, with or without including the transactions for forward accruals.