Query Item Movement {FPMO4-21}

This option allows a user to query item movements.

On entering a store code and item on the "Query Item Movements" tab page the item description, present issue value, the stock level “In Stock” and “On Order” quantity is displayed.

On navigating to the Item Deatil tab page,the following item movement deatil is displayed:

Date of movement,
Document type and the description (e.g. “Order”, “Delivery”, etc.),
Reference 1 is the document numbers
Reference 2 is the original document or in the case of an order is it the sequence number or the record in the order,
Quantity involved (as number of items),
The value of the item at time of movement,
The cost price of the item at the time of the movement,
The user code of the person who initiated the movement.

Fields in the option:

Block 1: Query Item Movements

Field	Type & Length	Description
Store Code	A2	Store code.
Item Code	N8	Item code to query.
Present issue Value	Display	Displays present issue value.
In Stock	Display	Displays the stock levels "In Stock" in issue units.
On Order	Display	Displays the "On Order" quantity.

Example:

Block 2: Item Movement Detail

The tab page displays the item movement detail. On navigating to the tab page all records for the item and store are queried but the user is allowed to query specific records. As the date contains date and time value any query on date should end with the character "%". If this character is not present the system will not query the user request.

Field	Type & Length	Description
Date	DD-MON-YYYY	Date of the item movement for query purposes, enter % query e.g. DD-MON-YYYY
Type of Document	A2	The type of document and the description (e.g. "Order", "Delivery", etc.),
Ref #1	A10	Reference 1 is the document number of a stock receipt or issue
Ref #2	A10	Reference 2 is the original document or in the case of an order is it the sequence number or the record in the order,
Quantity	N6.3	Quantity in stock units not issue units
Value	N15.2	The unit price of the item at which the item was received or issued. Multiplying the value with the quantity should always be equal to the item total on the document.
Cost Price	N15.2	The weighted average cost price resulting from the movement. Weighted Average Cost Price = New Cost / New Quantity New Cost = The stock value on hand before the movement plus/ minus cost of the movement. New Quantity = The quantity on hand before the the movement plus/ minus quantity of the movement Receipts are added i.e GRV, Departmental Returns Issue are subtracted i.e Departmental Issues, Supplier Returns ** The weighted average cost price is expressed in terms of issue units
User	A8	The user code of the person who initiated the movement.

Example:

Processing Rules
	No special processing rules

Date	System Version	By Whom	Job	Description
10-Jun-2007	v01.0.0.0	Amanda Nell	t134646	New manual format.
27-Feb-2009	v01.0.0.1	Marchand Hildebrand	t152121	Proof Read System Owner