Navigation:  Movement Functions >

Inspection To Supplier

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

The Inspection to Supplier movement function is used to return items in inspection received from the supplier, back to the supplier due to incorrect quantities, non-conformance to standards/specifications etc.

 

Inspection can refer to either the physical inspection of the items or just to verify the quantity received.

 

The setting, Receipt of Items via Inspection, on the Inspection Criteria function will determine whether items may or may not be moved via inspection or whether it is a prerequisite that goods be forced through inspection.

 

INQUIRE

The user must have a security profile linked to the function Inspection to Supplier with an access allowed of Inquire.

 

On this tab the following fields can be viewed:

 

hmtoggle_plus1Apply

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

When a line is selected in the "Available Order Lines" list box, the "Apply" button is enabled.  When the "Apply" button is clicked, the following updates are performed:

 

1.  The system validates that an order line is selected for processing, a movement, is selected to be returned and a reason code is entered.

 

2.  The system also validates that the movement quantity is between 1 and the maximum movement quantity. If the movement quantity is in the part unit of measure, it may not be a decimal value. The system will also validate that if a Decimal Quantity is entered that Decimal Quantities are allowed.

 

3.  The stored procedure, Movement_Inspection_Supplier is executed.  The following parameters can be passed to and used by the stored procedure:

 

FIELD

 TYPE

 COMMENT

Part_Number

 varchar(30)

 

Serial_Number

 varchar(30)

 

Employee

 Employee_ID

 ID of signed on user

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 Quantity

 decimal 16,5

 

Reason_Code

 varchar(10)

 

Return_Advice_Number

 varchar(15)

 

Division_Code

 varchar(4)

 

Stock_Status

 char(1)

 

Organisation_Code

 varchar(20)

 

Responsible_Organisation

 varchar(20)

 

Original_Movement_Key

 Datetime

 

 

4.  A check is performed to see if the (Requirement % Issued - Production Ratio Check Sensitivity % on the System Configuration table) is greater than or equal to the Order % Complete on the Order Line i.e. the Ratio Checker 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

OrderNumber

 varchar(30)

OrderType

 char(4)

LineNumber

 smallint

CompletionDate

 varchar(20)

Deliver_To_Op

 varchar(10)

Part_Number

 varchar(30)

Required_Date

 smalldatetime

Check_Order_Or_Requirement

 char(1)

Adjustment_Quantity

 decimal (16,5)

 

 

5.a. The Stock Valuation Method from System Configuration is determined to calculate the part's unit cost.  If the Stock Valuation Method is Standard Cost "S", the source is Interplant "I", and the division entered is the part's controlling division, the unit price is calculated as the (material price + labour price + subcontract price + overhead price) from the Part Financial Year Data table.

 

ELSE

 

The (material price + labour price + subcontract price + overhead price + transfer price) is selected from the Part Financial Year Data table.

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

Line Unit Cost + Sum of Requirements Avg. Cost.

 

6.  The system validates that the selected order is still valid.

 

7.  The Order Line table is updated and the Quantity In Inspection is set equal to the Quantity In Inspection - the Movement Quantity.  If a return advice number is entered the order line Quantity Rejected is set equal to the Quantity Rejected + the Movement Quantity.

 

8.  The movement is created i.e. the movement from, movement to, line part number, employee ID, delivery note, PO header, order type, line number, line type, completion date, days early late, movement quantity, fixed account, return advice, frozen costs, order division, store, stock status, and external organisation are inserted in the Movement table.

 

9.  The Update_Requisition_Actual 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

OrderNumber

 varchar(30)

OrderType

 char(4)

LineNumber

 smallint

CompletionDate

 varchar(20)

Requisition_Number

 Varchar(5)

Amount

 decimal (16,5)

 

If the Required Amount is less than or equal to the (Actual Amount + Movement Amount) and the requisition is not an Unplanned Issue "U" or Order Issues "O" requisition, the requisition status is set to Closed "C".

 

If the Required Amount is greater than the (Actual Amount + Movement Amount) and the requisition is not an Unplanned Issue "U" requisition, the requisition status is set to In Process "I".

 

If the Required Amount is equal to the (Actual Amount + Movement Amount) and the requisition is an Order Issue requisition "O", the requisition status is set to In Process "I".

 

The Requisition table is updated and the status is set equal to the status as determined above and the actual amount is set equal to the (actual amount + the movement amount).

 

10.  If the line is a Non-Stock "NSTK" or Repair "REP" line or the line type is not a Non-Stock "NSTK" or Repair "REP" line, and the fixed account on the Order Line is No "N", the movement value is down adjusted with the (unit price on the Order Line * the movement quantity entered).

 

         A check is done to determine if the node status allows the actual amount on the requisition to be reduced. (If Node's are applicable)

 

11.  The supplier to inspection journal is created once the movement is applied.

 

If the Stock Valuation Method is "A" (Average) then the Journal "Journal_Supplier_Inspection_Average_Cost" is written:

A.        Fixed Account Parts

CT                Incoming Inspection (Orders Division)

                         (Sum of Requirements Avg Cost + Order Line Unit Cost) x Qty Moved.

DT                Subcontract Suspense/Creditor Suspense (Orders Division)

                         (Order Line Unit Cost x Qty Moved)

DT                WIP Material Purchases (Orders Division)

                         (Sum of Requirements Avg. Cost x Qty Moved)

 

B.        Order Lines with an Account or Node

CT                WIP Project Management (Nodes Division)

                                                         or

                         Node Material Account

                                                         or

                         Order Line Account

                         (Order Line Unit Cost x Qty Received)

DT                Creditors Provisioning

                         (Order Line Unit Cost x Qty Received)

hmtoggle_plus1Available Movements

It displays all Supplier to Inspection and/or Store to Inspection movements for the selected order line and completion date, in descending date sequence, where the quantity is greater than the quantity returned.

It is populated with the movement date, stock status, available to return calculated as (movement quantity - quantity returned), serial or lot number, unit cost, and responsible organisation from the Movements table.

hmtoggle_plus1Available Order Lines

It displays all released order lines for the selected supplier and purchase order header with a completion date up to the date specified in the "Completion dates till." text box.

It is populated with the line number, completion date, (quantity ordered - (quantity complete + quantity in inspection)), quantity in inspection, part number, line type, status, serialised, source, quantity ordered, fixed account, unit price, account code, node, notify, and description from the Order Line, Order Master and Part Master tables where:

The status on the Order Line table is Released "R" or Closed "C", andThe quantity in inspection on the Order Line table is greater than zero.

hmtoggle_plus1Description

It is a read only field that displays a short narrative description of the line selected in the "Available Order Lines" list box.

hmtoggle_plus1Part Quantity

When an order line is selected, the quantity outstanding on the order line is defaulted to this field.

The movement quantity can have a minimum value of 1 and a maximum value equal to the quantity outstanding on the order line.

When a Stock "STCK" line is selected in the list box the quantity returned in Part/Ordered unit of measure must be confirmed or entered.

When a Non-Stock "NSTK" line is selected in the list box the movement quantity returned must be confirmed or entered.

hmtoggle_plus1Part Unit of Measure

When a Stock "STCK" line is selected in the list box, it displays the part's unit of measure description that the "Movement Quantity" corresponds with from the Unit of Measure table.

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

hmtoggle_plus1PO Header

It is populated with all purchase orders (i.e. order number, order type and division code), for the selected supplier from the Order Master table.

It also selects the line number from the Order Line table where:

 

         The line is Released "R" or Closed "C", 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_plus1Preview

When clicked the Return Advice document as to be printed will be displayed on the screen.

hmtoggle_plus1Print

When clicked, a copy of the Return Advice will be printed to the default printer.  To view the receipt before it is print the Preview button can be used.

hmtoggle_plus1Ordered Unit of Measure

When a Stock "STCK" line is selected in the list box, it displays the ordered unit of measure's description that the "Ordered Movement Quantity" corresponds with from the Unit of Measure table.

This only applies to order lines where a unit of measure conversion was performed. If the ordered unit of measure is equal to the part unit of measure, this field is disabled.

hmtoggle_plus1Ordered Quantity

It displays the quantity in the "Ordered Unit of Measure" that is going to be moved from inspection to the supplier selected.

This field is only visible and only applies, where an order line is selected, where a unit of measure conversion was performed.  If the ordered unit of measure is equal to the part unit of measure, this field is disabled (hidden).

When a Stock "STCK" line is selected in the list box the quantity returned in part or ordered unit of measure must be confirmed or entered.

hmtoggle_plus1Reason Code

This field is used to indicate the reason why you are returning goods to the supplier.

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

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

hmtoggle_plus1Receipt Correction

If checked the system will not validate that a return advice number is entered.

If no return advice number is entered the system regards it as a correction only.  A correction may be necessary when goods were received against the wrong purchase order line no credit link is created in this case.

hmtoggle_plus1Return Advice

The return advice number serves as your delivery note to the Supplier for goods returned.

The return advice number is entered or derived from the system if Auto Numbering is selected on the System Configuration function and is written to the Movements table.

If a number is entered in this field and an invoice line is already linked for the original receipt, a credit link is automatically created for the return when the Creditors invoice is opened.

If the Receipt Correction field is checked the system will not except a return advice number. A correction may be necessary when goods were received against the wrong purchase order line no credit link is created in this case.

hmtoggle_plus1Supplier

It is populated with the supplier name, organisation code and Partial Receipts from Allowed from the External Organisation table where the Supplier has a valid creditors account.

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