Customizing OE Invoice to include a Segment Value Description for the item

Question

Our inventory Items have a structure "Style" (8 char)-"Colour" (5 Char)-"Size"-(3 Char) 
 We want to separately show the segment description in a field on the invoice for the style and the colour. 
 I have tried a little sub report for style connected by OEINPR3.ITEM, I have tried simply linking the ICSEGV to the OEINPR3.ITEM in Database Expert (trying various join types), but the things I have tried come up blank. 
 Any suggestions? 
 
 Sam

Shane - Ascend Business Solutions · Answer

Not terribly difficult: This would need to be done as a sub-report using the OEINV01.rpt as a starting point. In the sub-report, you'll need two tables: ICITEM and ICSEGV. Here's the key - the ICSEGV table should be added three times. When you do, Crystal will want to confirm that you've already added and indicates that you'll need add as an alias. Once confirmed, Crystal will add the second instance of ICSEGV as ICSEGV_1. Once you've added the ICSEGV three times, you can right-click on each instance and change the name. I'd suggest something like ICSEGV_COLOUR, ICSEGV_SIZE, ICSEGV_STYLE. Each instance of ICSEGV should be linked based on the segment in the ICITEM table. In the detail section of the sub-report, you can create a formula for each segment, something like: If NOT IS NULL(ICSEGV_STYLE) Then ICSEGVAL_DESC ELSE "" Next, add a group on ITEM and for each of the formulae, right-click and select SUM, MAX

Sam Richards · Answer

I got it to work without sub report: 
 I used Jay's suggestion to link OEPRN3.ITEM to ICITEM.FMTITEMNO 
 I used 13381622's suggestion to add ICSEGV twice and rename them as Style and Colour, linked my ITEM Segment1 to Style SEGVAL, and Item Segment2 to Colour SEGVAL. 
 I then simply put DESC from each into the report where I needed it and it worked. 
 
 Many thanks to both. 
 
 Now I have to figure out how to get rid of the password pop up. 
 
 Sam

Sage 300

Customizing OE Invoice to include a Segment Value Description for the item

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING