CreditCardAuthorizationNo field missing from ALE lookup since upgrade:
In 4.20 this customer used an ALE for Sales Orders and had the CreditCardAuthorizationNo as one of the fields in the lookup. In this way they could determine which Orders to select based on whether there was data in this field.
Now in 2013 the field is not in Sales Order Header. I know that field is now in the SO _SalesOrderPayment table. Too bad that table is not added to the Available Fields section of the ALE.
What I can't remember is if I can edit one of the data dictionary files in order to add that table to the lookup or if there is another way. Funny what you can forget if you're not careful, isn't it?
As a workaround, speaking of Crystal, I have created a q&d report to show open orders with a value in the CreditCardAuthorizationNo, but it would be nice if I could give them back their ALE.
Any thoughts?