Shows stock movements in the last 7 days.
Stock movements are added when pre-advices are receipted and when orders are confirmed picked.
Â
Output
| Field Name | Notes |
|---|---|
| CustomerCode | Â |
| ProductCode | Â |
| RotationNumber | Â |
| MovementDate | This is the date that the movement occured on the system. For stock being received there is a warehouse receipt date but this is the date when the stock was on and available to use For stock being desptached there is an orders processed date but this is the date when the order was confirmed picked and in the case of a duty paid warehouse is the duty point. |
| StockMovementDescription | Â |
| TotalSingles | Â |
| Cases | Â |
| Bottles | Â |
| OutboundUID | Â |
| InboundUID | Â |
Â
Criteria
The movements date is in the last seven days
The movements type is one where stock is being added or deducted, payments of duty, warehouse location changes are excluded from this type of movement.