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)

Parents
  • 0

    Hi there - does anyone have a hint or ideas on how to get the credit card auth number on the SO picking sheet crystal report? 

    Can I get the field into the existing report work table? (I hope)

    OR would I be forced to bring SalesOrderPayment table into the crystal report designer, or...?

Reply
  • 0

    Hi there - does anyone have a hint or ideas on how to get the credit card auth number on the SO picking sheet crystal report? 

    Can I get the field into the existing report work table? (I hope)

    OR would I be forced to bring SalesOrderPayment table into the crystal report designer, or...?

Children