Item activity reports

An Item Activity report contains detailed information about which items are available (on-order, on-hand, and reserved quantity totals), and where they are located. 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).

For more information, see Item Activity report in the Sage Intacct Help Center.

Run an item activity report

post/services/reports/inventory-control/item-activity

Runs an item activity report

SecurityOAuth2
Request
Request Body schema: application/json
required

Report parameters

title1
string

Primary title for the report.

Example: "Item activity June 2025"
title2
string

Secondary title for the report.

Example: "Monthly report"
footerText
string

Text of the footer included in the report.

Example: "June 2025 Item Report"
scheduledReportDate
string <date>

Specifies the date on which the report is scheduled to run.

Example: "2025-06-30"
outputType
string

Output format for the report.

Enum: "csv" "excel" "html" "pdf" "text"
Example: "html"
outputLocation
string

Specifies where the report is stored and can be accessed.

Enum: "cloud" "intacct"
Example: "intacct"
reportName
string

Specifies the name used in report lists.

Example: "June 2025 Item Report"
object

Report cloud store options

cloudStore
string

Predefined cloud store name, required with the cloud outputLocation

Example: "CloudStore"
object

List of Predefined cloud stores name, required with the cloud outputLocation

key
string

Unique key for the cloud storage.

Example: "44"
id
string

Unique identifier for the cloud storage.

Example: "Amazon Storage Plan"
path
string

Cloud store path, used with the cloud outputLocation

Example: "2025 Reports"
object

parameters

reportOn
string

Specifies whether to report on itemID or UPC.

Enum: "UPC" "itemID"
inventory-control-item-filter (object) or inventory-control-item-operator (object) or inventory-control-upc-filter (object) or inventory-control-upc-operator (object)
One of:
object
object
key
string

Product line key

Example: "319"
id
string

Product line ID

Example: "Automotive"
includeStandaloneValueDocuments
boolean
Default: false

Indicates whether to include value-only transactions that weren't converted from any other transaction.

Example: false
excludeInactiveItems
boolean
Default: false

Indicates whether to exclude inactive items.

Example: false
excludeInactiveWarehouses
boolean
Default: false

Indicates whether to exclude inactive warehouses.

Example: false
excludeItemsWithoutActivity
boolean
Default: false

Indicates whether to exclude items without activity.

Example: false
includeInTransitTotal
boolean
Default: false

Indicates whether to include the INTRANSIT total, which is the number of items that are being moved between warehouses with an in transit warehouse transfer.

Example: false
includeReservedTotal
boolean
Default: false

Indicates whether to include the RESERVED total, which is the number of items that are moved into the fulfillment process.

Example: false
includeAllocatedTotal
boolean
Default: false

Indicates whether to include the ALLOCATED total, which is the number of items in the fulfillment process that have been assigned to an order.

Example: false
txnFilter
string

For multi-entity companies, specify the transaction locations for which to show results.

  • allLocations - show results for the top level and all entity locations.
  • thisLocation - show results for the current entity's location.
  • childLocations - show results for entities only (omit the top level).
Enum: "allLocations" "childLocations" "thisLocation"
Example: "allLocations"
Responses
200

OK

400

Bad Request

Request samples
application/json
{
  • "title1": "Item activity through 2024",
  • "title2": "All items",
  • "footerText": "2024 report",
  • "reportNamee": "Item activity 2024 all",
  • "outputType": "pdf",
  • "outputLocation": "intacct",
  • "parameters": {
    • "timePeriod": {
      • "periodToDate": {
        }
      },
    • "reportOn": "itemID"
    }
}
Response samples
application/json
{
  • "ia::result": {
    • "reportId": "114",
    • "status": "submitted",
    • "outputType": "pdf",
    • "outputLocation": "intacct",
    • "href": "/services/reports/status?reportId=114&outputType=pdf&outputLocation=intacct"
    },
  • "ia::meta": {
    • "totalCount": 1,
    • "totalSuccess": 1,
    • "totalError": 0
    }
}