Looking Up Stock Transactions

Use the I/C Stock Transactions Inquiry screen to view opening and closing costs for a fiscal period, and to view transactions that result in movement of inventory items.

To look up stock transactions:

1. Open Inventory Control > I/C Statistics and Inquiries > Stock Transactions Inquiry.
2. Select a year and period.

   Note: The opening and closing costs that appear in the table are calculated from the start of the year up to the period you specify.

3. Specify a range of item numbers, account sets, and locations to include in the inquiry.

   Note: The Quantity and Average Cost columns appear in the table only if you specify a single item (by specifying the same item number in the From and To fields).

4. Click the Refresh button to view documents that match the criteria you specified.

   The table displays opening and closing costs as at the year and period you selected (calculated from the start of the year up to the period you specify). It also displays information about transactions for the period, such as receipts, returns, sales, adjustments, transfers, assemblies, and internal usage transactions.

   Note: The Total Cost column appears for all inquiries. The Quantity and Average Cost columns appear in the table only if you specify a single item (by specifying the same item number in the From and To fields).

5. If you want to open the I/C Stock Transactions Inquiry Detail screen and view a list of transactions that include an item (such as Purchase Orders receipts, or Order Entry shipments and invoices):
   1. Select a row, and then click Details.
   2. On the I/C Stock Transactions Inquiry Detail screen, if you want to view information about a transaction in a transaction entry screen, select a row, and then click (the Edit button).
   3. Close the screen to return to the I/C Stock Transactions Inquiry screen.

Published: September 11, 2020
© 2020 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks