Page Comparison

...

Through Accounting Module

To do this, you just need to follow the steps below :

1. Go to Accounting -> → Journal and Ledger ->GL → GL Listing
2. Select Company, Date range & click Get List button
3. Select the "inventory GL, click Select GL for Viewing" GL
4. Click Details View or Summary View

Through Inventory ModuleTo do this, you just need to follow the steps below :

1. Go to Report > Stock Reports > SBR-05 Historical Stock Balance
2. Select location, date , item code, *item category, *status, *type, *option (*OPTIONAL)
3. Refer to the Acc Inv Value(C) column
4. You need to total up the Acc Inv Value(C) column for each location, in order for you to know your
5. Refer to Inv Value based on Historical MA (A*C) column for each location→ to know the Closing Stock Balance
6. The difference between the Total of Acc 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
   

As you know, 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

As you also know, depending on the Transaction, either the Transaction Price or the Cost Price will be recorded in the Inventory GL, as shown below :

Image Removed

Thus, by using the formula above, the system is able to calculate Acc Inv Value(C).

Just for your information, when Reseting the MA, below is what happened in the Accounting side :

Image Removed

...

• 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

...

This is caused by Reset of MA. For example :

Image Removed

Thus, after step 3, you will see that your Stock Balance Quantity is actually ZERO, but your Acc Inv Value(C) will be showing RM10. However, as mentioned earlier, the difference between the Acc Inv Value(C) and inventory GL is you Reset MA value, thus,

Acc Inv Value(C) : RM10
Reset MA : - RM10
Total : RM0

This can happen in various situations, for example :

1. Back-dated Transactions

Image Removed

Thus if you generate you Historical Stock Balance report as of 2008-01-04, below is what you will see :

...

• 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)