Import formulas

After the basic structure data has been imported, additional information (like formulas, account types, etc.) can be added by importing other structure data. When specifying a formula in a text file, the formulas must be enclosed between two keywords. When importing from a table or view, omit these keywords. The syntax is:

~BeginFormula~(<formula>)~EndFormula~

The formula must be mapped during the import process.

If you are storing the data in database tables or views, the maximum row size that can be used for a formula is determined by the database type. You should review the documentation for your database to identify any limitations. Keep in mind that there are restrictions on column types. See Data type compatibility for the column types that can be used.