Stock Movement Report

In This Section

Here you will be able to export all of the stock movements over a period of time.

Select Customer Account

You can search the company name here.

Select SKU

You can search using the SKU or stock name (Or a bit of both sometimes works)

Date From

Select the date in the following format yyyy-mm-dd

Date To

Select the date in the following format yyyy-mm-dd so when selecting "1 Day"- Enter the same date in both From and To.

Include Packs

The master pack item is hidden by default so it will only show the child items, tick this to include packs as well.

Run Report

Once the report has been run, these are fields:

• Date-this is the date/time.
• SKU.
• Order No- the 9 digit spitfire order number.
• Issued quantity- The issue/delivered quantity.
• Store
• Bin location
• Customer Account Reference- If there "tp_acno" is set during the import, it will be displayed here, if not it will display the numeric Spitfire Customer ID.
• Cost Price-Current cost price
• Sell price - Selling price at the time of order- this will be 0.00 if it is a pack item as it won't hold the selling price against it.

There is a download CSV option after running the report