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)

  • +1 in reply to SageAcolyte
    verified answer

    I wanted to follow up that SAGE was able to identify that this was an actual bug..the sage support analyst advisory said:

    "The discussion with engineering was they think it was a missed oversight when they redesigned the new credit card programing and to submit issue."  So it is a 'missed oversight' lol!!  He continues:

    "I know there will be no hot fix on this issue since it does not fit the severity 1 or 2 symptoms, so more than likely it would be in Product Update." That was 2 months ago.  10 days ago he emailed me again:

    "The issue with the authorization date does not print was submitted to engineering and in discussion it looks like an oversite at this point.  Defect is 108500 and KB: 87800.  Not much more status than that other than scheduled for PU2 in version 2018."

    For now, what I actually did was to link the SQL table SO_SalesOrderPayment to the work table in the crystal report and displayed the AUTH DATE for each company division.  This will do for now.