Database Enquiry Help

[BUSH002]

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

[Marc Pons-Burt]

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

 

Marc

[BUSH002]

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