Jump to content
Why are we here ..... Read more... ×
  • 0
lesley

Keywords into Email

Question

Following the Open GI User training, we have put our renewal letter into Tables, all works fine on word letters.

However when we pull the template into Email, all is working other than the renewal premium

the code we are currently using for the calculation is btx.orig.debt     

the annual premium which is a bpy is working in the email.    

your help would be appreciated

KR   Lesley and Kate   from Meadons Insurance Brokers

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi Lesley - hope you are well

 

Have you tried using the BLT alternatives?

 

Always tricky on which should be used (BTX/BLT) - and depends on when / where the letter (mail) request is initiated. But if it's OK in a letter - it should be OK in the mail - you would like to think ... 

 

The on-line guides confusingly use both types in the examples - but I cant find the recommended options / reasons / guidelines which are documented in there somewhere!

 

Try BLT options but if not, come back and I'll have another look on the systems and get you a definitive answer - if I can :)

 

Otherwise Marc PB - the maestro of OpenWord - may need to jump in 

 

Let me now 

 

Thanks

 

Share this post


Link to post
Share on other sites
  • 0

Thanks Mark and hi there Lesley and Kate

 

My first question is where is the e-mail being initiated from?

 

If it's anywhere other than the Transaction itself, the BTX and BLT related original debt won't work properly because it needs to know which one it's looking for.

 

Obviously, this does make it a pain when trying to attach Renewal Schedules from OpenPrintManager.  I'm looking into ways around it.  I'll keep you posted.

  • Like 1

Share this post


Link to post
Share on other sites
  • 0

Pretty sure I had this issue when letters not printed directly from transaction and resolved it with code selecting BTX records. Will check Monday and feedback.

Share this post


Link to post
Share on other sites
  • 0
On ‎18‎/‎11‎/‎2017 at 23:24, karl said:

Pretty sure I had this issue when letters not printed directly from transaction and resolved it with code selecting BTX records. Will check Monday and feedback.

Yeah, I just looked and I created a back office doc with a Calculations box in it containing:-

 

select btx find last where

 

[BTX.Trantype] eq "r"

 

[YCT.Date2] is [BTX.Dt.raised]

[YCT.Var1.2] is [BTX.orig.debt]

 

Then just include as text document within your OpenWord template and set the YCT variable as needed to display latest renewal transaction info.

 

  • Like 1

Share this post


Link to post
Share on other sites

  • Posts

    • Nice one Karl - Just how a good solution should be built!!   Shame GETREPLY and INPUT screens are not part of core calcs though 😩   Thanks for sharing
    • I tried to make my frame as 'user-friendly' as possible so made all the consent given/retracted dates auto populate based on when questions answered/changed.
    • Coffee-MP4.mp4
    • If this email does not appear to be displayed as intended, click here to view it online.   May 2018 Welcome to Issue No.37 In this issue the Chairman brings you up to date with what has been happening on the GDPR Issue, we draw your attention to the current deadline for the implementation of IPIDs and provide a summary of the Minutes of our Committee Meeting held in January.  In addition, we bring you news of Exclusive Membership Benefits and highlight the problems that can be encountered when relying on next day delivery of consumable items. It is worth taking the time to click through and read these articles; you never know what nuggets of information await! Important Open GI update to Integrated Products and Core. The latest update of IP5.81.0 and Core 15.81A will be bringing the ability to Purge linked Open Attach records as part of your Core Purge.  This is going to be a huge time saving update, so keep a look out for it in the near future in your system messages! As always we would love to hear from you with your experiences and suggested improvements for the Open GI system. Barbara Pena - Administrator If you haven't already done so, why not try logging onto our Forum. To gain access to the Forum you simply need to register on the site and a confirmation email will be sent out. To register, go to the following link:- http://opengiusergroupforum.invisionzone.com    GDPR Issue

      Click here to Find out more Committee Meeting Highlights
      The Open GI User Group Committee met on 29th January 2018 for one of their quarterly meetings to discuss topics raised by Open GI users.  The Committee then met with Open GI at their Worcester offices on 1st February 2018 to exchange feedback and raise user issues and queries.  A summary of the minutes has been produced for your information. 

      Click here to Find out more   IPIDs are Coming!


      Click here to Find out more   Membership Benefits for 2018
      Exclusive Discounts off selected Open GI Software have been negotiated for 2018.

      Find out more   Next Day Delivery - May not always work!!
      Do you rely on next day delivery for your consumable items?  Have you experienced problems?       

      Click here to Find out more   Open User Group Open User Group The views and opinions expressed in this email may not represent the views
      and opinions of the Open GI User Group and are made without prejudice and
      subject to contract. Although this message and any attachments are believed
      to be free of any virus or other defect that might affect any computer
      system into which it is received and opened, it is the responsibility of the
      recipient to ensure that it is virus free and no responsibility is accepted
      by the Open GI User Group for any loss or damage in any way arising from its
      use.

      The information contained in this message is correct at the time of going to
      press. Any action taken as a result of the information should be checked
      with the sender before taking action.   If you would like to be removed from this mailing list please click unsubscribe    
    • What a difference an "F" makes. The report is coming out now - thank you so much for your help. Well worth being a member of Open GI User Group!!! Carol
×