Difference between revisions of "Stock Movement Report"
Jump to navigation
Jump to search
m (info added) |
m (spelling corrections) |
||
| Line 27: | Line 27: | ||
*Store | *Store | ||
*Bin location | *Bin location | ||
| − | *Customer Account Reference- If there "tp_acno" is set during the import, it will be displayed here, | + | *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 | + | *Cost Price-Current cost price |
| − | *Sell price - Selling price at the time of | + | *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=== | ===There is a download CSV option after running the report=== | ||
[[File:Download-csv-blue-short.PNG|alt=Downlaod=|Download]] | [[File:Download-csv-blue-short.PNG|alt=Downlaod=|Download]] | ||
Latest revision as of 13:40, 1 November 2021
Contents
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
