Transfer Physical to Book (PI19)

This program is used by the Tag Full, Tag Partial, Sheet Full, and Sheet Partial count methods (see Using Physical Inventory).

Note: We strongly recommend that a full backup be performed prior to running this program.

PI19 works with warehouse restrictions. Upon first entry to PI19, the operator's default warehouse is selected. In multi-warehouse environments, you must use the Options Menu to change your warehouse selection.

Program PI19 transfers all physical counts to book by posting an inventory adjustment in the amount of the variance units, as reported by program PI18 File vs Physical Listing.

PI19 compares the physical count units to the book units and updates the product's quantity on hand with the difference. If inventory balances were frozen then "book" units equals the product's frozen quantity on hand (captured by PI10 freeze Inventory). If inventory balances were not frozen then "book" units equals the product's current quantity on hand from the live inventory file at the time of executing PI19.

Inventory Movement records are written for the variance quantity and are reported via program IC80 Print Inventory Movement or viewed in program IC45 Display Product Availability/Movement Tab. The movement record date is equal to the date that the inventory was frozen. If inventory was not frozen, the movement record data is equal to the date that inventory was transferred to book (i.e., the date PI19 was run)

Note that once the transfer has been processed, the IC81 Print Inventory Evaluation should be run and, if desired, run IC80 Print Inventory Movement.

An option is provided that allows the user to abort the physical count. If this option is selected, all PI records and files are erased. The PI system is reset for a complete restart of the count process from the beginning; program PI01.

Upon completion of the transfer, the count areas in PI04 and the Count Transaction file are cleared for subsequent counts. Cycles defined in PI02 Maintain Cycle Master are not cleared.

Note: When processing a full count, if a product is not counted (i.e. no record exists in the Count Transaction File) but there is quantity on hand for that product, it is automatically counted as zero. Full counts look at every product in the Inventory Master even if they are outside of the defined count areas. For example: Assume full count, count sheets, for a single count area defined as bins A to ZZZZZ. Products in those bins would be reported on a count sheet and either real count records or skeleton records would exist in the Count Transaction file. But if there was a product assigned bin location 12345 and it had quantity in the system, then a full count would adjust that product's quantity to zero even though no count record existed.

Abort Physical Count

Selecting this checkbox activates a complete physical count abort. All PI records and files are erased, and the PI system is reset for a complete restart of the count process from the beginning, program PI01 Set-up Files for Physical Count. Since the complete erasure of all the count files is a serious decision, this option requires a password prior to execution. Therefore, you must have first set up the password in CC04 Maintain Override Passwords using System Code=PI, Selector Code=19, Option Number=00 and finally the password used to activate this feature. A confirmation window appears after successfully entering the password, identifying the warehouse count that is about to be aborted.

Use Live On-hand

This checkbox is only enabled if you did not freeze your inventory. In this case, the software is requesting confirmation to use live files for the count adjustments. If you normally freeze your inventory as part of the count process but have not done so this time, you may wish to exit the program to confirm that live quantities are ok to use.