I’ve been creating Quick Searches for a while now, and for the most part, they work quite well. Lately, however, I noticed that certain criteria which use Calculated Fields do not always work.
For example, I created a BAQ that includes two calculated fields:
- Vendor_ID_Name: VendorID + ’ - ’ + Name
- Buyer_ID_Name: BuyerID + ’ - ’ + BuyerName
The Analyze output looks great, so I save the BAQ.
Next, I create a QuickSearch on PO Entry that uses the two calculated fields as the Criteria. What’s strange is that I can setup both calculated fields as my two criteria, and save the QS, but if I sweep and re-open it, Vendor_ID_Name looks great, but my Buyer_ID_Name criteria is now blank! The field will also blank out if I click Refresh. Standard fields do not have this problem.
The primary reason that I concatenate the two values is to allow for searching by either ID or Name in one field via the MATCHING option. I could certainly create four criteria, but real estate is at a premium on the QS dialog, and it’s just plain easier for users to use.
Has anyone else run into this and found a solution?