Preferences: Inventory
- Tatum Garino (Unlicensed)
- Emma Greenwood
- Tom Williams
The Inventory functional area is used to manage inventory balances, lot tracing, and inventory movement. The main tasks performed include maintaining the Item Master and importing and/or entering all inventory transactions. The Inventory functional area integrates with the Financial, Fisherman Accounting, Purchasing, Sales and Sales Program functional areas. The purpose of the Inventory Preference Page is to configure how these features work. From here, users can set defaults, identify which features are used, and how the enabled features perform.
Software Version: 2024.04.12 and newer
Page Header
| Toolbar Icons | Description |
|---|---|
| Excel |  Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. |
| 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.
|
| Grid Layout | Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).
|
| Help | Opens the online WIKI help page for the current page.
|
| Save | Saves all changes. |
| Fields | Description |
| Preference Name | Identifies the Preference that is being setup. |
| Value | A text box or lookup to set the value of the preference. Preference values are always editable and can be changed at any time, unless otherwise specified. |
| Preferences | Description |
| BOM | |
| Next BOM ID | A text box to assign the next ID that will assigned to a new Bill of Material record. When a new Bill of Material is added, the BOM ID is auto-assigned from this preference value and then the value is incremented by 1. This defaults to 1000 and is always required and editable. |
| BOM Rounding Precision | A text box to indicate the # of decimals for BOM Costs. This defaults to 2 and is always editable. It is required to be a whole number between 0 and 5. If not, the message "BOM Rounding Precision must be between 0 and 5." will be displayed on Save. |
| Costing | |
| General Ledger Cost | A single select lookup to assign the Cost that posts to the General Ledger. This defaults to 'Actual', is required, and can be changed to Standard. The General Ledger Cost (aka GL Cost) refers to the Cost Type (Actual or Market) that posts to the General Ledger for Inventory Items assigned with a 'Cost Type' of "Active". |
| Default | |
| Default Shipping UOM | A single select lookup to assign the default Weight Unit of Measure used for Inventory Shipments. This defaults to 'Lbs' but can be changed at any time to any "Weight" unit of measure. This field is always enabled. This lookup contains a list of all the 'Active' Weight UOM's. |
| Default Attribute Class from Item Class for new Items | A Yes/No lookup to identify if the Attribute Class should default from the Item Class for new Items. If this is set to "Yes" and there is an 'Attribute Class' assigned to the Item Class, it will default on the new item. If it is set to "No" the Attribute Class will need to be manually set for the item. |
| Default Production Batch Attribute Class | A single select standard lookup to assign a default 'Production Batch Attribute Class' to be assigned to new Inventory Items. This defaults to blank and can be changed at any time. This is typically used in companies that have different Production Batch Attributes defined for different types of items or in companies that want all Production Batches to have the same list of Attributes. This lookup contains a list of all the 'Attribute Types' assigned to the Production Batch Attribute Class. |
| Default Owner | A single select standard lookup to assign the 'Owner' that will default on new Inventory Lots. This is required and defaults to "Default Owner" but can be edited at any time. Owners are used to identify who owns the inventory. Additional Owners are typically added for companies that do custom processing and need to keep that inventory separate from their own. Owner is one of the 5 components that make up a unique Inventory Lot and it is required on all Inventory Lots. This lookup contains a list of all the Owners in the Owners master file. |
| Use the Host System's lot tracking capability | |
| Default Gross Weight from Item Setup on Transfer Transactions | A Yes/No lookup to identify whether or not Transfer transactions calculate the Gross Weight for each transfer line item or always set the Gross Weight to 0.00. The value defaults to "No" but can be changed at anytime. A value of "No" means that the 'Gross Weight' for each transfer line will be set to 0.00 and will require manual input to be updated. A value of "Yes" means that the 'Gross Weight' for each transfer line will be calculated (but can be overwritten) based on the Items "Manage Items By" property value as follows:
|
| Inventory Balances | |
| Include Sales Quote transactions in Available balances | A Yes/No lookup that identifies whether transaction lines on open (unposted) Quote transactions update Available balances of inventory. This defaults to “Yes" but can be changed at any time. Changing this preference only impacts the real-time calculation for Available balances.
|
| Include Shipped & Approved Sales Orders in On Hand balances | A Yes/No lookup that identifies whether items/lots on Sales Orders in a Status of “Shipped” or “Approved” update On Hand balances of inventory. This defaults to “No" but can be changed at any time. Changing this preference only impacts the real-time calculation for On Hand balances.
This only applies to inventory tracked line items with positive quantities. Sales Order Returns and Price Adjustment transactions never update On Hand balances until they are posted. |
| Include open Production transactions in Available balances | A Yes/No lookup that identifies whether transaction lines on open (unposted) Production transactions update Available balances of inventory. This defaults to “Yes" but can be changed at any time. Changing this preference only impacts the real-time calculation for Available balances.
|
| Include open Adjustment transactions in Available balances | A Yes/No lookup that identifies whether transaction lines on open (unposted) Adjustment transactions update Available balances of inventory. This defaults to “Yes" but can be changed at any time. Changing this preference only impacts the real-time calculation for Available balances.
|
| Include open Transfer transactions in Available balances | A Yes/No lookup that identifies whether transaction lines on open (unposted) Transfer and/or or Transfer Receipt transactions update Available balances of inventory. This defaults to “Yes" but can be changed at any time. Changing this preference only impacts the real-time calculation for Available balances.
|
| Include open non-PO Receipt transactions in Available balances | A Yes/No lookup that identifies whether transaction lines on open (unposted) Receipt transactions NOT assigned to a PO update Available balances of inventory. This defaults to “Yes" but can be changed at any time. Changing this preference only impacts the real-time calculation for Available balances.
|
| First Status to include unreceived Purchase Order quantities in Available | A single select lookup that identifies the first status to include Purchase Order quantities that have not yet been received. This defaults to "Released" but can be changed at any time. Changing this preference only impacts the real-time calculation for Available balances. When the option "Do Not Include" is selected, Purchase Orders of any status will not impact the Available balances. When a Purchase Order is in a status that is equal to or greater than this preference value, (excluding "Do Not Include" and "Closed") the quantities will show in the Committed (+) and Available columns. For example, if this preference is set to a status of "Released" and the Purchase Order is set to a value of "New" the quantities that have not been received will not show in the balances, however when the Purchase Order is saved to a status of "Released" these quantities will be visible in Available balances. When a Receipt is assigned to the Purchase Order with some of the quantities and is Posted, any remaining quantities for that Purchase Order will be displayed in the Available balances based upon the preference value and status of the Purchase Order. If all quantities have been received, the Available balances will not be impacted. The lookup contains the values "New", "Released", and "Do Not Include". Note: Closed Purchase Orders will not impact the Available balances. |
| First Status to include Production Order Inputs in Available balances | A single select lookup that identifies the first status that Input line type items are to be included in Available balances. This defaults to "Scheduled" but can be changed at any time. Changing this preference only impacts the real-time calculation for Available balances. When the option "Do Not Include" is selected, the Input line type items will not impact the Available balances. When the status of the Production Order is saved in a status that is equal to or greater than the status of this preference value the following rules apply:
The lookup contains all the values in the IMProductionOrderStatus Enumeration Class (with the exception of 'Recurring') and "Do Not Include". Note: Closed Production Orders will not impact the Available balances. |
| First Status to include Production Order Outputs in Available balances | A single select lookup that identifies the first status that Output line type items are to be included in Available balances. This defaults to "Scheduled" but can be changed at any time. Changing this preference only impacts the real-time calculation for Available balances. When the option "Do Not Include" is selected, the Output line type items will not impact the Available balances. When the status of the Production Order is saved in a status that is equal to or greater than the status of this preference value the following rules apply:
The lookup contains all the values in the IMProductionOrderStatus Enumeration Class (with the exception of 'Recurring') and "Do Not Include". Note: Closed Production Orders will not impact the Available balances. |
| Setup | |
| Require Reason Codes for all Adjustment lines | A Yes/No lookup to identify whether or not Adjustment transactions can saved to a Status of "Approved" or "Ready to Post" if they contain transaction lines without a 'Reason Code'. The value defaults to "No" but can be changed at anytime. A value of "Yes" means that every Inventory Adjustment transaction line must have a 'Reason Code' assigned. If they do not, the message "Reason Codes are required for all Adjustment transaction lines." will be displayed on Save. A value of "No" means that Inventory Adjustment transaction lines are not required to have a 'Reason Code' specified. |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.