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', 'Production Batches' and 'Warehouse Lots' attribute types. However, because these attributes are user defined, they are not included in the help documentation.

Software Version: 2024.12.16 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. Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.
Help	Opens the online WIKI help page for the current page. This icon is only visible on pages that are documented in the online help.
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: Cycle Count Dump And Destroy Variable Item Correction
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	Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. 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. This field is disabled if the item is managed by Weight Only.
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. This field is disabled if the item is managed by Units Only.
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. Fixed Weight Items are Items that are packed to a specific weight. Variable weight items are Items that are packed within a targeted weight range. This is a non-editable text box that is required. It defaults from the 'Variable Weight' property 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.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: Units Only: values can only be entered for the # of Units, weight values cannot be entered and are disabled. Weight Only: values can only be entered for Weight, unit values cannot be entered and are disabled. Units & Weight: values can be entered for both Units & Weight This is a non-editable text box that is required. It defaults from the 'Manage Items By' property 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.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. The On Hand Units and On Hand Weight are always displayed with 5 decimals, but the Actual On Hand Units and/or Weight are entered with the units/weight decimals configured for the item. Use Adjustment transaction record if the units/weight must be adjusted with greater decimals than what the item properties allow.
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: Item: The Item ID (required for all Inventory Lots) Site: The Site/Warehouse that contains the inventory (required for all Inventory Lots) Production Batch: The date code or other traceability reference that stays with product and never changes. It is required for Items with a 'Lot Tracked' property of "Yes" and will be blank for Items with a 'Lot Tracked' property of "No" Warehouse Lot: The identifier or location within a Site/Warehouse, this is most typically used for 3rd party distribution sites. It is required for 'Inventory Lots' in a Warehouse Lot tracked Site and will be blank for 'Inventory Lots' in a non Warehouse Lot tracked Site. This has nothing to do with whether the Item is 'Lot Tracked' or not. Owner: Identifies who owns the product. This is required for all Inventory Lots. 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: Cycle Count Dump And Destroy Variable Item Correction 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. This field is blank if the item is managed by Weight Only. 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. This is a non-editable text box that is required. It defaults from the 'UOM Schedule' property 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.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: Item: The Item ID (required for all Inventory Lots) Site: The Site/Warehouse that contains the inventory (required for all Inventory Lots) Production Batch: The date code or other traceability reference that stays with product and never changes. It is required for Items with a 'Lot Tracked' property of "Yes" and will be blank for Items with a 'Lot Tracked' property of "No" Warehouse Lot: The identifier or location within a Site/Warehouse, this is most typically used for 3rd party distribution sites. It is required for 'Inventory Lots' in a Warehouse Lot tracked Site and will be blank for 'Inventory Lots' in a non Warehouse Lot tracked Site. This has nothing to do with whether the Item is 'Lot Tracked' or not. Owner: Identifies who owns the product. This is required for all Inventory Lots. 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. This field is blank if the item is managed by Units Only. Database Field: ERPX_IMItem.DefaultIMWeightUOMSK

Page Header

Header Toolbar

Home Tab

Search

Attributes Tab

Page Detail

Related Topics

Page Definitions

Technical Details

Browser not supported