Email - Modify body of email in SAP Business One v9.0

[larryenet]

I cannot find where I can permanently change the default email.

When I am sending the email, I can manually change the body but I want to permanently change it.

Any help would greatly be appreciated.

Thank you.

[larryenet · Accepted solution]

See the query

IF $[OALR.Subject.0] = 'Statement from eNet Components'

Begin

SELECT T0.[U_Message] FROM OCRD T0 WHERE T0.[CardType] ='L' and U_Message Like '%Your Statement%'

END

IF $[OALR.Subject.0] = 'Invoice from ENET'

Begin

SELECT T0.[U_Message] FROM OCRD T0 WHERE T0.[CardType] ='L' and U_Message Like '%Your Invoice%'

END

IF $[OALR.Subject.0] = 'Credit Memo from eNet Components, Inc.'

Begin

SELECT T0.[U_Message] FROM OCRD T0 WHERE T0.[CardType] ='L' and U_Message Like '%Your Credit%'

END

[julie_jamieson2 · Accepted solution]

Can you run this query in the query manager:

SELECT T0.CardCode, T0.CardName ,T0.[U_Message] FROM OCRD T0 WHERE T0.[CardType] ='L'

See what results you get?

[larryenet]

Awesome!!!

Thank you Julie!! You rock!!!

[larryenet]

Here are the results:

[larryenet]

Each of the Field Values above have the "body" of the email when I go to send out an email.

I need to edit each of those values.

[larryenet]

I looked in there and the Message field is blank

[kothandaraman_nagarajan]

Hi,

You can add permanent text for email under Administration--->System Initialization-->Print Preferences-->Per Document.

You set different email message for different documents.

Thank you

[larryenet]

Please look at my screen shots to determine where I can edit this:

1. Click on Email Icon.

2. Click on Search Icon

3. Select User-Defined Value

4. User-defined value shows up in Subject field. Click on Search icon in Text "body"

5. I do not know how the original user saved this information in here. I need to change it.

Thank you.

[larryenet]

I'm getting closer..

Here is what I found. Where can I edit 'Statement from eNet Components', 'Invoice from ENET', and 'Credit Memo from eNet Components, Inc.'?

IF $[OALR.Subject.0] = 'Statement from eNet Components'

Begin

SELECT T0.[U_Message] FROM OCRD T0 WHERE T0.[CardType] ='L' and U_Message Like '%Your Statement%'

END

IF $[OALR.Subject.0] = 'Invoice from ENET'

Begin

SELECT T0.[U_Message] FROM OCRD T0 WHERE T0.[CardType] ='L' and U_Message Like '%Your Invoice%'

END

IF $[OALR.Subject.0] = 'Credit Memo from eNet Components, Inc.'

Begin

SELECT T0.[U_Message] FROM OCRD T0 WHERE T0.[CardType] ='L' and U_Message Like '%Your Credit%'

END

[larryenet]

Here is more information.

How do I edit Message Table Value?

[julie_jamieson2]

It looks like the message is in a User defined field on you Business partner Master Data?

Use CTRL SHIFT U to bring up the panel. This means you will have to edit it on each business partner.

[larryenet]

Yes, I found it in User-Defined Fields - Management

Master Data > Business Partner > Message

Where do I update the message data?

[julie_jamieson2]

Open a Business partner Master Data record, use CTRL SHIFT U to display the user defined fields against the Business Partner.

You should see one there called Message.

The text you want to update should be in there.

[Former Member]

Hi Tucker,

I usually do that using the option in Administration > System Intialization > E-mail Settings.

Regards

[larryenet]

Hi Lais,

That is helpful, but that is not the area where I am trying to change body of email.

In our system there is only signature under "E-mail Settings"

When I click on email icon, the Send Message window opens.

I click on the magnifying glass in the Subject field and the List of User-Defined Values window will open.

From there, I select "Invoice from ENET" and click Choose and it brings me back to the Send Message window.

Then I click on the magnifying glass in the Text field and it will populate.

Look at pics:

After I click on magnifying glass icon, it will populate:

How can I permanently change the text in that window?

[julie_jamieson2]

This is set by a formatted search.

If you select New in the List of Values that comes up, can you see the full list? You should be able to edit it there

[larryenet]

I can see the list by selecting New but it doesn't let me edit or save anything.

I'm in version 9.0