PS_CUST_DATA have balances even through there are no open items
PS_CUST_DATA have bal_amt <> 0 for business_unit/item/cust_id combination even though the same combination is having PS_ITEM.ITEM_STATUS = 'C'.
Any idea what needs to be done so that PS_CUST_DATA.BAL_AMT is 0.
Thanks in advance,
Ranjith