BAQ Report - Calculating Available Credit for a Customer

I want to show for a given (global) customer what their current
available credit is, as well as their limit. I see fields on the
customer master screen (TotGlbOrderCredit) that are not in the
underlying tables, so presumably the BO is calculating these on the fly.
There are also flags like GlobalCredIncPI that appear to drive this
behavior as well.

How can I duplicate this in a BAQ crystal report? I want to give my
planners visibility into "will this order be able to ship" given that
some customers may be approaching their limit based on open payables and
the current order. This avoids a fire drill when we have product to
ship but the customer is on credit hold, etc.



Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /

<mailto:bspolarich@...> ~ 734-864-5618 ~ <>

[Non-text portions of this message have been removed]