Stock Reports

No

Report name

Description

1

Stock Sales Report

This report could be used to generate each and every detail sales records drill down to the item level. As the report is by default sorted by item code, users would be able to compare the selling price and margin for each of the product by different salesman, and time/date.

This report include all sales and sales return.

The flexible filters above to filter by salesman, product code, date range makes it useful for the report to answer questions such as:

a) How much gross profit does salesman A make in a month, and give me the details of every product he/she sold.

b) I would like to know the gross profit we made in selling product ABC for the last 6 months

Limitations:

Since the gross profit is calculated based on per item basis, audit to check for selling below cost for certain products or by certain salesman could not be effective if invoicing or cash bills are created based on package price.

2

Stock Purchase Report

Similar to stock sales report, stock purchase report display the detailed purchases and purchase returns. This report is especially useful in analyzing the trend of the stock prices.  When a purchase is done on a specific item higher than its average cost, the report use green color to show that the price is rising, or that specific purchase is higher than normal (investigation may be needed). On the other hand, if the purchase is lower than the average cost, the system will show it as red color.

For volatile stock prices, this report could be useful for merchandisers to adjust the selling price of the stock accordingly.

3

Historical Stock Balance Report

Historical stock balance report display the stock balance quantity as of any date at a specific point in time in the past. Please note that the cost of stock display is based on current cost (not the average cost at that point of time), because it would require too much re-calculation or too much storage to take a snap shop of every item in every location.

Hence, it is important to note that for audit or record purposes, it is important for the users to generate the stock balance report on the day of closing for a specific financial period.

Sometimes, if negative quantity is detected, this could be caused by the back dated transactions.

4

Stock Balance By Location

This report shows the stock balance quantity at a specific location. Users could filter by category, and the costing is based on current average cost.

5

Stock Ageing Report

Stock Ageing Report shows the break down of the stock balance base on the number of days the stock has been purchased. System uses first in first out method, multiply by the purchase cost to display the balance quantity and total amount of the stock in each of the basket.

6

Stock Adjustment By Reset Moving Average

Stock adjustment by resetting moving average cost are normally done for the following reasons:

a) Adjust according to the market price

b) Price protection from the principals

c) Convert marketing funds from the principal to reduce the stock cost

d) Incorporate special supplier rebate into stock pricing

e) Capitalize import duties, taxes and other transportation charges to increase the stock cost.

By recording the "reason" field properly when performing the "Reset MA", users will be able to generate meaningful stock adjustment report for various purposes.

7

Item Code Stock Movement Report

This report provides user an overall summary of all stock movement within a specific period of time. With this report, users could look at all purchases, purchase returns, sales, sales returns, stock transfer in / out, cost of goods etc item by item.

8

Trade In Report

This is just a simple report displaying all trade in done based on locations.

9

Stock Movement Details By GRN Report

When requesting for the management to pay for supplier invoices, very often, the management would like to see the sell thru of the goods, for various reasons. Goods that does not have good sell through may be swapped with other products from the suppliers, or procurement department could negotiate for better price in the next batch of purchases

10

Stock Balance Summary Group By Extended Category

This is a normal stock balance report, users could group the products or items by extended category for easy viewing.

11

Stock Balance with Selling Price Report

12

Stock Purchase with PO Details Report