Tips and Tricks for Proper Inventory Control

Tips and Tricks for Proper Inventory Control




Tips and Tricks for Proper Inventory Control – GL/Perpetual 


Summary:  This document explains how to help keep the Perpetual Inventory and G/L Accounts in balance when using Standard Costing or Actual Costing* in EIQ.   Many things can cause the G/L to drift out of balance from the Perpetual,  incorrect G/L setups, incorrect transactions in the system and not processing PIT transactions in a timely basis.  



Key Areas Covered:

  1. Basic Setup on the G/L Side 
  2. Inventory Item Setup
  3. Labor and Overhead Setup
  4. Transactions Processing
    1. Purchasing
    2. Production
      1. Assy1,2,3 
      2. Production Reporting
      3. PRA/PRW

    3. Manual Transactions
    4. Other Floor Transactions
      1. Receiving
      2. Shipping

  5. Cost Roll Ups
    1. Raw Material
    2. Manufactured Goods

  6. Good Practices






    • Related Articles

    • Comparing Perpetual On Hand to the General Ledger Inventory Accounts

      ​ ​ Comparing Perpetual On Hand to the General Ledger Inventory Accounts The procedure for comparing the perpetual on hand at standard cost to the general ledger inventory accounts should be as follows: Process ALL Post Inventory Transaction Types  ...
    • GL Account Setup for Standard Costing

      ​ ​ G/L Account Required for Standard Costing & PIT Summary This document helps explain some of the common accounts that are required for using EIQ in a Standard Costing environment when the transactions will be journalized.   Note that some of these ...
    • GL Account Setup for Standard Costing

      ​ ​ G/L Account Required for Standard Costing & PIT Summary This document helps explain some of the common accounts that are required for using EIQ in a Standard Costing environment when the transactions will be journalized.   Note that some of these ...
    • Main Reports to use for Month End Accounting Close

      ​ ​ Main Reports to use for Month End Accounting Close Account Receivable – Accounts Receivable Aging – Any Period – AR Invoice  Accounts Payable   --  Accounts Payable Aging – Any Period  -- AP Invoice  Accrued Receipts --  Accrued Receipts As of ...
    • Things to look at for PIT

      ​ ​ Comparing Perpetual On Hand to the General Ledger Inventory Accounts The procedure for comparing the perpetual on hand at standard cost to the general ledger inventory accounts should be as follows: Process ALL Post Inventory Transaction Types  ...