Bulk
Count Compare/Update
Program/Screen: RABCUC/RABCUCFM
Description:
Use this program to run a report that compares the "frozen" bulk item quantities (processed using Save Current Quantities) to the actual physical counts entered via Bulk Count Entry and shows variances. If the Allow bulk to go negative 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 RABCUR
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. Indicate whether you only want to print items that have variances.
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 cat/class location file
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
If applicable, enter the starting category/class for which you want to compare or update count quantities.
If applicable, enter the ending category/class for which you want to compare or update count quantities.
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.
Update Category/Class Location File
Indicate whether to update inventory files during the processing of the comparison report. See the Navigation section above for more information on this setting.
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
Special Topics
Bulk Equipment Physical Inventory Flow
Physical Inventory white paper
Back to top