Create Stock Opening Balance in QNE AI Cloud POS Portal Ⓙ

Overview:

This article explains how to set up the Stock Opening Balance in QNE AI Cloud POS. Stock Opening Balance is used to record the initial quantity and cost of each stock item when starting a new system or outlet. It ensures that inventory records are accurate from the beginning.  

✅ Input starting stock quantity and cost  

✅ Ensure stock reports reflect correct balances  

✅ Required during first-time setup or stock take

Scenario:  

A hardware was newly opened in May, they decided to use QNE AI Cloud POS system and needs to record the quantity of items already on the shelves. The user goes to the Stock Opening Balance module and enters the quantity and unit cost for each item, such as “Exterior Wall Paint (5L)” with 20 units at RM75 each. This ensures accurate stock valuation and enables the POS to track stock movement correctly from day one.

Solution:

1. Go to Stock > Stock Opening Balance

2. Click Add button

3. Input Description for Opening Balance. For this scenario, you can describe it as “Opening Balance for June 2025”.

4. By default, the system will set the Date to be not later than your cutoff Date. The cutoff Date can be referred in your Financial Period from your Company Profile Settings. 

For example, your cutoff date was set as June, 2025. So, you need to set the Stock Opening Balance before 1 June, 2025 which can be 31^st May 2025.

5. You are optional to fill in another field such as Outlet and Ref No. For business owner that has multiple Outlets or Branches, you may choose the Outlets you required. 

6. In the Details tab, you may search and select the existing stock from the Stocks column. For example, Exterior Wall Paint (5L).

7. By default, system will automatically fill in the Qty as 1 and the base UOM of the stocks. You require to edit the stock’s Quantity manually to record the initial quantity, which is 20.

8. For the UOM, system will set as TIN(S) as this is the Base UOM for Exterior Wall Paint (5L), Unit Price will be shown as its Unit Cost and the Amount is calculated automatically based on the Qty and Unit Price.

9. You have options to add other stocks by selecting stocks in the Stocks column or click Add Lines if you required.

10. Once the details have been confirmed, you may save the record either to Save only or Save & New or Save & Close.

11. System will generate the document code which is SBOB2505/004.

12. You can view the stock movement by clicking on the Stock Journal button.

Stock Journal Preview:

13. You also have options to Edit the Stock Opening Balance if you required, by clicking on the Edit button.

14. The created Opening Balance can be previewed by clicking the Preview button.

Stock Balance Printable Preview:

You will see the difference in the report for Stock Balance before and after creating the Opening Balance. System will update the data accurately.

Stock Balance (Before): 0

Stock Balance (After): 20

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software