Sales Recurring report

The Sales Recurring report shows the recurring transactions in the Order Entry application.

Use this report to:

  • See recurring transactions for a specific customer or customer type
  • Analyze sales based on recurring transactions

You can sort the results by criteria such as due date, customer ID, customer name, and so on. This report covers document type, transaction frequency, transaction amount, next scheduled transaction date, and more.

Who typically needs this report?

  • Finance or accounts receivable staff who need to review billing transactions before invoicing customers. After reviewing this report, the finance or AR clerk identifies changes to be made, updates the transactions, and re-runs the report.
  • Many customers run this report at the end of the month (for example, four days or so before the end of the month), review it, and wait for the summary scheduler to run.

To access this report:

  • Go to Order Entry > All > Reports > Sales recurring.

Subscription

Order Entry
User type

Business, Employee, Warehouse, CRM
Permissions

Sales recurring: Run

View a monthly report

  1. On the report settings page, select View.

    The report displays all results for the default reporting period.

  2. To refine the report, select Customize.

Customize and run

Before running the report you can select the time period and types of items to include, and specify how you want the report to appear.

If you want to see every result for a particular category, don't make selections from any of the data entry fields. You can run this report without entering any search information. If you do that, however, the report might take a long time to run and might return too many results to be useful.

  1. Select the reporting period from the dropdown list, or enter the start and end dates you want the report to cover. If you don't specify a reporting period, the system generates a report for the current month to date.
    • You can specify either the reporting period or the start and end dates, but not both.
  2. Set the filters to get the specific data you want.
    • Filters enable you to include or exclude specific types of data in the report, such as customer, item, UPC, value, or account. As a general rule, to get fewer and more precise results in your report, set more filters.
  3. Format the report.
    • Format options will vary from report to report. Generally, you can set the layout of the report and arrange how to group and display the data contained in the report.
  4. Enter a title, subtitle, and footer text for your report.
  5. To view, process, memorize, or export the report select one of the following:
To... ...select

View the report now.

View

Generate the report and store it for later access. Reports can be either stored in My Stored Reports or delivered to a cloud storage location, such as Dropbox. Learn more about processing and storing reports.

Process & Store

Memorize (that is, save) the report so that later you can refer back to it or modify and re-run it.

Memorize

Export the report to a separate file that you can then distribute or save to your local drive. Export to Excel, Word, text, or csv formats.

Export

You can use trial-and-error to get the precise results you want. Just fill in the desired fields, and select View to see the report. If the results aren't what you want, select Customize to return to the report setup page and refine the report further. Repeat this process until you're satisfied.

For complex financial reports that will be run regularly, save the report after you're done setting it up. The next time you're ready to run the report, you only have to change the As of date before running the report.

Time period

You can use one of the numerous pre-defined reporting periods available from the Reporting period and As of date fields, or create your own reporting period using the Start date and End date fields.

  1. In the Time Period section:

    EITHER:

    1. Select the Reporting period down arrow, and then select the period you want.
    2. Enter an As of date (the date that the system will use as a baseline for the period you select. Leave blank for today's date).

    OR:

    Enter a specific start date and end date. (If you prefer, to specify these dates select the icon next to each date field to open up a calendar window, and then select the date you want.)

  2. In the Based on options, select an option button to set whether to base the report's time period on one of the following:
    • The Start date of this series of recurring transactions
    • The Due date of the current transactions; or
    • The dates of the next transactions (Next date)

If you complete all the time period fields (that is, if you fill in the Reporting period, As of date, Start date, and End date fields), Intacct generates your report based on the start and end dates. It ignores the As of date.

Time period field Notes Limitations

Reporting period

These periods are relative to the As of date.

All periods begin on the first day of the period, such as the first day of the month, quarter, or year that you select.

Only works with As of date. Does not apply if you select a Start date or an End date.

As of fate

Leave this field blank to use today's date.

Only works with Reporting period. Does not apply if you select a Start date or an End date.

Start date, End date

Leave the Start date blank to include all information from the earliest date you entered data into your company up to and including the end date. Leave the End date blank to include all information from the start date up to today.

 

Prompt on run

Select this checkbox to force the system to wait for you (or anyone using this report) to enter a location, department, and/or time period before it will run the report.

 

Based on

The default value is the Due date of the current transactions.

 

Report filters

Use the filters to focus the results of your report. In effect, filters enable you to isolate and assemble just the data you want.

All From and To field pairs work the same way. Use them to get search results in as broad or as fine a range as you need, from everything in the system down to a single specific object.

To run this report for a single object:

  1. From the From dropdown list, select the object you want.
  2. From the To dropdown list, select the same object.

To run this report for a specific range of objects:

  1. From the From dropdown list, select the object that you want at the beginning of the range.
  2. From the To dropdown list, select the object that you want at the end of the range.

To run this report for all objects:

Leave both fields blank.

If you have a large number of objects or the report takes too long to process, use the From and To fields to run a series of smaller reports. For example, you can run five reports, one each for objects whose names begin with A-E, then F-J, K-O, P-T, and U-Z.

An object is a catch-all term that refers to any specific data item in the system. Customers, vendors, items, and accounts are all examples of objects.
  1. To limit the report to a specific customer or range of customers, use the From customer and To customer dropdowns.
  2. To limit the report to a specific customer type, select the customer type from the Customer type dropdown.
    • Partners and direct are two examples of customer types.
  3. To limit the report to a specific document template or range of templates, use the From document template ID and To document template ID dropdowns. The following are your choices:
    • Sales invoice
    • Sales order
    • Sales quote
    • Shipper
    • Shipper invoice
  4. To view additional payment columns in your report, select the Display Payment Details checkbox. The report displays Payment Method, Pay in Full, and Partial Payment Amount columns.

  5. In a multi-entity environment, you can filter by location, department, or both.

    1. To filter the report by geographic location, either enter the name of the region, country, state or territory, or city in the Location dropdown list. Or, select the location from the list.

      Enter or select a location if you want to run this report at the top level. The system uses the location that you specify to determine the appropriate currency.

    2. To filter the report by department within the company, enter the name of the department in the Department dropdown list. Or, select the department from the list.

    3. If you want the report to cover certain locations regardless of what's selected in the Location dropdown list, use the Show for dropdown list to select the locations for the report:

      • All locations: To include data for all locations regardless of the entity that you're currently using.
      • This location: To include data only for the entity that you're currently using.
      • Child locations: To include data only for the locations that are child locations of your current entity. For example, if your current entity is California, and you have child locations for San Francisco and Los Angeles, use this option to have the report include data only for Los Angeles and California.
Filter field Notes

From customer, To customer

Enables you to get data only for that specific customer or range of customers. By default these fields are blank, which means the report will get results for all customers.

Customer type

Enables you to get data only for the type of customer you specify here. By default this field is blank, which means the report will get results for all customer types.

From document template ID, To document template ID

Enables you to get data only for that specific document template or range of templates. By default these fields are blank, which means the report will get results for all document templates.

Display payment details

Displays Payment Method, Pay in Full, and Partial Payment Amount columns in report.

Formatting

Use the fields in this section to sort the report results and to select the report layout.

  1. Sort the data in the report by category. To do this, select the Sort by dropdown and then select the sort order you want.
    • The abbreviation "desc" after an option means "Descending order", reverse alphabetical or reverse numerical order.
  2. Set the report layout to either Portrait or Landscape mode. To do this, select the Page orientation dropdown and then select the layout you want.
Format field Notes

Sort by

The default sort order and number of options change depending on whether you want a summary report or a detail report.

Page orientation

Portrait is the default layout.

Titles and footer

Titles, subtitles, and footers apply only to the print versions of this report. Export to Excel or CSV, or select Print for a PDF version.

  1. Enter the title in the Report title 1 field.

    • This title displays in large type at the top of the page, directly under your company name.
    • You can type over any default name that Sage Intacct might have populated in this field.  

  2. Enter the subtitle in the Report title 2 field.

    • The subtitle displays in smaller type, directly beneath the main title.
  3. Enter the footer text in the Footer text field. Footer text displays at the bottom center of the report.

You can use up to 80 characters, including spaces, in each title, subtitle, and footer.