Navigation:  Movement Functions > Inspection To Stores >

Receipt

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

On this tab the following fields can be viewed:

 

hmtoggle_plus1Apply

The user must have a security profile linked to the function Inspection to Stores with a Change access allowed. .

 

The "Apply" button is enabled when a valid store is selected and the movement quantity or the movement and ordered quantity are entered.

 

When the "Apply" button is clicked, the Movement_Inspection_Store stored procedure is executed. If you are not using the front end for updates, the following parameters can be passed:

 

FIELD

 TYPE

Part_Number

 varchar(30)

Serial_Number

 varchar(30)

Employee

 employee_ID (ID of signed on employee)

Delivery_Note

 varchar(15)

Order_Number

 varchar(30)

Order_Type

 char(4)

Line_Number

 Smallint

Line_Type

 char(4)

Completion_Date

 Smalldatetime

Quantity

 decimal 16,5

Contractual Qty

 decimal 16,5

Crate

 varchar(30)

Reason_Code

 varchar(10)

Concession_Number

 varchar(10)

Return_Advice_Number

 varchar(15)

Requisition_Number

 varchar(5)

Division_Code

 varchar(4)

Store_Code

 varchar(4)

Location

 varchar(20)

Stock_Status

 char(1)

Organisation_Code

 varchar(20)

Account

 varchar(10)

Deliver_To_Operation

 varchar(10)

Parent_Serial_Lot_Number

 varchar(30)

Revision

 varchar(5)

Responsible_Organisation

 varchar(20)

Quantity_Returned

 decimal 16,5

Quarantine_Quantity

 decimal 16,5

Allocated_Quantity

 decimal 16,5

Remaining_DOL_Units

 decimal 16,5

Original_Movement_Key

 Datetime

Document_Number

 varchar(30)

 

1.  a. The value of the setting Stock Valuation Method on System Configuration is determined.

 

If the Stock Valuation Method is Standard Cost "S", the part's source is Interplant "I" and the part's controlling division is equal to the order's division, the unit cost is calculated as the (material + labour + subcontract + overhead + fixed overhead price) from the Part Financial Year Data table

 

ELSE

 

The unit cost is calculated as the (material + labour + subcontract + overhead + fixed overhead + transfer price) Part Financial Year Data table.

 

If the Stock Valuation Method is Average Cost and the Stock Status is 'New' and  no External Organisation isdefined, the Movement Unit Cost is calculated as (((Sum (Old Quantity On Hand * Old Average Cost) + New Movement Quantity * Movement Unit Cost)/ Sum of New Quantity On Hand).

 

1b. If the Stock Valuation Method is "A" (Average) then the Movement Unit Cost is calculated as follows:

Line Unit Cost + Additional Cost (From the Order Line or Shipment Document) + Sum of Requirements AVG. Cost

 

2.  The system checks whether Decimal Movements is allowed.

 

3.  The system checks to determine whether the Location Maximum is exceeded. If you are not using the front end updates, the following parameters can be passed to the Stored Procedure:

 

Field

 Type

Part_Number

 varchar (30)

Division_Code

 varchar (4)

Store_Code

 varchar (4)

Location

 varchar (20)

Stock_Status

 char (1)

Quantity

 decimal 16,5

ExceedesMax

 bit

 

 

4.  The system checks that the order is still a valid order.

 

5.  The quantity on hand is up adjusted with the movement quantity.  The stored procedure, Update_Location is executed.  If the front end is not being used for updates, the following parameters can be passed to the stored procedure:

 

FIELD

 TYPE

Part_Number

 varchar(30)

Serial_Number

 varchar(30)

Division_Code

 varchar(4)

Store_Code

 varchar(4)

Location

 varchar(20)

Stock_Status

 char(1)

Organisation_Code

 varchar(20)

Quantity_On_Hand_Adjust

 decimal 16,5

Quarantine_Quantity_Adjust

 decimal 16,5

Allocated_Quantity_Adjust

 decimal 16,5

Revision

 varchar(5)

Remaining_DOL_Units

 dec(7,2) = 0

Location_Update_Cost

 decimal 16,5

Movement_Time_Stamp

 Smalldatetime

 

If the order line is not equal to Non-stock "NSTK" and is a Repair "REP" line, the stock status is set to Released "R".

 

If serialised on the order line is Yes "Y" or Record Later "R", or the order line is lot controlled, the External Organisation uses the movements organisation otherwise it uses the selected External Organisation.

 

If the order line is equal to Non-stock "NSTK" and is not a Repair "REP" line, the stock status is set to New "N" and the External Organisation is updated equal to the selected External Organisation.

 

6.  The Order Line table is updated.  The quantity at inspection is down adjusted with the movement quantity and the quantity complete is up adjusted with the movement quantity. Where the (order line quantity complete minus the movement quantity) is less than the quantity ordered, the order line status is set to Released "R". Or if the part being received has a UOM Conversion with tolerance percent greater than zero and if the quantity being moved is within this tolerance then the Order Line will be short closed.  The same applies if a short close tolerance exists on the part being moved.

 

Over deliveries will also be allowed if the part being moved allows Over Deliveries on the Part Master or Part UOM Conversion.

 

7.  The movement is created and a new record is inserted into the Movement table. If the movement quantity returned is greater than zero, the original movement quantity returned is up adjusted with the movement quantity returned.

 

8.  The Order_Xref_Auto_Allocation stored procedure is executed.  If you are not using the front end for updates, the following parameters can be passed to the stored procedure:

 

FIELD

 TYPE

@Replenishment_Order_Number

 varchar(30)

@Replenisment_Order_Type

 char(4) = 'PUR'

@Replenisment_Line_Number

 smallint

@Replenisment_Completion_Date

 smalldatetime

@Serial_Number

 varchar(30)

@Division_Code

 varchar(4)

@Store_Code

 varchar(4)

@Location

 varchar(20)

@Stock_Status

 char(1)

@Organisation_Code

 varchar(20)

@Movement_Quantity

 decimal 16,5

@Ignore_Allocation

 bit

 

A check is performed to determine whether any allocation records exist for the above fields on the Order Cross Reference table where the outstanding quantity is greater than zero.

 

If an allocation record(s) exists, the quantity to be used is calculated.  The lesser of the Cross Reference Quantity or the Movement Quantity will be used (i.e. if the Cross Reference Quantity is 5 and the Movement Quantity is 10, the Cross Reference Quantity will be used).

 

If the setting Ignore_Allocation is 1 (Yes), the Order Cross Reference table is updated.  

 

If the setting Ignore_Allocation is 0 (No) and an allocation amount exists, the Allocation table is updated and the allocated quantity is set equal to (the Allocation Quantity + the Movement Allocated Quantity).

 

OR

 

If no allocation amount exists, a new allocation record is inserted into the Allocation table for the movement allocated quantity.

 

The Requirements table is updated and the allocated quantity is set equal to the Movement Allocated Quantity.

 

9.  If a shipment document number is entered, the Shipment Document table is updated and the Received Quantity is up adjusted with the movement quantity.

 

10.  If a Non Stock or Purchase Requisition exists on the line being received then the system will up adjust the Requisition Actual amount with the additional Unit Cost (from the Order Line or Shipment Document) x Quantity being moved.

 

The Stored Procedure update_Requisition_Actual is executed, the following Parameters can be passed:

 

Field

 Type

Order_number

 varchar(30)

Order_Type

 char(4)

Line_Number

 smallint

Completion_Date

 smalldatetime

Movement_Additional_Unit_Cost

 decimal 16,5

 

 

11.  The Part Last Average Cost is updated according to the calculation method selected on the Part Master table.

 

12a. If the Stock Valuation Method  equals "S" (Standard) the  inspection to stores journal is written for fixed accounts once the movement is applied.

 

12b. If the Stock Valuation Method equals "A" (Average) then the Journal_Inspection

_Stores_Average_Cost journal is written.

 

A Fixed Account Parts

DT Stores Stock (Division)

((Sum of Requirements Avg. Cost + Order Line Unit Cost +

Additional Unit Cost) * Qty Received)

CT Incoming Inspection (Division)

(Sum of Requirements Avg. Cost + Order Line Unit Cost) * Qty Received

CT Additional Cost Provision (Division)

(Additional Unit Cost * Qty Received)

DT Interdivisional Clearance Account (Order Division)

((Sum of Requirements Avg. Cost + Order Line Unit Cost +

Additional Unit Cost) * Qty Received)

CT Interdivisional Clearance Account (Move Division)

((Sum of Requirements Avg. Cost + Order Line Unit Cost +

Additional Unit Cost) * Qty Received)

 

B. Order Line with an Account or Node

DT Wip Project Management (Division)

                 or

DT Node Material Account

                 or

DT Order Line Account

Additional Unit Cost  * Qty Received

CT Additional Cost Provisioning

Additional Unit Cost  * Qty Received

 

 

BUSINESS RULES WHEN APPLYING AN INSPECTION TO STORES MOVEMENT:

 

1.  An order line must be selected to be processed.

 

2.  A store must be selected and the quantity in the part's unit of measure and ordered unit of measure must be entered for a Non-Stock "NSTK" line.  For any other line type, a store must be selected and a quantity must be entered.

 

3.  If "Save Under External Organisation" is enabled and serialised on the order line is No "N" or Record Later "R", the movement quantity cannot exceed the External Organisation default quantity.

 

4.  The movement quantity must be between the minimum and maximum values.

 

5.  The location must be entered if the line type is not equal to Non-Stock "NSTK".  If Default Location format is true, the location must have the same number of characters as the format.

 

6.  Where the order line is a Rework "REW" or Repair "REP" line, and serialised is Yes "Y" or Record Later "R", a serial number must be selected, otherwise a serial number must be entered.

 

7.  If the line type is Repair "REP" and the part source is Customer Furnished "C", an External Organisation must be selected.

 

8.  If stock is received where stock of an External Organisation has been issued against an order, the received stock must first accommodate the issued stock as belonging to the External Organisation. This applies to Repair, Rework, Modification and Subcontracted Parts.

 

9.  If the part source is Customer Furnished "C" and the line type is not Repair "REP", the Supplier of the order number is used.

 

10.  If the part source is not Customer Furnished "C" and the line type is equal to Non-Stock "NSTK", the External Organisation is set equal to spaces, otherwise it is set equal to the selected External Organisation.

hmtoggle_plus1Contractual Movement Quantity

It displays the quantity in the "Ordered Unit of Measure" that is going to be moved to the selected store and location.  This field only applies to order lines where a unit of measure conversion is performed.

 

This field is disabled if the ordered UOM is equal to the part UOM.

When performing a conversion, the ordered movement quantity is calculated as (quantity ordered / contractual quantity ordered) from the Order Line table.

 

If a UOM conversion exists the over and under receipt quantity is checked and will be allowed against the percentage specified on the field Max Conversion Tolerance Percentage in the Part UOM Conversion table. The Quantity Ordered will be compared with the Contractual Quantity Ordered (Conversion).

 

This field will be equal to the Movement Quantity if no UOM conversion exists.

hmtoggle_plus1Contractual Unit of Measure

It displays the ordered unit of measure description (that the "Ordered Movement Quantity" corresponds with) from the Unit of Measure table, for the ordered unit of measure on

the Order Line.

 

This only applies to order lines where a unit of measure conversion is performed.  This field is disabled if the ordered UOM is equal to the part UOM.

 

(This field displays quantities received in the foreign Unit of Measure if UOM Conversion exists on the Movement table.

If no UOM Conversion exists, the Alternate UOM Quantity will be equal to the Movement Quantity on the Movement table.)

hmtoggle_plus1Description

It is a read only field that displays the "Line Description" of the order line selected in the "Available Order Lines" list box.

hmtoggle_plus1Location

The Location field is enabled when an order line is selected in the "Available Order Lines" list box where the line is a Stock, Rework, Sub-contract or a Repair line. If a default Location was specified on the Part Stock Location table, this location will be defaulted, else a Default Location will populate if a location with the right stock status exists for the Part Number on the selected Division and Store in the Stores table.  

 

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.

 

If the selected store does not have a default location, enter free  text into this field.  The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory).

 

When an order line that is a Stock "STCK" line, is selected, a location may be entered or a stock record may be selected. This field displays the location of the selected line and is disabled when a line is selected in the "Stock" list box..

 

On apply the system will also check that the default Location (if selected) Location Maximum quantity is not exceeded.

hmtoggle_plus1Lock

This checkbox only enables when the Maximum Conversion Tolerance Percentage on the Part Unit of Measure Conversion table is greater than zero.

 

This enables the user to lock one of the fields. The one quantity can be fixed quantity while the other quantity can fluctuate between the tolerance percentage allowed.

 

Example: Base         =100 kg        98kg

Contractual  =  10 me                10 me Locked

The original conversion is checked. The unlocked original quantity is checked against the max conversion tolerance percentage. If the quantity is within the tolerance the movement will be allowed.

hmtoggle_plus1Movement Quantity

The movement quantity defaults to the sum of the movement quantity from the Movement table.

 

If the order line selected is a Non-Stock "NSTK" line, the movement quantity is equal to that order line's quantity at inspection.  For this scenario, the movement quantity can have a value between 1 and the order line's quantity at inspection.

 

If the line type selected is not a Non-stock "NSTK" line and the order line part selected is serialised, the movement quantity is equal to one, otherwise it is equal to the order line's quantity at inspection.

 

When a line is selected in the "Stock" list box, the movement quantity is equal to the order line's available quantity.  For this scenario, the movement quantity can be between 1 and the available order line quantity.

 

When a line is selected in the "Shipment Documents" list box, the movement quantity is equal to the outstanding selected shipment documents quantity.

 

For this scenario, the movement quantity can be between 1 and the outstanding shipment documents quantity.

 

When performing a conversion, the part's movement quantity is calculated (contractual quantity ordered / quantity ordered) from the Order Line table.

 

If a UOM conversion exists the over and under receipt quantity is checked and will be allowed against the percentage specified on the field Max Conversion Tolerance Percentage in the Part UOM Conversion table. The Quantity Ordered will be compared with the Contractual Quantity Ordered (Conversion). If Decimal Movements for Stocked, Rework, Modification, Repair and Subcontracted Parts are Allowed on the Part Master table you may enter a value resulting in a decimal. For Non-Stock lines Decimal Movements will be allowed if the Unit Of Measure allows it.

hmtoggle_plus1Order Lines

It displays the line number, completion date, quantity in inspection, quantity complete, part number, line type, and line description for all released purchase order lines for the Supplier and the purchase order number selected, where the quantity in inspection is greater than zero

hmtoggle_plus1Part Unit of Measure

If the order line selected is a Stock "STCK" line, this field displays the part unit of measure description that the "Movement Quantity" corresponds with from the Unit of Measure table.

 

Where the order line selected is not a Stock "STCK" line, this field displays the orders unit of measure code from the Order Line table and the unit of measure description from the Unit of Measure table.

 

If the ordered unit of measure is equal to the part unit of measure, the Ordered Quantity field and the Ordered Unit of Measure fields are disabled.

hmtoggle_plus1PO Header

It displays all released purchase order lines for the selected Supplier.  

 

It selects the order number, order type, division code and the organisation code from the Order Master table for the supplier selected where the order is a purchase order and the line number from the Order Line table where:

 

         The order line status is Released "R", and

         The quantity in inspection is greater than zero.

 

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

hmtoggle_plus1Reason Code

This field is used to indicate the reason why stock received into the store is quarantined.  This field is enabled in conjunction with the field, "Stock to be Quarantined".

 

It is populated with all inspection returns reason codes and descriptions from the Movement Reason Code table.

 

If "Stock to be Quarantined" is checked, this field is populated with all inspection returns reason codes and descriptions from the Movement Reason Code table where the field Quarantine is "1" (checked).

 

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

hmtoggle_plus1Save Under External Organisation

Where a Repair order has been selected, and stock of an External Organisation, has been issued to the order requirements, this field is populated with a distinct name, and organisation code from the Movement and the External Organisation tables where:

 

The movement quantity of (Store to Order Requirements - Order Requirements to Store) - (Supplier to Store + Inspection to Store) - (Store to Supplier + Store to Inspection) + (movement quantity of store to inspection) is greater than zero.

 

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

hmtoggle_plus1Serial\Lot Number

This field is only enabled if a serialised or lot controlled part number is selected.  The user must enter the serial number for parts always serialised and can optionally enter the serial number if the serial number can be recorded later.

 

The label is varied to Lot Controlled if the part from the selected order line is lot controlled.  It is populated with the serial number from the Movement table for the selected part and purchase order number where:

 

The summed quantity on the (Stores to Order Requirements)movement - the summed quantity on the (Order Requirements to Stores) movement on the Movement table is greater than zero.

 

The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory when either a serialised or lot controlled part is selected).

 

RELATED TOPIC: Serialised on the Part Master

         Lot Controlled on the Part Master

hmtoggle_plus1Shipment Documents

It displays the shipment document number and outstanding quantity for all the purchase orders, of the selected order line where:

 

         The outstanding quantity is greater than zero,

         The completion date is equal to order line's completion date, and

         A shipment document exists.

 

It is populated with the document number, and outstanding quantity calculated as (shipment quantity - received quantity), from the Shipment Document table.

hmtoggle_plus1Stock

It displays the location, stock status, quantity on hand, quarantine quantity, available quantity and serial/lot number of the stock in the selected store, of the order lines part from the Location table.

hmtoggle_plus1Stock Status

For modification purchase order lines this field will be enabled.  The default will be "New".  The user can select a status of  New, Used or Repaired.

If the user selects Repaired then the system will check that an account or node exists on the order line if not an error message will be displayed.

hmtoggle_plus1Stock to be Quarantined

For modification purchase order lines this field will be enabled.  The default will be "New".  The user can select a status of  New, Used or Repaired.

If the user selects Repaired then the system will check that an account or node exists on the order line if not an error message will be displayed.

hmtoggle_plus1Store

It is populated with the store code, store manager, description, location format predefined, and location format preferred from the Store and the Employee Master tables where:

 

         The order line's deliver to division exists the division code is equal to either the order line's deliver to division otherwise the division is equal to the order's division, and

 

         The order line's deliver to store exists, the store code is equal to either the order line's deliver to store otherwise the store code matches the code the user entered.

 

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

hmtoggle_plus1Supplier

It displays all suppliers with a valid creditor account.

 

It is populated with the name and organisation code from the External Organisation table where a valid creditors account exists.

 

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

hmtoggle_plus1Take on Value

When a customer furnished item is received this field can be used to capture the take on value.

hmtoggle_plus1Print Labels

The Inspection to Stores movement can also automatically print purchase order receipt labels and bar coded part labels when the field “Print Labels” is checked, the user can also specify the number (the default = 1) of labels to print.

 

The auto printing of labels is dependant on the order division setting “Auto Print PO Receiving Labels” and if allowed on the division the “Print Label” check boxes will be checked and enabled.

If auto printing is not allowed then the fields will be unchecked and disabled.

 

The bar coded label to be printed must first be specified in the function "Part Pack Print" per movement type, division and store.

Bar coded labels can not be printed for non stock purchase order lines.

To be able to print bar coded labels (.BTW) the BarTender software must exist

To print the bar coded label QMPARTPROJECTLABEL.rpt the following font must exist on the users PC

Font Name: C39HrP72DlTf (True Type)

Filename: Bar Code 139.TTF

 

The user can unselect the fields if no labels is to be printed for a specific movement.

 

 

If the labels for some reason fail to print it can still be printed from the “Print Documentation” function for the receipt labels and from the function “Movement Stock Label Print” for bar coded part labels.