Sage 100

A client is having Crystal issues subsequent to upgrading to 2013 and the newest version of the Crystal. Here's what they say: ""New information now that I had the designer back, I went back into these particular forms and added the Credit Card authorization info IE: unencrypted last 4 digits, auth date, auth amt, auth date. This morning, for giggles, I removed that same information and the form works again - - so my question now, is how do I add that information properly, so that my form doesn't break? We do need that information on the forms, so we can see at a glance, that the CC has been PreAuthorized before we ship anything out. Any idea? I pulled that info from SO_SalesOrderPayment perhaps that's not the right one to pull from?

I believe that data is now part of the form work file and no longer needs to be linked to a separate table.

What type of error did they receive?

My first thought is the key to the SO _SalesOrderPayment file. Is she linking correctly? And possibly using a left outer join.

They don't get an error. The data on the form just disappears.

If the data just disappears that is usually a join issue.

These fields are in the So work table..see pic

From the File layouts table for SO _SalesOrderPayment: KPRIMARY: SalesOrderNo+PaymentSeqNo ""Murphy's corollary - when all else fails, get the directions out of the trash can

I may be asked to post this as a new question but this is so closely related to @DebThomas' post that I have to first try to piggy-back on here. I have been trying to resolve almost the exact same question, but not in a Crystal Report, in an ALE lookup. 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. As you wise folks have indicated here it 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?