SageForum for UK versions of Sage 50- Help and support.

Hi, I'm trying to recreate a report I designed years ago. It is simply the NOMACT report with a column giving the date the transaction was reconciled in the bank. I put in the variable but it only displays the variable name on the report, not a value.

I use it for accounts year ends to pick up any discrepancys in the bank rec as the retrospective reports are a bit iffy.

I suspect you added a text box and typed the name of the variable in there.

Try adding the variable and picking it from the list or attach your layout to a response and I will look at it.

I've tried copying the variable from the audit trail and pasting in, I've also tried finding the variable called AUDIT_HEADER.DATE_BANK_RECONCILED when I'm adding a data field or an expression.

This explanation may make it obvious that I'm no expert with report designer and the last time I created this report was ten years ago (I didnt make notes!!)

file is shared on MS onedrive here https://1drv.ms/u/s!AtTcSrPoAEJN6iabqnUwcfJpjNAt

As I suspected you have typed the words into a text field.

There is another issue in that the report is Based on the AUDIT_JOURNAL table and this does not have the bank reconciled date available.

It does have the Bank Reconciled Flag, but not the Date.

As you need the Date, then you need to link in the AUDIT_HEADER table as well which is a bit more complicated and you seem to be having difficulty already.

I shouldn't really do it for you because the idea is to help you grow your skills, but I have made an exception, see attached.