How to include Serial Numbers in a marketing documents

Hi,

we would like to show the serial number attached to the right item in the Invoice and Delivery documents. But the serial number columns are always empty in the markleting documents. My boss don't want to see the serial numbers on a separate report like it is right now.

Do you have any solution ? I tried to use a Formatted search to fill the Serial Number Field, but it's not working, I can't discard the wrong serial number or the SQL query do not work in SAP (thought it's working well in SQL Server)..

Daniel Gagnon