Get Credit Card Authorization No into Picking Sheet report (SO_PickingSheetWrk)

SOLVED

Hello

We are planning our upgrade from MAS 200 to Sage 100 and our Crystal Report for the Picking sheet used to print out the CreditCardAuthorizationNo but that data is now in a new table called SO_SalesOrderPayment.  I looked into the Custom Office UDF customizier, but was not able to customize SO_PickingSheetWrk to include the CC auth No from SO_SalesOrderPayment.

SO_SalesOrderPayment did not show up as available under the objects for SO_PickingSheetWrk.  Is there another way to add the CC auth no into the Picking Sheet work table?  (The report is customized using the built-in crystal reports designer)