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?

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,