System Manager
General Ledger
Accounts Receivable
Accounts Payable
Currency Manager
Sales Orders
Purchase Orders
Project/Job Costing
Bill of Materials
U.S. Payroll

Learn more
View Web Help

AdaptAccounts source code accounting software for Microsoft SQL Server


Inventory Management

Multi warehouse. Inventory supports any number of warehouses. The system provides On Hand quantity and monetary values by Warehouse. When Sales Orders is installed these values are provided by Warehouse for Sales Orders Allocated and Sales Back Orders. When Purchase Orders is installed these values are provided by Warehouse for Purchase Back Orders.

Click here for a sample screen-shot for "View Product Summary".

Transaction entry. When entering transactions directly or through the other modules, you can either specify a Product by entering its Product code or simply select it from the Product table using the lookup help feature which is always available. While entering transactions you can browse through all of them and make any corrections required. Pre-posting listings are available. Transactions are not Posted until your request. You can Post an individual transaction or you can Post a group of transactions.

Transaction importing. Transactions originating externally can be easily imported. All you need to do is insert them into the Import tables for Inventory. This may be done by any SQL Server compliant process. The Import process first applies the business rules to validate the candidate transactions and identify any errors. Valid transactions are then posted to Inventory and removed from the Import tables. Invalid transactions remain in the Import tables with their errors identified so you can easily correct and resubmit them.

The entire import facility may be driven externally. The import tables can be loaded by an external process. Importing occurs using a SQL Server database stored procedure that may be invoked externally. The procedure can be called to import just a single transaction or a group of transactions or all available transactions.

Multiple Product Groups. Any number of Product Groups can be specified. For example, separate groups for Standard Products, Special Products and Parts could be set up. Products inherit the defaults for their Group. Interactive queries can also easily summarize information by Group.

Click here for a sample screen-shot for "Product maintenance".

Product Unit of Measure. The system includes Product Unit and Product Unit Conversion tables preloaded with typical units of Count, Weight, Volume, Length and Area in common, U.S., British and Metric units of measure.

Product Unit maintenance task supports local extensions and modifications. 

Unit of Stock is specified at the Product level for Inventory tracking and determines Product Unit of Measure Class.

Unit of Sale is specified at the Product level for generic Customer pricing. Unit of Sale is specified at the Product by Customer level for Customer-specific pricing and may be different from the Unit of Sale at the Product level.

Unit of Purchase is specified at the Product level for generic Supplier pricing. Unit of Purchase is specified at the Product by Supplier level for Supplier-specific pricing and may be different from Unit of Purchase at the Product level.

Allow/Disallow fractional (non-integral) units is individually specified for Inventory, Sales Orders and Purchase Orders transactions at the Product level.

Full Product movement history. All transactions are cross-referenced and are retained on-line until you archive them. Active Receipts and Issues (e.g. unapplied issues) may be viewed directly with the option to instantly view the full Product movement history. There is no limit on the number of Active and historical transactions that are maintained.

Click here for a sample screen-shot for "View Product transactions".

Simplified AccountID inheritance for Asset, Revenue and Expense Accounts. Base Asset AccountID, Revenue AccountID and Expense AccountID values are defined by Product Group and inherited by Product Group by Warehouse and are editable within the Product maintenance task. This simplifies maintaining these AccountID values while enabling them to vary by Warehouse. Transaction Product line items inherit the applicable AccountIDs based on the Product Group for the Product and the applicable Warehouse for the transaction.

Product by Warehouse. Bin Location, Minimum Quantity, ReOrder Quantity and Preferred SupplierID are specified at the Product by Warehouse level.

FIFO or LIFO Average costing. Issues are applied to Receipts on either a FIFO or LIFO basis and the FIFO or LIFO Average Cost recalculated and maintained at the Product by Warehouse level. All-Warehouse weighted Average Cost is also maintained at the Product level.

Fully integrated with Sales Orders and Purchase Orders. Direct transaction entry of Receipts, Issues and Transfer transactions is also supported. Issues generated from Sales Invoicing are reflected in Inventory together with their sale value. Receipts from Purchase Orders are reflected in Inventory together with the applicable cost data from the Purchase Order.

Easy report changes. All reports are based on a visual report designer so they can be readily changed. Additional reports may also be readily created using any of the various report designer tools for Microsoft SQL Server 2012.

Easy queries and analysis. You can use the full power of SQL Server query analysis tools to resolve even the most complex relations between Products, Customers, ShipTos, Suppliers, SalesReps, States, Countries etc.

Company   Products   Downloads   Support   Partners   Contact Us

Copyright 1995-2012 Adapta Software Inc. All rights reserved.  Legal Notices.