Navigation:  Movement Functions >

Order Requirements To Stores

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

This function is used to return parts previously issued to an order.

Parts may be returned and quarantined immediately.  Parts can be returned via a pallet.  If a pallet is returned, it is returned in full. If more than one part exists on the pallet id selected, the pallet cannot be selected in conjunction with the order line and part number combo boxes. To move such a pallet only the order number and pallet id has to be selected.

Parts can only be returned if they were issued, and with the same stock status, External Organisation and serial or lot numbers.

 

hmtoggle_plus1Additional Instructions

This field is enabled when an employee is selected in the "Send Message to Storeman" field and is used to specify any additional instructions regarding the movement.

It is an alphanumeric field with a maximum length of 100 characters (optional).  Any additional instructions entered here will be included in the mail message sent to the selected Employee in the combo Send Message to Storeman.

 

hmtoggle_plus1Apply

The user must have a security profile linked to the function Store to Order Requirements with an access allowed of Inquire.

 

The "Apply" button is enabled when the user is either the Store Manager or he was granted rights by the store manager of the selected store for the movement Order Requirements to Stores.  When the "Apply" button is clicked, the following updates are performed according to the mode selected:

 

1.The system performs a front end validation to see that all the mandatory fields have been entered.

 

2.If a Pallet ID is selected, the Movement_Cust_Order_To_Pallet stored procedure is executed.  If you are not using the  front end for updates, the following parameters can be passed to the stored procedure:

 

Pallet_ID                          pallet                                Movement Pallet ID

Store_Code                        store                                Into Store

Division_Code                      division                        Into Division

Order_Type                        order_type                        'CUST'

Order_Number              order_number                        Movement Customer Order

Reason_Code                        varchar(10)                        Valid Movement Reason Code

if 'Part to be Quarantined' is checked, else spaces Quarantine bit "1" if 'Part to be Quarantined' is checked, else"0"

Location                          store_location                        Into Location

 

When executing the stored procedure, the pallet content of all the components of the selected pallet ID will be updated by inserting the selected Stores Division Code, the Store Code of the selected Store and the location as entered on the movement in the Location field.

 

3.The Movement Store Order Reqs stored procedure is executed automatically if a

Pallet ID is selected

If a Pallet ID is not selected, and you are not using the front end for updates, the following parameters can be passed to the stored procedure.

 

FIELD                                                TYPE                                                DESCRIPTION

Serial_Number                          Serial_Number                                                      Serial Number of Movement Requirement Part

Employee                                employee_id                                                                           Logged on User ID

Order_Number                            Order_Number                                                                                 Movement Order Number

Order_Type                              Order_Type                                                                   Movement Order Type

Line_Number                            Order_Line                                                           Movement Order Line Number

Line_Type                              char(4)                                                                       Movement Order Line Type

Completion_Date                smalldatetime                                                          Movement Order Line Completion Date

Quantity                                decimal(16,5)                                                                   Movement quantity Crate                                                  

Reason_Code                            varchar                                                  Valid Movement Reason Code if 'Part to be Quarantined' is checked, else spaces

Requisition_Number              Requisition                                                                Spaces, else if exists for this Order Line, from Order_Issue_Requisition table

Division_Code                          Division                                                               From Division

Store_Code                              Store                                                                                From Store

Location                                Store_Location                                                                                              From Location

Stock_Status                            char(1)                                                                   Status of selected stock

Organisation_Code              Organisation                                      Spaces or if applicable, Movement External Organisation code

 

 

 

4. The system determines the current financial year and selects the Stock Valuation Method from System Configuration.

 

If a requirement part number is selected, the system selects the part's fixed account indicator, source, controlling division and serialised indicator from the Part Master table.

 

If the Stock Valuation Method is Standard Cost "S", the part source is Interplant "I", the movement's division code is equal to the part's controlling division, the part's unit cost is calculated as the (Material Price + Labour Price + Subcontract Price + Overhead Price + Fixed Overhead Price) from the Part Financial Year Data table

 

ELSE

 

The unit cost is calculated as (Material Price + Labour Price + Subcontract Price + Overhead Price + Fixed Overhead Price + Transfer Price) from the Part Financial Year Data table.

 

The system validates that the order is still a valid order and selects the allocated quantity from the Requirements table.

 

5. The Requirements table is updated.  The issued quantity is down adjusted with the movement quantity and the allocated quantity is set equal to the allocated quantity.

 

6. The Allocation table is updated.

 

7.The Update Location stored procedure is executed.

 

The Location table is updated and the Quantity On Hand is up adjusted with the movement quantity.  When the line type is Rework "REW", and the requirement allocated quantity is equal to zero, the quarantine quantity is down adjusted with the movement quantity.

 

8. The movement is created and original movement is updated.

 

9. The Update Requisition Actual stored procedure is executed.

The Requisition table is updated.  When the stock status is not New "N" or Used "U", fixed account is not Yes "Y" and an organisation is not entered, the unit cost is down adjusted with the movement quantity.

 

10. If an Order Line exists where node or account is not spaces en requisition number is not spaces, a record is inserted into the Requisition Journal table.

 

11. The standard cost Requirements to Stores Journal (stored procedure = Journal ORQ Store Std Cost) is written for fixed accounts.

 

The average cost Requirements to Stores Journal (stored procedure = Journal ORQ Store Avg Cost) is written for fixed accounts with a stock status of new or user and an external organisation of spaces.

 

BUSINESS RULES WHEN APPLYING AN ORDER REQUIREMENTS TO STORE MOVEMENT:

 

1.        The user must select a valid requirement Part Number.
2.        The user must select stock to be issued.
3.        The user must select a valid store.
4.        The movement quantity must be between the minimum and maximum quantity allowed.
5.        The movement quantity must be 1 for serialised parts.
6.        If serialised is "yes", a serial number must be selected.
7.        You cannot issue more than the outstanding quantity of the requirements.
8.        The requirement quantities must be able to consume the pallet content when a pallet is selected.

 

12. Journals

The following Journals will be created for the movement:-

        General Rules for journals are that Only stock with a stock status of New or Used for movements where the External Organisation is spaces and where the movement part has a Fixed Account of Yes will write Journals.

        When Non Fixed Account requirements is returned to store with on a order with a Node on it, the stock is returned with the WBS node of the order on it and therefore the Location Node and WBS Node will be the same. There will be no Journal in these circumstance.

 

Condition

Account

Debit

Credit

Comments

Standard Cost:-

Order Line has no Account or Node and part Moved is Fixed Account = Y

Stock Account from Movement Store.

Sum of Part Financial Year Data * Movement Quantity




Work In Progress Account from Order Division


Sum of Part Financial Year Data * Movement Quantity * -1


Order Line Has Account Or Node. Part Moved is Fixed Account = Y

Stock Account from Movement Store.

Sum of Part Financial Year Data * Movement Quantity




WIP Project Management Account of Order Division, or Node Material Account if exists or Order Line Account if exists


Sum of Part Financial Year Data * Movement Quantity * -1


Division On Order <> Division on Store

Inter Divisional Clearance Account Order Division

Sum of Part Financial Year Data * Movement Quantity


Inter Divisional Clearance journals will only write if Order and Store Divisions differs


Inter Divisional Clearance Account Store Division


Sum of Part Financial Year Data * Movement Quantity * -1


Order Line has no Account or Node and part Moved is Fixed Account =N




No Journal

Average Cost:-

Order Line has no Account or Node and part Moved is Fixed Account = Y

Stock Account from Movement Store

Requirement Average Cost * Movement Quantity




Work In Progress Account from Order Division


Requirement Average Cost * Movement Quantity * -1


Order Line Has Account Or Node. Part Moved is Fixed Account = Y

Stock Account from Movement Store

Requirement Average Cost * Movement Quantity




WIP Project Management Account of Order Division, or Node Material Account if exists or Order Line Account if exists


Requirement Average Cost * Movement Quantity * -1


Order Line has no Account or Node and part Moved is Fixed Account =N




No Journal

Division On Order <> Division on Store

Inter Divisional Clearance Account Order Division

Sum of Part Financial Year Data * Movement Quantity


Inter Divisional Clearance journals will only write if Order and Store Divisions differs


Inter Divisional Clearance Account Store Division


Sum of Part Financial Year Data * Movement Quantity * -1


 

 

hmtoggle_plus1Available Movements

This list box displays all available, "Store to Order Requirements" movements in descending date order.

 

It is populated with the movements date time, stock status, quantity available for return calculated as (quantity issued - quantity returned), unit cost, revision, account, and responsible organisation, from the Movement table, for the selected order number and order line, where the quantity available for return is greater than zero.

 

If a pallet is selected for return, all lines with the pallet ID in the crate field for Store to Order Requirements movements where the quantity less the quantity returned is greater than zero are populated.

 

An available Issue movement has to be selected in order to return a component.

The Movement Unit cost of the issue movement will be used during the return movement of the inventory. In a Standard cost database, where the stock has been issued to an order line with a Node or an Account on the line, the stock will be returned to store at the current Part Financial Year data and the Project Wip Account of the Node on the requisition or the Account on the requisition will be credited by the Original forward movement unit cost. The difference between the Current Part Financial Year Data and the Original forward movement unit cost will be written to the Stock Revaluation Account of the Store Division.

hmtoggle_plus1Deliver to Operation

It is a read only field that displays the operation, of the selected part number,as per the selected forward movement in the available movements listbox.

hmtoggle_plus1Display Serial Number

This check box will enable when the selected Part Number is serialised or Lot controlled. If selected, the list box that displays the stock in stores will display the serial numbers or lot numbers of the stock per store. If not selected the stock will be displayed without the serial or lot numbers and all stock will be grouped by the location field.

hmtoggle_plus1External Organisation

It is populated with the name from the External Organisation table, and the organisation code from the Movement table, for the selected forward movement. The External Orgaisation displayed here will be entered into the movement table as well as the location table. Only the value of the forward movement can be entered here in order to retain the stock ownership.

hmtoggle_plus1Instruction

The "Instruction " button is only enabled when an employee is selected in the field "Message to Storeman".

When the "Instruction" button is clicked, the instruction is sent to the selected person in the store, to make the relevant stock movement via the Internal Mail system.

hmtoggle_plus1Location

This field is populated with the location format preferred, location format alternative 1 and location format alternative 2 from the Store table for the selected store whenever a new store is selected.

This field will also display the location of the selected stock when a line is selected in the "Stock" list box.

If a location exists for the Part Number on the selected Division and Store and with the corresponding status on the table Part Stock Location, the location will be defaulted into the location field once the Store/Division and stock status has been selected. Alternatively a new location can be entered in the Location field.

When the movement is performed it will check that the Quantity on Hand does not exceed the location Maximum as specified for the selected location.

hmtoggle_plus1Message to Storeman

This field is used to specify the name of storeman to which the message is to be sent.

 

It is populated with the surname, first name, middle initial, and the employee ID from the Employee Master, Store Employee Access and Store tables where:

 

         The status is Active (A) or Unavailable (U),

         The employee has movement rights on the selected Store, or

         The employee is the manager of the selected Store as specified on the Store table.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

hmtoggle_plus1Movement Quantity

The Movement quantity is restricted to the Movement Quantity minus the Quantity Returned from the selected forward movement in the available movements list box.The movement Quantity can be changed to less than the defaulted Quantity but must be equal to one or more. In the case of serialised parts the quantity can only be one.

hmtoggle_plus1Order Line

It displays all the available lines for the selected order number where the line type is not equal to Stock "STCK" or Non-Stock "NSTK".

 

It is populated with the line number,completion date, part number and the line type from the Order Line table, for the selected order number, where:

 

         The status is Released "R"  and

         The line is not a Stock "STCK" or Non-Stock "NSTK" line.

 

It also selects the requisition number, node, (required amount - actual amount), and status from the Order Issue Requisition and Requisition tables for the selected order number, if the selected order line has a node or an account in order to check the requisition status for the movement.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

hmtoggle_plus1Order Number

It displays all released and closed orders for the selected store, where the line type is not Stock "STCK" or Non-Stock "NSTK".

 

It is populated with released and closed order numbers, order types, and notes, from the Order Master and Order Line tables where the line is not a Stock "STCK" or Non-Stock "NSTK" line.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

hmtoggle_plus1Pallet Id

This field is enabled when a customer order is selected.  It is populated with the pallet ID, pallet type, and serial number from the Pallet Instance table where the ship to organisation is equal to spaces.

 

If more than one part exists on the pallet id selected, the pallet cannot be selected in conjunction with the order line and part number combo boxes. To move such a pallet only the order number and pallet id has to be selected.

hmtoggle_plus1Part To Be Quarantined

This setting governs whether the part returned from order requirements to the selected store must be quarantined.

 

When checked, parts received from order requirements can be quarantined when received into the store.

 

The "Reason Code" field will populate with reason codes from the Movement Reason Codes table where the quarantine option is selected. On apply, the part will be moved into the location as quarantined stock.

 

When unchecked, the Reason Code field is populated with all the quarantine reason codes.

hmtoggle_plus1Part Number

It is populated with the part number, required date, deliver to operation, and required quantity from the Requirements table and part description from the Part Master table, for the selected order line where the issued quantity is greater than zero.

hmtoggle_plus1Populate

The "Populate" button is enabled when the user enters a serial number in the "Serial Number Like" field.

When the "Populate" button is clicked, the "Stock" list box is populated with stock where the serial number is like  the "serial number like" entered.

hmtoggle_plus1Reason Code

This field is used to indicate the reason why the part received into the store from order requirements is quarantined.  This field is enabled in conjunction with the field, "Part to be Quarantined".

 

It is populated with all quarantine reason codes and descriptions from the Movement Reason Codes table.

 

If "Part to be Quarantined" is checked, it is populated with all quarantine reason codes and descriptions from the Movement Reason Codes table where the field Quarantine is checked "1".

hmtoggle_plus1Serial/Lot Number

It is populated with serial/lot numbers from the Movement table for the selected Movement in the Available Movement List box where the movement quantity is greater than the Quantity Returned. This field will only populate with serial Numbers for Serialised or Lot Controlled Parts

 

When a line is selected in the available movements list box this field will display the serial/lot number of the selected movement record that was originally issued to the requirement.

hmtoggle_plus1Serial Number Like

This field is only enabled/displayed when a serialised or Lot Controlled part is selected in the "Part Number" field.

 

This field is used when populating the "Stock" list box (the list box will only be populated with stock that has a serial number that matches the number specified in this field when the button"Populate" is clicked).

hmtoggle_plus1Stock Status

When a line is selected in the "Stock" list box, this field will display the stock status of the selected forward movement.

hmtoggle_plus1Stock

It displays all the stock for the selected requirements part number.

It is populated with the location, stock status, quantity on hand, quarantine quantity, serial number, and organisation code from the Location and External Organisation tables for the selected requirements part number.

Where the user entered a value in the "Serial Number Like" field, the list box is populated where the serial number matches the "serial number like" text

When a User select a row in the list Box the Location field will be populated with the Location from the selected row.

hmtoggle_plus1Store

This field specifies the store where the part(s) must be received, from order requirements.  It displays the store code and description and the division code and division description of the selected store.

It is populated with the store code and store description from the Store table and the division code, and division description from the Division table, and the location format predefined and the location format preferred from the Store table where:

The store is not an in transit store.

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

 

RELATED TOPIC: In Transit Store on Store.