Count
Compare/Update
Program/Screen: POCCUC/POCCUCFM
Description:
Use this program to run a report that compares the "frozen" sales item quantities (processed using Update Quantity on Hand: Item Count) to the actual physical counts entered via Physical Inventory Count Entry and shows variances. If the Allow negative sales qty field in control record AVLQTY is set to N, an error report is generated to warn of situations where updating the inventory files with the variances will result in a negative quantity on hand for some items. The report also suggests entries to make to the general ledger based on the variances. You can also use the program to update inventory records with the variances.
It is recommended that you restrict access to this program by setting
the Secure update function
field in control record POCCUR
to Y, and then
giving security code Z26
only to personnel authorized to update inventory records.
Click a link to advance to that section of the topic.
Navigation
Access this program from the Physical Inventory menu. Indicate whether you want to update inventory files with count variances or just report the variances. Choose the sort order for the report and indicate whether you only want to print items that have variances. You can include or omit specified PME (parts, merchandise, equipment) codes, and you can run the report/update for ranges of items, stock classes, vendors, bins, and item descriptions.
It is recommended
that the first time you run this report for each physical inventory
that you DO NOT update the inventory files, but only run the comparison
report. Use the comparison report to investigate large discrepancies
and determine if items need to be recounted or if transactions were
not put into the system in a timely manner. Once all counts
and variances have been confirmed, run this program again and set
Update files to Y.
Inventory files are updated, but the general ledger is not automatically
updated. Manual journal entries must be made to update the general
ledger.
Fields
Indicate whether to update inventory files during the processing of the comparison report. See the Navigation section above for more information on this setting.
Choose the order in which the report should sort.
Only Print Items with a Quantity Difference
Indicate whether you only want to see items with count variances on the report. Enter N to print all items.
Back to top
If applicable, enter the PME (parts, merchandise, equipment) code or codes that you want to include or omit in this run. If you want to run the report for all items, leave these fields blank.
If applicable, enter a range of item numbers for which you want to run the report or update inventory files.
If applicable, enter a range of stock classes for which you want to run the report or update inventory files.
If applicable, enter a range of vendor numbers for which you want to run the report or update inventory files.
If applicable, enter a range of vendor names for which you want to run the report or update inventory files.
If applicable, enter a range of bin locations for which you want to run the report or update inventory files.
If applicable, enter a range of item descriptions for which you want to run the report or update inventory files.
Function Keys
|
Function Key |
Description |
|
F1 |
Help. Place your cursor in a field and press F1 to access online help for that field. Place your cursor outside of any field, and press F1 to access online help at the program level. |
|
F3 |
Exit. Exit the page or program. |
|
F5 |
Printer Output. Advance to the Work with all Spooled Files screen where you can view a list of all of your spooled print jobs. |
|
F6 |
Messages. Advance to the Display Messages screen where you can view all of your system messages. |
|
F12 |
Cancel/Previous. Exit the program or move back a screen. |
|
F14 (Shift + F2) |
Submitted Jobs. Advance to the Work with Submitted Jobs screen where you can view a list of all of your submitted jobs. |
Related Programs
Update Quantity on Hand: Item Count
Physical Inventory Count Entry
Special Topics
Sales Item Physical Inventory Flow
Physical Inventory white paper
Back to top