title: Where can I find the pending amount from invoices in DynamicsAX Database?
body: <p>This is what I already know, Tables for open invoices:</p>
  
  <ul>
  <li>"CustTransOpen"</li>
  <li>"CustInvoiceJour"</li>
  <li>"CustTrans"</li>
  </ul>
  
  <p>I've been working on this for a while without a clue, there must be a way to get the pending amount or at least to know if these invoices have been paid.</p>
  
  <p>I already looked on all the Microsoft documentation with no success, hope you can help me.</p>