Posts by Muthukumar Palaniappan

AR Unearned Invoice Report query

SELECT customer, account_number, invoice_no, line_no, accounting_rule_name, functional_amount FROM ( SELECT replace(hp.party_name,’,’,’ ‘) customer, hca.account_number, rcl.customer_trx_line_id, aps.creation_date creation_date, rct.trx_date invoice_date, rct.invoicing_rule_id invoice_rule, rct.trx_number invoice_no, rcl.line_number line_no, replace(rcl.line_type,’,’,’ ‘) line_type, replace(rcl.description,’,’,’ ‘)…

Read More

Ar Aging Bucket Report query

SELECT “Transaction Type Name”, party_name, party_site_number, “Payment Terms”, gl_date, due_date, total_days, CASE WHEN total_days > 0 THEN amt_due_remaining END “Not Due Amount”, CASE WHEN total_days BETWEEN 1 AND 30 THEN…

Read More