An “Out of Balance” error message displays when the General Ledger is out of balance with Accounts Receivable. This message displays in the area of the report where account number totals are found. Note: Keep in mind that if you exclude any data when making selections on the Prompt, then the A/R detail will not match the General Ledger.
Select Accounts Receivable|Reports|Aged Trial Balance by Account.
If you want to show each age group as a ”number of months past due,” key the month and year (MM/CCYY) you want to be reported in the Current column or if you want to show each age group as a ”number of days past due,” key the full date (MM/DD/CCYY) to age on day and year you want to be reported in the Current column. If you want a report of items billed through a certain past date, key that date in this field. This allows the system to ignore any billing performed after that date.
From the Client Detail Selection drop-down list, select the client reporting level. Select Client Only to report at the client master level only. Select Client and Level 2 to report at the Client/Division level. Select Full Detail All Client Levels to report at all Client/Division/Product levels.
From the Data Type Selection drop-down list, select All Receivables (Include all receivable accounts), Exclude Intercompany (Include all receivable accounts except intercompany accounts), or Intercompany Only (Include only intercompany receivables).
From the Invoice Sort Selection area, click to sort in Invoice Date Order or Invoice Number Order.
From the Client (Payer) Sort area, click to sort By Client (Payer) Code or By Client Sort Name order.
From the Report Version drop-down list, indicate the maximum number of days past due (or months past due) you want to appear on the report. 120+ days shows five age groups from current to ”more than 120 days old” (or "more than 4 months old” if you entered an effective month). 180+ days shows shows seven age groups from current to ”more than 180 days old” (or ”more than 6 months old” if you entered an effective month). This setting is only possible if you are using a dot matrix printer.
From the Page Break Selection area, click Separate Page per Payer to start a new page for each payer. This allows for easy distribution of the report. Click Print Continuously to print continuously without a page break for each new payer.
From the Print Media Totals area, click Yes to print receivable amount totals by media type on the report; otherwise, click No. This field only applies if you selected to report at the client master level.
From the Period Selection drop-down list, select the receivable balance to come from either the current open status or recreate from the history file. The system recreates the balance at that period in time.
The O|X Invoice Number check box allows users who receive media bills from Mediaocean O|X to see invoice numbers as the standard eight-digit number used in Financials or prefixed with the O|X-assigned alpha code used by Mediaocean O|X. If you are an O|X user and want to see invoice numbers on media bills prefixed with the O|X-assigned alpha code, click the O|X Invoice Number checkbox. To see invoice numbers with the standard eight-digit numbers used in Financials, leave this checkbox blank.
To display the Printing Selections Window, click the Report button.
To export the report to a spreadsheet format, click the Export button.
To continue to work in another option or even log off while the information is being processed, click in the "Process in Background/Batch checkbox. This feature works with the Export function so make sure you click both the Export radio button as well as the "Process in Background/Batch" checkbox to process requested information in the background.
To limit information that displays in the collection, click the Selection buttons and select items from the list. Displayed lists show only clients assigned to you in User/Client Window Security. The <A/R Accounts> selection button only shows accounts that are set up as A/R accounts in the Chart of Accounts Definition Subsidiary Type.
Click the Next icon. If you selected Report, the Printing Selections Window displays. If you selected Export, the Columns to Include on Listing window displays. Select only the information you wish to include on the report then click the Next icon again to display the Processing Window.
You may click <Cancel> to cancel your request or if the report is large, you can take advantage of the <Send to Background> function which processes the request in the background so you can continue to work in other options. This function is also available on the Prompt as described above. As always, if you process in the background and your report is under 2MB in size, you will receive your report as an attachment in an email after processing is completed. If your report is over 2MB in size, your email will contain a link that will open a download window where you can save the file to a spreadsheet format.
If you do not click <Cancel> or <Process in Background>, your report is output to the browser where you will see Filter, Page Number, and Max Rows functions. Click the Next Page (down) arrow to display the next page of information on the report. Click the Previous (up) arrow to return to the previous page of information. Key a Max Row to limit the amount of rows that display on a page to the specified number. To filter information, key a valid filter in any of the blank fields located below the applicable column heading and press <Enter>. Only values that match the specified filters are displayed. When filters are applied, page numbers are no longer displayed; however, you can continue to use the Next Page feature to advance to the next page of filtered information on the report. To remove all filters, click <Clear Filters> or you may remove filters separately by highlighting a filter and clicking <Delete>. Note: Total rows are not recalculated when filtering.
Click <Export to Spreadsheet> to export your report to a spreadsheet format or click the Print icon to generate a PDF of your report. If filters are used, only the information that is filtered displays on the spreadsheet or PDF.
Note: PDF processing limits the number of rows that display on the PDF to 3,000. If you receive the message “3000 row limit reached”, use the new filter function to limit the amount of information that is collected.