How to set up database logging on VendTable.BankAccountNum

(0) Share

Report

Posted on by NCom

Hi,

Let's see if the community can help me!

We would like to have a database log set up on the VendTable.BankAccountNum, however I can't find the field in the Database log setup form.
Currently we have the database log set up on VendTable.BankAccount. Since this field can only contain 10 characters it doesn't show the entire bank account number (incl IBAN).

Did anyone face this problem before and how did you solve it?

Regards,

Niels

*This post is locked for comments

All responses (4)

Answers (1)

NCom 25 on at

Like (0)

Report

RE: How to set up database logging on VendTable.BankAccountNum

Thanks a lot! I must have overlooked that Note.
Verified answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: How to set up database logging on VendTable.BankAccountNum

If you specify a field, you can only track Update. Fields can only be updated, not inserted or deleted. Only full records can be inserted or deleted. This means you can only track "Update" for individual fields.

Please see the documentation docs.microsoft.com/.../configure-and-manage-database-logging
NCom 25 on at

Like (0)

Report

RE: How to set up database logging on VendTable.BankAccountNum

Hi Nikolaos,

Thanks. In the meantime we also figured we should use VendBankAccount.BankIBAN instead. Just now we are facing another issue: We can only set the checkbox for 'Update', while we also want to log on 'Insert' and 'Delete'. For some reason these options are not editable.

Gr Niels
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: How to set up database logging on VendTable.BankAccountNum

VendTable contains only the BankAccount id. The details of the bank account (including IBAN) are in VendBankAccount ("Vendor bank accounts") table.