Is there a report that lists all open debit notes? How to identify them in SQL?

Epicor ERP 10
, , ,
1

I’m trying to find or create a report that lists all open debit notes in our system. Before I build something from scratch, I wanted to ask:

  1. Is there an existing standard or custom report in Epicor that provides a list of open debit notes?
  2. Does anyone know what marks a debit note as “open”? Specifically, what criteria define it as open, is it based on remaining balance, status flag, or another field?
  3. Which table and column in SQL indicate whether a debit note is open or closed?
    Any insights or pointers to documentation would be greatly appreciated.
2

Epicor considers a debit note “open” if it has a remaining balance greater than zero. There isn’t a standard report specifically listing open debit notes, but you can create one using a BAQ or custom report filtering debit notes with outstanding balances. Related invoice tables, with columns like OpenDueAmt or Balance indicating if a debit note is open or closed. Status flags may also be used for this purpose depending on your Epicor setup.