<img alt="" src="https://secure.shoo5woop.com/166337.png" style="display:none;">

Product Updates

Find product updates to see what’s new with Datacor products and services

Physical Inventory Count - Updated!

November 29, 2018 by Caitlin O'Donnell

Physical Inventory Count (IC 15) has been rebuilt and is now available as a .NET program. As with the VB6 version, the purpose of this program is to allow a user to enter physical inventory counts. The new Counts grid includes additional fields - New Lot, Cost, Receipt Date and Expiration Date and a New Lot Info button. Note that as with before, a user will still need to use IC 17 to permanently apply the counts.

IC 15.NET provides enhanced functionality, greater flexibility and ease of use over its counterpart in the areas of importing counts, entering/modifying manual counts, and clearing and recovering previous counts. Before using IC 15.NET, make sure you have a Chempax version of 11/9/18 or later.

(Note: click images to view larger version.)

Starting Count Cycle

Whether you will be importing counts or using the manual entry to update counts and add new lots, the following steps are needed to start the count cycle in IC 15.NET:

    1. Use the search box to select the Warehouse, check the Tag Physical Entry box in the Primary Information section.
    2. 01_clearallcountsClick on Clear All Counts button to clear all counts. (See Ribbon Buttons section for two other clearing options.)
    3. Prepare data to be used for counting and do one of the following:
      1. Click on Load Lots button to load all applicable products and lots and zero out the quantity for each. This option will force a user to enter an amount for each lot.
      2. 02_loadlotsClick on the arrow of the Load Lots button and select Load Lots with Current Quantity.
      3. Skip this step which will result in a blank Counts grid and force users to enter all product and lot information with the counts.
    4. Review the Counts grid in the Counts section. (Note: If Step 2 is skipped, the Counts grid may show counts that have already been applied and if so, will display in red font with a date in the Date Applied column).03_counts5. As described below, either import the counts or manually enter the information directly into the Counts grid.

Importing Counts

Especially useful for large warehouses, IC 15.NET allows imported counts with new lot information. This is not available in VB6. Overview of a typical procedure might be the following:

  1. 04_exporttemplateClick on Export Template button and save file. This will export any data from the Counts grid to Excel.
  2. Update the spreadsheet.
    1. If  you chose options 3a or 3b for Load Lots in the Starting Count Cycle section, enter Amount and update Amount UM, if needed, for each lot. (Note if applied lots were exported and the Amount was changed in Excel, the lot status will change to unapplied on the import.)
    2. If you chose option 3c  for Load Lots in the Starting Count Cycle section, manually enter all data. The columns with red headings are required.
    3. If a new lot number was entered, also enter New Lot Measure, New Lot UM and New Lot UP fields for the new lot (but not Lot Packaging). Optionally, enter New Lot Cost, Receipt Date and Expiration Date. Save and close file.05_newlot
  3. 06_importtemplateClick Import from Template button to import records for the selected warehouse and review status on IC15 toolbar for errors. Any new entries will also be highlighted on the Counts grid making it easier to determine which records need to be reviewed. If any records with applied counts were updated, the lot status will change to unapplied and will display in black font.07_ribbonchart
  4. Verify changes and then click Apply Changes button or Cancel Import.08_cancelapplychanges
  5. If the import was completed, the updated information will show in the Counts grid.09_countsgrid
  6. New Lot field will be checked for all records with new lot information and if any are checked, the New Lot Info button will also be enabled to make additional changes, if needed. (This is described below.)10_newlotfield

Manual Counts

The new Counts grid has two advantages over the VB6 counterpart:

  • Each record loads in either black or red font making it easy to identify which lots have counts already applied in the database and
  • Provides the ability to make changes to existing records as well as add new records directly on the grid.
When a count for the same lot consists of quantities with different UMs, Chempax allows you to enter each amount per UM and then quickly converts to the final sum. The Counts grid is very flexible when reviewing and updating counts. The input is also faster because Chempax validates each record and will only display a message if a record is not valid (as opposed to in VB6, confirming each successful record.)

A typical manual entry for existing records in the Counts grid might be the following:

  1. In Update mode, enter a new Amount and Amount UM on all applicable records that appear in the Counts grid. If the change is on a lot with applied counts (red font and applied date) then the lot status will become unapplied.
  2. For lots that have quantity in different UMs, click on plussignin the Amount field to display the Amount drop down box. 11a_UM
    1. Enter the quantity in Add Qty and select the corresponding UM.
    2. 11b_UMClick Add to enter additional quantity with corresponding UM.
    3. Review Current Qty and corresponding UM. Current Qty should reflect the converted amount if different UMs were used. Click OK to save the new Amount or Cancel to close and revert to the original amount.
    4. For any records in which New Lot is checked, click on the New Lot Info button to open the Edit New Lot Info window. All the fields can be updated except Lot Number, if needed. Measure, UM and UP are the only required fields.12a_newlotinfo
  3. To add new product/lot records in the Counts grid:
    1. In Update mode, click on the Product field of the last row marked by a ‘*’
    2. Enter product name or number or use the arrow to scroll and double click on the product from the list.13_newprodrecord
    3. Checkmark the New Lot box (if applicable). In the Edit New Lot info window, enter Lot Number, Measure, UM, UP and Cost for the new lot. The other fields - Receipt Date and Expiration Date are optional. These fields cannot be updated directly in the grid. Click Finish (to save information) or Cancel.
    4. Enter a new Lot number or select an existing one from the search box.
    5. Enter Amount as described above and change the Amount UM, if needed
    6. Note Tag # is required if Tag Physical Entry had been checked in the first step. If it is not checked, this field will not display in the Counts grid.
  4. To delete records, in Update mode, click on the record to highlight and then Delete key on your keyboard.

Restoring Cleared Counts

In VB6, there is only one way to clear a count and a different program, EX 27, is needed to restore the last saved count. This functionally has been greatly enhanced. With IC 15.NET, there are three different ways to clear a count using the Clear All Counts button and with each one, Chempax maintains a copy of all cleared counts. This sets up the user for a much easier restore process.

  1. Use the search box to select the Warehouse in the search box and if using tags, check the Tag Physical Entry box in the Primary Information section.
  2. 19_restoreappliedcountsIf counts need to be reviewed but have been deleted from the Counts grid, click on the arrow of the Restore Applied Counts button and select the Restore Deleted Counts option. The Restore Counts window will display all counts that were cleared at the same time grouped by time and date. Click on the set of counts that need to be restored and Restore or Exit (to cancel the restore).15_restorecountsgrid
  3. Review the Counts grid.
  4. Follow the steps above to finish the process.

Ribbon Buttons

Four of the Ribbon buttons have additional options accessed from the arrow on each button.

    1. 16_toolbar_loadlotsLoad Lots - The arrow provides two options: Load Lots with Current Quantity and Load Lots with Zero Quantity (default). Press the button for the default. If ICPHYSICALWITHQUANT custom option is turned on, the default changes to Load Lots with Current Quantity.
    2. 17_toolbar_exporttempExport Template – The arrow provides two options: Export All Visible Rows (default) and Export Blank Template. The latter option just exports the column headings without any data. Note this button and options are available for all .net grids.)18_toolbar_clearall
  1. Clear All Counts - The arrow provides two options: Clear Applied Counts and Clear with Zero Quantity. A third option is the button itself which clears ALL counts.
  2. 14_restoreappliedcountsRestore Applied Counts - Press the button to unapply all counts on the Counts grid (those records that display in red with a Date Applied). The arrow on this button provides a second option Restore Delete Counts which as described above, opens a Restore Counts window listing ALL 
    previous counts that were cleared at the same time and date.
** A new version of Physical Inventory for scan guns is now available. Contact your primary support representative for more information.**

Topics: Inventory Management, Datacor ERP, Datacor ERP VB

Written by Caitlin O'Donnell


See how our software delivers data with depth.

Contact Us

Datacor offers products and services designed specifically for process manufacturers and chemical distributors. Contact us to learn more about our products and services. Call us now at (973) 822-1551 or fill out the form to the right.