Line ActionsPhysical Inventory sessions are available to users with the assigned security to record and verify the results of a physical inventory count for quantity tracked items within an inventory location. Existing Physical Inventory sessions can be edited by selecting them from the Outstanding Transactions heading on the WorkPlace Dashboard. Open Physical Inventory Session(s) are those that have already been created but have not yet been submitted.
Valid Item and Location combinations can only be loaded into a single open Physical Inventory session at a time. Once all lines have been entered and verified and the session has been processed, an Inventory Adjustment will be automatically created to update the Inventory and General Ledgers.
Clear
Allows the user to delete the session if it has not been processed.
Verify Select All
This option is available to mark all items within the session as verified without the need to mark each line individually. When selected, the user will be prompted to confirm 'Verify All Row(s), Are you Sure?' with options for 'OK' or 'Cancel'.
Verify Deselect All
This option is available to uncheck the Verified checkbox for all items within the session after confirming 'Verify Deselect All Row(s), Are you Sure?' with options for 'OK' or 'Cancel'.
Clicking this option will process the session and automatically create any Inventory Adjustments based on the count information provided. The Process button will only be available when the user has been provided access to the 'Physical Inventory - Process' security setting.
Count Sheet
Once a session is created, users have the option to print a Count Sheet to complete before they return to the session and record the results. This report is also available to print from the My Reports tab.
Once a session is created, a Variance Report can be printed that displays the detailed quantities on hand, counted and the associated variances. This report is also available to print from the My Reports tab.
A system generated sequential tracking number assigned to all Physical Inventory sessions as defined on the Inventory tab in System Settings.
System generated date identifying when the Release Request was created.
Name of the user who is logged in and creating the Release Request, they are the 'owner' of the session.
This read-only field displays sort order that was selected on the Physical Inventory Load window.
Displays the inventory location for the session that was selected on the Physical Inventory Load window.
Defaults to current date, may be changed if needed.
Defaults to the Document Date and may be changed if needed.
This field is displayed as read-only when Intercompany is the company selected on the Physical Inventory Load window that owns the inventory for the physical count.
Displays the specific or range (displayed as from / to) of Items selected on the Physical Inventory Load window.
Displays the specific or range (displayed as from / to) of Item Groups selected on the Physical Inventory Load window.
Displays the specific or range (displayed as from / to) of Commodity Codes selected on the Physical Inventory Load window.
To delete a line from the session, click on the Delete Checkbox and press the Save button on the Entry Toolbar. Lines can only be deleted for sessions that have not been processed.
System generated sequential number assigned to each line.
System generated sequential number assigned to each line.
Displays the quantity tracked item that is being counted.
Displays the Item Group for the Item.
Displays the Commodity Code assigned to the Item.
Displays the Unit of Measure for the Item being counted and defaults to the base unit of measure (UOM Base) setup in Item Maintenance.
Displays the total quantity On Hand for the Item.
Type in the quantity for the item that represents the actual quantity counted at the inventory location. If the Counted quantity is not equal to the On Hand quantity within the system, the session line will result in an inventory adjustment to record the variance upon processing.
If the Item on the session line is Serial or Lot tracked, the Serial/Lot Entry window will be available to enter each serial or lot number counts. The user will not be able to submit the session until the total quantities entered in the Serial/Lot Entry window match the quantity for each session line.
This is a calculated, read-only field that represents the quantity variance between what is recorded in Inventory Ledger and the actual Counted quantity. Positive variances will result in increase adjustments and negative variances will create decrease adjustments when the session is processed.
Defaults to the Document Date and may be changed by the user to record the date the Item was counted.
All lines within a Physical Inventory session need to be verified before the user will be permitted to process. The checkbox will be automatically checked when the Counted field is populated for the session line.
Line ActionsThis button becomes available on the session line or the bottom toolbar for any session line containing serial or lot tracked items. If the item on the selected line is not serial or lot tracked, the user will not be permitted to open the Serial/Lot Entry window.
