Get Inventory Movement

Returns a list of inventory movement figures per outlet.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

Requires the Sales module or the Inventory module, and Insights Hub access for the user.

Period boundaries

Each outlet's period runs from just after its opening boundary up to and including its closing boundary.

  • The opening boundary is the finished timestamp of the full count the outlet closed on the start date (the latest, if it closed several), or the start_datetime you passed, unchanged, if it closed none.
  • The closing boundary follows the same rule against the end date and end_datetime.

Calendar days are resolved in the library's timezone, not UTC, so a count finished at 23:30 UTC can belong to the following day. The offset you send on start_datetime does not change which day a moment falls on.

So for an outlet that counted at 14:00 on the start date, the movements booked before 14:00 are left out, because they belong to the previous period. opening_value_has_full_count and closing_value_has_full_count tell you which rows a count applied to.

Signs

The response mixes two sign conventions, so adding the fields up as they are double-counts what left the outlet:

  • sold_stock_value, created_out_stock_value, transfers_out_value, shipped_out_stock_value and wasted_stock_value are negative, because that stock left the outlet.
  • positive_variance_value and negative_variance_value are both positive, even though a negative variance is a loss. Use net_variance_value for the signed figure.
Query Params
date-time
required

Start of the reporting period, in ISO 8601 format.

date-time
required

End of the reporting period, in ISO 8601 format. Must not be earlier than start_datetime.

string

Comma-separated outlet IDs to report on. Omit to report on every outlet in the library. IDs that do not exist, or that belong to another library, match nothing rather than returning an error.

string

An outlet name to query on. Matches outlets whose name contains this value.

string

Filter on outlet custom fields. Check reference guide for details.

string
enum

Restrict to outlets by whether they closed a full count on the start date. actual keeps only those that did, theoretical only those that did not, all applies no restriction.

Allowed:
string
enum

Restrict to outlets by whether they closed a full count on the end date. actual keeps only those that did, theoretical only those that did not, all applies no restriction.

Allowed:
int32

A page number within the paginated result set.

int32
≤ 200

Number of outlets to return per page. Maximum 200.

Responses

400

A filter is missing or malformed.

403

The library has neither the Sales nor the Inventory module, or the user lacks Insights Hub access.

Language
Credentials
OAuth2
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json