how to add Customer Phone and Customer email on OE invoice Bill Address

Solved

on oeinv01 invoice report, Bill Address subreport under Sold To

I would like to add Customer Phone and Customer Email

I thought it's something easy until I hit a brick wall. 

thought these 2 fields should be mandatory

anyone who knows how to add these 2 fields  

Parents
  • Verified Answer

    HI  sure thing, here is how you can do it:

    1. Open your OEINV01 template in a Crystal Reports editor.
    2. Right-click on the billaddress subreport -> right-click on Change Subreport Links...
    3. Add BILLPHONE and EMAIL1 or EMAIL2.  Click OK.
    4. Double-click on the billaddress subreport.
    5. Right click on Report Header G -> Insert Section Below (x2).
    6. Drag your new fields from the right onto where you want them.
    7. Perform cosmetic formatting as required.
    8. Save your updated Crystal template and test it!

Reply
  • Verified Answer

    HI  sure thing, here is how you can do it:

    1. Open your OEINV01 template in a Crystal Reports editor.
    2. Right-click on the billaddress subreport -> right-click on Change Subreport Links...
    3. Add BILLPHONE and EMAIL1 or EMAIL2.  Click OK.
    4. Double-click on the billaddress subreport.
    5. Right click on Report Header G -> Insert Section Below (x2).
    6. Drag your new fields from the right onto where you want them.
    7. Perform cosmetic formatting as required.
    8. Save your updated Crystal template and test it!

Children