Stock - Management and Reporting

Stock Management

Tools are available to help manage stock in addition to stock item opening stocks and adjustments, purchase orders, receipts, sales orders and despatches. These allow for finished goods to be transferred between branches, stock takes, unit cost update and global BOM cost roll ups. These tools are accessed via the Stock Management Menu:

Stock - Manage Stock - Select Tool

Stock Movements

This is used to view for a selected stock item and stock movement type the physical stock balance and movements between selected dates.

Transfer Stock

This tool is used to record the transfer of finished goods between branches if they are being used. The Stock Item is selected from the drop-down; enter the quantity to be transferred. The Source Branch is the branch the stock is being taken from. Note that manufactured finished goods are initially all stored in the Global Stock branch. Select the Destination Branch from the drop-down.

Stock Count

This is used to batch enter the results of a physical stock count. The screen can be filtered by stock type and mirrors a hard copy report that can be printed to assist the count process.

The counted physical stock figures are entered in the Revised Stock column. Click SUBMIT to record the new stock. Postings are made to the appropriate Stock Account and the Stock Value Adjustment Account in profit and loss. The accounting transactions for a stock count change use the quantity change and the current unit cost and are as follows:

Unit Cost Update

The screen is similar to the stock count screen except it is the current unit stock cost that is displayed together with a column to enter new unit costs. It is usually used when standard costs are being updated, but can be used to amend both FIFO and Average unit costs.

Click SUBMIT to record the unit costs. Postings are made to the appropriate Stock Account and the Stock Value Adjustment Account in profit and loss. The accounting transactions for a unit cost update use the cost change and the current physical stock and are as follows:

Please note that when BOM's are being used, the BOM is NOT re-costed, even though the component standard costs have been changed, until the unit the BOM is updated or the Re-Cost All BOM's process is run (see below).

Re-Cost All BOMs

When SUBMIT is clicked all BOM's are re-costed from the lowest level.

Reports

A range of stock reports exist to assist in day to day stock management as well as providing control and audit. Reports are accessed via the Reports sub-menu.

Stock - Reports
Stock Status
lists all stock items with the current quantity and unit cost and value
Stock Movement
for a selected stock item between dates shows the stock movements and balance
Stock Item Usage
for a selected stock item where it is used in BOM's
Stock Item Usage
provides a listing of any Bills of Materials in which the selected stock item is specified
Stock Variance Report
used to report variances between system stock and stock count quantities. Summarises the variances recorded between selected dates.
Unit Costs
used for unit cost updates, lists stock items within stock type showing current quantity, unit cost with space for updated costs
Costed BOM's
for a selected BOM shows the quantity and cost breakdown
PO Status
shows the status and a detail of all PO's between selected dates; can be filtered by Supplier
SO Status
shows the status and a detail of all SO's between selected dates; can be filtered by Customer, closed or open and sorted by either:
  • Sales Order Number
  • Order Date
  • Delivery Date
  • Planned Ship Date
Replenishment Planning
used to compare the available stock to the reorder level for the stock item. The Report may be filtered by stock type.
Sales Order Shipment Planning
this report lists those stock items for which there are outstanding Sales Orders and shows the demand and the current stock availability
WO Item Plan
for a selected BOM and between dates shows the history of Works Order Makings
WO Planning
this report lists those stock items for which there are outstanding Works Orders
Demand Planning
a detail report to support planning. It displays outstanding sales orders, the fulfilment plan and the planned stock position for each stock item
Stock Count
used for physical stock counts, lists stock items within stock type showing current quantity with space for counted amounts
Reconcile Goods Received Accrual
this report helps to reconcile the Goods Received Accrual account balance, identifying items where no bill has yet been recorded against the purchase order or where the amounts accrued on receipt and the amounts on the bill do not match
BOM Audit
Provides an audit trial of changes to BOM.s. The report is in two sections. Section one gives an audit trial of amendments to existing BOM's. The second section shows the audit history of the creation of new BOM's.

Related Topics