Inventory Processing Guide Overview
 
The Integral Accounting Enterprise system has a very comprehensive inventory system that can support organizations of all sizes. All inventory is stored in bins, and each warehouse can have an unlimited number of bins, and each company can have an unlimited number of warehouses.
Please review the screens in the "Inv" tab in the demo system for more Inventory related functions and screens.

Posting Overview
All of the posting within the Integral Accounting Enterprise Application is done through the use of stored procedures. The stored procedures are passed accounting documents and are then reviewed by the posting procedures to make sure all of the data necessary is accounted for and then the procedure updates the proper accounts in the system.
Stored procedures within the system are designed to be as autonomous as possible, so the same procedures that are called right after a user enters an order for example can also be used, for example, to post EDI Documents automatically without user intervention.

Inventory by Warehouse Table
The central location for all item inventory information is the Inventory By Warehouse table. It is very important that you take the utmost care and test a lot when you adjust any code that affects this table or your systems inventory can be adversely affected.

Inventory Costing
Integral Accounting Enterprise handles FIFO, LIFO, and Average costing methods.You are allowed to select one of these costing methods as the default costing method of your inventory.
Most companies use FIFO costing to manage their inventory. Our system tracks all three inventory costs per item, but only posts the costing you select as your default to the General Ledger.
Of course, we store all of the Order Information, Invoice information, and all of the Purchase Order Information in the system, so you can implement any kind of costing method you like if these three regular methods don't appeal to you.

Defining Inventory Costing in the system
You can set the system's default costing method in the "Companies" table. The field that holds the value is "DefaultInventoryCostingMethod" and the values for the field are "F" for FIFO (System Default), "L" for LIFO, and "A" for Average. "O", "E", and "C" are reserved for future use, but you can use any other letter to define custom costing methods within the system.
 Costing is calculated using the InventoryLedger table in the system. This table is updated with every inventory transaction and all proper related costs are updated as well.

Inventory Serial Number Processing
The Integral Accounting Enterprise System supports serialized inventory and lot numbers.