Physical

This screen is for recording physical counts at the end of an inventory period.

 

If you are using Perpetual inventory, the program keeps track of your inventory on a perpetual basis, providing you with a way to view your on-hand inventory at any time.

However, it is recommended that you take an actual physical count periodically, so that you can reconcile the actual inventory with the calculated values.

About Load On Hand

This feature is available with Perpetual inventory and you must have rights in System Management: User Setup.

When to use Load On Hand

This feature is most useful for summer months when there is little or no activity, or for warehouse sites where all Receipts and Transfers are entered on a daily basis and there is no Usage.

NOTE: It calculates the On Hand quantities as of the selected Physical date based on the closed transactions that have been entered. The system cannot calculate On Hand correctly if all transactions, including Receipts and Usage, are not entered.

For Summary users, the Physical counts can be recorded periodically for exporting or reconciling with another database.

Entering and Editing a Physical

o  If a different date is entered or selected off the calendar, it will automatically be reset to the last calendar day.

Be sure to select the correct month. If you select a future date, you will get a warning but you can still enter and save your Physical.  

Sample Physical Screen

When you open the screen, if you have appropriate user rights, the Load On Hand button will be enabled.

 

Upper Grid: Physical Inventory Items

o  The On Hand is calculated for all items, up through the transaction date selected.

o  Any future transactions (after the Physical date) which have affected the On Hand are not included in the calculation.

o To reload On Hand based on a different month, select the new month and check the Date box again. You will get a dialog to re-load On Hand. Click yes to reload based on the new date.

 

Lower Grid: Browse Items

o  You can filter the list to limit the items displayed.

o  If you enter quantities in the lower grid the items will automatically be added to the upper grid.

Example: An item is stocked by the CASE, which contains (6) six CANS. 

o  If you have (3) three full cases plus (2) two extra cans, you could enter Primary Quantity as (3) three, Secondary Quantity as (2) two.

o  Or you could enter Secondary Quantity as 20, which would be the same total number of cans.

Additional Notes about Physicals – Load On Hand vs. Entering Items Manually

Closing a Physical

When you close a Physical, it does automatic Adjustments if any quantity is different from the calculated On Hand quantities and it also updates the On Hand quantities to match the quantities entered.

NOTE: Be sure you have entered and saved all other prior transactions.  After closing a physical, saving preceding transactions is not allowed. 

Example: After you close a physical dated 7/31/11, you will not be able to save any receipts or usages dated before 8/01/11.

Be sure to select the correct month. If you Update a future month, it will prevent running the Transaction Summary for the current month.   

If a physical is stuck “in process,” there was an issue with the physical and it could not be saved.  If there is an issue with the data in the current physical and it cannot be used, you will need to delete the physical and create a new one to ensure correct inventory information.

Note: You must have security rights to Close a Physical.

If you click Save Only, you can print out a copy of your Physical for review before it is updated. This may be helpful if it is a large inventory.

Value Change

Value Change will show the amount that the current Physical Count value differs from the On Hand value. If the Physical value matches the On Hand value for that date, the Value Change will be zero. (Value change is shown only with Perpetual Inventory.)

 

Save, Update On Hand and Close

Handling Incomplete Physicals

This prevents situations where two different users close the same physical simultaneously OR where a physical was interrupted before it was completed.

o   IN PROCESS means that either:

§  It has not finished yet, or

§  It failed or was interrupted before it finished

o   If you try to modify a physical that is in process, this message will display:

o  In most cases it just means that the update is running and you just need to wait a few minutes for the physical to be completed.

o  If a previous update failed, you will need to delete the physical.

o  If a site has an incomplete physical it will be highlighted in orange in the Physical Status grid. You have two options:

§  You can either wait for it to finish, or

§  Delete it from the Physicals screen

o  If you try to run Transaction Summary with an incomplete Physical, this message will display:

Printing Physicals

o None displays a list based on your Sort selection.

o Account Category groups items that are in the same Account Category and print a subtotal for each category. If an item is not assigned to an Account Category it will be listed as Undefined.