R42520 - Pick Slip BI Word template

johndanter

Legendary Poster
Hi,

Can I ask if anyone has made a BI template of the pick slip yet? And if so, would they be so kind as to email me their MS template please?
I've been asked to make one that has bar codes and if someone already has one, it maybe a bit quicker for me.

[email protected]


Thanks

John
 

jileto

Well Known Member
John,

The thing to bear in mind with R42520 is that whoever coded it did so without thinking that it will be used to generate more than 1 pick document. That is why the main stumbling block working with it is grouping lines. And that is the basis of any BIP solution for R42520 - customize it to include data to facilitate grouping.

Have a look at this: http://smartbridge.com/bi-publisher-advanced-technique-5-multiple-pick-slips/

It encapsulates the solution I got years ago - ca 2009 - from Oracle's BIP blog. When you do a web search now on BI Publisher R42520, the above page comes up (and a EURO site that actually sells a R42520 BIP template). It does do a better job of explaining the solution - which is probably why it percolated up the search results.

The other way is to dodge the issue. Have your functional people look at the other Pick Slip UBEs - R42521 and R42522. For one client, R42522 was a good fit so they switched to that instead. It was way easier to work with R42522's XML than R42520's.
 

johndanter

Legendary Poster
I'm assuming the value entered into Pick_Slip_Number_Detail_ID222 is the same as the one obtained from the headers BSFN? rpt_mnHdrPickSlpNum_PSN feeding into RV Pick Slip Number Display....?
 

jileto

Well Known Member
Yes it is. The objective of the for-each loop is to group the detail lines by pick number. To do that, each detail line must have the pick number value.
 
Top