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
 
Introduction for the Inventory Setup
This is where user sets up the default Inventory General Ledger numbers.   Enter the default accounts associated with Inventory  and these numbers will be available during routine entry of data.

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:

                                    Debit                 Credit

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


 

Please note: 

You should not use the same GL Account numbers in the Inventory Setup 


That you are using within the Sales Types.  


We have had a case where a customer happen to have the same GL account for COGS - Direct Labor that was associated to a Type also loaded within the Inventory Setup Labor field.  This would causing their COGS to be $'s short.  


Also make sure that all of the Inventory Handling GL Defaults are using Overhead Cost GL Accounts instead of GL account for COGS as well.  


Article ID: 4419