Jump to content
Why are we here ..... ×
  • 0

Database Enquiry Help



Is there a keyword for tracing payments accepted on the system ?


I am looking to do a Database Enquiry which will find all transactions with an effective date after the 06/04/2015 where we received a payment towards the premium between the 07/04/2015 to 30/04/2015.


Thanks for any assistance.

Kind regards

Tim Bush

Link to comment

2 answers to this question

Recommended Posts

  • 0

Hi Tim


Assume you're using Database Enquiry.


Try BTX.Pay.dt which is the date that payment is assigned to the transaction.


In DBE, if you're using Open-i, choose "Transactions".  On the Keyword choice, type BTX and TAB and it'll show you the BTX frame where the keyword appears at the top.


Hope that helps.


All the best



Link to comment
  • 0

Hi Marc


Thank you very much for replying.


Yes I am using database enquiry, but are on the old Brooms version and not Open-i but that's not a problem.


Would you know the keyword for pulling off the amount paid, tried using BTX.samt but everything was £0.00. So if this makes sense it is the date and amount showing on a cashbook that I am looking to find and total up.


Best regards,

Tim Bush

Link to comment
  • Posts

    • Hi Claire,   We took on INVU back in 2008 and still use it today in its Virtual Cabinet guise. No issues with printing from VC whether that be to network printers or pdf and there are also options to send from VC to email which can be useful.    Overall, we remain very happy with VC so have seen no real advantage to move over to OpenAttach.   One little issue is we never managed to get the automatic indexing / filing of standard OGI/OpenWord letters and emails into VC. We just click a few buttons to file them manually.   Happy to chat through further if you wish - I will be at the Members day this coming Thursday    Darren
    • Hi @Clare Carter   I probably cant advise on day to day use / issues, but may be able to help although not sure of your question   Are you still on Virtual Cabinet (VC) and how are you trying to print on OGI - and what / where from   Also - I'm pretty sure there are minimal issues with transferring to OpenAttach - what are the concerns there?  
    • Just wondering if any of the current members have previously been using Virtual Cabinet, and which originally was Invu provided by Linden House.   It is only relatively recently that Open GI have come up with Open Attach but there is an issue in transferring data.   If anyone is still using Virtual Cabinet which evolved from Invu and Linden House, could they let me know whether they had any issues with Open GI and printing.    Thanks
    • Hi Andrew   I do have a copy - but you can get them / best to get latest copy from the support site - presumably you have a registered account??   Just go to the link here RMAR Reports and Spreadsheet   Any problems come back and let me know!
    • Hi   I am new to OGi and not sure how the system deals with the FCA required Client Money Calculation. A previous post mentioned a OGI PDF document detailing the reports to get the numbers and apparently there is a spreadsheet to input all the numbers as well.   Is anyone able to forward the PDF and spreadsheet or provide assistance please.   Thanks
  • Create New...