Stock Flow Report
Menu Path: Accounting > Other Function > Stock Flow Report
EMP system is modulated according to the Perpetual Inventory system. Therefore, the Cost of Goods Sold (COGS) is not reflected in the Profit and Loss Statement, instead the Inventory Cost will be reflected. Therefore, the COGS is formulated in the Stock Flow Report. The Stock Flow Report calculates the COGS from the Opening Stock, Closing Stock and Reset MA.
- Select Company
- Select Date Range
- Click Generate Report Now
- Stock Flow will alert on the rounding amount error → you may refer to "Adjustment suggested due to rounding on transaction calculation"
- The details on affected transactions type will be listed when user click on the Blue amount under the row; "Adjustment suggested due to rounding on transaction calculation"
- User may key in the GL Code to where the rounding adjustment will be transferred → example: "Rounding" GL Code
- The function will be DISABLED if financial year is NOT EXISTING
example:
Financial Year IS EXISTING
Financial year IS NOT EXISTING
For Error Checking, user may perform Accounts Health Check to compare the reports
- Please refer to the excel sheet template for the data comparison (Account Health Check)
- Following is the screenshot for the Account Health Check template.
- You need to generate Historical Stock Balance Report (SBR-05) without GL Code item type→ as of financial year date
- Generate Balance sheet → base on financial year date
- Generate Stock Flow Report → base on financial year date
- ALL those reports are comparable for the inventory
- Copy the amount from Stock Flow Report, SBR-05 and Balance Sheet to the Account Health Check template and check the discrepancies
Found any amount in Difference column -> Please report to Technical Support Team
NOTES:
- The following image indicates how the calculation for COGS is performed within the Stock Flow Report and the amount will be reflected in the Profit and Loss as in Inventory Cost.
- The closing stock calculated in Stock Flow Report will be reflected in the Balance Sheet.
Related WIKI Pages:
Found 5 search result(s) for stock flow.
Private & Confidential