Expense Distribution Detail Report
Use the Expense Distribution Detail Report to review detail invoice distribution information for expense distributions that include three segments of your account that you specify. For example, company, cost center, and account.
In the Account Segments for Expense Reporting window, you define the following options, which Payables uses to generate this report:
- Three account segments on which Payables reports
- Default segment value ranges
The report lists all posted and unposted invoice distributions that match report parameters and definitions in the Accounting Segments for Expense Reporting window. To change the report format, update the Account Segments for Expense Reporting window.
If you enable the Automatic Offsets Payables option, you can also use this report to see the offsetting AP liability accounts for each of your invoice distributions.
The report orders the report by the Report Sequence values you assigned in the Account Segments for Expense Reporting window.
Prerequisite
Report Submission
You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.
Selected Report Parameters
Start/End Date. The report includes invoices with GL Dates on or between the Start Date and the End Date.
Posted Option. The report includes distributions with the posted status you select:
- All. Posted and not posted.
Asset Option. Enter the option to review either expense or asset type invoice distributions for your posted invoice distributions. If you are reviewing only unposted invoice distributions, you cannot enter this parameter.
- Assets. Review only asset type invoice distributions.
- Not Assets. Review only non-asset type invoice distributions.
- Unchecked. Review only invoice distributions that Oracle Assets has not already checked to identify whether they are asset type invoice distributions. When Oracle Assets transfers assets from Payables, it marks each distribution as an asset. Using the Unchecked option lets you see which assets Oracle Assets has not already marked.
- All. Review all invoice distributions, assets, non-assets, and unchecked distributions.
Display Liab Acct. Enter Yes if you want Payables to display the Liability account for each invoice distribution. If you leave this field blank, Payables does not print the Liability account for an invoice distribution on this report.
If you enable the Automatic Offsets Payables option, Approval builds an offsetting Liability account for each invoice distribution when you approve an invoice. Approval builds the offsetting Liability account from the Expense account for the distribution and the Liability account for the supplier site. If you do not enable the Automatic Offsets Payables option, the Liability account for each distribution on an invoice is the same.
Segment 1-3 Low/High. For each reporting segment (1-3), optionally adjust the default inclusive range of values that you want to report on. To report on one value, for example, one company, use the same value for the low and high range.
Selected Report Headings
Batch. Name of an invoice batch for a distribution if you use invoice batch entry.
Distribution Amount. The amount of an invoice distribution. If you are using multiple currencies, Payables prints the amount in your functional currency.
Post. Payables prints Yes or No to indicate whether it has transferred the invoice distribution to your general ledger.
Account Use. Payables prints the type of the account on an invoice distribution. The account use can be:
- Exchange Rate Variance. Exchange rate variance between the invoice and its matched purchase order.
- Expense. Expense or asset account.
- Invoice Price Variance. Price variance between the invoice and its matched purchase order.
Liability Account. Payables prints the liability account for an invoice distribution if you enter Yes in the Display Liability Account report parameter.
Description. Partial description of an invoice distribution.
See Also
Defining Your Chart of Accounts
Account Segments for Expense Reporting
Common Report Parameters
Common Report Headings
Automatic Offsets
Define the report format in the Account Segments for Expense Reporting window. See: Account Segments for Expense Reporting.