Crystal/Query to show what orders on credit hold

Yahoo Archive
1
To determine if an order is on hold, you need to reference a field from two different tables, the customer table to see if the customer is on credit hold and the OrderHed table to see if the creditOverride field is checked. In a BAQ, the calculated field looks like this:
If ((Customer.CreditHold=TRUE) and (OrderHed.CreditOverride=FALSE)) Then TRUE ELSE FALSE
Â
Â

If (((Customer.CreditHold=TRUE) and (OrderHed.CreditOverride=FALSE)) or OrderHed.OrderHeld) Then TRUE ELSE FALSE
If you are doing this in a crystal report and



________________________________
From: dardelano <ddelano@...>
To: vantage@yahoogroups.com
Sent: Monday, August 10, 2009 11:34:03 AM
Subject: [Vantage] Crystal/Query to show what orders on credit hold

Â
In customer credit manager, I can view a customer on credit hold and I can view his open orders and individually remove them from credit hold. Does anyone have suggestions on how to query this data? I cannot use the Customer.CreditHold field because that represents the customer's status, not necessarily the individual order status. I cannot use the OrderHead.OrderHold field because that doesn't appear to represent anything.

Thanks for any help you can provide.


There is also a OrderHed.OrderHeld field that is a non-credit hold for the order. So if you want to incorporate this into the query also, the calculated field in the BAQ would look like this:




[Non-text portions of this message have been removed]
2
In customer credit manager, I can view a customer on credit hold and I can view his open orders and individually remove them from credit hold. Does anyone have suggestions on how to query this data? I cannot use the Customer.CreditHold field because that represents the customer's status, not necessarily the individual order status. I cannot use the OrderHead.OrderHold field because that doesn't appear to represent anything.

Thanks for any help you can provide.
3
To determine if an order is on hold, you need to reference a field from two different tables, the customer table to see if the customer is on credit hold and the OrderHed table to see if the creditOverride field is checked. In a BAQ, the calculated field looks like this:
If ((Customer.CreditHold=TRUE) and (OrderHed.CreditOverride=FALSE)) Then TRUE ELSE FALSE
Â
Â

If (((Customer.CreditHold=TRUE) and (OrderHed.CreditOverride=FALSE)) or OrderHed.OrderHeld) Then TRUE ELSE FALSE
If you are doing this in a crystal report where for whatever reason you can't use a BAQ calculated field, you could apply the same logic using the Crystal programming language.



________________________________
From: dardelano <ddelano@...>
To: vantage@yahoogroups.com
Sent: Monday, August 10, 2009 11:34:03 AM
Subject: [Vantage] Crystal/Query to show what orders on credit hold

Â
In customer credit manager, I can view a customer on credit hold and I can view his open orders and individually remove them from credit hold. Does anyone have suggestions on how to query this data? I cannot use the Customer.CreditHold field because that represents the customer's status, not necessarily the individual order status. I cannot use the OrderHead.OrderHold field because that doesn't appear to represent anything.

Thanks for any help you can provide.


There is also a OrderHed.OrderHeld field that is a non-credit hold for the order. So if you want to incorporate this into the query also, the calculated field in the BAQ would look like this:




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