ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
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 Inventory Setup
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
 
Inventory Setup
Enter SQLACCTSETTING.EXE  (within the ManEx root directory)
  

This action will then prompt the user for a password 
 
The following screen will be displayed,  enter the Inventory Setup

The following screen will be displayed:
 
 
This screen is similar to the Sales-A/R and Purchases-A/P Setup screens. Enter the default accounts associated with Inventory, and these numbers will be available during routine entry of data.

If you have the Multi-Plant version of Manex, prepare defaults for each division set up previously in G/L Divisions /Departments .

Note that the accounts selected as defaults must have the class of posting in the General Ledger Account Setup screen.

 
For further detailed explanation on the variances please see Article #3053 and Article #913

It is up to the users to establish a G/L account for the Inventory Standard Cost account. This gives the user the option to have the Cost adjustment and Inventory adjustment broken out to hit two seperate G/L accounts.   If this field is left blank any transaction made from the Std Cost Adj module will default in the same GL account number as the Inventory Adjustment account, so no data will be lost if the users neglect to populate this field with a new G/L account number. 

 
Once changes have been made depress the Save button to save changes or the Abandon Changes button to abandon changes

The InStore Inventory Account should be a Liability 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.

The inventory account should be an Asset account, normally under Current Assets.  The Cost adjustment account should be an Income/Expense account, normally under Cost of Goods or Inventory Adjustments.  Asset Accounts are Balance Sheet accounts and are shown on that statement, Income/Expense accounts are on the Income statement
.

So if you have a cost adjustment to reduce inventory by $500 you are saying that you have $500 less than you should so that has to be expensed and recognized in the Profit and Loss, the transaction would be:

Cost Adjustment 500.00

Inventory 500.00

The Inventory account would be reduced by $500.00, the total of all of the inventory accounts (Raw Goods, Finished goods, etc) would be reduced by $500, the total Current Assets would be reduced by $500 and the Total Assets would be reduced by $500, Current earnings would be reduced by $500 and Total Liabilities would be reduced by $500.

On the income statement, the Cost adjustments would be increased by $500, depending what category the put the account, the sub total of that group would increase by $500, gross income would be reduced by $500 and total income would be reduced by $500.00

 
Article ID: 4422