Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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, 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: 20232024.1103.3029 and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Excel
Insert excerpt
Excel - Global (old)
Excel - Global (old)
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Save
Insert excerpt
Save - Global
Save - Global
nopaneltrue
FieldsDescription
Preference NameIdentifies 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. 
PreferencesDescription
BOM
Next BOM IDA 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 PrecisionA 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.

Insert excerpt
Def - Cost - General Ledger
Def - Cost - General Ledger
nopaneltrue

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 ItemsA 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.

Insert excerpt
Def - Owner
Def - Owner
nopaneltrue

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:

  • Units and Weight: ( [Total Item Net Weight] + ( [#of Units] * [Unit Tare Weight] ) )
  • Weight Only: Not calculated, set to 0.000
  • Units Only: Not calculated, set to 0.000
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.

  • A value of “No” means that items and lots on these open transactions will not be included when calculating Available balances.
  • A value of “Yes” means that items and lots on these open transactions will be included when calculating 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. 

  • A value of “No” means that the inventory on Sales Orders will not update On Hand Balances until the transaction Status is changed to “Ready to Post”.
  • A value of “Yes” means that the inventory on Sales Orders will update On Hand Balances once the transaction Status has been updated to “Shipped” or “Approved”.

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 Adjustment Production transactions in Available balances

A Yes/No lookup that identifies whether transaction lines on open (unposted) Adjustment 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.

  • A value of “No” means that items and lots on these open transactions will not be included when calculating Available balances. This also means the items and lots on these transactions will not be included in Committed and/or Allocated columns on Inventory inquiries.
  • A value of “Yes” means that items and lots on these open transactions will be included when calculating Available balances.
Include open Receipts Adjustment transactions in Available balances

A Yes/No lookup that identifies whether transaction lines on open (unposted) Receipt 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.

  • A value of “No” means that items and lots on these open transactions will not be included when calculating Available balances. This also means the items and lots on these transactions will not be included in Committed and/or Allocated columns on Inventory inquiries.
  • A value of “Yes” means that items and lots on these open transactions will be included when calculating 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.

  • A value of “No” means that items and lots on these open transactions will not be included when calculating Available balances. This also means the items and lots on these transactions will not be included in Committed and/or Allocated columns on Inventory inquiries.
  • A value of “Yes” means that items and lots on these open transactions will be included when calculating Available balances.
Include open Production non-PO Receipt  transactions in Available balances

A Yes/No lookup that identifies whether transaction lines on open (unposted) Production 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.

  • A value of “No” means that items and lots on these open transactions will not be included when calculating Available balances. This also means the items and lots on these transactions will not be included in Committed and/or Allocated columns on Inventory inquiries.
  • A value of “Yes” means that items and lots on these open transactions will be included when calculating 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. 

Include Quote transactions

The lookup contains the values "New", "Released", and "Do Not Include". 

Coming soon! This feature is not implemented yet.

First Status to include Production Order Inputs in Available balances

A Yes/No single select lookup that identifies whether transaction lines on open (unposted) Quote transactions update Available balances of inventory.  This defaults to “Yes" but 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  Changing this preference only impacts the real-time calculation for Available balances.

  • A value of “No” means that items and lots on these open transactions will not be included when calculating Available balances.
  • A value of “Yes” means that items and lots on these open transactions will be included when calculating Available balances

      When the option "Do Not Include" is selected, the Input line type items will not impact the Available balances. 

    The lookup contains all the values in the IMProductionOrderStatus Enumeration Class and "Do Not Include". 

    Coming soon! This feature is not implemented yet.

    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. 

    The lookup contains all the values in the IMProductionOrderStatus Enumeration Class and "Do Not Include". 

    Coming soon! This feature is not implemented yet.

    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.

    ...