ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon Prerequisites & Introduction
DrillDown Icon Access Levels
DrillDown Icon General Ledger
DrillDown Icon A/R-A/P Setup
DrillDown Icon Bank Setup
DrillDown Icon Inventory Setup
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To ..........
DrillDown Icon FAQs - Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Fields & Definitons for the Inventory Setup
 
 
Instore Inventory Account This G/L account is used if a Supplier has inventory stored at your site but title to that inventory has not yet passed.  ManEx strongly suggests setting this up as a Liablility Account.  The IPS inventory does not carry any value until pulled to a kit. This is why it needs to be a Liability GL account. Because at the time you pull the inventory to a Kit, is the first time a transaction is created in the system and at that point in time the IPS stock that you issued to the kit becomes a liability that you owe to the Supplier per contract.  See Article #3268 for further detail.
Raw Material Inventory This G/L account is used for inventory purchases.
Work in process inventory This G/L account is used for all components once the kit has been issued until the final assembly reaches the Finished Goods Inventory Work Center.
Unreconciled Receipt This G/L account is used for all purchase orders that have been received but not reconciled and/or transfered to Accounting.  
Finished Goods Inventory This G/L account represents a completed assembly – ready to ship.
Labor This G/L account is for labor configuration when product is transferred into FGI.
Overhead This G/L account is for overhead configuration when product is transferred into FGI.
Other Costs This G/L account is for other costs configuration when product is transferred into FGI.
User Defined This G/L account is for user defined configuration when product is transferred into FGI.
Purchasing Variance This G/L account is where the Purchase Order Price differs from the Standard Cost per the Inventory Master. Indicate the General Ledger account where you want the differences posted.  The Purchase Price Variance is a Balance Sheet account classified under Inventory, Raw Materials.
Configuration Variance Account This G/L account is where the sum of the components listed in the Bill of Materials is not equal to the Standard Cost per the Inventory Master for the Product. Indicate the General Ledger account where you want the differences posted.
Manufacturing Variance Account
This G/L account is where more components are used in the assembly than called for in the Bill of Materials. Indicate the General Ledger account where you want the differences posted.
Shrinkage/Scrap Account This G/L account is the account you want to use when items have to be scrapped or they were shop worn, broken, etc.
Rounding Variance Account This G/L account is would be the difference between the standard cost calculation and the actual kit issuance.  Note that the Rounding Variance for any given component cannot exceed the standard cost of the component, because the rounding would bring the component to the next higher quantity.  This variance may seem small (non-existent in the case of large lots) but does add up over time to significant values.  This field MUST be setup before the users can close a Kit.   
Inventory Adjustment Account
This G/L account gathers information from the Cycle Count, and Physical Inventory modules. The values entered are the offsets of the values actually made to inventory accounts.  When user changes the value of inventory by adding or removing value (by change in inventory counts), we have to record the other side of that transaction somewhere, and it goes to this account 
Inventory Standard Cost Account This G/L account gathers infomation from the Std Cost Adj module. When user changes the value of inventory by adding or removing value (by change in standard cost), we have to record the other side of that transaction somewhere, and it goes to this account.  If this field is left blank any transaction made from the Std Cost Adj module will default in the same GL account number that is already used within the Inventory Adjustment account so no data will be lost if the users neglect to populate this field with a new GL account number. 
 
For further detailed explanation on the variances please see Article #3053 and Article #913   
 
 
 
Article ID: 4420