Listed here is some steps for getting the formulas from a Quik Link financial statement into the Adagio Financial Reporter, either in Adagio Ledger or Adagio FX.
- In Quik Link, save the spec to a new file (for backup purposes).
- Select the entire sheet and use the Replace function and change =ACCPAC to '=ADGET. This is nesessary as the function is different, and information can only be pasted to Adagio as Values. The quote in front of the = is necessary.
- Do the same for the negative formulas, =-ACCPAC to '=-ADGET
- Copy the cells (not the sheet) within Quik Link and paste them to a blank sheet in the Adagio Financial Reporter.
- Because only values can be pasted to Adagio, you will need to reset the fonts and formatting as you require.