User Tools

Site Tools


implementation:wms:cycle_count

10. Cycle Count

To check the correctness of the stock that is kept at the administrative level against the stock that is actually present in the warehouse, Produmex offers a cycle counting function. Produmex provides two types of cycle count:

  • ‘Direct cycle count’: This type of count automatically books stock differences as “Goods Issues” (in case of negative differences) or “Goods Receipts” (in case of positive differences) in SAP.
  • ‘Cycle count’: This type of count will not directly book the differences into SAP. First it registers the differences in Produmex according to the type of cycle count (Lost and Found, Registration). Then the booking in SAP can be done in the ‘Processing’ step.

‘Cycle count’ types:

  • Lost and Found: The differences will be booked during the count therefore the new stock will be displayed in the inventory without processing. To balance the inventory, the system will add the inverse of the stock difference to the ‘Lost and Found’ location.
  • Registration: The differences will be stored in a table and the stock on the counted location will remain the same until the count is processed.

Please note that differences for serial numbers will always use type 'Registration', regardless of the selected type in the controller.

10.1. Configurations

Before starting the cycle count, adjust the following settings:

10.1.1. Quality status

The quality status of the found stock can be the following:

  1. The default quality status of the location.
    • If the location has a default quality status set.
  2. The quality status of the stock that has the exact same details (Location, SSCC, Batch, BBD).
    • If the counted location has no default quality status set and there is only one quality status found for the stock with the same details.
  3. The default quality status set for cycle counting on the Defaults tab of the Organizational Structure.
    • If the counted location has no default quality status set and multiple quality status found for the stock with the same details or there is no stock with the same details.

When quantity is reduced and there are two or more statuses found for the same stock details, the system will also replace them with the default “Quality status cycle counting”. Additional items that are counted at a certain location where existing stock row is found, will also get the default “Quality status cycle counting”.

Examples:
Default quality status: BLOCKED

Scenario 1:
Location default quality status: -
On location: 1 piece with quality status RELEASED
Counting: 2 pieces
Result: The additional piece will get quality status RELEASED

Scenario 2:
Location default quality status: -
On location: 1 piece with quality status RELEASED and 1 piece with quality status REJECTED
Counting: 3 pieces
Result: All 3 pieces will get quality status BLOCKED

Scenario 3:
Location default quality status: -
On location: 2 piece with quality status RELEASED and 2 piece with quality status REJECTED
Counting: 3 pieces
Result: All 3 pieces will get quality status BLOCKED

Scenario 4:
Location default quality status: -
On location: 0 pieces
Counting: 2 pieces
Result: The 2 pieces will get quality status BLOCKED

Scenario 5:
Location default quality status: SUQ
On location: 0 pieces
Counting: 3 pieces
Result: The 3 pieces will get quality status SUQ

10.1.2. Cycle Count Controller

Adjust cycle count settings for the company. For further information about the cycle count controller see:
5.1.3.9. Cycle count controller

10.1.3. Location

Adjust cycle count settings for a location. For further information about the cycle count settings see:
5.2.7. Cycle count settings

10.1.4. Lost and Found

When using the cycle count type ‘LostAndFound’, extra configuration needs to be done:
Create a non pick BIN location where the stock differences will be booked. On the warehouse definition select this location as Location ‘Lost and Found’ from a dropdown menu.

10.1.5. Cycle count during other operations

Set the configurations for the cycle count during other operations. For further information see:
3.2.3.17. Produmex cycle count – Other operations filter (PMX_COOF)

10.1.6. Pick List Controller

Set if the system allows cycle count on alternate picking. For further information see:
5.1.3.44. Picklist controller

10.1.7. Force serial numbers during cycle count

When the ‘Force serial numbers during cycle count’ option is enabled for items with PMX serial numbers and enabled track location, then during the ‘Cycle count’ process, the quantity must be entered by scanning the serial numbers. This option can be enabled at the item’s Produmex Inventory tab.

10.2. Direct Cycle Count

Count locationIdentify locationScan SSCCIdentify productEnter batch dataAdd quantityAdjust logistic unitScan SSCCSelect itemAdjust quantityCount items on locationIdentify locationIdentify productScan SSCCEnter batch dataAdd quantity

Select the “Direct cycle counting” function on the handheld terminal.

Select the cycle count task:

  • Count location: count all the items on this location.
  • Adjust logistic unit: count all the items on the selected logistic unit.
  • Count items on location: count only a certain product on the location.

10.2.1. Count location

Identify location

Identify the location for which cycle counting has to be done.

Scan SSCC

Identify the logistic unit on which the item is stored or to select “No SSCC” in case the item is not stored on an existing logistic unit.

Stop process

To stop the process, press the ‘Stop’ button. After pressing the button, the system will ask for confirmation.

  • Press ‘No’ to proceed with the cycle count.
  • Press ‘Yes’ to finish the cycle count. After pressing ‘Yes’, the differences will be shown if configured. If no item was counted during the cycle count, the location will be booked as an empty location.
Identify product

Scan or select an item. It is possible to scan the GTIN on the product or the GS1/EAN128 barcode on the logistic unit (in case of a mono pallet). When selecting a product manually, the complete item list will open, as it is always possible that any item which has not been registered administratively at that location, may be present there.

Enter batch data

If there is no GS1/EAN128 product barcode on the logistic unit, the system will ask to enter additional information about the product manually, e.g. the batch number, second batch number, and/or the best before date. If there is a GS1/EAN128 barcode on the logistic unit, the system would have recorded this information directly.

Add quantity

Enter the quantity.

Add new item or finish process

After the confirmation of the quantity, the system asks whether to count an additional item at that location. When pressing ‘Yes’, the counting process will proceed with a new item. When pressing ‘No’, the system calculates if there is a difference between the quantity of items counted on the location and the registered quantity in the inventory report.

When there is no difference, the system will display an empty ‘Difference stock’ screen.

When there is a difference, the following will be shown on the screen:

  • In the case the difference is positive, the handheld will show a blue arrow pointing upward. (Items with differing batch data will be counted as a new item as well.)
  • In the case the counted item is new for this location, the handheld will show a green arrow pointing upwards to the right.
  • In the case the difference is negative (i.e. less stock at the location than registered in inventory), the handheld will show a red arrow pointing downwards to the right and add a minus sign before the quantity.

Press the right arrow button to confirm the differences. After that, the system books positive differences as “Goods Receipt” and negative differences as “Goods Issue”. The pricelist defined on the Cycle count controller is used on these documents.

Cancel cycle count

To cancel the process, press the left arrow button. The system will check whether there are already entered stock. If there are, the system will ask for confirmation.

  • When clicking ‘Yes’, the list of counted stock will be cleared, and no bookings will be done. This can be considered a ‘cancellation’ of the counted stock.
  • When clicking ‘No’ the cycle count process can be continued.

10.2.2. Adjust logistic unit

Scan SSCC

Identify the SSCC. After identifying the SSCC, the system will display all the items stored on the SSCC.

Select item

Select an item from the list.

Adjust quantity

Adjust the quantity of the selected item. If the quantity in stock matches with the quantity in the inventory, the system goes back to the list of the items on the SSCC. If the quantity in stock does not match with the quantity in the inventory, the system updates the quantity in the inventory. After the system update, the counting can be continued on another SSCC.

10.2.3. Count items on location

Identify location

Identify the location for which cycle counting has to be done.

Identify product

Select the item to count on the location. It is possible to scan the GTIN on the product or the GS1/EAN128 barcode on the logistic unit (in case of a mono pallet). When selecting a product manually, the complete item list will open, as it is always possible that any item which has not been registered administratively at that location, may be present there.

Empty location

If the location is empty, press on the ‘Location is empty’ button. After pressing the button, the system will ask for confirmation whether the location is empty or not. When pressing the ‘Yes’ button, the system books this location as an empty location and the counting can be continued on another location. Scan an SSCC. If there is no SSCC present, press the ‘No SSCC’ button.

Enter batch data

If there is no GS1/EAN128 product barcode on the logistic unit, the system will ask to enter additional information about the product manually, e.g. the batch number, second batch number, and/or the best before date. If there is a GS1/EAN128 barcode on the logistic unit, the system would have recorded this information directly.

Adjust quantity

Enter the quantity.

Add new item or finish process

After the confirmation of the quantity, the system asks whether to count an additional item at that location. When pressing ‘Yes’, the counting process will proceed with a new item. When pressing ‘No’, the system calculates if there is a difference between the quantity of items counted on the location and the registered quantity in the inventory report.

When there is no difference, the system will display an empty ‘Difference stock’ screen.

When there is a difference, the following will be shown on the screen:

  • In the case the difference is positive, the handheld will show a blue arrow pointing upward. (Items with differing batch data will be counted as a new item as well.)
  • In the case the counted item is new for this location, the handheld will show a green arrow pointing upwards to the right.
  • In the case the difference is negative (i.e. less stock at the location than registered in inventory), the handheld will show a red arrow pointing downwards to the right and add a minus sign before the quantity.

Press the right arrow button to confirm the differences. After that, the system books positive differences as “Goods Receipt” and negative differences as “Goods Issue”. The pricelist defined on the Cycle count controller is used on these documents.

Cancel cycle count

To cancel the process, press the left arrow button. The system will check whether there are already entered stock. If there are, the system will ask for confirmation.

  • When clicking ‘Yes’, the list of counted stock will be cleared, and no bookings will be done. This can be considered a ‘cancellation’ of the counted stock.
  • When clicking ‘No’ the cycle count process can be continued.

10.3. Cycle count

Without taskWith taskCount everythingCount SSCCCount items on locationScan SSCCScan itemEnter batch dataAdd quantityIdentify itemScan itemEnter batch dataAdd quantityProcess cycle count

Select the “Cycle counting” function on the handheld terminal.
Select the cycle count task:

  • With task: When selecting this task, only locations with the option ‘Location needs to be counted now’ set to true are allowed.
  • Without task: When selecting this task, all locations with the option ‘Allow to be counted during cycle count’ set to true are allowed.

10.3.1. Cycle count with task

Office
Tasks can be made for the cycle counting process. Tasks allow users to plan the cycle counting.

The settings on this screen can be used to limit the locations that will need to be counted. After pressing the ‘Update’ button, it will set the property ‘Needs to be counted now’ on the selected location(s) to true.

Pick locations, non-pick locations, reception dock, shipping dock, production lines
Select the type of locations to perform the actions on.

Only when cycle count requirements are met
When this setting is set to true, the cycle count settings (like number of days, number of operations, …) on location and cycle count controller are checked. Only locations where these requirements are met will be used to perform the actions.

Warehouse
Select the warehouse. If no warehouse is selected all warehouses are used.

Zone
After selecting a warehouse, all zones in this warehouse will be listed here. Select a zone to only use the locations in this zone. If no zone is selected, all zones are used.

Location from… to
Select location(s) which needs to be counted.

Lock location for user
Select a user to lock the locations for. If no user is selected, the location(s) will not be locked. When a user is selected, the locations that are found using the entered selection criteria will be locked for this user. This means stock on these locations cannot be used. Only the selected user can perform the cycle counting task on the handheld device. This option can be used to divide the cycle counting task for users.

Item group
Select an item group. The property ‘Needs to be counted’ will be set to true on locations where the items from the group are stored.

Item from… to
Select item(s). The property ‘Needs to be counted’ will be set to true on locations where the selected item(s) are stored.

Remove count task from selected locations
If this is set to true, the property ‘Needs to be counted’ on location will be set to false.

Remove lock from selected locations
Remove the lock on the selected locations.

Shopfloor

All screens regarding the cycle count will have the prefix ‘Cycle count:‘ on the screen title. This is done because when the user needs to perform cycle count during other operations, it is visually clear that he is performing a cycle count.

Select the option ‘Cycle count’ and then ‘With task’.

If there are no locations which needs to be counted, the system will display the message ‘No more zones to count’.
If there are locations which needs to be counted, the system will display the list of zones where those location(s) are located. Select a zone.

After selecting a zone, select a location from the list. Only locations that need to be counted and have no locking, or are locked for the current user, are displayed in the list.
After the user has selected the location, this location will be locked for this user. No other user will see this location in the list of locations to be counted.

When the cycle count type is ‘Registration’, the system will check if there are open registrations. When there are open registrations, the system asks whether to remove those registrations. Press ‘Yes’ for clearing the previous registrations. In this case only new registrations will be used. Press ‘No’ for keeping the previous registrations. In this case, new registrations will be added to the already existing registrations.

Select a task:

  • Count everything: count all the items on this location.
  • Count SSCC’s: count all full logistic units on the location.

Note: Full logistic units in the system are SSCC’s where no stock has been removed yet.

10.3.1.1. Count everything

Scan SSCC

Scan the SSCC or press the ‘No SSCC’ button if there is no SSCC present.

To stop the process, press the ‘Stop’ button.

Empty location
If the location is empty press the ‘Location is empty’ button. After pressing the button, the system will ask whether the location is empty. Press the ‘Yes’ button to confirm. Then the system will display the list of differences in stock if configured. When proceeding, the differences will be registered according to the type of cycle count (Lost and Found, Registration).

Scan item

Scan the product barcode. When no barcode is present, press the ‘Select product’ button and select it from a list. This list contains all the products.

Enter batch data

If there is no GS1/EAN128 product barcode on the logistic unit, the system will ask to enter additional information about the product manually, e.g. the batch number, second batch number, and/or the best before date (if applicable). If there is a GS1/EAN128 barcode on the logistic unit, the system would have recorded this information directly. After the batch information has been entered, the system will check if the combination of batch/BBD is known in the system. If this is not the case, confirm that the batch/BBD is not known.

Add quantity

Enter the quantity. For more information about how to enter the quantity please see: Screens for entering additional information.

When the item is managed by 'On every transaction' SAP serial numbers and the track location option is enabled, the quantity must be defined by scanning the serial numbers.

When the item is managed by ’On release only’ SAP serial numbers and the track location option is enabled, the quantity must be entered manually. When there is a negative difference and there are existing serial numbers on the location, the missing serial numbers can be selected during processing the count.

When the item has PMX serial numbers and track location enabled, the quantity can be defined by scanning the serial numbers or entering the quantity. If the 'Force serial numbers during cycle count' option is enabled for the item, then the quantity can only be added by scanning the serial numbers.

When the item has serial numbers but the track location option is not enabled, the quantity can only be defined by entering it manually. However Produmex does not support these items in the ‘Process’ step of the cycle count.

Add new item or finish the process

After entering the quantity, proceed with the next item on the location. The system will display the ‘Cycle count: Scan an SSCC’ screen, however the ‘Location is empty’ button will not be displayed.

After counting all the items on the location, press the ‘Stop’ button.
When pressing the ‘Stop’ button, a confirmation to stop the cycle count is asked.

  • Press ‘No’ to proceed with other items on the location.
  • Press ‘Yes’ to finish the cycle count. After pressing the button, the differences will be shown if configured. When proceeding, the differences will be registered according to the type of cycle count (Lost and Found, Registration).
Cancel cycle count

To cancel the process, press the left arrow button. The system will check whether there are already entered stock. If there are, the system will ask for confirmation.

  • When clicking ‘Yes’, the list of counted stock will be cleared, and no bookings will be done. This can be considered a ‘cancellation’ of the counted stock.
  • When clicking ‘No’ the cycle count process can be continued.

10.3.1.2. Count SSCC's

Enter the number of full SSCC’s.

If the number of the entered SSCC’s does not correspond to the number of full SSCC’s in the system, the system requires to perform the ‘Count everything’ cycle count task.

If the number of entered SSCC’s corresponds to the number of full SSCC’s in the system, the system will ask to enter the data for the partial SSCC’s.

When there are partial SSCC’s on the location, proceed by scanning the SSCC on the partial logistic unit or press the ‘No SSCC’ button. Then the ‘Count everything’ cycle count task will be performed for those logistic units.

When there are no partial SSCC’s, press the ‘Location has no partial SSCC’s’ button. Then the system will ask whether there are partial SSCC’s on the location. Confirm this action.

10.3.2. Cycle count no task

Scan or select a location.
After identifying the location, select a task:

  • Count everything: count all the items on this location.
  • Count SSCC’s: count all full logistic units on the location.
  • Count items on location: count only a certain product on the location.

10.3.2.1. Count everything

Scan SSCC

Scan the SSCC or press the ‘No SSCC’ button if there is no SSCC present.

To stop the process, press the ‘Stop’ button.

Empty location
If the location is empty press the ‘Location is empty’ button. After pressing the button, the system will ask whether the location is empty. Press the ‘Yes’ button to confirm. Then the system will display the list of differences in stock if configured. When proceeding, the differences will be registered according to the type of cycle count (Lost and Found, Registration).

Scan item

Scan the product barcode. When no barcode is present, press the ‘Select product’ button and select it from a list. This list contains all the products.

Enter batch data

If there is no GS1/EAN128 product barcode on the logistic unit, the system will ask to enter additional information about the product manually, e.g. the batch number, second batch number, and/or the best before date (if applicable). If there is a GS1/EAN128 barcode on the logistic unit, the system would have recorded this information directly. After the batch information has been entered, the system will check if the combination of batch/BBD is known in the system. If this is not the case, confirm that the batch/BBD is not known.

Add quantity

Enter the quantity. For more information about how to enter the quantity please see: Screens for entering additional information.

When the item is managed by 'On every transaction' SAP serial numbers and the track location option is enabled, the quantity must be defined by scanning the serial numbers.

When the item is managed by ’On release only’ SAP serial numbers and the track location option is enabled, the quantity must be entered manually. When there is a negative difference and there are existing serial numbers on the location, the missing serial numbers can be selected during processing the count.

When the item has PMX serial numbers and track location enabled, the quantity can be defined by scanning the serial numbers or entering the quantity. If the 'Force serial numbers during cycle count' option is enabled for the item, then the quantity can only be added by scanning the serial numbers.

When the item has serial numbers but the track location option is not enabled, the quantity can only be defined by entering it manually. However Produmex does not support these items in the ‘Process’ step of the cycle count.

Add new item or finish the process

After entering the quantity, proceed with the next item on the location. The system will display the ‘Cycle count: Scan an SSCC’ screen, however the ‘Location is empty’ button will not be displayed.

After counting all the items on the location, press the ‘Stop’ button.
When pressing the ‘Stop’ button, a confirmation to stop the cycle count is asked.

  • Press ‘No’ to proceed with other items on the location.
  • Press ‘Yes’ to finish the cycle count. After pressing the button, the differences will be shown if configured. When proceeding, the differences will be registered according to the type of cycle count (Lost and Found, Registration).
Cancel cycle count

To cancel the process, press the left arrow button. The system will check whether there are already entered stock. If there are, the system will ask for confirmation.

  • When clicking ‘Yes’, the list of counted stock will be cleared, and no bookings will be done. This can be considered a ‘cancellation’ of the counted stock.
  • When clicking ‘No’ the cycle count process can be continued.

10.3.2.2. Count SSCC

Enter the number of full SSCC’s.

If the number of the entered SSCC’s does not correspond to the number of full SSCC’s in the system, the system requires to perform the ‘Count everything’ cycle count task.

If the number of entered SSCC’s corresponds to the number of full SSCC’s in the system, the system will ask to enter the data for the partial SSCC’s.

When there are partial SSCC’s on the location, proceed by scanning the SSCC on the partial logistic unit or press the ‘No SSCC’ button. Then the ‘Count everything’ cycle count task will be performed for those logistic units.

When there are no partial SSCC’s, press the ‘Location has no partial SSCC’s’ button. Then the system will ask whether there are partial SSCC’s on the location. Confirm this action.

10.3.2.3. Count items on location

Identify the product

Scan the product. When no barcode is present, press the ‘Select product’ button and select it from a list. This list contains all the products.

Empty location
If the location is empty press the ‘Location is empty’ button. After pressing the button, the system will ask whether the location is empty. Press the ‘Yes’ button to confirm. Then the system will display the list of differences in stock if configured. When proceeding, the differences will be registered according to the type of cycle count (Lost and Found, Registration).

Scan SSCC

Scan the SSCC the item is on. If there is no SSCC present press the ‘No SSCC’ button.

Enter batch data

If there is no GS1/EAN128 product barcode on the logistic unit, the system will ask to enter additional information about the product manually, e.g. the batch number, second batch number, and/or the best before date (if applicable). If there is a GS1/EAN128 barcode on the logistic unit, the system would have recorded this information directly. After the batch information has been entered, the system will check if the combination of batch/BBD is known in the system. If this is not the case, confirm that the batch/BBD is not known.

Add quantity

Enter the quantity. For more information about how to enter the quantity please see: Screens for entering additional information.

When the item is managed by 'On every transaction' SAP serial numbers and the track location option is enabled, the quantity must be defined by scanning the serial numbers.

When the item is managed by ’On release only’ SAP serial numbers and the track location option is enabled, the quantity must be entered manually. When there is a negative difference and there are existing serial numbers on the location, the missing serial numbers can be selected during processing the count.

When the item has PMX serial numbers and track location enabled, the quantity can be defined by scanning the serial numbers or entering the quantity. If the 'Force serial numbers during cycle count' option is enabled for the item, then the quantity can only be added by scanning the serial numbers.

When the item has serial numbers but the track location option is not enabled, the quantity can only be defined by entering it manually. However Produmex does not support these items in the ‘Process’ step of the cycle count.

Finish process

After entering the quantity, proceed with the next logistic unit on the location. The system will display the ‘Cycle count: Scan an SSCC’ screen, however the ‘Location is empty’ button will not be displayed.

After counting the total stock for the item on the location, press the ‘Stop’ button.
When pressing the ‘Stop’ button, a confirmation to stop the cycle count is asked.

  • Press ‘No’ to proceed with other logistic units on the location.
  • Press ‘Yes’ to finish the cycle count. After pressing the button, the differences will be shown if configured. When proceeding, the differences will be registered according to the type of cycle count (Lost and Found, Registration).
Cancel cycle count

To cancel the process, press the left arrow button. The system will check whether there are already entered stock. If there are, the system will ask for confirmation.

  • When clicking ‘Yes’, the list of counted stock will be cleared, and no bookings will be done. This can be considered a ‘cancellation’ of the counted stock.
  • When clicking ‘No’ the cycle count process can be continued.

10.3.3. Cycle count during other operations

When the cycle counting needs to be done during other operations, the system will display the message ‘This location needs to be counted’. After pressing the ‘Ok’ button, a ‘Cycle count’ type process can be started.

Based on the cycle count controller configurations, the system might allow to skip the count. When the skipping is allowed, and extra ‘Skip count’ button will appear. For skipping the count, select the ‘Skip count’ button or press the left arrow button.
If configured, the system displays a list of reasons for the skipping. Select a reason.

When the skipping is not allowed, the normal ‘Cycle count’ process will be performed. When pressing the left arrow button, the system will display a warning message that the count cannot be skipped.

10.4. Process

In case of the ‘Cycle count’ flow, for processing the counted data open the ‘Process’ window from the Produmex menu. This window displays all the differences counted according the cycle count type.

Warehouse
The warehouse where the cycle count was performed.
Remarks
Remarks to be added to the issue and/or receipt.
Posting date
The posting date of the issue and/or receipt.
G/L Account receipt/issue
The G/L account to use for the issues and/or receipts. (This only needs to be set when using Perpetual Inventory and if this is set on the controller)

10.4.1. Process LostAndFound

If there are multiple rows in the list, selected rows can be removed by pressing the ‘Delete’ button. This deletes the entries from the list to process but the data is not deleted from the database. Deleted rows will appear again after the list is refreshed.

It is possible to process the counted difference in multiple steps. Adjust the quantity on the grid before processing the row. Example: The quantity on the row is 64. If you would like to process only 20, change the quantity to 20. When processing the row, only 20 is processed, and the remaining 44 can be processed later.

The item cost will be the item cost for the given warehouse (OITW.AvgPrice) when the following verifies:

  • The Item Groups Valuation Method is ‘Moving Average’ (OADM.InvntSystm = ‘A’) for the company
  • The Manage Item Cost per Warehouse option is enabled (OADM.PriceSys = ‘Y’) for the company

In other cases this will be the item cost (OITM.AvgPrice).

A negative quantity means that there is not enough stock in the system. When processing this, a goods receipt will be booked to add stock to the system. A positive quantity means that there is too much stock in the system. A goods issue will be booked to correct this.

After pressing the ‘Update’ button, the selected rows in the grid will be processed. After processing, the system will inform the user that the processing has been done. After processing, the list will be refreshed.

Please note that goods issues can only be performed if the stock is not currently locked. If this is the case, the locking should be removed before processing the cycle count.

Recommendation when using cycle count type ‘LostAndFound’:
If cycle counting during other operations is used, or cycle counting is performed while other processes (Picking, production, …) still take place, it is recommended to regularly process the counted locations.

For example:
In the system there is no stock in the system of ProductA. Location A1 is counted, and 10 pieces of ProductA are found. On the LostAndFound location, the stock of ProductA is -10, and on location A1 there will be 10 pieces. The sum of that stock is 0, and that corresponds to the stock available in SAP.

Because there is now 10 pieces of ProductA on location A1, it is possible to make a pick list for this stock, and pick the items. But when the user will try to ship the items, an error will occur, because the stock is not known in SAP.

So the processing of the cycle count needs to be done first. A goods receipt of 10 pieces of ProductA will be booked, so the stock in SAP will contain 10 pieces of ProductA. Now the shipping of the pick list can be performed.

10.4.2. Process Registration

If there are multiple rows in the list, selected rows can be removed by pressing the ‘Delete’ button. This deletes the entries from the list to process but the data is not deleted from the database. Deleted rows will appear again after the list is refreshed.

It is possible to process less than the counted difference. For example the counted difference is -32. The quantity can be changed to -20. When processing the row, only 20 is processed and the remaining 12 will not reappear on the list. It is not possible to change the quantity to process to -34.

The item cost will be the item cost for the given warehouse (OITW.AvgPrice) when the following verifies:

  • The Item Groups Valuation Method is ‘Moving Average’ (OADM.InvntSystm = ‘A’) for the company
  • The Manage Item Cost per Warehouse option is enabled (OADM.PriceSys = ‘Y’) for the company

In other cases this will be the item cost (OITM.AvgPrice).

Contrary to the cycle count type ‘LostAndFound’, the processing of the positive and negative quantity is done oppositely.
A positive quantity means that there is not enough stock in the system. When processing this, a goods receipt will be booked to add stock to the system. A negative quantity means that there is too much stock in the system. A goods issue will be booked to correct this.

After pressing the ‘Update’ button, all rows in the grid will be processed. After processing, the system will inform the user that the processing has been done. After processing, the list will be refreshed. If there were deleted rows, they will appear again in the list.

Note: Goods issues can only be performed if the stock is not currently locked. If this is the case, the locking should be removed before processing the cycle count.

10.4.3. Adjust price

When the ‘Manually set price on processing the count‘ option is enabled on the Cycle Count Controller, the price of the items can be adjusted. Four additional columns are displayed on the screen:

  • Enter new price: Add the new price for the item to this field. By default it is filled with the value from the ‘Item Cost’ field. The price of a catch weight item cannot be adjusted on this field.
  • Price/weight: The price per weight ratio of the catch weight items. It is calculated based on: ((Total pieces x item cost)/Default weight ratio)
  • Enter new price/weight: Add a new price per weight ratio for the catch weight item on this field to adjust the price.
  • Total new price: the new total cost by item.
    • For normal items the new total price will be calculated based on: (Number of pieces x New price)
    • For catch weight items the new total price will be calculated based on: (Weight x New price/weight)

After processing the cycle count, the value from the ‘Total new price’ column will be added to the goods receipt/ goods issue document.

10.5. Serial Numbers

On the Produmex > Cycle count menu there is an option to list and remove missing serial numbers. Serial Numbers

Type
Displays the filtering conditions for the items in the list. Select the serial number type on the combo box. The following items can be listed:

  • items managed by PMX serial number with track location, but the linked LUID is no longer in stock
  • items managed by SAP serial number with track location, but the linked LUID is no longer in stock
  • items managed by PMX serial number without track location, but the batch is not in stock

Item
Filter the list by selecting an item. Only items having PMX serial numbers or SAP serial numbers with track location can be selected.

To remove serial numbers, select their line and click on the ‘Remove’ button.

implementation/wms/cycle_count.txt · Last modified: 2017/10/05 09:22 by csuhaa