...
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 |
occurred 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
...