Cycle Count Record View
- Janice Dannenberg (Unlicensed)
- Tom Williams
- Emma Greenwood
The Cycle Count Record View allows users to view and adjust multiple lot balances simultaneously from a list view. This feature simplifies the inventory adjustment transaction creation and therefore it is particularly useful when multiple lot balances must be adjusted.
This record view also contains columns for each Attribute that is set up for the 'Items' and 'Production Batches' attribute types. However, because these attributes are user defined, they are not included in the help documentation.
Software Version: 2021.05.21 and newer
Page Header
Header Toolbar
| Toolbar Icons | Description |
|---|---|
| Favorites |   Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.
|
| Help | Opens the online WIKI help page for the current page.
|
| Process Adjustment | Clicking this toolbar icon updates the lot balances accordingly and creates Adjustment transaction(s) for the lot(s) that were updated. The Adjustment transaction(s) can be viewed from the Inventory Transactions List View or the Transaction History inquiries. Adjustment transactions posted through the Cycle Count record view have a prefix value of "CC_" in the Reference field. Once adjustments have been successfully processed, the page reloaded with default inquiry parameters. |
| Refresh Data | Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. |
Home Tab
Search
| Search Options | Description |
|---|---|
| Balances as of | Used to select the transaction date. All transactions occurring on or before the specified date will be included. This is a date picker that is not required to return results and defaults to blank. If the date is not entered, the returned results use the current date. This date is used as the transaction date when adjustments are created. |
| Default Reason Code | Identifies the reason the balances are being adjusted. This is a single-select standard lookup that is not required to return results. It defaults as blank. This value will auto populate the Reason Code field in the grid section when actual balances have been entered. The lookup contains the following options:
|
| GL Date | Specifies the GL date for adjustments when the Process Adjustment button is clicked. This is a date picker that is required to return results. This field defaults to the current date, but it is editable. The GL Date must reside within an open fiscal period and the date must be greater than or equal to the ‘Balances as of’ date. |
| Include Lots | Used to specify the type of balances or items/lots to include. This is a multi-select standard lookup that is required to return results. It defaults as blank. This lookup contains the values in the IMIncludeInCycleCount Enumeration Class. |
| Process Adjustment As | Specifies the status of the adjustment transaction(s) to be created. This is a single-select standard lookup that is required to process adjustments. It defaults as "Posted". This lookup contains the values of "Open" and "Posted". |
| Site | Used to select one or more Sites. This is a multi-select load on demand lookup that is required to include one or more Sites in the search results. It defaults to all Sites. Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances. The lookup contains a list of all Sites. |
Attributes Tab
| Fields | Description |
|---|---|
| Attributes | The Attributes displayed are determined by the Attribute Setup and the Assign Attribute Rules. The Attributes can be setup and assigned to the transaction type in the Attributes section of the Company module (Company → Attributes → Inventory). |
| Available | This field displays whether or not the attribute is available and required. Only available attributes will be displayed with a 'Yes' followed by whether or not it is a required attribute. Required attribute values must be entered before saving the transaction as Approved or Ready to Post. |
| Value | The values in each attribute lookup are determined by the values created for the attribute, as set up in the Attributes setup in the Company module. |
Page Detail
| Toolbar Icons | Description |
|---|---|
| Column Filter Show/Hide |  Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
| Excel | Export the contents of the list view to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported. |
| Group By Show/Hide |  Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
| Quick Column Filter |  Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
| Saved Layouts |
Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
| Fields | Description |
| Actual On Hand Units | Identifies the actual On Hand units of the item at the corresponding Inventory Lot. This is a text box that is required to process an adjustment. It defaults as blank and is always editable. This field allows users to enter the correct quantity of On Hand Units for the lot. Entering a quantity and processing the adjustment updates the lot balance On Hand Units to the entered quantity. Additionally, an Adjustment transaction is created to update lot balances using a calculation of [Actual On Hand Units] - [On Hand Units]. This value is not stored in the database.
|
| Actual On Hand Weight | Identifies the actual On Hand weight of the item at the corresponding Inventory Lot. This is a text box that is required to process an adjustment. It defaults as blank and is always editable. This field allows users to enter the correct quantity of On Hand Weight for the lot. Entering a quantity and processing the adjustment updates the lot balance On Hand Weight to the entered quantity. Additionally, an Adjustment transaction is created to update lot balances using a calculation of [Actual On Hand Weight] - [On Hand Weight]. This value is not stored in the database.
|
| As Of | Identifies the cutoff transaction date to view Inventory balances that occur on and before this date. This is a non-editable textbox that is required. It defaults from the 'Balances as of' field in the 'Home' tab. When an Adjustment is processed, the value in this field will populate the Adjustment transaction's Date. This field can be changed by updating the 'Balances as of' field in the 'Home' tab and clicking the Refresh Data button in the header. Database Fields: ERPx_IMTransactionHeader.TransactionDate, ERPx_SOorderHeader.OrderDate |
| Available Units | Displays the available units of the item or lot at the corresponding site. All transactions occurring on or before the 'Balances as of' date will be included. This is a non-editable text box that is not required. The Available Units balance is calculated as [On Hand Units] + any balances from open transactions. This can be edited when units for an item on an inventory transaction has been entered or units for an item on a sales order have been committed or allocated. This is a calculated field and not stored in the database. |
| Available Weight | This field displays the available weight of the item or lot at the corresponding site. All transactions occurring on or before the 'Balances as of' date will be included. This is a non-editable text box that is not required. The Available Weight balance is calculated as [On Hand Weight] + any balances from open transactions. This can be edited when weight for an item on an inventory transaction has been entered or weight for an item on a sales order have been committed or allocated. This is a calculated field and not stored in the database. |
| Clean Out | Identifies whether or not the inventory lot should have zero balances. This is a checkbox that is not required. It defaults to unchecked and is always editable. Checking this checkbox populates "0.00" quantities to the ‘Actual On Hand Units’ and ‘Actual On Hand Weight’ fields and populates the ‘Reason Code’ field with the Default Reason Code selected in the header section. Unchecking the check box removes the quantities and Reason Code. This field is not stored in the database. |
| Is Variable Weight | Displays whether the item is configured to be variable weight.
Database Field: ERPX_IMItem.IsItemVariableWeight |
| Item: Description | Identifies the Item, displayed as Item ID: Item Description. This is a non-editable text box that is required. This defaults from the 'Item Description' field on the 'Properties' tab of the Item record view. This field is for informational use only and is never editable from this page. Database Field: ERPX_IMItem.ItemID, ERPX_IMItem.ItemDescription |
| Manage Items By | Identifies how item quantities are managed. The options include:
Database Field: ERPX_IMItem.ManageItemsByEN |
| On Hand Units | Displays the On Hand units of the item at the corresponding Site or Inventory Lot. All transactions occurring on or before the 'Balances as of' date will be included. This is a non-editable text box that is required. This can be edited when units for an item on an inventory transaction has been Posted or units for an allocated item on a sales order has been Posted. This is a calculated field and not stored in the database. This field is for informational use only and is never editable from this page. |
| On Hand Weight | Displays the On Hand weight of the item at the corresponding Site or Inventory Lot. All transactions occurring on or before the 'Balances as of' date will be included. This is a non-editable text box that is required. This can be edited when weight for an item on an inventory transaction has been Posted or weight for an allocated item on a sales order has been Posted. This is a calculated field and not stored in the database. This field is for informational use only and is never editable from this page.
|
| Production Batch | Identifies the Production Batch ID of the Lot. This is a non-editable text box that is required. This value defaults from the 'Production Batch' value specified on the Inventory transaction that created the Production Batch. This can be edited from the 'Production Batch' field on the Properties tab of the Production Batch record view. A Production Batch is the identifier that contains all the Traceability information (Production Batch Properties and Attributes) for Lot Tracked Items. This number stays attached to the product, even if it is transferred to another Site. Production Batch is one of the 5 components that make up a unique Inventory Lot and it is required when entering a transaction line for a Lot Tracked Item. This value will be blank and/or disabled for all non-Lot Tracked items on screens that include a Production Batch field. An Inventory Lot is the most granular level that item balances (quantities of Units and/or Weight) are stored within NorthScope. Inventory Lots are created for all Inventory Items assigned an Item Type of “Inventory', regardless of whether the Item is Lot Tracked (i.e., balances are maintained by Production Batch) or the Site containing the product is 'Warehouse Lot' tracked or not. An Inventory Lot is unique by combination of:
Database Field: ERPx_IMProductionLot.ProductionLotID |
| Reason | This field displays the reason why the lot is listed in the grid (All Balances are Zero, Mismatch of On-Hand Units & Weight or Negative On Hand Balance). This is a non-editable text box that is not required. The field is blank if the lot’s balance is not zero, mismatched or negative. This field is for informational use only, is not stored in the database and is never editable. |
| Reason Code | Identifies the reason the balances are being adjusted. This is a single-select standard lookup that is required to process an adjustment only when the Inventory Preference 'Require Reason Codes for all Adjustment lines’ is set to "Yes". It defaults from the 'Default Reason Code' selected on the 'Home' tab. If missing and required, the message "Reason Codes are required for all Adjustment transaction lines" will be displayed when the Process Adjustment button is clicked. This field is always editable and will be saved to the resulting Adjustment transaction. The lookup contains the following options:
Database Fields: ERPx_MFNoteTypeReasonCode.ReasonCode, ERPx_IMTransactionHeader.ReasonCodeSK |
| Site | Identifies the unique Site ID (warehouse ID) of the Site the transaction, shipment, item, or lot is associated with. This is a non-editable text box that is required. This defaults from from the 'Site' field on the 'Home' tab of the Inventory transaction or the 'Default Site' field on the 'Home' tab of the sales order transaction. This field is for informational use only and is never editable from this page. Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances. Database Fields: ERPx_MFSite.SiteID, ERPx_IMLotBalance.SiteSK |
| Unit UOM | Identifies the default inventory unit of measure that the units are stored in (boxes, Bags, Cases, Totes, etc.) for the item. This is a non-editable text box that is not required. It defaults from the 'Inventory Unit UOM' property on the 'Properties' tab of the Item record view. This field is for informational use only and is never editable from this page. A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.
Database Field: ERPX_IMItem.DefaultIMUnitUOMSK |
| UOM Schedule | Identifies the UOM Schedule that is used to determine what Units of Measure are to be used for specific items that are bought, sold and manufactured as well as the conversions for those Units of Measure. Database Field: ERPX_IMItem.UOMScheduleSK |
| Warehouse Lot | Identifies the Warehouse Lot to which the selected item or inventory lot belongs. This is a non-editable text box that is not required. It defaults from the 'Warehouse Lot' field on the Warehouse Lots list view. This field is for informational use only and is never editable from this page. A Warehouse Lot (aka Storage Lot) is used by 3rd party distribution sites to identify a unique quantity of product they are storing. Unlike a Production Batch number that never changes, Warehouse Lots will change as product is transferred to other Sites and/or transferred into exiting Warehouse Lots within the same Site. The 'Warehouse Lot' is one of the 5 components that make up a unique Inventory Lot and it is required when entering a transaction line on a transaction for a Warehouse Lot Tracked Site. This value will be blank and/or disabled for all non-Warehouse Lot Tracked Sites on screens that include a Warehouse Lot field. An Inventory Lot is the most granular level that item balances (quantities of Units and/or Weight) are stored within NorthScope. Inventory Lots are created for all Inventory Items assigned an Item Type of “Inventory', regardless of whether the Item is Lot Tracked (i.e., balances are maintained by Production Batch) or the Site containing the product is 'Warehouse Lot' tracked or not. An Inventory Lot is unique by combination of:
Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK |
| Weight UOM | Identifies the default inventory unit of measure that the weight is stored in (Lbs, Kg, Oz, Ton, etc.) for the item. This is a non-editable text box that is not required. It defaults from the 'Inventory Weight UOM' property on the 'Properties' tab of the Item record view. This field is for informational use only and is never editable from this page. A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.
Database Field: ERPX_IMItem.DefaultIMWeightUOMSK |
