Cust.vwStockMovements7

Owned by Alan Gilchrist
Last updated: Aug 20, 2020 by Sarah Stalley (Unlicensed)
1 min read

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

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

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.

Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.