Looking for Beginning and Ending Inventory Report

XFMuseum — Wed, 23 Feb 2022 20:41:50 GMT

The title of this thread has been edited by a Square Moderator from the original: "Beginning and Ending Inventory Report"

I am looking for a report I can run that shows the beginning inventory of an item and the current/ending inventory of that same item. I need to know how many we started with and how many we have sold to see sales trends for that particular item. There must be a way to do this, but I'm coming up short when running reports.

Re: Beginning and Ending Inventory Report

Nexus_Software — Mon, 21 Feb 2022 14:57:37 GMT

Hello,

One way to achieve your desired report is to use Square's /v2/inventory/changes/batch-retrieve API endpoint.

The Batch retrieve inventory changes endpoint returns historical physical counts and adjustments based on the provided filter criteria. Results are paginated and sorted in ascending order according their occurred_at timestamp (oldest first).

Documentation for this endpoint is located at: https://developer.squareup.com/reference/square/inventory-api/batch-retrieve-inventory-changes.

For basic inventory history, you can view your inventory history and gain insights into the flow of your inventory by viewing historical adjustments in your online Square dashboard.

Thank you.

thread Re: Beginning and Ending Inventory Report in Archived Discussions (Read Only)

Looking for Beginning and Ending Inventory Report

Re: Beginning and Ending Inventory Report