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 has been 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. (It must be set only when using Perpetual Inventory and if it is set on the controller.)
10.4.1. Process Lost and Found
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 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 want 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 is 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).
Note: When performing a goods receipt or a goods issue, the system uses the price list set on the Cycle Count Controller.
A negative quantity means that there is not enough stock in the system. When processing this, a goods receipt is booked to add stock to the system.
A positive quantity means that there is too much stock in the system. A goods issue is booked to correct this.
After clicking the Update button, the selected rows in the grid are processed and the system informs you that the processing is done. The list is refreshed.
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.
Recommendation when using cycle count type Lost and Found:
If cycle counting during other operations is used, or cycle counting is performed while other processes (e.g. picking, production) still take place, it is recommended to regularly process the counted locations.
Example:
There is no stock in the system of ProductA. Location A1 is counted, and 10 pieces of ProductA are found. On the Lost and Found location, the stock of ProductA is -10, and on location A1 there are 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 picklist for this stock and pick the items, but if the user tries to ship the items, an error occurs because the stock is not known in SAP. The processing of the cycle count needs to be done first. A goods receipt of 10 pieces of ProductA is booked, so the stock in SAP contains 10 pieces of ProductA. The shipping of the pick list can be performed.
10.4.2. Process Registration
If there are multiple rows in the list, the 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 appear again after the list is refreshed.
It is possible to process less than the counted difference.
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 do 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).
Note: When performing a goods receipt or a goods issue, the system uses the price list set on the Cycle Count Controller.
Contrary to the cycle count type Lost and Found, 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 is booked to add stock to the system. A negative quantity means that there is too much stock in the system. A goods issue is booked to correct this.
After clicking the Update button, all rows in the grid are processed. After processing, the system informs you that the processing has been done and the list is refreshed. If there have been deleted rows, they 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 is calculated based on: (Number of pieces x New price)
- For catch weight items the new total price is calculated based on: (Weight x New price/weight)
After processing the cycle count, the value from the Total new price column is added to the goods receipt/ goods issue document.