Mike Mackinnon
Well Known Member
I am working on a BI Publisher report for R42565 and the customer wants to see the sales order lines 'condensed' by item. What they are looking for is if the item is repeated to only list the item ONCE but have a listing of all the serial numbers for that item that come from different lines for that item (split lines from SD/OD receipts). I think this may be extremely difficult as the R42565 has the detail line section with all the information together in it like item, prices, lot number, etc so when I condense by item (from process options - 2-Print, option 11) I lose the lot/serial information on the report.
I am almost thinking I need to modify the R42565 (or create custom object) or if there is some other way to add 'code' to the RTF document to either display the information or hide depending if the item is repeating or not.
I have attached the section of the RTF that I am talking about.
I am almost thinking I need to modify the R42565 (or create custom object) or if there is some other way to add 'code' to the RTF document to either display the information or hide depending if the item is repeating or not.
I have attached the section of the RTF that I am talking about.
Attachments
Last edited: