Cycle Counting Order Lines (whinh5101m000)

Use this session to view, create, or maintain cycle-count order lines.

If the Printed check box in the Cycle Counting Orders (whinh5100m000) session is selected, you can maintain cycle-count order-lines. If these lines are maintained, you can enter the physical quantities counted in the current session. LN will calculate the variance between the counted quantities and the registered quantities.

If the counted quantity of a stock point is less than the allocated inventory for that stock point, you can reduce the allocated quantity.

You can delete all, or part of, the outbound advice or assign allocated inventory to another location.

If a variance has been approved, that is, the Approval field is set to Approved, and the variance is adjusted again, approval is only necessary when the variance is more than is stated in the Inventory Handling Parameters (whinh0100m000) session. If a recount is requested by the approval process in the Approve Cycle Counting Variances (whinh5801m000) session, you can no longer modify this order line.

To process one or more specific cycle count order lines, select the concerned cycle count order lines, and on the appropriate menu, choose Process.

Note: 

When the ownership changes, the peg distribution is removed.

For Customer Owned items, the peg(s) are not generated automatically, but must be entered manually. Before you approve a cycle counting line, LN checks if the peg data is specified.

Note: To view the peg distribution data, use the Peg Distribution option from the References menu. This option is enabled only if the project pegging functionality is implemented and for the warehouse of type Project.
Note: 

If a cycle count order line concerns:

  • A project warehouse, you must specify the project data in the Cycle Counting Order Line Peg Distribution (whinh5107m000) session before you can process the cycle count order. To start the Cycle Counting Order Line Peg Distribution (whinh5107m000) session, on the appropriate menu, choose Peg Distribution.
  • A serialized item, you must specify the serialized items that are added to or subtracted from inventory in the Cycle Counting Order Line Stock Point Details (whinh5106m000) session before you can process the cycle count order. To start the Cycle Counting Order Line Stock Point Details (whinh5106m000) session, from the appropriate menu, choose Serials.

Inventory ownership

If the vendor managed inventory (VMI) functionality is used, you can view and maintain inventory ownership records in the Cycle Counting Order Line Ownership (whinh5105m000) session. An inventory ownership record specifies the owner or owners of the items that comprise the variance entered on the cycle counting order line.

Inventory ownership records are either generated or manually created, this depends on the ownership settings of the warehouse and the items for which the variance occurs. For further details, see Cycle Counting Order Line Ownership (whinh5105m000)

To start the Cycle Counting Order Line Ownership (whinh5105m000) session, click Ownership in the appropriate menu.

For further information on ownership and vendor managed inventory, see Inventory ownership in Warehouse Management and Vendor managed inventory

Field Information

Cycle Counting
Order

The order number of the cycle-count order.

Count Number

The number of counts that are performed on one or more lines of this order.

Note: A recount can be initiated in the Cycle Counting Order Lines (whinh5101m000) session or in the Approve Cycle Counting Variances (whinh5801m000) session.
Line

The number of the cycle count order line.

Approval

The approval status of the order line.

To Approve

The variance must be approved before further processing.

Approved

The variance has been approved. Therefore, the order line can be processed.

Recount

The variance has been disapproved and the inventory of the stock point must be counted again.

Not Required

Approval is not required.

Workflow Status

The status that is applicable if the business object requires authorization approval using ION Workflow.

When you perform a change that requires authorization, a checked-out version is automatically created for the business object. The changes you submit are only effective after approval/check-in. You can also undo your changes, or recall your submitted changes.

  • Checked-out and checked-in objects are displayed in the Checked-out Objects (ttocm9599m000) session.
  • From the appropriate menu of this session, select Workflow and execute the required action for the business object.

Allowed values

Draft

The object is checked out. It can be changed and saved multiple times until the user submits the changes.

Pending

Any changes made to the object are submitted. The object is pending for approval. The data of the object cannot be modified.

Recall Requested

The object was already submitted, but is recalled by the user. Approval will not take place anymore. If the recall is accepted, the object status becomes Draft (Revision). If the Recall is rejected, the object status becomes Pending.

Draft (Revision)

The object was recalled after it was submitted and the recall is accepted. The object can be changed and saved multiple times until the user submits the changes.

Rejected

The submitted changes to the object are rejected. The user can make changes to the object and submit these changes again, or discard all changes.

Approval Received

The submitted changes to the object are approved. The object will automatically be checked in. If the check-in fails, the status remains Approval Received. An administrator must decide what to do with the object.

Approved

The submitted changes to the object are approved and the object is checked in.

Not Applicable

The object is checked in. Instead of an Object status, an Approval status is applicable.

Note: For more information on setting up and using ION Workflow for business objects in LN, refer to the Infor LN Integration Guide for Infor ION Workflows and Monitors.

Specification

If this check box is selected, specifications are present for the items included in the current cycle counting order lines. Specification information is available in the fields of the Demand Peg group box of the details session.

Location
Location

The location.

Effectivity Unit

The code of the effectivity unit.

E-item Revision

The revision number of item.

Storage Zone

The zone.

Row

The code of the location's row.

Level

The code of the location's level.

Bin

The code of the location's bin.

Note: Often a bin number is used as a sequence number for the combination of row and level.
Item
Handling Unit

The handling unit.

Handling Unit Present

If this check box is selected, the handling unit is present in inventory. If required, you can clear this check box to remove the handling unit from the inventory.

Item

The item.

Note: 

If a cycle count order line concerns a serialized item and the Serials in Inventory check box in the Item - Warehousing (whwmd4600m000) session is selected, you must specify the serialized items that are added to or subtracted from inventory in the Cycle Counting Order Line Stock Point Details (whinh5106m000) session before you can process the cycle count order.

You can start the Cycle Counting Order Line Stock Point Details (whinh5106m000) session either from the Cycle Counting Order Lines (whinh5101m000) session or from the Enter Cycle Counting Results (whinh5101m100) session.

Subject to Trade Compliance

If this check box is selected, the item is subject to global trade compliance checks.

Lot

The lot.

Inventory Date

The date assigned to the item when the item was stored. If the item has a particular shelf life, the inventory date is the product expiry date defined for the item.

Default value

If the value of the Outbound Method field in the Item - Warehousing (whwmd4600m000) session is one of the following, the default inventory date is the current date:

  • LIFO
  • FIFO

If the value of the Outbound Method field in the Item - Warehousing (whwmd4600m000) session is By Location, no inventory date is specified.

Unit

The storage unit.

Package Definition

The package definition.

Quantity
Stock point Inventory (Storage Unit)

The quantity present at the stock point, expressed in the storage unit. When printed on a counting list, this quantity can be used to match with the quantities counted.

Actual Inventory (Storage Unit)

The quantity counted at the stock point, expressed in the storage unit.

If the item is serialized and the Serials in Inventory check box in the Item - Warehousing (whwmd4600m000) session is selected, you cannot enter the actually counted inventory in the current field. To specify the counted inventory, click Serials. The Cycle Counting Order Line Stock Point Details (whinh5106m000) session starts, in which you can register the serial numbers, and specify whether the serial numbers are actually in inventory.

Note: You can only enter the counted quantity if the cycle-count order is printed. Therefore, you must select the Printed check box on the Cycle Counting Orders (whinh5100m000) session.
Variance (Storage Unit)

The difference between the quantity as registered in LN and the quantity counted at the stock point, expressed in the storage unit.

/

The inventory unit.

Stock point Inventory (Inventory Unit)

The quantity present at the stock point, expressed in the inventory unit. This quantity is printed on counting lists, if necessary, and checks the counting results.

Actual Inventory (Inventory Unit)

The quantity counted at the stock point, expressed in the inventory unit.

Variance (Inventory Unit)

The difference between the quantity as registered in LN and the quantity counted at the stock point, expressed in the inventory unit.

If the stock point is not blocked during inventory counting, you must adjust the variance.

Count
Reason for Variance

The reason code for adjusting the variance.

If the variance is changed for some reason, you must enter this code.

Counting Date

The date the inventory was counted.

New Stock Point

The check box is set to selected if no stock point data exist. The location, lot code, inventory date, package definition and storage unit can be changed for a new stock point until the Counted check box is set to selected. For a new stock point, the Cycle Counting Data (whinh5140m000) session is updated when the Counted check box is set to selected.

Note: 
  • You cannot modify the field manually.

  • By default the check box is clear.

Status
Lots and Serials Unbalanced

If this check box is selected, the variance for the current cycle counting order line differs from the aggregated variance of the lot and/or serialized items in the Cycle Counting Order Line Stock Point Details (whinh5106m000) session .

Blocking Reconciliation Present

If this check box is selected, records exist for the current cycle counting order line in the Cycle Counting Order Line Blocking Reconciliation (whinh5108m000) session.

Counted

If this check box is selected, counting data was entered.

Recount

If this check box is selected, the inventory of the stockpoint must be recounted.

After processing the Generate Cycle Counting Orders (whinh5200m000) session, this stock point is added to a new cycle count-order using the same order number. The Count Number field in the Cycle Counting Order Lines (whinh5101m000) session will be increased by 1.

Processed

If this check box is selected, the cycle counting order lines were processed.

Ownership
Ownership

The Ownership of the goods listed on the current cycle counting order line. This field is applicable if the variance is positive or if the item is a low volume serialized item. The default value is company owned. Value customer owned is not allowed for a project item.

Owner

The owner of the items listed on the cycle counting order line. This field is applicable if the variance is positive or if the item is a low volume serialized item and if the ownership behavior is customer owned or consigned.

The value in this field is defaulted from either of the following:

However, if the ownership registration level for the item is by location, this field is read-only and filled with the business partner allocated to the location.

Note that the owner must be an active business partner at the order date.

Issue Strategy

The strategy used to pick inventory for the item.

This field is not applicable if the variance is positive and the item is a not a low volume serialized item

The default value is Free.

If the item is not serialized in inventory and variance is negative, you can select one of the following values:

  • Free
  • Preferred
  • Restricted

If item is serialized in inventory, the available values are:

  • Free
  • Restricted

This field is read-only and the value is Restricted if the Ownership Registration Level is one of the following:

  • Location
  • Physical Item
  • Physical Item and Location

Issue from Business Partner

If the value in the Issue Strategy field is Preferred or Restricted, in this field, you must enter the business partner owning the items that must be or are preferably to be issued.

If the inventory adjustment order is negative or the item is a low volume serialized item, this field is defaulted with:

  • The owner of the location if the Ownership Registration Level is Location.
  • The owner of the handling unit if the Ownership Registration Level is Physical Item and you are adjusting a handling unit.

This field is empty if:

  • The variance is positive and the item is a not a low volume serialized item.
  • The value in the Issue Strategy field is Free.

This field is read-only and the value is taken from the Owner field if the Ownership Registration Level is one of the following:

  • Location
  • Physical Item
  • Physical Item and Location
Note: The owner must be an active business partner on the order date.

Issue Ownership

The ownership behavior of the inventory that is picked for the current outbound order line.

This field is not applicable if the variance is positive and the item is not a low volume serialized item.

The value in this field is determined to a large extent by the values of the Issue Strategy and Issue from Business Partner fields.

  • If the issue strategy value is Free or Preferred, the default value in this field is Company Owned or Consigned. The following values are unavailable:

    • Customer Owned
    • Not Applicable
  • If the issue strategy value is Restricted and the issue-from business partner is an internal business partner, the value in this field is Company Owned.
  • If the issue strategy value is Restricted and the issue-from business partner is not an internal business partner, the default value in this field is Consigned. The available values are:

    • Customer Owned
    • Consigned
Inventory Discrepancies Paid By

The party that is to pay for lost or damaged goods if negative variances occur.

Allowed values

  • According to Terms and Conditions

    The issue-from business partner shown in the Issue from Business Partner field pays for the lost or damaged goods. However, if the Inventory Discrepancies Paid by Business Partner check box of the Logistics Terms and Conditions (tctrm1140m000) session is cleared, the own company is to pay.

  • Owner

    The owner of the counted inventory pays for the lost or damaged goods.
  • Own Company

    The own company pays for the lost or damaged goods.
  • Not Applicable

    Payment for inventory discrepancies is not applicable if:

Price
Price
Use Adjustment Price

If this check box is selected, LN uses the Adjustment Price, as specified in the current session, for the financial transactions related to the cycle-count order line.

You can only specify or modify the adjustment price if the current check box is selected.

The current check box is only available if both of the following conditions apply:

  • The cycle-count order line concerns a positive variance.
  • The item's inventory-valuation method is not Standard Cost. You can view the item's inventory-valuation method in the Item Data by Warehouse (whwmd2110s000) session.
Adjustment Price

The new price for each item.

Default value

LN retrieves the default adjustment price as follows:

  • If the item is not a project item, the default adjustment price is the standard cost. LN retrieves the standard cost from the Standard Cost Calculation module in Manufacturing .
  • If the item is a project item, LN retrieves the default adjustment price from Project .

You can only specify or modify the adjustment price if the Use Adjustment Price check box in the current session is selected. If the Use Adjustment Price check box is cleared, no adjustment price is specified in the current field.

Currency

The currency in which the adjustment price is expressed.

LN only retrieves the currency if the Use Adjustment Price check box is selected. The currency is the local currency of the financial company that is linked to the enterprise unit you are working in. LN retrieves the local currency of the warehouse from the Companies (tcemm1170m000) session.

Inventory Value

The valuation price of the item.

Default value

For the positive cycle counting orders, the default value is the price defined for the valuation method selected in the Default Inventory Receipt Value field in the Inventory Handling Parameters (whinh0100m000) session.

Note: The valuation price is displayed, only if the Use Adjustment Price check box is cleared.
Adjustment Amount

The adjustment price multiplied by the variance, expressed in the inventory unit.

Adjustment Amount

The currency in which the adjustment amount is expressed.

Text
Line Text

If this check box is selected, text is available.

Specification
Demand Peg
Allocated to Sold-to Business Partner

The sold-to business partner to which the inventory is allocated.

LN can use the inventory specified by this record for the business partner specified by this field; LN does not use this inventory for any other business partner.

Allocated to Ship-to Business Partner

The ship-to business partner to which the inventory is allocated.

Business Object Type

The type of order to which the inventory was allocated, such as, Sales Order, or Service Order.

Note: 

The following fields are always used in combination; together, they identify the relevant order or order line:

  • Business Object Type
  • Business Object
  • Business Object Reference

Allowed values

Service (Manual)

Maintenance Sales Order

maintenance sales order

Maintenance Sales (Manual)

Maintenance Work Order

maintenance order

Maintenance Work Order (Manual)
Sales Order

sales order

Sales Schedule

sales schedule

Not Applicable

Sales (Manual)

Service Order

service order

Business Object

The order, or order line, to which the inventory was allocated.

Note: 

The following fields are always used in combination; together, they identify the relevant order or order line:

  • Business Object Type
  • Business Object
  • Business Object Reference

Reference

A reference code to which the inventory was allocated.

LN can use the inventory specified by this record to fulfill a demand specified by this reference and for no other purpose.

LN can use this field in two ways:

  • If the Sold-to Business Partner field is filled, LN uses the Reference field to record a reference code defined by a customer.
  • If the Sold-to Business Partner field is empty, LN uses the Reference field to record an internal reference.

You can use a reference code to keep a collection of parts linked together, even if they follow different routings, for example, if some of the parts are transported to a subcontractor to be returned later.

Derived from Product Variant

product variant

Product Variant

The description or name of the code.

Option List ID

option list ID

The ASN specifications include the option list ID. The ASN specifications are populated from the Inbound Order Lines (whinh2110m000) session. In turn, the specifications on the inbound order line are populated from the purchase schedule line.

For configurable purchased items in Warehousing , only the option list ID is part of the specifications. This means that inventory is maintained per option list ID and is the total of inventory of all product variants with the same option list ID.

Note: 
  • The field is displayed only if the Assembly (APL/ASC/ASL) check box is selected in the Implemented Software Components (tccom0100s000) session.

  • The field is populated only for configurable purchased items and manufactured assembly (FAS) items.