Inventory Status Report as of date

By | October 28, 2017

An inventory control system is a system that encompasses all aspects of managing a company’s inventories; purchasing, shipping, receiving, tracking, warehousing and storage, turnover, and reordering. The Inventory control system is maintained by every firm to manage its inventories efficiently. Sometimes it is crucial to check the status of Stocks as of date for each warehouses.

Greytrix has developed one custom report which allows user to track the Stock quantity on hand and Average cost of the stock available as of date in particular location as standard Sage 300 ERP does not does not provide this information.

New Stuff: Locate No. of Shipments in Sage 300 ERP for an Order

Kindly refer below screen shot to check filters present on report printing utility.

Inventory Status Report utility

This utility contains three filters respectively as of date selection, Item Range and Location range which allows user to select the particular criteria.

Report will get generate according to the criteria selected hence here report will get generated till date 24-10-2017 and display the Quantity on hand and average cost for item selected i.e. A1-103/0 to A1-320/0 and for location 1 to 6.

You can check below screen shot for detail record generated according to criteria selected.

IC Inventory status repiortHere you can check quantity of each item and value i.e. Average cost of each item is getting displayed for all individual location of stock item. Report is also showing Total stock balance and total Average cost.

So using this custom report it is very easy for sage 300 users to track the quantity and cost for all stock item as of date.

Note: All the updated details of inventory control will get reflect in report only after day end process is completed.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at We will be glad to assist you.