Creating stock correction document

What you can do in this page

Unified Glossary

Basics of using a typical web page

Using online help

This  page provides the facility to correct the system stock based on the physical stock counted. Tell me more.

The “Create Stock Correction” page appears.

The system displays the following in the “Correction Information” group box:

Stock Correction #

A unique number identifying the stock correction document. This number is automatically generated by the system based on the numbering type selected, and displayed at the time of creating the stock correction document. This unique number enables you to trace the stock correction details.

Numbering Type

Use the drop-down list box to specify the numbering type based on which the stock correction document number must be generated. Mandatory . The  system lists the numbering types defined in the “Create Numbering Type” activity under the “Document Numbering Class” business component. All the numbering types set for the transaction type “Stock Correction” are available for selection.

Note: You must not select a numbering type that is mapped to a group company, if the stock correction is being created for the login company.

However, if you are creating the stock correction for a warehouse exclusively mapped to a group company and, if "Separate Numbering Type for Trading Partner Transactions" between the login company and the group company is ‘1’ in the Maintain Options for Partner Transactions activity of Organization Setup, the system automatically generates the stock correction # on creation based on the numbering type set for the Stock Correction transaction in the same activity. If "Separate Numbering Type for Trading Partner Transactions" is set as ‘0’, you can select the numbering type for generating the stock correction #.

Warehouse #

Use the drop-down list box to select the warehouse for which the stock correction details must be entered. Mandatory. The system lists all the active warehouses defined in the “Create Warehouse Information” activity of the “Storage Administration” business component.

Note: The warehouse must exclusively belong to the supplier that owns the part for which you are creating the stock correction, if stock valuation is mandatory for the supplier.

Status

Use the drop-down list box to assign a status to the stock correction document. The system provides the following options:

 
  •  Draft - The status of the document, when all the mandatory details have not yet been entered.

 
  • Fresh - The status of the document, when all the mandatory details have been completely entered.

 

The system sets the field to “Draft” by default.

Correction Type

Use the drop-down list box to specify the correction type. The system displays all the values as defined in the “ Set Inventory Options” activity of the “Logistic Common Master” business component for the “General” Stock Correction.

 
  • Quantity – Select this option if you wish to correct the stock quantity.

 
  •  Value - Select this option if you wish to correct the stock value. The system ensures that for each part in the multiline the “Expensing Policy” is other than “On Receipt” in the interacting “Part Administration” business component.

 
  • Quantity & Value – Select this option if you wish to correct both stock quantity and stock value.

User Status

Use the drop-down list box to assign a user-defined status to the stock correction document. The system lists all the ‘active’ user statuses as defined in the “Create Quick Codes” activity.

Correction Date

The date on which the stock details are corrected (Date Format). Mandatory. The correction date must be earlier than, or the same as the system date.

Correction Category

Use the drop-down list box to specify the category to which the stock correction document belongs. The system lists all the ‘active’ categories as defined in the “Create Quick Codes” activity.

Costing Usage

Use the drop-down list box to select the type of the costing usage. The system lists all the “Active” user-defined “Usage” that are mapped for the event “Stock correction in the “Cost Center Rule Definition” business component.

Note: Ensure that the “Costing Usage” is entered for the stock correction document, if any of the part has the expense type other than “Capital”, or a part with “Issue Basis” other than “Returnable”.

Account Usage

Use the drop-down list box to select the type of the account to be used. The system lists all the “Active” usages as defined in the “Account Rule Definition” business component and mapped to the event “Stock Correction”.

If only one account usage value is listed in the drop-down list box, the system defaults the account usage value whichever is listed. Otherwise, the system leaves the field blank by default.

Ensure that a value is selected in this field, only if the current business component interacts with the “Stock Maintenance” business component.

Apply Default Correction Value

Check this box to set the default correction value for the stock correction document. This is valid only if

a) the “Correction Type” of the document is set to “Quantity & Value”

b) the consolidated correction quantity for all the parts in the stock correction document is positive

c) the “valuation Method” of parts in the stock correction document is “Weighted Average” / LIFO / FIFO.

The system displays the following in the “Parts Information” multiline:

Line #

The sequential number generated by the system for the parts entered in the multiline.

Part #

The number identifying the part (Alphanumeric, 40). Mandatory. This number must have been defined in the “Create Parts Main Information” activity of the “Part Administration” business component and must be in “Active” status. The part number must not be repeated for the same zone, bin and stock status.

 

Help facility available.

Note: For successful stock correction to happen: 1) The warehouse # must be defined in the “Create Warehouse Information” activity under “Storage Administration” business component. 2) The specified stock status must be allowed for the stock correction transaction, in the “Create User Defined Stock Status” activity under “User Defined Stock Status” business component. 3) The specified part type must be allowed for stock correction in the “Part Type Allowed for Transaction” group box of the “Set Inventory Options” activity in Logistics Common Master.

The system displays the following:

Part Description

The textual description of the part.

Costing Usage

Use the drop-down list box to select the type of the costing usage. The system lists all the “Active” user-defined “Usage” that are mapped for the event “Stock Correction” in the “Cost Center Rule Definition” business component.

Corrected Quantity

The actual physical stock quantity available in the warehouse number for the specified part number, stock status, zone number and bin number. Ensure that this value is not negative.

Note: The “Corrected Quantity” must be entered, if the “Correction Type” is selected as “Quantity” or “Quantity & Value”.

Note: Fractions can be entered in the “Corrected Quantity”, only if the UOM has been set to “Allow fractions” in the “Create UOM” activity of the “Unit of Measurement Administration” business component.

Note: If the set option "Allow Negative Quantity Correction for Allocated stock" is set as ‘No’, in the “Set Inventory Process Parameter” activity of the “Logistics Common Master” business component, then the “Corrected Quantity” should not be less than the ‘Sum of Allocated Quantity’ across all the documents (Issues/Build Kit/Break Kit/Part Sale Packslip/Stock Conversion and other documents) for the Warehouse-Part-Stock Status-Zone-Bin combination.

The system displays the following:

UOM

The unit of measurement in which the part is stocked.

Stock Status

Use the drop-down list box to correct the stock status of the part. The system lists all the stock statuses for the part number as defined in the “Create User Defined Stock Status” activity of the “User Defined Stock Status” business component.

This table guides you to select the rights stock status.

Zone #

The number identifying the zone in the warehouse (Alphanumeric, 10). Ensure that the zone number is in “Active“ status and is defined in the “Create Warehouse Information” activity of the “Storage Administration” business component.

 

Help facility available.

  Bin # 

The number identifying the bin in the zone (Alphanumeric, 10). This bin number must be in “Active” status and defined in the “Create Warehouse Information” activity of the “Storage Administration” business component.

 Help facility available.

Note: Ensure that the “Bin #” is entered under the following circumstances:

1) The correction type is “Quantity” or “Quantity & Value” and the zone is “Normal”.

2) The correction type is “Value”, zone is “Normal”, valuation method is “Actual Costing” and the part is “Serial Controlled” or “Serial & Lot Controlled”.

Note: Ensure that the zone and bin are left blank, if the warehouse is of type “Free”.

Note: For serial number-controlled, lot number-controlled, or both serial number-controlled and lot number-controlled parts with stock status attribute set to “Ownership-Supplier” and “Ownership-Customer” in the “User Defined Stock Status” business component, ensure that the warehouse-zone-bin combination is mapped to the trading partner in the “Maintain External Stock Allocation” page of the “Storage Administration” business component.

Note: For none-controlled parts with stock status attribute set to “Ownership-Supplier” and “Ownership-Customer” in the “User Defined Stock Status” business component, ensure that the warehouse-zone-bin combination is mapped to the trading partner as an exclusive storage category in the “Maintain External Stock Allocation” page of the “Storage Administration” business component.

The system displays the following:

System Stock Quantity

The quantity of the part as maintained in the system. This quantity is displayed for the particular part, stock status, zone and bin.

Reason for Correction

Use the drop-down list box to select the cause of stock correction. The drop-down list box displays all reason codes in ‘Active’ status as defined in the Logistics Common Master component.

Note: This field is mandatory; 1) if the process parameter “Reason for Correction” under Stock Correction category in the Set Inventory Process Parameters activity is set as ‘1’ and, 2) if S/L Detail Link is “Not Applicable”.

The system displays the following:

Correction Quantity

The quantity of the part calculated by the system, as the difference between the corrected quantity and the system quantity , which may be positive quantity or negative quantity. .

S/L Detail Link

Indicates whether the “Serial & Lot Correction Details” link is “Applicable” or “Not-Applicable” for the line number. If the details are entered in the “Edit Serial & Lot Details” page, the value will be displayed as “Data Entered”.  For more details on the values displayed in this field, refer to the topic "Link Details".

Value Detail Link

Indicates whether the “Specific Receipts” link is “Applicable” or “Not-Applicable” for the line number. If the details are entered in the “Correct Specific Receipts” page, the value will be displayed as “Data Entered”. If the value details are calculated by the System itself, it will be displayed as “System Defaulted”.     For more details on the values displayed in this field, refer to the topic "Link Details".

Specific Receipts Link

Indicates whether the “Specific Receipts” link is “Applicable” or “Not-Applicable” for the line number. If the details are entered in the “Correct Specific Receipts” page, the value will be displayed as “System Defaulted”.  For more details on the values displayed in this field, refer to the topic "Link Details".

Part Control Type

The part control type, which could be “Serial Number controlled” or “Lot Number controlled” or “Serial & Lot controlled” or “None”.

Valuation Method

The method in which the costing of the part is done at an inventory location.

 

  • Standard Cost – indicates that the receipts and the issues of a parts are always made at the standard cost. In case the unit rate of  part is different from its standard rate, then, difference between the rates is posted as price variance of the part.

 

  •  LIFO (Last In First Out) - indicates that the parts are issued at the latest price. Issues thereafter are made at previous prices. A strict chronological order is followed.

 

  •  FIFO (First In First Out) – indicates that the parts are issued at the earliest receipt prices. Issues thereafter are made at recent prices. A strict chronological order is followed.

 

  •  Actual Cost – indicates that the receipts and issues of a part are always made at the actual cost.

 

  •  Weight Average Rate – indicates that the issue rate is calculated as the average of receipt values divided by the receipt quantity.

 

Note: You must select “Actual Cost”, if you are creating the stock correction document for supplier-owned valuated parts.

Expensing Policy

The method for clearing off the value of the part from the inventory.

  • On First Issue - indicates that on first issue, the cost of the part will be cleared off.  

  • On Phase Out - indicates that on phase out, the cost of the part will be cleared off.  

  • Core value on Phase Out - indicates that the time life costing parts will become phased out or obsolete when the core value is cleared off.

  • On Receipt – indicates that on receipt, the cost of the part will be cleared off.

User Defined Detail – 1

Any other additional details pertaining to the stock correction (Alphanumeric, 25).

User Defined Detail – 2

Any other additional details pertaining to the stock correction (Alphanumeric, 25).

Comments

Any additional remarks pertaining to the stock correction (Alphanumeric, 255).

File Name

The name of the file used as document reference for stock correction (Alphanumeric, 50).

Note: The system does not allow stock correction, if the part/component is a restricted part with a restriction code that has the process parameter “Allow Stock Correction” under the entity type Stock Restriction Code in the Define Process Entities activity set as 0/No during the restriction effective period. However, this process parameter does not impact system-generated stock corrections owing to PDC and PICC transactions.

The system updates the stock correction document status as “Fresh” or “Draft”.

Note: If the Part Classification is set as “None” or not defined in the “Part Administration” business component, then the part is classified as Non-Repairable.

The system assigns the “Draft” status to the stock correction document under the following circumstances:

The system ensures the following on clicking the “Create Stock Correction” pushbutton :

The system calculates the “Correction Value” and the “Corrected Value” based on the following conditions:

Correction Type

Valuation Method

Consolidated Correction Quantity

Correction Value

Corrected Value

Quantity

Standard Cost

Any

Correction Qty * Std Cost

Current Value + Correction Value

Quantity

Weighted Average

Positive

Correction Qty * Std Cost

Current Value + Correction Value

Quantity

LIFO/FIFO

Positive

Correction Qty * Std Cost

Correction Value

Quantity or Quantity & Value

Weighted Average

Negative

(Current Value / Current Qty) * Correction Qty

Current Value + Correction Value

Quantity & Value

Weighted Average

Positive and if “Apply Default Correction Value” Check box is checked

Correction Qty * Std Cost

Current Value + Correction Value

Quantity or Quantity & Value

FIFO

Negative

First Receipt and then subsequent receipt values based on the consumption of correction quantity

Receipt Value + Correction Value

Quantity or Quantity & Value

LIFO

Negative

Last Receipt and then subsequent previous receipt values based on the consumption of correction quantity

Receipt Value + Correction Value

Quantity & Value

FIFO / LIFO

Positive and if “Apply Default Correction Value” Check box is checked

Correction Qty * Std Cost

Correction Value

Stock correction for Restricted parts

The system does not allow stock correction, if the part/component is a restricted part with a restriction code that has the process parameter “Allow Stock Correction” under the entity type Stock Restriction Code in the Define Process Entities activity set as 0/No during the restriction effective period. However, this process parameter does not impact system-generated stock corrections owing to PDC and PICC transactions. (You can place restrictions on specific transactions of parts in the “Manage Part Restrictions” activity of Aircraft by associating a restriction code that does not allow these transactions during the period between Effective From and To dates. Restrictions placed on part # via the restriction code apply to all serial #s/lot #s of the part. Restrictions can also be placed on specific serial #/lot # or on a range of serial #s/lot #s of a part. Process parameters of restriction codes are defined in the “Set Process Parameters” page of “Define Process Entities” activity of Common Master.)

To proceed, carry out the following

Note: It is mandatory to enter the values in the “Edit Serial & Lot Details” page, if the “S/L Details Link” field is displayed as “Applicable”.

Note: It is mandatory to enter the values in the “Edit Value Details” page, if the “Value Details Link” field is displayed as “Applicable”.

Note: It is mandatory to enter the values in the “Correct Specific Receipts” page, if the “Specific Receipts Link” field is displayed as “Applicable”.

      

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What you can do in this page

Specify the numbering type for the stock correction document

Specify the type of stock correction

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Specify the numbering type for the stock correction document

You can select the numbering type based on which the stock correction document number will be generated. The numbering type is unique for a combination of the login organization unit and the “Stock Correction” transaction type.

On clicking the “Create Stock Correction” pushbutton, the system automatically generates the stock correction document number based on the numbering type selected.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Specify the type of stock correction

You can specify the stock correction type based on your requirements

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Creating stock correction document – An overview

Create Stock Correction - A summary of the activity

This page provides the facility to correct the system stock based on the physical stock counted. The stock correction document is created when there is a discrepancy between the system stock and actual physical stock in the warehouse and when the reason for discrepancy cannot be ascertained.

Note: This activity supports the creation of stock correction documents, of Correction Basis “General” only.

Stock correction type can be based on “Quantity”, “Value” or “Quantity & Value”. The stock correction document can be created in the “Draft” or “Fresh” status.

For quantity corrections, you can enter the corrected quantity and the system calculates the ‘correction quantity’ using the following formula:

Correction Quantity = Corrected quantity - System stock quantity

The correction quantity can be positive, negative or zero.

For value corrections, you can enter the part number, Stock Status, if the valuation method of the part is “Weighted Average” / “LIFO” /  “FIFO” / “Actual Costing” and if it is a lot-controlled part.     You can enter the part number, zone number, bin number, if the valuation method of the part is “Actual Costing” and if the part is serial-controlled or serial & lot-controlled.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Link Details

The following table explains the various conditions based on which the system displays the value as “Applicable” or “Not Applicable” or “System Defaulted” in the “S/L Details link”, “Value Details Link” and the “Specific Receipts Link” fields.   On entering the details in the respective link  pages, “Applicable” will be updates as “Data Entered”  If value entered in a “Data Entered” link page is deleted, the value will be changed from “Data Entered” to “Applicable” again.

Correction Type

Part Control Type

Valuation Method

Consolidated Correction Quantity

Apply Default Correction Value

S/l Details Link

Value Details Link

Specific Receipt Link

Quantity

Serial/ Lot controlled

Any

Positive / Negative

---

Applicable

Not Applicable

Not Applicable

Quantity

None

Any

Positive / Negative

---

Not Applicable

Not Applicable

Not

Applicable

Value

Serial Controlled / Serial & Lot Controlled

Actual Costing

---

---

Applicable

Not Applicable

Not Applicable

Value

Lot Controlled

Actual Costing

---

---

Not Applicable

Applicable

Not Applicable

Value

Any

LIFO/FIFO

---

---

Not Applicable

Not Applicable

Applicable

Value

Any

Weighted Average

---

---

Not Applicable

Applicable

Not Applicable

Quantity & Value

Serial / Lot controlled

Actual Costing

Positive / Negative

---

Applicable

Not Applicable

Not Applicable

Quantity & Value

Serial / Lot controlled

LIFO/FIFO

Positive

Not Checked

Applicable

Applicable

Applicable

Quantity & Value

Serial / Lot controlled

LIFO/FIFO

Positive

Checked

Applicable

System Defaulted

Not Applicable

Quantity & Value

Serial / Lot controlled

LIFO/FIFO

Negative or Zero

---

Applicable

Not Applicable

Not Applicable

Quantity & Value

Serial / Lot controlled

Weighted Average

Positive

Not Checked

Applicable

Applicable

Not Applicable

Quantity & Value

Serial / Lot controlled

Weighted Average

Positive

Checked

Applicable

System Defaulted

Not Applicable

Quantity & Value

Serial / Lot controlled

Weighted Average

Negative or Zero

---

Applicable

Not Applicable

Not Applicable

Quantity & Value

None

LIFO/FIFO

Positive

Not Checked

Not Applicable

Applicable

Applicable

Quantity & Value

None

LIFO/FIFO

Positive

Checked

Not Applicable

System Defaulted

Not Applicable

Quantity & Value

None

Weighted Average

Positive

Not Checked

Not Applicable

Applicable

Not Applicable

Quantity & Value

None

Weighted Average

Positive

Checked

Not Applicable

System Defaulted

Not Applicable

Quantity & Value

None

LIFO/FIFO/

Weighted Average

Negative or Zero

Checked

Not Applicable

Not Applicable

Not Applicable