Bring in the ACLOB table into you report and join your transaction ID (order #, return #....) to the IDENT1_0 column.

Then you need to filter the CODBLB_0 field based on the transaction. For Sales Orders you’ll filter CODBLB_0='CO_SOH' , Purchase Orders = CO_POH, Sales Quotes = CO_SQH, Sales Returns = CO_SRH, Deliveries = CO_SDH….

The CLOB_0 field has the actual comment.

In SQL you would write something like this

SELECT SOHNUM_0, CLOB_0

FROM SORDER

JOIN ACLOB

   ON SORDER.SOHNUM_0 = ACLOB.IDENT1_0

   AND ACLOB.CODBLB_0 = 'CO_SOH'

Israel Braunfeld said:

Bring in the ACLOB table into you report and join your transaction ID (order #, return #....) to the IDENT1_0 column.

Then you need to filter the CODBLB_0 field based on the transaction. For Sales Orders you’ll filter CODBLB_0='CO_SOH' , Purchase Orders = CO_POH, Sales Quotes = CO_SQH, Sales Returns = CO_SRH, Deliveries = CO_SDH….

The CLOB_0 field has the actual comment.

In SQL you would write something like this

SELECT SOHNUM_0, CLOB_0

FROM SORDER

JOIN ACLOB

   ON SORDER.SOHNUM_0 = ACLOB.IDENT1_0

   AND ACLOB.CODBLB_0 = 'CO_SOH'

Israel -

Thank you.  Your suggestion pointed me to the correct data.  This is the first half of the process.

Just for Community notes:  if the CLOB type is RTF (Rich Text), you'll have to instruct Crystal Reports to translate the field from RTF to something legible.  You can do this by right clicking the field added to the report (CLOB_0), select "Format Field", and then selecting the Paragraph tab.  See screenshot below.

I have a Sage HTG on this if you would like me to email it to you.  I cannot find a way to upload a PDF to this post.

Thanks to you both for uplifting the community. I wish I could give you guys points!

Bob

Do you have the HTG? Is it on the support site, im looking for a copy.....