Signature command
The Signature command allows an unlimited number of signatories to be shown on a Financial Statement.
The syntax is as follows:
=SIGNATURE("BS","#Prefix #FName #LName #Suffix")
- Type This can be either DR or BS. It will pick up the officers who sign either the Directors Report, or the Balance Sheet.
- Name parameter The parts of the name parameter specify the parts of the name that will be printed:
- Prefix This picks up the Title field of the Contact
- FName This picks up the First Name field of the Contact, or this will be just the initial if present
- LName This picks up the Last Name field of the Contact
- Suffix This picks up the Suffix field of the Contact
However, all the name parameters are replaced by the Name Override field, if present
When evaluated, it will render:
...................... ........................ ........................
Mr Partner A Msc Ms Partner B Bsc Dr Partner C PhD
...................... ........................ ..........................
Mr Partner D Ms Partner E Dr Partner F
Notes
- The SIGNATURE() command acts as a replacement for commands like:
- =AP("#bsig1") to print the first Balance Sheet signatory, or
- =AP("#dirsig2") to print the second Directors Report signatory, or
- =AP("#mrsig3") to print the third LLP Members Report signatory
- Unlike these commands, all signatories are printed in one operation. Also you have more control over the format in which the names are printed.
- When the SIGNATURE() command is used for the LLP Members Report signatories, use the "DR" form.