by Administrator | Feb 3, 2021 | Query
Select * from [Options] where convert(varchar, [Options].[DBId]) + ‘-‘ + [Options].[Variable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + convert(varchar, [Options].[FieldId]) in (Select...
by Administrator | Jan 24, 2021 | Interface
Currency rate: RecordType;DBId;StartDate;EndDate;OrgCurrency;DestCurrency;Value;BuyValue;SellValue;InputValue;Invert;RoundPos Nr Name Type Description 1 RecordType Long Type of object to import. 51 is for currency rates 2 DBId Long Database Id in DeMaSy. It is...
by Administrator | Nov 29, 2020 | Query
Select [GLAccount].[DBId], [GLAccount].[Number] + ‘, ‘ + [GLAccount].[Name], count([GLMovement].[EntryNumber]) from [GLMovement] INNER JOIN [GLAccount] On ([GLMovement].[GLAccountId] = [GLAccount].[Id] and [GLMovement].[DBId] = [GLAccount].[DBId]) where...
by Administrator | Aug 26, 2020 | Non classé
To set the global default report language go to: Application / Options / Database Options. Select the Reports Language in the Reports folder, as shown below. This is a global value for all the users for the specified database. However each user will be able to set a...
by Administrator | Aug 14, 2020 | Non classé
For security reasons access to our ftp site has been modified : 1) The login to download updates for DeMaSy has been changed into a read-only login. 2) A new login has been created to upload files to a separated space. Please contact our helpdesk, to receive the user...