Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Menu Path: Accounting > Other Function > Stock Flow Report


Panel

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 Variance will be reflected. Therefore, the COGS is formulated in the Stock Flow Report.

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

Image Added

  • The Stock Flow Report calculates the COGS from the Opening Stock, Closing Stock and Reset MA.
  • The following image displays the Report table. 

Image Added

  • 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 Variance. 
  • The closing stock calculated in Stock Flow Report will be reflected in the Balance Sheet.

Image Added


Info

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.

...

Image Added


(A) To get the data

...

Image Removed

...

for SBR-05:

Menu Path: Reports > Stock Reports > Stock Balance Report > Historical Stock Balance

Image Added

  • Click on the SBR-05 Historical Stock Balance.

...

Image Added

  • Select Location,date(fill the closing & opening date),type (select all),transaction type(select all) & click generate report now.

...

Image Added

  • Now take the Balancesheet inventory amount & compare it with balance sheet & stock flow report.

Image Modified

(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 Modified

...

  • Compare it with SBR-05.

Image Removed

(C) Go to Accounting > other functions > stock flow report

  • Select company,date range & generate report now.

Image Removed

Image Removed

Image Removed

...

Image Added

  • 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