Home > TbSync2 Add In
TbSync Add In
The TbSync2 function was specifically written for the Financial Pack design but can be used in other scenarios.
It Synchronizes a column (Source Column Range Name) of values in one sheet (Source sheet) with a column (Target Column Name Range) in another sheet (Target Sheet) and will bring formulas down with the synchronised column based on a range that is specified to be copied down (Formula Range to Extend). The target sheet synchronisation needs to be told what row to start synchronizing from (Target Sheet Start Row).
Optional Parameters:
Run interactive: Set to 1 for the TBSync box showing new accounts to show. Set to 0 for synchronisation to happen without prompts.
Only Handle Numerics: Set to 1 to ignore non numeric values.
Support for Stored Procedures - The Sage Intelligence Reporting Application has been extended to allow developers to use Sage Intelligence Reporting to access data returned by database Stored Procedures.
System Variables - System Variables have been introduced for use with filtering and Parameterization.
Pass Through Variables - Pass Through Variables increase the options available for and power of report Parameterization.