Printing /C Comment Lines on DropShip Purchase Orders

SOLVED

Hello,

We have purchase orders with /C comment lines that we would like to print using a non-Standard form code if possible.  I know these lines can be printed with the Standard form code, but I cannot figure out a way to print them with a non-Standard form code.

Thank you for your help,

Brian

  • 0

    If the "Print Comments" option is set to Partial or Full, they should be displayed unless the crystal report has been customized to suppress them regardless of the option picked.

  • 0

    I suspect someone added a table to the form in Crystal Reports.  For example, if CI_Item was added and linked with an equal join, comment lines will not print.

  • 0

    IM_AliasItem was added to the form with an equal join.  Someone did this for us, because we would like to see the alias item description on the purchase order when an alias item number is present.

    I remember seeing a post advising not to join other tables to Wrk tables, but obtain the same information by adding UDFs to the appropriate Work table.  Is a better approach to add a UDF, for the AliasItemDescription, to the PO_PurchaseOrderWrk table?  Then, add this UDF to the report.

    Thank you,

    Brian

  • +1 in reply to bp3278
    verified answer

    Aliases are different.  It isn't possible to link that field into the work table.

    Use a sub-report for the Alias description instead.  That won't break the main report for /C lines.

    Someone might suggest an outer join, but I do not recommend that.  Technically Alias codes are not enforced (by Sage) as unique, and your PO lines will duplicate if the same alias code is ever used for more than one item (or the same item has more than one alias... depending on how you configure the table link).  A sub-report is safest, where the impact of those issues is just extra descriptions, not extra lines.