Stock Ledger Report in QNE AI Cloud POS Portal Ⓙ

Overview:

Stock Ledger Report in QNE AI Cloud shows detailed movement of each stock item including Stock Transactions (Stock Opening Balance, Stock Adjustment, Stock Transfer), all Purchase Transactions (Purchase Invoices, Purchase Returns, Cash Purchases), Sales Transactions and Sales Refund. This report helps in stock tracking and audit purposes.

Scenario:

An outlet manager in Kuala Lumpur wants to investigate why stock balance is low for a certain item, for example Exterior Wall Paint (5L). He checks the Stock Ledger Report in QNE AI Cloud POS to view all transactions affecting that item.

Solution:

1. Go to Reporting > Report Center

2. From the Reports Center page, Click Stock tab to view the Stock report.

3. In the Stock tab, click ➕ to expand the Other Reports.

5. Select Stock Ledger report.

6. Select start date and end date to view. For this scenario, I will select a month period.

7. Select Stock Code. If you have specific stock code, you may directly select from here. For my scenario, I will directly search and select Exterior Wall Paint (5L).

8. It is optional for you to select the Stock Category, Group and Class. If you have selected the specific Stock Code, you may ignore these fields.

9. Next, you may proceed with selecting the Outlet. Please note that this option will filter the stock based on the location allocated for each stock during Stock, Purchase or POS transactions.

        a. Non-Location: Stock shown will not be assigned to any outlets

        b. All Location: Stock will be displayed for all existing outlets

        c. Select Specific Outlet: Stock will only display in the selected Outlet.

For this scenario, I will choose Kuala Lumpur Outlet.

10. After selecting the outlet, you also have options to view POS transactions only. By default, system will enable this function. By enabling this option, system will not display the Stock and Purchase transactions. For this scenario, I will disable it.

11. There are options to Include Zero Balance and Include Inactive Stock. By default, system will disable these options. However, you are allowed to enable if required.

12. Once you have done filtering all required information, you can click Preview to view the report in printable format.

13. The printable view will be displayed in other tab. Please note that the balance should be referred to the last row of the transactions. As from my report preview below, the last transaction was on August 15, 2025 which resulted the balance of Exterior Wall Paint (5L) to be -12 TIN(S). This help supervisor to double check and adjust the inventory.

If the report shown has more than 1 page, you are able to view the next page or even the last page by clicking on the navigation button.

You are also allowed to control the page view by clicking on the multipage toggle button. Either to view one by one page or to scroll down all pages.

If the report is too small or too large in your point of view, you may zoom in or zoom out if required.

If let’s say your manager require you to provide a hardcopy version of Stock Ledger , this page will allow you to Print the report and share it to your manager accordingly.

Meanwhile, if you require a softcopy version, you may Export the report to multiple formats based on your preferences. The most preferrable format is PDF.

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software