VIEWING INVENTORY INFORMATION

Information about the inventory can be viewed in the various tabs under Order in inventory maintenance. The information displayed in these tabs is controlled by stored procedures attached to system settings in Inventory of the System Configuration form. These stored procedures can be modified to suite specific requirements and the changed stored procedure name attached against the relevant system setting.

• On Order - displays purchase orders raised for the part number (StoredProcForInventoryOnOrderGrid)
• On BackOrder - displays all back order records sourced from sales orders, Job cost Entry records, manufacturing requisitions and Service Manager jobs (StoredProcForInventoryOnBackOrderGrid)
• On Unprocessed Sales Orders - sales orders including deliveries and back orders not yet processed (StoredProcForInventoryOnUnprocessedSalesOrdersGrid)
• On Forward Order - sales orders with the Order Type of 'Forward Order' (StoredProcForInventoryOnForwardSalesOrdersGrid)
• On Ship Complete - sales order of the Billing Type of 'Ship Complete' that still have outstanding back orders (StoredProcForInventoryOnShipCompleteSalesOrdersGrid)
• On WIP - components that have stock allocated to Manufacturing Requisitions with the status of 'Alloc to WIP' (StoredProcForInventoryOnWIPGrid)
• O/S MR's - Bill Maintenance header records that are outstanding
• Transaction History - provides a screen display of inwards and outwards movements for a selected date range (StoredProcForInventoryForInventoryTransactionHistoryGrid). There are two stored procedures for this tab - one that is restricted to physical inventory items (usp_Jiwa_Inventory_BuildGrid_TransactionHistory) and the the other that shows transactions for non physical inventory items (usp_Jiwa_Inventory_BuildGrid_TransactionHistoryAll)

Sales information for an inventry item is avaible from the Utilities ribbon of Inventory Maintenance

Copyright © 2012 Jiwa Financials. All rights reserved.

Open topic with navigation