This article will provide an overview of the Physical Count screen in EMDECS.
Video Walkthrough
Create a New Physical Count
1. Open the Parts menu and select Physical Count.
2. The Physical Count screen lists any open counts that have not yet been posted. To continue with an existing physical count, click on the count number.
If you have multiple inventory warehouses, ensure that the correct Warehouse is selected from the drop-down list. Each physical count is tied to a specific inventory warehouse.
3. To create a new physical count, click on +Add New Count in the top right corner of the screen
4. Select the inventory Warehouse where the count is being performed, then click OK.
5. A unique physical count number will be generated and displayed at the top left-hand corner. In the top pane, a Part Location, Part Number, and Quantity can be entered to be added to the count. This is one way you can manually add the parts and their on-hand values to the count.
6. A second way to add parts to the physical count is by using a barcode scanner. Click on the Barcode Icon. In scan method mode, EMDECS will recognize locations and part numbers entered using your barcode scanner.
7. To set a location for the parts being counted, click on Set Count Location, then enter the Store Room, Row, Shelf, and/or Bin numbers and click the Set Count Location button to save the location.
8. Once the count location is set, start typing in the Part Number being counted. EMDECS will search automatically and display results in a drop-down list. Click on the Part Number.
9. Enter the Quantity of parts counted and click Count.
10. Now you can see the counted part is added to the physical count part list below.
11. To change the part Count Location, click on the red X icon. Then you can select a new location to continue with your count.
Generate List of Parts to Count
1. Alternatively, instead of entering Part Locations and Part Numbers as you move around your warehouse counting them, you can generate a list of parts to be counted, count and record the quantities on paper, then return to the computer later to complete your data entry. Click on Generate List of Parts.
2. The list of parts can be generated based on the Part Location, Count Cycle, Product Group, Inventory Class and Line, or the Preferred Vendor, and can be sorted by up to three different options. Users may also choose options on the right-hand side to include parts based on the Active status, Stock status, and Transaction History.
3. For example, options can be selected to sort alphabetically by part number and product group, then click Generate to create the list to count.
Note: You can generate the list multiple times to add more parts while choosing different filter options
In the example below, the generated list of parts has been added with the default count set to 0:
5. Once you're finished generating your list of parts, you can click on Print Count Sheet.
6. You have the option to Show Prior OnHands or to Hide Prior OnHands. Once you've chosen, click Print.
This will open a PDF of the count sheet which you can print on paper. As you go through your inventory, you can write down all the values on the paper and then go to EMDECS later on to fill in the values.
UPC Barcode
1. To associate a part with a third party vendor UPC barcode, click on Add UPC Barcode.
2. Scan the barcode with a barcode scanner, enter a Quantity of parts in the package, and click OK to save.
Post Physical Count
1. After all part counts have been entered, click on Post. If you need to step away and come back later, you can click Save/Exit and pick up where you left off later.
2. To finalize and Post the physical count, select an Effective Date and time and click Post to finalize the count. Here you have the option decide what happens to blanks in the count sheet, you can:
Ignore Blank Counts: This will leave the count to the on hand that was present before
Zero Out Blank Counts: This sets the blank counts as 0
Note: Before selecting Zero Out Blank Counts be sure that you want to 0 out the counts, once closed the PC cannot be opened or reversed.
Once Post is clicked the on-hand values will update based on the effective date.
History Tab
1. From the History tab, users can review previous physical counts. Click on any Count # to drill down.
2. The pop-up will display the details of the posted count. If you click on the Print button, this will open a PDF to see the posted count report.