R42520

[murthyr]

Hi,
Could any one give suggestions as how to program print pick slip report (R42520) to show the order that is being shipped today and associated line items with shipped quantiy and back order quantity with that order. I need to show only if that order has both shipped quantity and Backorder quantity.

 

[Sef]

Hi Murthy

Sounds like a mod to me.
In order to print 'today's orders only, you need to include additional data selection in the initialise section. Something like:
VA_evtTodaysDate_URDT = date_today()
Set Selection Append Flag = <Yes>
Set User Selection(BC Date - Scheduled Pick (F4201), <Equal To>, VA evtTodaysDate_URDT, <none>)

Or preferably make it Processing Option driven.

Wrt back orders and shippable qty's, are you talking at order level or line level. At line level you need addtional data selection like SOQS<> 0 and SOBK <> 0. If you need this at order level you need additional validation in the driver section as you cannot do it upfront in data selection. Based on the result you can suppress output AND status code update and pick slip number assignment.

Good luck,

 

[murthyr]

Thanks a lot. I have finished report today with your suggestions.