BIP report for Accrual Balance

Summary:

Hi All,

We have a requirement to create a BIP report for accrual balances for liabilty account with PO details.

The query we are using is not giving us the correct balances. Can you please suggest what we are missing?

SELECT CASE
WHEN gjh.je_source = 'Payroll'
THEN 'Payroll'
ELSE COALESCE(sup.vendor_name, sup_xte.vendor_name, sup_rcv.vendor_name, sup_attr.vendor_name)
END AS vendor_name
,CASE
WHEN gjh.je_source = 'Payroll'
THEN 'Payroll'
ELSE COALESCE(pha.segment1, pha_xte.segment1, pha_rcv.segment1, pha_attr.segment1)
END AS po_no
,CASE
WHEN gjh.je_source = 'Payroll'