Ways to create transaction reports in Compiere ERP

In any ERP, there will transactions which will be entered across various modules including Purchase, Sales, Storage & Distribution, Inventory handling, Accounting etc

For any transactions posted to the Accounting ledgers, there has to other module level reports which will have to be matched between Accounting Reports & these module level reports

We can classify the match back of reports into 4 types

• Daily
• Weekly
• Fortnightly
• Monthly

The ERP Reports to be verified on a DAILY BASIS

• Bank Reconciliation
• Day Book Accounts (Journal/Bank/Stock/Invoices)
• Cost Factor

The ERP Reports to be verified on a WEEKLY BASIS

• Trail Balance against below reports
• Reminder Letter
• Accounts Payable
• Accounts Receivable
• Party Ledger Report

The ERP Reports to be verified on a FORTNIGHTLY BASIS

• Trail Balance against below reports
• Sales Register
• Purchase Register
• Stock Valuation Report
• Warehouse Transfer Report
• Bill of Material Production Reports
• Other Stock related Reports

The ERP Reports to be verified on a MONTHLY BASIS

• Trial Balances against below reports
• All GST Related Reports (Purchase, Sales, Purchase Return, Sales Return, RCM)
• TDS related Reports (Across various sections under Income Tax Act)