Invoice should be direct if you want to choose/see lot number in standard sales invoice lot field. If invoice is created from delivery, however lot numbers are stored in STOJOU table, you can find them and display in custom sales invoice field. Same for crystal, you should look for lot number in STOJOU.

Paulius

Thanks for the input. The invoice is being generated directly from the Delivery. However, on the invoice screen it shows the column LOT number on the grid but does not carry over the data from the delivery.

This is on the delivery:

This is on the invoice:

How can i get it to show so I can pull it on the form. Since the fields are empty it does not pull anything on the form. If I need to edit the cyrstal how would I go about doing that?

In Crystal report, you will need to link sales delivery tables to invoice - SDELIVERY (link to sales invoice) and SDELIVERYD (information about LOT number). 

By any chance do you have a snip of what that would look like in Crystal. I am fairly new to crystal. Also, how would the system know to pull the LOT for each line item.

If you can show me that would be awesome. My email address is [email protected] if you have few min to spare. 

Thanks,

By any chance you can advise on how I can get this to show up on the crystal form. Meaning how to connect the two so it output the lot from the delivery onto the invoice per line item.

Any idea, how the link would occur in Crystal? Also, I am trying to do the same thing on a query, where I want to pull the delivery data with the lot number. I have the following but the query keeps breaking. 

It keeps saying the link is not correct. I am using the product as the unique identifier. But it looks like the system does not like that.