Skip to content

x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 127 subscribers
  • Views 304 views
  • Users 0 members are here
Browse Forums
Announcements
333
topics
272
replies
Databases and Operating Systems
777
topics
3k
replies
Financials Suite
722
topics
2k
replies
General Discussion
2k
topics
8k
replies
Operational Suite
451
topics
1k
replies
Reporting and Analytics
1k
topics
4k
replies
Reports, Macros, and Customizations
835
topics
3k
replies
Sage CRM for Sage 300
167
topics
444
replies
Mr_Mayor

OE Optional Fields

SOLVED
Posted By

I have gone to common services and added a

txt optional field with 3 values 123, 456, 789

when to IC setup and assigned three items the optional fields 

went to OE optional fields and linked the shipment details and invoicing details the optional fields 

I do an invoice from shipment and the optional fields come through nicely for the three items all the way to invoice screen. 

Went to oeinv01 report insert a column next to item number for this optional fields. linked the default OEINPR3.INVUNIQ TO OEINVDO.INVUNIQ and it seems to print okay. Closer look it’s duplicating the optional fields but everything else is okay. 

any other field on the index legend seems not to yield any results. Anyone ever met this. Not sure what to link anymore 

question 2. 
how do I use oeinv04

I recall back in the days there wa something like commenting out datapipe for it to work

maybe that could solve question 1 of I use report 4 since they are written differently 

Parents
  • 0

    You're correct in that you want to comment out the datapipe= line if you want to use the ODBC versions of the Crystal Reports - I'd very much recommend going that route.

    Optional fields are slightly challenging for reports. One way to get them into the report is to link OEORDD to OEORDDO with a left outer join. Then you can filter the records coming from OEORDDO for the optional field you want. If you have more optional fields you can add that table a second time and give the table an alias.

    Another way is to create a sub-report that will show the value of the optional field. This is slightly less conceptual and easier to have full control over it. I'd recommend this route.

    The last way is much more complicated and that is to use Shared Variables along with sub-reports. But it does give you the most control.

  • 0 in reply to Django

    after commenting out, the report oeinv04 pop up a parameter screen. once you enter first line, it then prints

    not sure what's upsetting to have  the pop up of parameters screen

Reply Children
No Data

*Community Hub is the new name for Sage City