Stock Summary Report

The Stock Summary report displays the details of all your item’s opening stock, quantity sold (Export In Period), purchased (Import In Period), and closing stock (calculated as Opening Stock + Quantity In - Quantity Out) for a given period. This report is generated based on the accounting stock of your inventory items and can be filtered based on warehouse locations.

Inventory Analytics

Profit Rate Differences = ((Profit Rate Inventory - Default Profit Ratio ) / Default Profit Ratio) * 100

Profit Rate Inventory = [(sale price / Average Cost of Inventory) - 1] * 100 ( Calculate the selling price using the cost and profit rate)

Profit Rate Inventory = [1 - (Average Cost of Inventory / sale price)] * 100 (Calculate the selling price using the selling price and profit rate)

The report calculates the expected profit based on the purchase and sale price of the item.

Inventory = Closing Stock

Expected Profit = Amount Sold - Amount Purchased

Warranty period report

Warranty Expiry date = date of creation of delivery note + warranty (month)

To get the data for this report, first need to declare the warranty (month) for the product.

Next, Create the inventory delivery voucher and select product above.