How to add the Lot Expiration Date to a Pick Ticket?

(0) Share

Report

Posted on by Rennecia Barran

Can someone tell me how to add the lot expiration date to a pick ticket to reflect for the relevant line?

I tried connecting tables but the fields to create the link between the tables do not exist. For example, to link the Lot Number Master table to the Item Quantity Master, I need to link the Qty Type field, which does not exist. Smh...

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Tami Farrelly 5,080 on at

Like (0)

Report
Copy link

Link copied!

We have had to use custom crystal reporting with sql views in the manufacturing module

the canned reports are lacking functionality to say the least

Was this reply helpful? Yes No
Rennecia Barran on at

Like (0)

Report
Copy link

Link copied!

Nah man, there must be a way to get it. I will keep my fingers crossed that someone else have done it in Report Writer.

Was this reply helpful? Yes No
Tami Farrelly 5,080 on at

Like (0)

Report
Copy link

Link copied!

you can try and add the Item Lot Master to the report IV00300

Was this reply helpful? Yes No
Rennecia Barran on at

Like (0)

Report
Copy link

Link copied!

Thats what i tried but all the link fields are not available.

Was this reply helpful? Yes No
Tami Farrelly 5,080 on at

Like (0)

Report
Copy link

Link copied!

and this is why we use crystal reports :)

Was this reply helpful? Yes No
Rennecia Barran on at

Like (0)

Report
Copy link

Link copied!

Sigh, I am still hopeful. Someone must have done it in Report Writer. I believe.

Was this reply helpful? Yes No