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 for use within the Outstanding Receipts / Payments Report module in Merciglobal Cloud ERP. This function allows developers to specify a particular column from the form table that should be used in the report display.

Purpose¶

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

Location¶

This function must be defined in the following file:

/libfuncs.php

Function Syntax¶

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

Replace¶

{form_table_name} → Use the actual name of the form table associated with your custom document.
'discamt' → Replace this with any other column name from the form table you wish to include in the report.

Example Implementation¶

If your form table name is custpayment, your function would look like:

function custpayment_osrep_customcol1() {
    return 'discamt';
}

Notes¶

This function must return a valid column name from the form table.
You can create multiple such functions for different forms by changing the function name accordingly.
This approach allows flexible customization per document type.

Use Case¶

This is helpful when you want to: - Show Discount Amounts (discamt) in the Outstanding Report. - Display other custom calculated or form-stored values.

Target Audience¶

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

Outstanding Receipts / Payments Report
Custom Form Table Integrations

For further help, contact support@merciglobal.com or refer to other documentation available at docs.merciglobal.cmo.