Product Entry Cycle Count Report overview

Product > Entry > ICE Reports > ICEPC

Function acronym: ICEPC

Use this report to start printing count sheets with the first bin location in the warehouse up to the number of products to count for the current session.

Cycle counting means counting a limited number of different products or bins each night. The system’s cycle counting is true cycle counting. This means there are no report ranges that can be entered. The count is performed in bin location order without regard to which products are supposed to be in the bins, and the count is done shelf to sheet. If several products have the same bin location, the products are sorted in product order. Build-on-demand kits and labor products are excluded from this process. Products with the Count Required field selected in Product Warehouse Product Setup - General are included if they are in the selected bin location.

The following evening, the count sheet picks up where the current count sheet ends. Each evening, the last bin location is stored internally on each warehouse record. The following evening, the count sheets start with the next available bin location. If the product is flagged as a must count, the letter c prints next to the expected quantity on the count sheet.

Note:  If a cycle count run number is open when a physical count run is created, any adjustments updated for the cycle count are made again when the physical count is updated. No cycle count runs should be made while a physical count run is in an open stage that has not been updated. Even with just cycle counts, a remote possibility exists that an item is cycle counted, then set for cycle counting due to an adjustment, and cycle counted again while the first run is still open. Use extreme caution with multiple open run numbers.

The Bin Locations and Products record, which does not contain an On Hand quantity, is not automatically deleted when you specify a zero quantity in Product Count Entry. Run the WM Audit Report to delete open bins before you run the Product Entry Cycle Count Report or Product Entry Physical Count Report.

Note:  It is important for products to be set up with unique bin locations in Product Warehouse Product Setup. This keeps the system running smoothly when generating cycle count sheets. If there are too many duplicates, the system cannot generate your count sheets in a timely manner.

Products that are tagged unavailable are not included in the expected quantity. These goods should be physically separate from shelf goods and in a special area that clearly indicates the goods are not to be picked from because they cannot be used for sales.

If you have warehouses in a foreign country, then you may need product descriptions in inventory count reports to be printed in alternate languages for certain warehouses where the employees do not speak the language specified for the Company. These employees are not able to check the products in the warehouse against the reports when they cannot read the product description. This leads to incorrect physical inventory counts.

You can specify the language in which you want to print the product descriptions in the Language field in Product Warehouse Description Setup-General. Then select whether to print the product descriptions in the language defined for your company or the warehouse in the Cycle Count Language field on the Count view.

Note: The product descriptions are printed in the warehouse language only when the language that you select in the Language field in Product Warehouse Description Setup-GeneralMultiple Language Setup window in Product Setup-General has matching product descriptions available on the . Otherwise, the product descriptions set up in Product Setup are printed.

The following error messages may print on the Product Entry Cycle Count Report.

Description Cause/Correction
Whse Does Not Exist You specified a warehouse that does not have a valid Product Warehouse Description Setup record. Specify a valid warehouse and rerun the report.
Unposted Cycle Count Records Exist for Whse, Run # When the last cycle count for the warehouse has not been posted and you attempt to create a run that already exists, you receive this error message. You are not be allowed to process count sheets if you have unposted count records in existence. Run Product Entry Cycle Count Report with a new number or clear the count in Product Cycle Count Entry.
Cannot Print Count Sheets and Tickets to the Same Printer has matching product descriptions available on the You cannot print the count sheets and tickets at the same printer.
No Printer Was Indicated for Printing Tickets The Ticket Printer option was blank. Designate a printer to print tickets. It cannot be the same printer at which you are printing count sheets.
No Printer Was Indicated for Printing Count Sheets The Count Sheet Printer option was blank. Designate a printer to print count sheets. It cannot be the same printer at which you are printing tickets.
A Count Already Exists for This Run Number Each time you print count sheets, a run number is assigned. Run numbers are cleared and may be reused only after a run has been updated.