Page Comparison

...

• Select the fields company date range & click on Generate Report Now.

Image Removed

...

Image Removed

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

...

Image Added

• Select Company
• Select Date Range
• Click Generate Report Now

Image Added

• Stock Flow will alert on the rounding amount error → you may refer to "Adjustment suggested due to rounding on transaction calculation"

Image Added

• 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

Image Added

Image Added

Financial year IS NOT EXISTING

Image Added

Image Added

Info

For Error Checking, user may perform Accounts Health Check to compare the reports. 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. (A) To get the data for SBR-05: Menu Path: Reports > Stock Reports > Stock Balance Report > Historical Stock Balance Image Removed Click on the SBR-05 Historical Stock Balance. Image Removed Select Location,date(fill the closing & opening date),type (select all),transaction type(select all) & click generate report now. Image Removed Now take the SBR-05 inventory amount & compare it with balance sheet & stock flow report. Image Removed (B) To get data for Balance Sheet:  Accounting > Financial statement > Balance Sheet  Select the Company, fill the Date for opening & closing. Click on Generate Report: Image RemovedImage Removed You need to generate Historical Stock Balance Report (SBR-05) without GL Code item type→ as of financial year date Image Added Image Added Generate Balance sheet → base on financial year date Image Added Generate Stock Flow Report → base on financial year date Image Added 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.

Image Added

Related WIKI Pages: