Modifying the cycle count sheet

What you can do in this page

Unified Glossary

Basics of using a typical web page

Using Online Help

In this page, you can modify the details of the CC sheet. Tell me more

The “Edit Cycle Count Sheet” page appears.

The system displays the following fields in the “Sheet Details” group box:

CC Sheet #

The number identifying the cycle count sheet that you need to modify.

Status

The status of the cycle count sheet, which could be one of the following:

  • Draft - The status of the cycle count sheet on clicking the “Edit Count Sheet” pushbutton.

  • Confirmed - The status of the cycle count sheet on clicking the “Confirm Count Sheet” pushbutton, provided all the mandatory details are entered.

  • Cancelled - The status of the cycle count sheet on clicking the “Cancel Count Sheet” pushbutton.

Sheet Description

The textual description of the CC sheet (Alphanumeric, 150). Mandatory.

User Status

Use the drop-down list box to assign a user-defined status for the CC sheet. The system lists all the “Active” quick codes defined for the user status in the “Create Quick Codes” activity of the current business component.  The system sets the field blank by default.

The system displays the following fields:

CC Plan #

The number that identifies the CC plan for which the CC sheet is created.

Plan Description

The textual description of the CC plan.

Warehouse #

The warehouse for which the CC sheet was generated.

Note: If the CC Plan Level is 'Warehouse', then for the selected Warehouse the system includes only those parts under the CC plan, for which the stock status is mapped to the attribute type ‘Cycle Count’ and is marked as “Yes”, as defined in the “User Defined Stock Status” business component.

Warehouse Description

The textual description of the warehouse.

WH – Zone #

The number that identifies the zone for which the CC plan was generated.

Note: If the CC Plan Level is 'Warehouse-Zone', then for the entered “Warehouse-Zone #” the system includes only those parts under the CC plan, for which the stock status is mapped to the attribute type “Cycle Count’ and is marked as “Yes”, as defined in the “User Defined Stock Status” business component.

Zone Description

The textual description of the zone.

System Quantity Display

Use the drop-down list box to indicate whether to show or hide the system quantity of parts while entering the count results. The system provides the options “Show System Quantity” and “Do not show System Quantity”. The system sets the field to “Do not show System Quantity” by default.

Note: The system displays both the options only if the “Sheet level Modification” option setting in the “Set Cycle Count Options” activity is set as “Yes”. Otherwise, the system sets this field to the option selected in the “System Quantity Display” field of the “Set Cycle Count Options” activity of the current business component.

Recount Mandatory

Use the drop-down list box to indicate whether recount is mandatory or not. The system provides the options “Required” and “Not Required”. The system displays “Required” by default.

Note: The system displays both the options only if the “Sheet level Modification” option setting in the “Set Cycle Count Options” activity is set as “Yes”. Otherwise, the system sets this field to the option selected in the “Recount Mandatory” field of the “Set Cycle Count Options” activity of the current business component.

The system displays the following:

OverDue Date

The date on which the cycle count is due for the part

Count Date

The date on which the cycle counting is done for the parts (Date Format). Mandatory. Ensure this date is equal to or later than the current server date. The system sets the current server date by default.

The system displays the following:

Zero Qty Parts

Indicates whether the zero quantity stock included in the in the cycle count.

No. of Records

The total number of line records associated with the sheet. The system displays this field on clicking “Edit Count Sheet” pushbutton

The system displays the following fields in the “Other Details” group box:

Class

TThe class to which the CC sheet belongs, which could be “A”, “B”, “C” or “V”, “E”, “D” .

Part Type

The type of the part for which the CC sheet is generated.

Part Group

The part group of the part for which the CC sheet is generated.

Part Category

The category of the part for which the CC sheet is generated.

Note: For CC sheet, the system retrieves only those parts for which “Mapping?” is set as “Yes” for the status attribute “Cycle Counting”, in the “Create User Defined Stock Status” activity of the “User Defined Stock Status” business component.

Incase of CC sheet based on plan, the system retrieves all the parts listed in the selected CC plan which were not included in any CC sheet includes them along with the previously associated parts. Incase of CC sheet based on overdue date, the system retrieves all the parts in which the overdue date is similar to the due date specified here, irrespective of the CC plan.

The system displays the following fields in the “Part Details” multiline.

Note: The system displays 100 records at a time in the multiline.

Line #

The line number generated by the system for part in the CC sheet.

CC Plan #

The number that identifies CC plan from which the CC sheet was created.

Part #

The number that identifies the part that you can include in the CC sheet.

Part Description

The textual description of the part.

Stock Status

The user-defined stock status of the part.

Class

The class to which the CC sheet belongs, which could be “ABC” or VED”.

Count Interval (Days)

The number of days after which the cycle counting is repeated for the class of a part. The part could be classified as “A”, “B”, “C” or “V”, “E”, “D” based on the classification method  (“ABC” or “VED”) set in the “Set Cycle Count Options” activity of the current business component.

Last Counted On

The date on which the part was last counted.

Next Due On

The date on which the part will be due for the next counting

System Quantity

The quantity of parts available as per the system inventory records.

Stock UOM

The unit of measurement for the parts.

To view subsequent set of records

For example if there exists 200 records, and if records 1-100 are currently displayed in the multiline, then on clicking the “Next” pushbutton the system displays the next set of records i.e. records 101-200 in the multiline.

Similarly if records 101-200 are currently displayed in the multilane, then on clicking the “Previous” pushbutton the system displays the previous set of records i.e. records 1-100 in the multiline.

Note: The system displays an error message on clicking the “Previous” and “Next” pushbuttons respectively when there exists no set of records prior and next to the set of records currently displayed.

The system displays the following in the “Record Statistics” group box at the bottom of the page:

Created By

The name of the user who created the CC sheet.

Created Date

The date on which the CC sheet was created.

Last Modified By

The name of the user who last modified the CC sheet.

Last Modified Date

The date on which the CC sheet was last modified.

To modify CC sheet

The system updates the modified details and It freezes the parts listed in the CC sheet.

 Note: The system updates the status of line items from "Planned” to "Generated”, when associated to the sheet.

To cancel CC sheet

The system cancels the sheet and changes the status as “Cancelled”. You can attach the parts associated with the cancelled sheet with other sheets.

Note: A cycle count sheet in “Cancelled” status cannot be modified.

Note: All the parts which were associated with this sheet reverts to "Planned" status and are free to be associated with the other sheets.

To confirm CC sheet

The system updates the cycle count sheet to “Confirmed”.

The system on confirmation of the cycle count sheet freezes the storage area (warehouse/zone/bin) to facilitate the Cycle Counting process. As a result, no stock movement of parts for which cycle counting is underway is allowed in the storage area.

Note: A cycle count sheet in “Cancelled” status cannot be confirmed.

To proceed, carry out the following

Top

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What you can do in this page

Modify the display option

Specify whether recount is mandatory or not

Include or exclude zero quantity parts in the CC sheet

Cancel the CC sheet

Top

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Modify the display option

You can modify the display option that is whether to show or hide the system quantity of parts while entering the count results.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Specify whether recount is mandatory or not

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Include or exclude zero quantity parts in the CC sheet

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Cancel the CC sheet

You can cancel the CC sheet in the “Draft’ status.

The system changes the status to “Cancelled”.

Top

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Modifying the cycle count sheet – An overview

Edit Cycle Count Sheet - A summary of the activity

In this page, you can modify the details of the CC sheet. You can modify the CC sheet, which is in the “Draft” sheet. You can modify the description, user-defined status, execution details such as the display option, whether recount is mandatory or not, overdue date, count date and whether zero quantity parts can be included in the CC sheet.

You can also confirm or cancel the CC sheet, in the page.

Top