Maintain Stock Level Adjustments {FPMO4-26}

This option allows for the maintenance of the Stock Level or GRV Value Adjustment Transactions.

Usage of the option should be limited to the following transactions.

Take-on of the Store item quantities and total item value.
GRV/Invoice adjustments resulting the Stock Movement Account {FPMOR5-30} reconciliation.
Stock Taking Adjustments.
Write off of old or stolen stock.
The receiving of a package item after the pack process.

THIS OPTION MUST BE USED WITH GREAT CAUTION AND THE NUMBER OF USERS PER INSTITUTION SHOULD BE LIMITED TO SENIOR PERSONNEL ONLY.

The following must exist before the user can process a document in this option.

Transaction Types for Stock Issue and Return

The users have no control over the Transaction type in this option, it is maintained by the program. Transaction Types must be defined on option {FCSO-7} for the following events.

Event	Description	Type of Document
GRV adjustments
SV	PM - Additional Cost Decrease	SL
SI	PM - Additional Cost Increase	TL
Stock level adjustments
SA	PM - Adjust Value Decrease	SK
SQ	PM - Adjust Value Increase	TK

User Restrictions {FCSM-4}

Access must be linked to a user code before that user can process documents.
The Access Codes are:
FP or subdivisions FPS, which can be further subdivided FPSK and FPSL

FP - Allows processing of all PM documents
FPS - Allows processing of GRV adjustments and adjustments documents only.
FPSL - Allows processing of GRV adjustments only.
FPSK - Allows processing of stock adjustments documents only.

A user linked to an Access Code FPSK

Can perform document processing and query functions for document types SK and/or TK.
Cannot be linked to Access Codes FP or FPS as well
Can be linked to Access Codes FPR, FPO, FPSA, FPSC, FPSD, FPSF, FPSH, FPSP or FPSL as well

A user linked to an Access Code FPSL

Can perform document processing and query functions for document types SK and/or TK.
Cannot be linked to Access Codes FP or FPS as well
Can be linked to Access Codes FPR, FPO, FPSA, FPSC, FPSD, FPSF, FPSH, FPSP or FPSK as well

Fields in the option:

Block 1: Stock Level/GRV Value Adjustments

The option provides the functionality to enter input parameters for the creation of document types SK, TK, SL or TL. The appropriate documents are created on commit of the input parameters.
Only one record per document can be created.
The application distinguishes between the two adjustment types using the first field.

The default adjustment is a stock level adjustment
To process a GRV value adjustment the user must select the adjust GRV radio button..

This is not a data base block.

Field	Type & Length	Description
Adjust Stock or GRV	A1	The user must specify the kind of adjustment namely Stock or GRV. Adjust Stock Level - the user must complete the Store and Item Adjust GRV - the user must complete fields GRV, Store and Item
GRV Number	A10	The GRV number for GRV Value Adjustments. The field must be null (blank) if the intention is a Stock Level Adjustment. The list of values will give the latest GRV Numbers plus the date, line number, Item detail type, Store code, Item Number, Sequence and Quantity of the GRV.
Store Code	A2	The store codes as defined under option {FPMM-22} or the store code used in the GRV number if GRV Value Adjustment. The list of values will display as follws depending on the type of adjustment:- Stock Level Adjustment Store codes and Description. GRV Value Adjustment Store codes used in the GRV plus the date, line number, Item detail type, Item Number, Sequence and Quantity of the GRV.
Item Number	N4	The stock item code as defined under option {FPMM-23} to be adjusted The list of values will display as follws depending on the type of adjustment: Stock Level Adjustment Item codes linked to above store code plus description. GRV Value Adjustment Item Code for the above Store codes used in the GRV plus the date, Line number, Item Detail Type, Sequence and Quantity of the GRV.
After the item number was entered, the system will display the following information:
		Section Code and description. The position of the item in the store. Row, Rack. Shelf and Bin. Quantity on order (actual units). Present Stock (actual units). Present Item Value (Cost price per actual unit).
The Adjustment fields
Group 1: Before Adjustment values (Display only fields)
Stock Quantity		The same value as present stock.
Total Item Value		The formula of the value is Present Item Value multiplied by Stock Quantity before Adjustment.
Group 2: Adjustment values
Stock Quantity	N9.2	The total adjustment quantity in actual units is entered here. This value can be positive or negative. This field cannot be used if it is a GRV Value Adjustment.If user presses <RETURN> or <TAB> in the field the program will calculate the Stock Quantity After Adjustment and validate that the quantity is not less than zero aftyer adjustment.
Total Item Value	N9.2	The total adjustment value is entered here,Total adjustment value is a total value and not a unit value. The default value of this field is Stock Quantity Adjustment multiplied by the Present Item Value. When the user presses <RETURN> or <TAB> the program will calculate the After Adjustment Stock Value and validate that the total item value is not less than zero or if Stock Quantity After Adjustment is zero the After Adjustment Stock Value is zero. If the Stock Quantity After Adjustment is zero, the system will default the negative value of Total Item Value Before Adjustment into this field and then the value is not updateable by the user.
Group 3: Rounding Adjustment (Display only fields)
Total Item Value		This is the value of the rounding correction that can occur in Total Item Value After Adjustments. The formula of the value is: Value A = (Total Item Value Before Adjustment plus - Adjustment) divided by Stock Quantity After Adjustment rounded to two decimals. Value B = Value A multiplied by Stock Quantity After Adjustment Total Item Value Rounding Adjustment = Value B minus (Total Item Value Before Adjustment plus - Adjustment)
Group 4: After Adjustment (Display only fields)
Stock Quantity		The formula of the value is Stock Quantity Before Adjustment plus Stock Quantity Adjustment.
Total Item Value		The formula of the value is Total Item Value Before Adjustment plus - Adjustment and - Rounding Adjustment.
Group 5: Item Value (Display only fields)
New Item Value		The formula of the value is Total Item Value After Adjustment divided by Stock Quantity After Adjustment.
Reason for Stock Item Adjustment	A4	The code for the reason for adjusment is entered here. The description is then displayed. Reason Codes are defined in {FPMC-25}
The system will display also the following information:
Date	DD-MON-YYYY	The system date and it will be the process and document date.
Type of Document		Depending on the following, the system will allocate a type of document: GRV Value Adjustment Total Item Value greater than zero then TL otherwise SL. Stock Level Adjustment Total Item Value greater than zero then TK otherwise SK.
Document number		The system will generate the number using Auto Generated Numbers {FCSM-3} codes. K0 STORE ISSUE/EQUIVALENT NUMBER K1 STORE RETURN/EQUIVALENT NUMBER
Approval Information
Flag	A1	The system will default Flag = Y
Date	DD-MON-YYYY	The system will default date to system date.
User	A8	The system will default the User code that created the document.

Example:

Processing Rules
	No special processing rules

Date	System Version	By Whom	Job	Description
25-Apr-2007	v01.0.0.0	Amanda Nell	t134667	New manual format.
27-Feb-2009	v01.0.0.1	Marchand Hildebrand	t152121	Proof Read System Owner
05-Sep-2011	v02.0.0.0	Magda van der Westhuizen	t165835	Correct Spelling Errors
11-Sep-2012	v02.0.0.1	Mac Thipe	t177662	New field Reason for stock adjustment added