Navigation:  Inventory Management >

Stock Allocation

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

This function provides the user with the ability to allocate and de-allocate stock to the requirements of firm or released orders.

 

Stock is allocated on an exceptional basis, either to reserve stock for usage by a specific order or to make certain stock status items recognizable for the order as available stock.

 

Examples of the latter is, stock belonging to an External Organisation where the organisation is equal to the organisation on the Order, used stock as a replacement for new stock, and repaired stock as a replacement for new stock.

 

Stock can also be allocated to reserve a specific serial number(s), or it can be allocated out of a specific store or location for the Order.

 

Allocated stock will be seen by MRP, to have already satisfied the requirement on the Order and will therefore not be available for other requirements.

 

The user is allowed to allocate Stock to Stores Issue Requisitions.  Stock can be allocated to Multiple Requirements of an Order, and stock of a specific Part can be allocated to different Orders.

 

On this tab the following fields can be viewed:

 

hmtoggle_plus1Allocate

The user must have a security profile linked to the function Stock Allocation with an access allowed of Change.

 

The  button is only enabled when a row is selected in the "Stock Locations" list box.  When the  button is clicked, the allocated quantity on the Requirements table is updated with the quantity that you have moved.  It is updated where:

 

1.        The requirements order number is the same as the order number;

2.        The requirements order type is the same as the order type;

3.        The requirements line number is the same as the line number selected;

4.        The requirements completion date is the same as the completion date on the selected line number;

5.        The requirements deliver to operation is the same as selected deliver to operation on the unallocated requirements list;

6.        The requirements part number is the same as the selected part number in the unallocated requirements list; and

7.        The requirements required date is the same as the selected required date in the unallocated requirements list.

 

The allocated quantity on the Allocation table is updated with the quantity you have selected to allocate.  It is adjusted where:

 

1.        The requirements order number is the same as the order number;

2.        The requirements order type is the same as the order type;

3.        The requirements line number is the same as the line number selected;

4.        The requirements completion date is the same as the completion date on the selected line number;

5.        The requirements deliver to operation is the same as selected deliver to operation on the unallocated requirements list;

6.        The requirements part number is the same as the selected part number in the unallocated requirements list; and

7.        The requirements required date is the same as the selected required date in the unallocated requirements list.

8.        The location serial number is the same as the selected serial number in the "Stock Locations" list box (if there is a serial number);

9.        The location division code is the same as the selected location on the "Stock Locations" list box;

 

11.  The location store code is the same as the selected store code from the store combo box;

12.  The location is the same as the selected location in the "Stock Locations" list box,

13.  The location stock status is the same as the selected stock status in the "Stock Locations" list box;

14.  The location organisation code is the same as the selected organisation code in the "Stock Locations" list box.

 

When allocating and an allocation record does not exist, a new allocation record is inserted.

 

The Location table is updated by means of a trigger on the Allocation table.    On the Location table the allocated quantity is updated with the quantity you have allocated and it is done in the specific record where:

 

1.        The location serial number is the same as the selected serial number in the "Stock Locations" list box (if there is a serial number);

2.        The location division code is the same as the selected location on the "Stock Locations" list box;

3.        The location store code is the same as the selected store code from the store combo box;

4.        The location is the same as the selected location in the "Stock Locations" list box,

5.        The location stock status is the same as the selected stock status in the "Stock Locations" list box;

6.        The location organisation code is the same as the selected organisation code in the "Stock Locations" list box.

7.        The locations part number is the same as the selected part number in the Stock Locations list box.

 

When allocating you will always be able to allocate only the minimum of the requirements quantity or the location quantity.

hmtoggle_plus1Allocate/De-Allocate Quantity

This field is only enabled when a row is selected in either the "Unallocated Requirements" or "Allocated Requirements" list box and a row is selected in the "Stock Locations" list box.

 

If an unallocated record is selected, the maximum value that can be typed in this field is the lesser of the available quantity of the selected stock record and the (outstanding quantity -

order-cross reference quantity).

 

If an allocated record is selected, the user can only down adjust the quantity.

 

Where a serialised part is selected, the quantity to allocate or de-allocate may only be 1.

 

If Decimal Movements are allowed on the Part Master table, the user will be allowed to enter a value resulting in a decimal.

hmtoggle_plus1Allocation Mode

In this mode the user may choose to allocate one or all the requirements at the same time to a line on an Order or Requisition.

hmtoggle_plus1Allocated Requirements

It is populated with the part number, sum of the allocated quantity, order x-ref quantity, description, manufacturing part number, deliver to operation, required date, location and

organisation code from the Allocation table, the outstanding quantity from the Requirements and Order Cross Reference tables, the part description and serialised from the Part Master table, and the external organization name from the External Organisation table where:

 

The organisation code on the Allocation table is the same as the organisation code on the selected allocated requirement record,The line number is the same as the selected line number,

The completion date is the same as the completion date on the selected line number,

The store code on the Allocation table is equal to the selected store code,

The division code on the Allocation table is equal to the stores division code, (if store selected) otherwise the division code is equal to spaces.

 

For the above combination, only the different serial numbers and stock statuses are displayed.

hmtoggle_plus1De-Allocate

The user must have a security profile linked to the function Stock Allocation with an access allowed of Change.

 

The  button is only enabled when a row is selected in the "Allocated Requirements" list box and the:

 

The signed on user has the necessary security profile,

The signed on user is the "Notify" employee on the Order Line table (if a customer order is selected), OR

The "Coordinator" on the Order Master table (if any other order is selected), OR

The signed on user is acting for either the Notify or Coordinator.

 

When the  button is clicked, the allocated quantity on the Requirements table is updated with the quantity that you have moved.  It is updated where:

 

1.        The requirements order number is the same as the order number;

2.        The requirements order type is the same as the order type;

3.        The requirements line number is the same as the line number selected;

4.        The requirements completion date is the same as the completion date on the selected line number;

5.        The requirements deliver to operation is the same as selected deliver to operation on the unallocated requirements list;

6.        The requirements part number is the same as the selected part number in the unallocated requirements list; and

7.        The requirements required date is the same as the selected required date in the unallocated requirements list.

 

The allocated quantity on the Allocation table is updated with the quantity you have selected to de-allocate.  It is adjusted where:

 

1.        The requirements order number is the same as the order number;

2.        The requirements order type is the same as the order type;

3.        The requirements line number is the same as the line number selected;

4.        The requirements completion date is the same as the completion date on the selected line number;

5.        The requirements deliver to operation is the same as selected deliver to operation on the unallocated requirements list;

6.        The requirements part number is the same as the selected part number in the unallocated requirements list; and

7.        The requirements required date is the same as the selected required date in the unallocated requirements list.

8.        The location serial number is the same as the selected serial number in the "Stock Locations" list box (if there is a serial number);

9.        The location division code is the same as the selected location on the "Stock Locations" list box;

 

11.  The location store code is the same as the selected store code from the store combo box;

12.  The location is the same as the selected location in the "Stock Locations" list box,

13.  The location stock status is the same as the selected stock status in the "Stock Locations" list box;

14.  The location organisation code is the same as the selected organisation code in the "Stock Locations" list box.

 

When de-allocating and an allocation record does not exist, a new allocation record is inserted.

 

The Location table is updated by means of a trigger on the Allocation table.    On the Location table the de-allocated quantity is updated with the quantity you have de-allocated and it is done in the specific record where:

 

1.        The location serial number is the same as the selected serial number in the "Stock Locations" list box (if there is a serial number);

2.        The location division code is the same as the selected location on the "Stock Locations" list box;

3.        The location store code is the same as the selected store code from the store combo box;

4.        The location is the same as the selected location in the "Stock Locations" list box,

5.        The location stock status is the same as the selected stock status in the "Stock Locations" list box;

6.        The location organisation code is the same as the selected organisation code in the "Stock Locations" list box.

7.        The locations part number is the same as the selected part number in the Stock Locations list box.

 

When de-allocating you will only be able to down-adjust the quantity.

hmtoggle_plus1Line Number

This field is only enabled when an order number has been selected or entered and is populated with line number a completion date, and status from the Order Line table where:

 

         The order line status is Firm "F" or Released "R",

         The order type is equal to spaces, and

         The line number matches the number entered.

 

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

hmtoggle_plus1Mode

This Mode provides the user with the options of allocating or viewing stock to an order or a requisition.

 

When selecting the Requirement option all available order numbers from the Order Master table will populate.

 

When the Requisition option is selected, the Order Number option will disable and all the Requisition numbers for Unplanned Issue Requisitions from the Unplanned Issue Requisition table that are not closed will populate in the grid and where the Required Quantity minus the Issued Quantity minus the Allocated Quantity is still greater than Zero.

hmtoggle_plus1Requisition Number

Only displays Requisition Numbers from the Unplanned Issue Requisition table where the Requisition is not Closed and where the Required Quantity minus the Issued Quantity

minus the Allocated Quantity is still greater than Zero.

hmtoggle_plus1Serial Number Like

When a requirement part is selected, where serialised is equal to Yes "Y" on the Part Master table, this field is enabled and it is applied as a wild card.

 

If the user enters a serial number, it will only populate serial numbers, like the user entered value, when populating from the Location table.

hmtoggle_plus1Show Stock

The  button is only enabled when a line has been selected in the "Unallocated Requirements" list box.  When the  button is clicked, and a store has been selected, it populates stock as follows:

 

Where the order type is Production (PROD), Sub Contract (SUB) or Modification (MOD) it populates with stock from the Location table where:

 

The location division code is equal to the order division code;

The location store is equal to the selected store;

The stock status is New (N) or Used (U);

The organisation code is equal to spaces; and

The (quantity on hand - quarantine quantity - allocated quantity) is greater than zero.

 

 

Where the order type is Rework (REW), it populates with stock from the Location table where:

 

The location division code is equal to the order division code;

The location store is equal to the selected store;

The stock status is New (N) or Used (U);

The organisation code is equal to spaces;

The locations part number is not equal to the order part number; and

The (quantity on hand - quarantine quantity - allocated quantity) is greater than zero.

 

Also includes is stock where:

 

The location division code is equal to the order division code;

The location store is equal to the selected store;

The stock status is new (N) or used (U);

The location part number is equal to the order part number; and

The location quarantine quantity is greater than zero.

 

 

Where the line type is Repair (REP) and the order type is Customer (CUST) it populates with stock where:

 

The location division code is equal to the order division code;

The location store is equal to the selected store;

The location organisation code is the same as the organisation code on the Order Master table for the specific order or where the organisation code is equal to spaces;

The stock status is equal to Awaiting Repair (W);

The location part number is equal to the order part number; and

The (location quantity on hand - location quarantine quantity - location allocated quantity) is greater then zero.

 

You also include the stock where:

 

The location division code is equal to the order division code;

The location store is equal to the selected store;

The organisation code is equal to the organisation code on the Order Master table or where the organisation code is equal to spaces;

The location part number is not equal to the order part number;

The stock status is New (N), Used (U) or Repaired (R); and

The (location quantity on hand - location quarantine quantity - location allocated quantity) is greater than zero.

 

 

Where the line type is equal to Repair (REP) and the order type is not equal to Customer (CUST), it is populated with stock where:

 

The location division code is equal to the order division code;

The location store is equal to the selected store;

The stock status is New (N), Repaired (R) or Used (U);

The location part number is equal to the order part number; and

The (location quantity on hand - location quarantine quantity - location allocated quantity) is greater than zero.

 

You include the stock where:

 

The location division code is equal to the order division code;

The location store is equal to the selected store;

The location part number is not equal to the order part number;

The stock status is New (N), Repaired (R) or Used (U); and

The (location quantity on hand - location quarantine quantity - location allocated quantity) is greater than zero.

 

 

Where the line type is not equal to Repair (REP) and the order type is Customer (CUST), it is populated with stock where:

 

The location division code is equal to the order division code;

The location store is equal to the selected store;

The location stock status is New (N), Repaired (R) or Used (U);

If the order has a node you must take into account whether the organisation code is equal to spaces or whether it is equal to the organisation code on the Order Master table;

If the order has no node the location organisation code is equal to spaces or equal to the organisation code on the Order Master table where the fixed account of the part is equal to No (N).  If the fixed account of the part is Yes (Y) you only take into account where the location organisation code is equal to spaces; and

The (location quantity on hand - location quarantine quantity - location allocated quantity) is greater than zero.

 

 

Where the line type is equal to Maintenance (MANT) you take into consideration all stock from the location where:

 

The location division code is equal to the order division code;

The location store is equal to the selected store;

The stock status is New (N), Repaired (R) or Used (U);

The (location quantity on hand - location quarantine quantity - location allocated quantity) is greater than zero;

If there is a node it populates with all the organisations i.e. it does not matter to which organisation the part belongs; and

If there is no node and the fixed account of the part is equal to No (N), it populates with stock from all the organisations.  If the fixed account of the part is equal to Yes (Y), it populates with stock only where the organisation code is equal to spaces.

 

When the "Show Stock" button is clicked and a store has not been selected, it populates stock from all stores, for the order number selected, where:

 

The division code on the Store table is equal to the division code on the Order Master table,

In Transit Store is equal to "0", and

Used By MRP is equal to "1".

hmtoggle_plus1Stock Locations

The "Stock Locations" list box is populated from the Locations table.  By clicking on a record in the "Stock Locations" list box the "Allocate" button will be enabled.  When clicking this button, the stock will be allocated.

 

When an unallocated requirement is selected, this field displays the order's division, organisation name, store code, available quantity, serial/lot number, stock status, location, revision and average cost from the Location table and the organisation name from the External Organisation table.  The Stock Locations list box is populated with stock from the Location table as follows:

 

Where the order type is Production (PROD), Sub Contract (SUB) or Modification (MOD) it populates with stock from the Location table where:

 

The stock status is New (N) or Used (U), and

The (Quantity on hand - quarantine quantity - allocated quantity) is greater than zero.

 

 

Where the order type is Rework (REW), it populates with stock from the Location table where:

 

The stock status is New (N) or Used (U), and

The (quantity on hand - quarantine quantity - allocated quantity) is greater than zero.

 

 

Where the line type is Repair (REP) and the order type is Customer (CUST) it populates with stock where:

 

The stock status is equal to Awaiting Repair (W), and

The (location quantity on hand - location quarantine quantity - location allocated quantity) is greater then zero.

 

 

Where the line type is equal to Repair (REP) and the order type is not equal to Customer (CUST), it is populated with stock where:

 

The stock status is New (N), Repaired (R) or Used (U), and

The (location quantity on hand - location quarantine quantity - location allocated quantity) is greater than zero.

 

Where the line type is not equal to Repair (REP) and the order type is Customer (CUST), it is populated with stock where:

 

The location stock status is New (N), Repaired (R) or Used (U);

 

If the order has a node you must take into account whether the organisation code is equal to spaces or whether it is equal to the organisation code on the Order Master table;

 

If the order has no node the location organisation code is equal to spaces or equal to the organisation code on the Order Master table where the fixed account of the part is equal to No (N).  If the fixed account of the part is Yes (Y) you only take into account where the location organisation code is equal to spaces; and

 

hmtoggle_plus1Store

It is populated with a distinct store code, description, division code, and used by Mrp from the Store and Order Master tables where:

 

 The store is not an in transit store,

     The order is a transfer order, the division code on the Order Master table is equal to the order numbers division, and

 The store code matches the store code entered.

         

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

hmtoggle_plus1Unallocated Requirements

It is populated with the part number, outstanding quantity (required quantity issued quantity - allocated quantity), order x-ref quantity, description, manufacturing part number, deliver to operation and required date from the Requirements table, the part from the Part Master table, and the sum of the outstanding quantity from the Order Cross Reference table where:

 

The (required quantity - issued quantity - allocated quantity) is greater than zero, and

The part number on the Requirements table is equal to the part number on the Part Master table,

 

When you click on a row in the "Unallocated Requirements" list box, the list box, "Stock Locations" is populated.