Enhanced interface

Item Activity report

The Item Activity report contains detailed information about which items are available (on-order, on-hand, and reserved quantity totals), and where they are located.

The quantities on the Item Activity report reflect the value changes resulting from transactions, not quantities remaining. These quantities can differ from what you see on a Physical Inventory or Inventory Valuation report, since those reports show quantities available.

To report on the quantities of all the inventory totals in your organization, create a custom report using the Inventory total detail object.

Use the Item Activity report to view:

Items available in each warehouse.
Types of item transactions for a selected period.
Availability of items that are components of a kit (creating a sales order for a kit moves the component items to reserved status).

This report appears when you drill down into certain other reports. For example, if you select the Qty available or End qty links in the Inventory Status and Inventory Register reports respectively, the appropriate item is displayed in the Item Activity report so you can review the series of transactions that led to the running totals results.

Subscription	Inventory Control
Regional availability	Australia, Canada, UK, USA, South Africa
User type	Business, Employee, Warehouse
Permissions	Item activity: Run

View a monthly item activity report

Go to Inventory Control > All > Reports > Item activity.
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, Sage Intacct generates a report for the current month to date. You can set either the reporting period or the start and end dates, but not both.

For more details on reporting periods, see Time period.

To view all results for the default reporting period, select View.

You can run this report without entering any filters; however, the report could take a long time to run and may return too many results to be useful.

To include or exclude specific types of data in the report, set filters 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.
Add title, subtitle, or footer text to your report.
To view, process, memorize, export, or customize the report or add it to the dashboard, select one of the following options:
- View: View the report now, in your browser.
- Print: Display the report now, in printable PDF format.
- Process & store: Generate the report and store it for later access. Reports can be either stored in the My Stored Reports list or delivered to a cloud storage location, such as Dropbox. Learn more about processing and storing reports.
- Add to dashboard: Add the report to your dashboard.
- Memorize: Memorize (that is, save) the report so that later you can refer back to it or modify and re-run it.
  
  You can schedule memorized reports to run on a recurring basis. Intacct can automatically email the reports or deliver them to a cloud storage location.
- Export: Export the report to a separate file that you can then distribute or save to your local drive. File formats to which you can export the report data vary among reports.
- Customize: After you run the report, return to the main report page and refine the report further.
- Email: After you run the report, email to others.
Some options are only available if you access the report from the Reports center.

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.

To set the time period:

In the Time period section, do one of the following:

Select a reporting period from the Reporting period dropdown list. Then, either enter a date in the As of date field or use the calendar tool to select a date.
Enter a specific Start date and End date or use the calendar tool to select the dates.

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 prompt fields
Time period field	Description
Reporting period	The 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. Reporting period only works with As of date. It does not apply if you select a Start date or End date.
As of date	The date Sage Intacct uses as a baseline for the reporting period that you select. Leave this field blank to use to today's date. As of date only works with Reporting period. It does not apply if you select a Start date or End date.
Start date, End date	Leave the Start date blank to include all information from the earliest date of your Intacct data up to and including the end date. Leave the End date blank include all information from the start date up to today. The date format in your personal preferences determines the required format. The default is MM/DD/YYYY. The default date displayed in As of date shows the required format as does using the calendar tool.
Prompt on run	Select this checkbox to force Intacct to wait for you (or anyone using this report) to enter a location, department, or time period before it runs the report.

Report filters

Filters focus the results of your report, to isolate and assemble just the data you want. You can set any combination of filters.

Set filters to fine-tune your report results

Select a Report on option to track items by either Item ID or UPC code:
- To track items by Item ID: Select Item ID, and then use either the From item and To item dropdown lists or the Operator and Value fields to specify the items to include in your report.
- To track items by UPC code: Select UPC, and then use either the From UPC and To UPC dropdown lists or the Operator and Value fields to specify the items to include in your report.
The Operator and Value fields help you filter on specific items.
For example, if you want a report on an item with the ID 800HGT453 but you only remember part of the ID, such as the HGT characters, select Contains from the Operator dropdown, enter HGT in the Value field, and select View. Intacct finds and displays all items where the Item ID contains the character string "HGT". If you select Includes or Excludes from the dropdown, the Value field can contain a list of values separated by commas.
How to use From and To fields
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 necessary—from everything in the system to a single specific object.
To run this report for a single object:
1. From the From dropdown list, select the object that 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 to begin the range.
2. From the To dropdown list, select the object that you want to end the range.
To run this report for all objects:
- Leave both From and To fields blank.
If you have a lot of objects or the report takes too long to process, use the From and To dropdown lists to run a series of smaller reports. For example, you can run 5 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.
To show results for a specific warehouse or range of warehouses, use the From warehouse and To warehouse dropdown menus.

Filters section

Field	Notes	Limitations
Report on	Enables you to list items in your report by either Item ID or UPC code.	In Sage Intacct, all items have IDs, but not all items have UPC codes.
From item, To item	Enables you to get data only for a specific item or range of items, such as items from A to F, or item numbers 3100 to 5000.	Select items from these dropdown lists or UPC codes from the From UPC and To UPC dropdown lists, but not both.
Operator, Values	Enables you to filter your list by using an operator For alphabetical lists, "greater than" means later in the alphabet, and "less than" means earlier in the alphabet. To search for all items from T through Z, search for "Greater Than" "S." To search for all items beginning with "A," search for "Less Than" "B." Most of the operators are self-explanatory. Others: Contains: You're searching for all items that contain a particular string of letters and/or numbers. Does Not Contain: You're searching for all items except those that contain a particular string of letters and/or numbers. Includes: You're searching for all items that contain two or more particular strings of letters and/or numbers. Does Not Include: You're searching for all items except those that contain two or more particular strings of letters and/or numbers . After selecting an operator, enter a value in the Value field.	Enter data in these fields or use the From item and To item dropdown lists, but not both.
From UPC, To UPC	Enables you to get data only for a specific UPC code or range of UPC codes.	Select UPC codes from these dropdown lists or items in the From item and To item dropdown lists, but not both.
Operator, Values	Enables you to filter your list by using an operator For alphabetical lists, "greater than" means later in the alphabet, and "less than" means earlier in the alphabet. To search for all items from T through Z, search for "Greater Than" "S." To search for all items beginning with "A," search for "Less Than" "B." Most of the operators are self-explanatory. Others: Contains: You're searching for all items that contain a particular string of letters and/or numbers. Does Not Contain: You're searching for all items except those that contain a particular string of letters and/or numbers. Includes: You're searching for all items that contain two or more particular strings of letters and/or numbers. Does Not Include: You're searching for all items except those that contain two or more particular strings of letters and/or numbers . After selecting an operator, enter a value in the Value field.	Enter data in these fields or use the From UPC and To UPC dropdown lists, but not both.
From warehouse, To warehouse	Enables you to get data only for a specific warehouse or range of warehouses.
Product line	Use to show results only for a specific product line.
Include standalone value documents	Includes value-only transactions that weren't converted from any other transaction. Consider selecting this checkbox if the Qty on hand for an item doesn't match the QOH in the item's record or for the item in the Inventory Valuation report.
Exclude inactive items	Enables you to exclude inactive items from the report results. This option is particularly helpful if items were zeroed out and made inactive, but numbers are still appearing in the reports.
Exclude inactive warehouses	Enables you to exclude items in inactive warehouses from the report results. This option is particularly helpful if warehouses were zeroed out and made inactive, but numbers are still appearing in the reports.
Exclude items without activity	Enables you to exclude items that haven't been involved in any transactions from the report results.

Additional totals to be included

Filter field	Notes
In transit	Select to include the quantity of items that are being moved between warehouses with an in transit warehouse transfer.
Reserved	Select to show the quantity of inventory that's set aside to fill sales orders (qty tracked on any order not in Open status).
Allocated	Select to show the quantity of inventory that's assigned to specific orders (qty picked or packed).

Location and department filters

These filter options appear only if you work in a multi-entity environment.

To set location and department options:

To filter the report by geographic location, select the location from the Location dropdown list.

Enter or select a location to run this report at the top level. Intacct uses the location that you specify to determine the appropriate currency.
To filter the report by department, select the department from the Department dropdown list.
If you want the report to cover certain locations regardless of what you select in the Location dropdown list, in the Show for dropdown list select one of the following:
- All Locations: Include data for all locations regardless of the entity you're currently using.
- This Location: Include data only for the entity that you're currently using.
- Child Locations: 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 options
Filter field	Descriptions
Location	Use to limit report results to a specific location.
Department	Use to limit report results to a specific department.
Prompt on run	Select this checkbox to force Intacct to wait for you (or anyone using this report) to enter a location or department before it runs the report.
Show for	Select to show different views of the data, based on the location or entity you choose: All locations: This option shows the data that's posted to the location or entity and its children. This location: This option shows only the data that's posted to the location or entity you select. The data posted to any child location is not shown. Child locations: This option shows only the data that's posted to the child locations of the location or entity that you select. Any data that's posted to the parent location or entity is not shown. Example: Suppose your location is United States > California > San Francisco. All locations would show transactions for United States, California, and San Francisco. This location would show transactions for United States. Child locations would show transactions for California and San Francisco only.

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.

What's in this report?

The default Item Activity report consists of the following columns to help you identify where your items are stored, and current transaction status:

Report Column Heading	Description
Item ID	The ID assigned to the inventory item.
Item description	The full name of the inventory item.
UOM	The unit of measure the system used for the item quantity and costing calculations. For example, Each or a Dozen. By default this report displays the Base units of measure associated with the items. If the Inventory Control configuration option Enable UOM conversion in standard reports is set to true in your company, this report will use the default Inventory unit of measure for this report. Learn how to set the default Inventory unit of measure for a unit of measure group.
Warehouse	The warehouse for the item. The report is grouped by item and then by warehouse for each item.
Transaction	The transaction type and the document number assigned to the transaction. For example, Purchase Order or Sales invoice.
Date	The date on which the transaction occurred.
Qty on order	The change in the quantity in open purchase orders.
Qty in transit	The change in the quantity for inventory being moved in in-transit warehouse transfers. The in-transit quantity is tracked at the destination warehouse.
Qty on hand	The change in the quantity in stock at the warehouse.
Qty on hold	The change in the quantity on hand to fulfill open sales orders.

You can select any link to drill down to the details.