Stock Transaction Enquiry

Initial entry into the Enquiry screen defaults through entries for the current period only for the location selected. Transaction types defaulted is Receipts, Issues, Stock Adjustments and Value Adjustments. These are the transactions which affect the Stock On Hand (SOH) for the current period.

On Hand quantity defaults through the same transaction types, Receipts, Issues, Stock Adjustments and Value Adjustments, but opens up the date range.

These two filters provide accurate quantity movement and On Hand balances but it is important not to assume accuracy of the On Hand Value from this enquiry screen. The receipt transaction is initiated in Inwards goods not the AP Invoice. This has the risk of compromising the on hand value as the receipt rate may not be the Purchase rate. Consequently the receipt rate is left out from this enquiry screen.

To find out what is still On Order and the AP Invoices processed select the appropriate button and filter. Purchase Orders must be approved before they will appear in Stock Management

View Source Document
Double click in the first column to view the source document.

• Receipt. This takes you to the appropriate Purchase Order. View transactions within the PO to see movements on the Receipts and AP Invoices.
• APInvoices. This takes you to a Read Only copy of the AP Invoice.
• Issues and Adjustments do not drill to further screens as detail is provided on this Stock Transaction screen.

Stock Transaction Report
Use the print function to run the stock transaction report detailing the transactions displayed on screen

Note:

The Stock Transaction screen is to show transactions and is not to be used as a valuation tool. In this example the receipt and the APInvoice relate to the same transaction. A listing was requested of all transactions not the On Hand transactions.

Receipt rates are not shown as the rate is not known until the APInvoice is processed. The quantity totals 30 whereas it relates to a quantity of 20.