Vat registration details aren't stored at the transaction level.  They are held on the Purchase and Sales Ledger accounts or on sales / purchase orders.  As these don't exist for Nominal payments  they wouldn't typically exist in the database.  You mentioned that they are being entered, whereabouts are they being entered?

This is where we enter the VAT red under Nominal > Enter Transactions > Nominal Vatable Payment - there is a field for the registration number with the reference and narrative fields.

I have located how to add this to reports, it is the field SYSTaxTrans.TaxRegistrationNumber but I am assuming at this point that there is no other way to view this information within Sage.

that would be a bespoke field then as in the standard program this isnt a field on this form.  Would recommend speaking to the person who amended it (developer/business partner) to see if it picks a different field from behind the scenes.  They also may be able to tell you where else this will display etc

Ah, that's really weird, but would explain why I could find very little on it. As far as I was aware this was a standard field, it certainly looks it. I'll find out from ICT who I will need to contact about this.

Thank you for your help.

That field looks like the one for additional transaction analysis.  It doesn't have a defined purpose it's just one you can customise yourself.

It's setup in Accounting System manager>Settings>system settings> transaction settings

On rep des it would be nlpostednominaltran.transactionanalysiscode.

You can also view it on the nl current transaction listing under additional analysis or if you select to view the detail of the transaction on the NL transaction enquiry screen.

That field looks like the one for additional transaction analysis.  It doesn't have a defined purpose it's just one you can customise yourself.

It's setup in Accounting System manager>Settings>system settings> transaction settings

On rep des it would be nlpostednominaltran.transactionanalysiscode.

You can also view it on the nl current transaction listing under additional analysis or if you select to view the detail of the transaction on the NL transaction enquiry screen.

Hi, if Jake is using Sage 200cloud Standard / Education then there is an additional box surfaced in Purchase Invoice Entry and Nominal Vatable Payment to allow the recording of VAT details. These are then picked up on a Sage 200cloud STandard/ Education specific VAT report which is produced when you hit 'Print' on a VAT return.

Good one David (Hope you are well BTW!)

Nice one Stu!  Gotta love when 3 former Sage colleagues solve an issue  

Yes, it will be the Education version that we have. The settings are different to what David showed and the only way I seem to be able to pull this field is with a report, if I manually add the field in wherever it may be required. I can work with this method now, it would have just been a lot easier if the field was visible within the Nominal Current Transaction list, and lack of reference to this online had me stumped.

Thank you all for your help with this.