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:
- Basic Setup on the G/L Side
- Inventory Item Setup
- Labor and Overhead Setup
- Transactions Processing
- Purchasing
- Production
- Assy1,2,3
- Production Reporting
- PRA/PRW
- Assy1,2,3
- Manual Transactions
- Other Floor Transactions
- Receiving
- Shipping
- Receiving
- Purchasing
- Cost Roll Ups
- Raw Material
- Manufactured Goods
- Raw Material
- 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 ...