I am trying to add field Approved_By_UserId from views ‘Gen_Led_Vouchers2’ or ‘Voucher’ to as a custom field on ‘Supplier Invoices Analysis’, ‘Multi-Company Invoices Analysis’, and ‘AP Suppler Invoices Analysis’.
Basically if the field is null in gen_led_vouchers2 i can get it from transactions in the hold table.
But I have never seen an IF/Then in a custom field select statement. :-/
Can this be done and does anyone have an example?