Datasheet

Release Notes - New Features included in Release 2.4.0
Page 46 of 89
The INRD (Delete Reconciliation) transaction removes details of the selected reconciliation from
the database.
The WIMD (Inventory Management) transaction now allows the Earliest Movement Date to be
maintained. Most TROPOS stock movement transactions allow the entry of a movement date and
this date cannot be backdated beyond the Earliest Movement Date. The previous Stock
Reconciliation suite (STKRECON was run as part of TROPOS Monthly or requested via BASY)
maintains this date setting it to the reconciliation date + 1. The new stock reconciliation facility
does not automatically maintain the Earliest Movement Date. WIMD can therefore be used to
maintain the Earliest Movement Date if you use the new INSM stock reconciliation instead of
STKRECON.
The RBC7500 Inventory Valuation Report shows inventory value by stock account and by stock
category and is requested via BAPR for PBC750 or RBC7500, which can be generated
immediately.
The RBC7500 Inventory Valuation Report can also be produced by submitting BASY for
PBC750U. This program updates the Earliest Movement Date to the date entered on the BASY
request and writes the inventory values by stock account and stock category to the mbc060 table
which may be useful for report writing.
The RBC7550 Stock Reconciliation Exceptions report lists the items which incurred a discrepancy
in the specified stock reconciliation.
For more detailed information, please refer to the help text for the INSM group of transactions and
the BAFD details for RBC7500 and RBC7550.
4.2.11.3 Lot Cost changes for Consignment Stock (SR3798)
The system has been enhanced to allow changes to lot costs when consignment stock is present.
Previously the LOCC (Lot Cost Change) transaction prevented a change to the cost of a lot if some
or all of the lot was held as consignment stock. This restriction has been removed.
For items which are Actual or Weighted-average costed, LOCC continues to create journal
adjustments in respect of quantities of the lot classified as bin stock, quarantine, onsite, picked and
in-transit. LOCC does not create journal adjustments in respect of consignment stock.
The nominal ledger postings for IPCS have been modified for Actual costed items to recognise any
changes in the cost of the lot which occur after the goods are received (GROS & GRIS) and before
the stock is consumed (IPCS). IPCS posts any such cost adjustment to the account given by the
COSTCHG mnemonic.
Example:
An order is placed for 100 KG of item A at £2/KG. 50 KG is received via GROS/GRIS as lot #1.
IPCS is used to bring 20 KG into bin stock leaving 30 KG as consignment stock. LOCC is used to
change the cost of the lot from £2 to £2.50. LOCC generates an adjustment to stock, increasing
stock value by (20 * £0.50=) £10.
IPCS is then used to move the remaining 30 KG from consignment stock to bin stock. The resulting
postings are Dr Stock (30 * £2.50=) £75, Cr GRNI (30 * £2 =) £60 and Cr COSTCHG (30 * (£2.50
- £2)) = £15.