I would like to have a message print on the pick ticket if the requested ship date is not the same as the order date. We print pick tickets to the warehouse and 95% of the time it should pack and ship today but some are “future orders” and get picked by mistake.
Nav. 6.0
on the picking ticket report there will be a dataitem “sales header”
what you are looking to is onaftergetrecord trigger of that dataitem is to add some code.
create a variable vPickMessage or whatever type text
if (“order date” <> “Requested Date”)
then vPickMessage := ‘This is a future order’
else vPickMessage :=’ ‘This order must ship today’;
add a text box to your report with sourcexp property = vPickMessage
to display it.
that’s the basics - you can change the message to say what you want it to say.
Thanks Savatage,
Since I am a novice i could use a bit more explanation. How do I create a local variable first. I apologize for the inconvenience but this is my first attempt at this.
check this post for links to nav guides:
http://dynamicsuser.net/forums/p/33037/173479.aspx#173479
on the 5.0 link there is an application designers guide that show you how to work with reports.
It’s also on your product cd.
your report → tools->designer->view->c/al globals
for a text field you need to fill in name,datatype(text) & length
Savatage’
Thank you so much for your patience. This has solved my issue but more importantly I have learned something today.