Full Usage history on rolling 25 months, including cost of sales.
Usage history is stored and is inquirable at location, warehouse,
facility and/or item level.
History is visible from its own inquiries, or from Material Status,
which now also includes a 'number of months' stock on hand' display.
Various Reports also included.
Full Receipt history on rolling 25 months. Receipt history is stored
and is inquirable at location, warehouse, facility and/or item level.
Reporting also included.
Depreciation Calculation and Reporting
Aged Inventory reports, based on either usage or receipt history,
or both. Similary aged stock reports are available. Makes monthly
depreciation entries a simple exercise.
Class Special Charge Control
New flags have been added to the Item Class Master to control whether
special charges are allowed against them, or not. The 'allow special
charges' flag is checked in Order Entry and Billing, to ensure that
only appropriate special charge codes are used.
When the accounting cost (average, standard or frozen standard cost)
is changed via Item Master, General Ledger journals are generated
to ensure that the Inventory sub-system remains in balance with
the General Ledger. An inventory transaction history is written
to record the 'before' and 'after' and to record the user details,
stock on hand, etc. Refer also the similar Costing improvements if you are running
the CST module.
Class Change Improvements
If the Item Class is changed on the Item Master, The Item Master
Maintenance program now resets all other files that hold the Item
Class separately, e.g. Purchase Order Lines (HPO).
Ledger Balancing Improvements
The General Ledger Journal Number is now recorder on the Inventory
Transaction History record (ITH) to ensure that balancing the Inventory
sub-system with the General Ledger becomes easier.
- G/L Posting enhancements
A 'Profit Center' has been added to the Transaction Effect definition,
so that a full Profit Center/Account Number General Ledger effect
combination can now be achieved.
Inventory Profit Centre' has been added to the 'Item Type Master',
so that a specific Profit Centre (Balance Sheet?) can hold the full
Inventory profit centre account. The Location Master Profit Centre
can still be used to post transactions like 'stock losses from stock
takes', so that they affect the branch which created the loss.
Ship Profit Centre' and 'Drop Ship Inventory Account' has been added
to the 'Item Type Master' to allow Drop Shipment transactions to
have a different General Ledger effect from normal Inventory Transactions.
This allows the Inventory General Ledger interface to generate a
a new General Ledger Effect - 'Freight accrual'. This posts an entry
from the new Vendor Type / Currency profit centre/accrual account
a new 'Transaction Period Open' flag to the General Ledger Period
Master. Inventory transaction posting now checks this, rather than
the 'General Ledger Period Open' flag, when validating transaction
dates. This allows you to close the accounting period, but still
process your final General Ledger journals, without having users
post transactions into the closed periods.
Rather than the standard system-wide Average, Actual or Standard
cost parameter, the costing method can be defined and run at an
item class level.
Status Inquiry Enhancements
Simple but effective - you can now 'page backwards' as well as forwards!
due dates on purchase orders
location filters, and display Location Names.
'number of months stock on hand' at all inquiry levels.
simple function key access to 'Item Notes' and 'Alternate Item'
displays. Function keys only display if 'Item Notes' or 'Alternate
Items' exist for the item.
display 'Item Status', in full colour to ensure that they are visible.
Finally a stock count function which allows you to count any time
you want, not just at month-end.
a blind count, and compares with the stock as it was when you controlled
your cut-offs. This is a six-stage process, consisting of
· count selection, including nominated warehouses, item classes,
item locations, etc.
· print count sheets (optional target quantities)
· freeze stock (which takes a snap-shot of the on hand balance,
so that you can continue processing while the count is being finalized)
· enter counts - a simple, 'no item number entry required'
quantity entry. If a new item is found, you can simply add a count
entry for it.
· Count vs. Actual report, in detail or 'variances only'
to compare what was counted with what was expected (stock on hand
when it was frozen)
· Variance Post - creates Inventory transactions for variances.
are two other optional steps;
· 'second count/recount' entry
· 'first' vs. 'second/recount' entry report, to check that
we have counted consistently
and Variances can be re-run ad infinitum, until acceptable.
The Transaction History Purge has been separated from the rollover.
This allows AS/400s with a short processing window to process the
essential month-end rollovers without holding up month-end processing
while doing the non-essential Transaction History purge processing.
The Transaction History Purge can then be run independently, at
a less pressured time.
and Receipt History is accumulated in their own 'History' files,
rather than lost, so that they can be used for more sophisticated
depreciation, usage history, stock turn and other reports.
Bulk List Price, Standard Cost Management
There is a new program which can be scheduled or can be run interactively
to automatically update your list prices, based on a desired margin.
The margin can be calculated from the current vendor quotes file,
or from the current cost.
the standard cost can be re-valued from the vendor quotes file,
based on a margin, while still keeping the General Ledger in synchronization
by passing the appropriate revaluation journals).
for both can be defined against multiple price breaks. The rounding
accuracy can be defined (i.e. number of decimal places)