How to retrieve Closing Stock Balance on a particular date

There are 2 ways to retrieve closing stock on a particular date :

Through Accounting Module

1. Go to Accounting → Journal and Ledger → GL Listing
2. Select Company, Date range
3. Select the "inventory" GL
4. Click Details View or Summary View

Through Inventory Module

1. Go to Report > Stock Reports > SBR-05 Historical Stock Balance
2. Refer to Inv Value based on Historical MA (A*C) column for each location→ to know the Closing Stock Balance
3. The difference between the Total of Inv Value based on Historical MA (A*C) and "inventory" GL is caused by Reset MA. 
   You can get the Reset MA amount from Inventory -> Reports -> Stock Reports -> OR-04 Stock Adjustment By Reset Moving Average
   
   

NOTES:

• Inventory GL is populated when the following transactions are done → system will calculate the INV value accordingly depend either by Transaction Price or Cost Price
  • Goods Received Note
  • Purchase Return
  • Invoice
  • Sales Return
  • Stock Adjustment
  • Trade In
  • Reset MA
• Inv Value based on Historical MA (A*C) only takes into consideration all transactions which involved Stock Quantity, either Quantity is being deducted or incremented → when user perform RESET MA, this is not being captured as no movement detected
• Inv Value based on Historical MA (A*C) might show some value (E.g: RM 10) while the Stock Balance is Zero→ due to Reset MA
  • E.g: ( Acc Inv based on Historical MA (A*C) : RM10, Reset MA : - RM10 → Total : RM0)
• Inv Value based on Historical MA (A*C) might shows negative value → due to various reasons (E.g: Back Dated Transactions)
  • E.g: (Acc Inv based on Historical MA (A*C) = RM100 - RM190 = - RM90)