Custom Column Function for Outstanding Receipts / Payments Report

Overview

This document guides Merci Developers and Sales Consultants on how to implement a custom column function within the Outstanding Receipts / Payments Report module in Merciglobal Cloud ERP. This function allows developers to define a specific column from the form table that should be displayed in the report.

Purpose

This function provides custom reporting logic by returning the name of a column from the form table. The column's value will be included in the Outstanding Receipts / Payments summary report.

File Location

Define this function in the following file:

/libfuncs.php

Function Syntax

function {form_table_name}_osrep_customcol1() {
    return 'discamt';
}

Replace the following:

{form_table_name} → Actual name of the form table associated with the document.
'discamt' → Column name from the form table that you want to include in the report.

Example Implementation

If your form table is custpayment, the function will look like this:

function custpayment_osrep_customcol1() {
    return 'discamt';
}

Notes

Ensure the function returns a valid column name from the form table.
You can define multiple such functions for different document types by changing the function name.
Supports flexible customization per module or document type.

Use Cases

Display Discount Amounts (discamt) in Outstanding Reports.
Show any other custom field or form-stored value.

Target Audience

👨‍💻 Merci Internal Developers
💼 Sales Consultants
⚙️ Implementation Partners

Outstanding Receipts / Payments Report
Custom Form Table Integrations

For additional assistance, contact support@merciglobal.com or refer to the documentation at docs.merciglobal.com.