Open balance of a bill

[soundsessential]

Hey folks

What's the best way of determining if a bill has had any payments applied to it? I have discovered that you can query the bill and get AmountDue, which I think is the total of the line items. You can also get OpenBalance, which would seem like it's the right field. But, if you have a credit on the account, the open balance is reduced by the credit, even if you haven't actually used the credit to pay the bill.

Any thoughts?

Thanks

[PCIPal]

Hi soundsessential, 

      I would set the "IncludeLinkedTxns" to true in the BillQuery request. Then I would loop through all the LinkedTxn in the response and look for any records with a TxnType of "BillPaymentCheck" or "BillPaymentCreditCard". Please give it a try. Thank you. 

 

Sincerely, Carson