Skip to main content

Exports of stock/inventory

You can easily export stock/inventory information from Zigaflow for analysis in other tools

There are several places you can export this data from.

Logs

Click on the Logs icon in the top right to access these reports.

Logs icon menu open to Logs & Exports submenu, with Stock Log and Stock Valuation options highlighted

Stock Log

An export of all the stock movements in a selected period.

Stock Log window with the Last 30 Days date range dropdown highlighted, above a table of stock movements by item and location

Stock Valuations

Downloadable spreadsheets with the valuation per day of stock/inventory. This is ideal for checking past stock valuations.

Stock Valuation Reports list of dated snapshots with total, list cost and list price values, each with Details and Export buttons

Stock/Inventory Overview Screen

Go To -> Stock -> Overiew

Click on the Export button and select from these options:

Export button highlighted, showing Download to Excel options: Changes Summary, Log, Quantities by Location, Quantities & Values, Values

Changes Summary

This summarizes the changes by item and location:

Stock export spreadsheet summarizing items by location with columns for Quantity Held, POs, Delivery Notes, and Internal Adjustments

Log

This lists all the individual changes:

Stock export spreadsheet listing changes with Time Stamp, Item Code, Qty Before, Action, Qty After, Location and Narrative

Quantities by Location

Quantities of items by location with their values

Spreadsheet stock export listing items by Stock Location with Qty, Allocated, Free Stock, prices, costs and total values

Quantities & Values

The quantities across all the locations with values:

Stock export spreadsheet listing item codes with Quantity, Allocated, Free Stock, On Order, Minimum Qty and cost columns

Values

A reduced version of the Quantities and Values report:

Spreadsheet export of the Quantities and Values report with columns for Item Code, Quantity, Prices, Costs, Notes and Last Valuation Date

Learn more: stock and inventory in Zigaflow

Related Articles
Did this answer your question?