Purpose

Report Classes and their Reports:

Customer

• 101 - Customer Balances
  • Select Show Balance to be like GL without Allocations, otherwise only fixed allocations will be used.
  • Rounding off SUM Errors when converted from other currencies
  • Allocate Bank Payment to Customer Credit Note on goods returned on originally allocated Sales Invoice
• 102 - Aged Customer Analysis
  • Select Show also allocated to get correct GL result, otherwise only fixed allocations will be used.
  • All currency" customers are presented in company currency together with customers in the same currency as the company. Only when a customer is selected that customers currency is presented.
• 103 - Customer Detail Listing
• 104 - Price Listing
• 105 - Order Status Listing
• 106 - Salesman Listing
• 107 - Print Invoices Condensed Format and it's Modified Code
• 108 - Print Statements
• 109 - Print Sales Orders Change Line Spacing
• 110 - Print Deliveries - Also handles Packing Lists , Bin Locations in Packing List
• 111 - Print Sales Quotations
• 112 - Print Receipts
• 113 - Print Credit Notes
• 114 - Customer Sales Summary Report
• 115 - Customer Trial Balance Report

Supplier

• 201 - Supplier Balances- Select Show Balance to be like GL without Allocations, otherwise only fixed allocations will be used.
• 202 - Aged Supplier Analyses
  • Select Show also allocated to get correct GL result, otherwise only fixed allocations will be used.
  • "All currency" suppliers are presented in company currency together with suppliers in the same currency as the company. Only when a supplier is selected that suppliers currency is presented.
• 203 - Payment Report
• 204 - Outstanding GRNs Report
• 205 - Supplier Detail Listing
• 206 - Supplier Trial Balance Report
• 209 - Print Purchase Orders
• 210 - Print Remittances

Inventory

• 301 - Inventory Valuation Report
• 302 - Inventory Planning Report
  • See line 175 - First the maximum of the last 4 months is calculated. Then this maximum is multiplied with 3 to get a 3 months estimate. This is based on known methods to know the needed stock in advance and to eliminate the risk for one-time sales.
• 303 - Stock Check Sheets
• 304 - Inventory Sales Report
• 305 - GRN Valuation Report
• 306 - Inventory Purchasing Report - as of v2.3.13 Build 3133
• 307 - Inventory Movement Report - as of v2.3.14 Build 3159
• 308 - Costed Inventory Movement Report - as of v2.3.15+ Build 3224
• 309 - Item Sales Summary Report - as of v2.3.15 Build 3231 and as an extension for prior builds
• 310 - Inventory Purchasing - Transaction Based Report - as of v2.4.3+ Build 20171215

Manufacturing

• 401 - Bill of Material Listing
• 402 - Work Order Listing
• 409 - Print Work Orders Δ

Fixed Assets

• 451 - Fixed Assets Valuation

Dimensions

• 501 - Dimension Summary

Banking

• 601 - Bank Statement | Mod to show Person / Item if not Supplier / Customer / Mod Commit
• 602 - Bank Statement w/ Reconcile

General Ledger

• 701 - Chart of Accounts - Page 1 | Page 2
• 702 - List of Journal Entries
• 703 - GL Account Group Summary (Absent)
• 704 - GL Account Transactions
• 705 - Annual Expense Breakdown
• 706 - Balance Sheet
• 707 - Profit and Loss Statement
• 708 - Trial Balance
• 709 - Tax Report
• 710 - Audit Trail

Reports 107 to 113 do not have Destination to Excel available.

Procedure

• If the EMail Report option is chosen, make sure the real_name field in the users table for the logged in user is filled. Otherwise the sender's name will be blank.
• - Linking Reports. reporting/includes/reporting.inc line 128, function print_link() shows how to make a link to the core report you want and manufacturing/workorder_entry.php line 64 shows how to build a report link.

Report Extensions

• Inventory
  • Inventory History Report
• General Ledger
  • Annual Expense Breakdown Report - Detailed
  • Annual Balance Breakdown Report - Detailed

.

• Cash Flow Statement - It uses an existing security code - 'SA_BANKREP'. Make sure Bank reports and inquiries is checked in the required role.

Hiding unauthorised report links

• - this is an extension of the original wish list for menu options visibility discussed here.
  • In reporting/includes/reports_classes.inc in the class Report add a class property $access
  • Modify the class constructor in it as:

Watermarking

Yes, indeed, there is possibility to insert watermark, or even whole externally designed blueprint in documents generated in SolutionERP.

The blueprint have to be designed as PDF-1.4 file (other pdf formats may also be supported), and you will have to put the designed watermark page in /reporting/forms folder.

Out of the box two blueprints are supported for two basic document layouts:

• Header2.pdf - for reports 107-113, 209,210 and 409
• Header.pdf - for all other documents

If you want to test this feature, just put attached file in the forms folder and generate Sales Invoice. In real design some small changes in repxxx.php files can be necessary.

Of course this feature does not address directly the problem of ad-hoc per document watermarks, but is ready to use if e.g. you plan to hire artist to design your invoices ;).

The following reports in SolutionERP can be emailed directly from the reports page form choices:

email_Customers

• 107 - Invoices (From 0, To 1, EMail 3)
• 113 - Credit Notes
• 110 - Deliveries
• 108 - Statements
• 109 - Sales Orders
• 111 - Sales Quotations
• 112 - Receipts

Email Suppliers

• 209 - Purchase Orders
• 210 - Remittances

EMail Locations

• 409 - Work Orders