Database Administration
This chapter contains some useful SQL queries for the PANTHEON database:
|
Converting Posts to a Different Currency
|
Explains how to convert posts from the primary currency to a different one (for example, for financial reports). |
|
FormulaParser
|
This example is not so much related to SQL-InterActive but rather to the way T-SQL is programmed |
|
Correcting the document date in posting
|
Explains how to corrects all entries in journals where the document date in the entries is empty, setting it to the document date recorded in the "document date" field (from invoices/transfers, etc.). |