Stock Summary Report in Sage 300

By | July 31, 2014

Sage 300 ERP provides a report named Stock Status which gives detailed information about Inventory status, opening, change and closing balance etc.

We have developed a similar report named as Stock Summary, which is a statement of the stock-in-hand for a particular date. It is one of the primary inventory statements and it updates the stock record in real time as and when transactions are entered. Stock Summary provides information on stocks and shows the quantity details, rate and closing value of the stock items.

The standard report allows us to view the total change in Item quantity or cost over a period of time. Whereas our custom report allows you to view the change quantity and cost in 2 different categories i. e: Inwards and Outwards.

The report displays the stock activity showing each transaction in and out of stock for the selected period. The Stock Summary displays the flow of stock, i.e. Opening Balance, Goods Inwards, Goods Outward and Closing Balance, as shown below:

New stuff: Excise Module- Tax Configuration
The report can be filtered on from and To Posting date, Category, and Item. The report is grouped on Item category.
stock summary ui
The report shows the following data calculated as:

• For Opening Balance, Inwards, Outwards and Closing Balance, report display Item Stock UOM with Quantity.
• Quantity=It the item Quantity in Stock UOM.
• Value=It shows transaction Cost of the Item.
• Rate = (Value / Quantity) for Opening Balance, Inwards, Outwards and Closing Balance.
• Closing balance Qty/value = Opening Balance Qty/value + Inwards Qty/value – Outwards Qty/value.

The report also shows the opening and closing balance if the there are no transactions available in the selected date range.
Also, it has a filter for printing item with 0 cost and quantity. The report displays the stock activity showing Summary of all transaction in and out of stock for the selected range of date category wise item for all location.
About Us
Greytrix is a one-stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.
Greytrix has some unique solutions of Sage 300 integration 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 to Sage business partners, end users, and Sage PSG worldwide.
For more details on Sage 300 Services, please contact us at We will be glad to assist you.