Queries
- Query: How to see connected users
- Query: Useful VersionLink Queries
- Query: Useful Query Examples
- Query: FAIA – Historical default values
- Query: How to mass create job numbers
- Query: How to create job numbers based upon job number
- Query: How to create jobs based upon job
- Query: How to delete unused Security records
- Query: How to select unbalanced accounting entries on all the databases
- Query: How to update a query in VersionSql table
- Query: Create UserOption
- Query: Select Countries and Translations
- Query: Select Companies having double VAT Number
- Query: Select InvoiceF total different from GLMovement total
- Query: Select InvoiceT total different from GLMovement total
- Query: Keep only last currency rate per year
- Query: View Groups for a specific Right
- Query: Delete all Currency rates that are not End of Year
- Query: Delete all Currency rates that are not End of Month
- Query: Update UserGroup
- Query: Compare initial balance and Y/E Closing
- Query: Select invalid GLYEBalance
- Query: Select Person that should be match in blacklist
Queries after upgrade:
- Queries: Issues with GLCaption
- Query: Select records with missing SecurityGLAccountId
- Query: Select missing Language records
- Query: Remove time from AccInterest.ToDate
- Query: Select TimeReport records with JobTaskId = -1
- Query: Select GLBankStatment with BCyAmount = 0
- Query: Select double GLAccountName numbers
- Query: Select Company with missing LegalName
Queries after upgrade V11:
Queries after upgrade V10:
No queries are necessary
Queries after upgrade V9:
- Query: Select Reltype with no InvRelType
- Query: Address LPrimaryKey
- Query: Forex LPrimaryKey
- Query: InvoiceFDetail LPrimaryKey
- Query: LVATCaseDesc LPrimaryKey
- Query: LVATGroup LPrimaryKey
- Query: ReminderDetail LPrimaryKey