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

The "Apply" button is enabled when a line is selected in either the Parts Crated Not Yet Transferred or Stocklist boxes or the Movement To Be Returned grid.  When the "Apply" button is clicked the following updates are performed:

If the controlling division is not equal to the from store movement's division, the unit price is calculated as:

(Material Price + Labour Price + Subcontract Price + Variable Overhead Price + Fixed Overhead Price).  The unit cost are the same as the above except that the transfer price will be included with the Transfer to Store movement.

If the stock valuation method is standard, the movement unit cost will be equal to the selected location average unit cost of the transit store from which the stock are being returned.

The account on the Return to Store is debited with the unit price and the Inter Divisional Clearance Account on the Return to Store Division is credited with the unit price (see Store to Transfer on the Movement Historyfunction).

At the same time the account on the From Transito Store is debited with the unit price and the Inter Divisional Clearance Account on the From Transito Store's Division is credited with the unit price (see Transfer to Store on the Movement History function). The transfer price will not be included with the Transfer to Store movement.

If the source on the selected part number (Part Master) is not equal to Interplant "I" but equal to Purchased "P", Subcontract "S", Phantom "N" or Manufactured "M") then the same journals and movements are created except that the transfer price is not included in the unit price.

Journals will be entered for all fixed account parts with a stock status of new or used and where the external organisation of the selected location from which stock is transferred is equal to spaces.

If the (existing quantity on hand + the adjustment quantity on hand = 0) and the existing quantity on hand is not equal to zero, the record is deleted from the Location table

ELSE

If the existing quantity on hand is not equal to zero, the Location table is updated for the selected part number, serial number, division code, store code, location, stock status and organisation code. The following fields on the Location table are updated:

Quantity on Hand = Quantity on Hand + Movement Adjustment Quantity on Hand.

Quarantine Quantity = Quarantine Quantity + Movement Adjustment Quarantine Quantity.

Allocated Quantity = Allocated Quantity + Movement Adjustment Allocated Quantity.

If a location with a different revision number already exists on the Location table, another location number must be entered.

If the location does not exist, a new record is inserted into the Location table i.e. the movement part number, serial number, division code, store code, location, stock status, organisation code, quantity on hand, remaining DOL units, quarantine quantity, allocated quantity and revision are inserted into the Location table.

9.  The movement is created (See the Movement History function).

This field specifies an existing crate to be applied for the stock transfer.  It is populated with the crate number from the Crate table where:

The requisition number on an existing crate is equal to the selected requisition number, and the crate is not linked to a container number.

This field is enabled when the Requisition Number is selected.

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

This field is used to specify the store to which the stock was to be transferred to.

It is populated with the store code, store description and division code from the Store and Employee Master tables where the store is not an in transit store and is not the same store as the issuing store.

This field is enabled when the Return To Store is selected.  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

The purpose of this store is to keep track of the stock that is in transit from one store to another, visible for the purpose of material requirement planning (MRP), material control/management etc.  This stock, while in the process of transfer, is not available for consumption purposes.

It is populated with the store code, description, and division code from the Store and Employee Master tables where:

The store is an In Transit Store store, and the division is the same as the division of the return to store.

This field is enabled after a Destination Store was selected.  The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

This field will display the location of the selected part in the return to store when the items have been selected in the "Parts Crated Not Yet Transferred", "Stock" list boxes and "Movement To Be Returned" grid.

It is populated with the location format preferred, location format alternative 1 and location format alternative 2 from the Store table where the division and store code are equal to the selected return to store's division and store.

If a location exists for the Part Number on the selected Division and Store and with the correct stock 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. A new location can however be entered in the Location field.

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

This list box displays the movement to be returned.  It is populated with the movement date, time, part number, part description, quantity crated, serial number, crate serial number, location, stock status, (movement quantity - quantity returned), available to return, unit cost, revision number and quantity returned from the Movement and the Part Master tables.

The combo box quantity returned indicates the stock quantity that is to be returned.  It is only enabled when a line is selected in the "Parts Crated Not Yet Transferred" or "Stock" list boxes and the "Movement To Be Returned" grid.  In this case the user must confirm the stock transfer quantity to be returned (mandatory).

This field will display the maximum quantity available to be returned as shown in the "Movement To Be Returned" grid.  This is calculated as (original movement quantity LESS returned quantity).

If Decimal Movements are Allowed on the Part Master table, you may enter a value resulting in a decimal.

A Default Location will populate in the 'Location' field in the grid if a location with the right stock status exists for the Part Number on the selected Division and Store.

A new location can be entered in the Location field.  The field will check if the Quantity on Hand does not exceed the Location Maximum.

See Location Return To.

This list box displays all "Store to Crating" movement parts, for the selected crate number and requisition number.

When a requisition number is selected, this list box is populated with part numbers, part descriptions, and the (movement quantity - the returned quantity), from the Requisition, Stock Transfer Requisition, Part Master and Movement tables for the selected requisition number where:

The in transit quantity is greater than zero,the stock transfer requisition number is equal to the requisition number selected, and the stock transfer requisition requested by store and requested by divisions are equal to the destination store and division.

Part number, description or quantity can order the information, in this list box

This field indicates the stock quantity that is to be returned.  This field is only enabled when a line is selected in the "Parts Crated Not Yet Transferred" or "Stock" list boxes and the "Movement To Be Returned" grid.   In this case the user must confirm the stock transfer quantity to be returned (mandatory).

This field will display the maximum quantity available to be returned as shown in the "Movement To Be Returned" grid.  This is calculated as (original movement quantity LESS returned quantity).

This field specifies the store where the stock is to be returned to.

It is populated with the store code, store description, and division code from the Store and Employee Master tables 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

This field is used to specify the stock transfer requisition number and is enabled when the From Transit Store is selected.

It is populated with in process, stock transfer requisition numbers, requisition descriptions, and statuses from the Requisitions and the Stock Transfer Requisition tables where:

The in transit quantity is greater than zero, the requested by division is equal to the to stores division of the destination store, and the requested by store is equal to the to destination store.

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

When the user clicks on a part in the "Parts Crated Not Yet Transferred" list box, the "Stock" list box is populated with the location, stock quantity calculated as the ((quantity on hand - allocated quantity) - quarantine quantity)), stock status, serial number, and revision from the Location table,  for the selected part number where:

The location's stock status is equal to the selected part's stock status, the location's division is equal to the in transit store's division,  the location's store is equal to the in transit store, and the organisation code is equal to spaces.