Linking INV1 and DLN1 SAP b1 fields in crystal

[Former Member]

Hi All,

   I am new to crystal and I am looking at creating a Invoice document that shows the Sales order number on the invoice. I have got as far as The attached I have grouped by sales order number but it displays all items even if they do not belong to that sales order any advice?

[abhilash_kumar]

Hi Nathan,

This looks more of a database/query issue. CR will show whatever is in the database. If you run the query on the database, I guess you'll see the same records for each order number unless the data for items is being pulled in from a Subreport and you've not setup the links correctly.

-Abhilash