Hello,
I’m trying to create a BAQ showing Customer credit limits and their total open credit. It’s marked as an external field, with ep binding Customer.TotInvoiceCredit. Can’t seem to find it in BAQ designer. Is there a way I can get to this field?
Thanks!
Kim
Unless I’m mistaken this is a calculated field so does not live in the DB. In a query I wrote for our AR dept I summed the InvoiceBal field from the InvcHead table for posted invoices and joined that to the Customer table for the credit limit. You could also add order credit in a similar way if you include open orders in credit.
That’s what I was wondering, but hoped it was not the case. Thank you for this information on the query, it is very helpful!
Take a look at the glbcustcred table.
Pair that up with the customer.creditlimit and you should get what you need.
Thanks for this - that’s the table I was hoping for, then I created a calculated column as suggested by the first comment, and it works well!