Spread Memorized Transaction List
  • 04 Jul 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Spread Memorized Transaction List

  • Dark
    Light
  • PDF

Article summary

The Spread Memorized Transaction List displays all spread and memorized transaction details from within a selected time frame. This enables a User to view the Locations associated with each spreading, the cost of each spread, the amount of times set to repeat, and the number of times each spread was repeated.


Navigation

  1. In the Reports section of the left navigation pane, select My Reports.
    The My Reports screen appears.

  2. At the top of the My Reports screen, select Financial.
    The screen generates a list of Financial reports in alphabetical order.

  3. Locate the Spread/Memorized Transaction List.

  4. Select Customize to adjust the report parameters and run the report.


Report Parameters

Field

Description

Filter By

Select a location reporting category by which to filter the report.

Options in the Filter By menu are configurable and specific to your organization.

Filter

Select specific filters from the selected Filter By category to determine what items appear in the generated report.

For example, if Filter By is set to Region, the Filter menu might include options such as North, South, East, and West.

Options that appear in the Filter menu are configurable and specific to your organization.

Start

Start date for the report.
The Start and End dates create a date range for which to generate data for the report. 

  • Selecting Today will automatically enter today's date in the field. 

  • Selecting Yest. will automatically enter yesterday's date in the field.

End

End date for the report.
The Start and End dates create a date range for which to generate data for the report. 

  • Selecting Today will automatically enter today's date in the field. 

  • Selecting Yest. will automatically enter yesterday's date in the field.

Spreads Remaining

Determine whether to show or hide current spreads.

  • Select Yes to show current spreads.

  • Select No to hide current spreads.

View controls

Select, save, edit, or delete a report view.
For more information about these controls, see My Reports: Using My Reports.

Run

Generate the report.
Select the arrow to Export, Email, or Print the report.


Report Columns

Column Title

Description

Orig Number

The original transaction number. This number is hyperlinked to the transaction. Expand a row to view additional columns:

  • JE Number - The Journal Entry that pulls the amount from the transaction and posts it to its correct account based on the time frame marked for the Spread Recurrence. This number is hyperlinked to its JE.

  • JE Date - The date that this entry was made.

  • Amount - The amount that was entered on that JE.

  • Spread Type - The type of Spread Recurrence, as noted on the 'Spread Transaction' pop-up window.

  • Spread Number - The sequential number in which this spread was repeated.

  • Approval Status - The status of the JE, which shows as Approved or Unapproved.

Company Name

Name of the vendor associated with the transaction.

Location Name

Location associated with the transaction.

Doc Date

Date of the document.

Amount

Subtotal of the spreads on the transaction details.

First Spread Date

First date when the spread occurred.

Last Spread Date

Most recent date when the spread occurred.

Times to Repeat

Number of times that a JE should be created as a result of the Spread Recurrence selection.

Time Repeated

Number of times that a JE has been created as a result of the Spread Recurrence selection.


Email, Export, or Print the Report

This report can be emailed, exported, or printed in custom formatting directly from the reporting window.
Click here to learn how to send, export, or print this report.


Was this article helpful?