|
Printable
Version PDF (Requires Adobe Reader)
Inventory Reporting-Database
Dual Entry Inventory & Reporting System
Inventory Reporting
Minimum System Requirements
Microsoft Windows 2003 Server
Microsoft SQL Server 2000
Dearman’s Inventory-Reporting Database is a fully functional dual entry
inventory system, providing a robust & flexible solution for your complex
inventory and reporting specifications.
With this databse you can consolidate all transactions from one or many
Terminal Automation Systems such as our
TAS.netTM, as well as many non-automated systems such as barge
and ship terminals.
Manual transactions can be added, deleted or modified directly to the
Inventory Database as needed while the imported transactions can be modified in
source system as needed. Product, Tank/Carrier, Ownership, and Terminal
tracking of transactions on both the source and target sides provide the
foundation for a comprehensive reporting system.
A full audit trail is created.
Key Features & Benefits
Designed specifically for the bulk liquids distribution
industy:
Scenarios such as several products, owned by several position
holders, moved by several different carriers to several different locations can
be traced completely.
Easily handles complex blending recipes.
Inventory positions provided from any point in time to
another point in time without need of fixed time of day close.
Physical and book amounts of the products in the facility.
Physical and book amounts of the products in the facility.
Static line-fills (piping and hardware associated with
storage location).
Dynamic line-fill for last product received or shipped.
Automatic and/or manual data collection:
Terminal Automation Systems such as our TAS.netTM(or
any others that provide an ODBC interface) can mirror transaction data directly
to our Inventory Database or the data can be uploaded by a comparison update.
Shipments, receipts, transfers and adjustments automatically
collected at the terminal. Manual changes or entries are made at the terminal
to balance and account for the terminal activity then they are all transferred
automatically to the inventory database.
Automated level gauging systems are fully supported. Manual
changes or entries are made at the terminal as needed or they can be adjusted
directly in the Inventory Database.
Entity data collected from automation system, other source
system and/or maintained in the inventory system. Entity data is shared
directly with ExSTARS reporting system.
Standardized entity data such as product, product group,
supplier, position holder, exchanger, destination and carrier makes for error
free data entry.
Accounting:
Stores inventory transactions by type, reason, product,
ownership, location and carrier, terminal, gross volume, net (corrected
volume), mass and time.
Volume and mass freely translates between units-of-measure
without accumulating rounding errors.
Modified transactions are reversed and replaced for audit
trail.
Memo transactions allow location and ownership volumes/masses
to be recorded at will.
Complete flexibility allowed with standard accounting journal
structure for transactions with journal header used for order/BOL/ticket
information. Journal key used to standardize all entity data.
Reports:
Standard Daily Inventory Report, Daily Ownership Report, and
Daily Gauge Report are usual reports but there are a wide variety of reports
available, which can be created upon request.
Comparisons and detailed transaction summaries and listings
for reconciling, balancing and analyzing are included.
Reporting data cube which uses inventory database as source
of data is available which allows the monthly data to be sliced and diced in
multiple ways with very fast output.
Partner terminal and carrier reports are available.
All reports are MS Excel workbooks with various save/send
options available.
|