by FLO | Mar 5, 2019 | Non classé
Select * from [GLAccGLCaption] where [GLCaptionPlanId] = 0 Select Top 20 [DBId] from [GLAccGLCaption] where [GLCaptionPlanId] = 0 Group by [DBId] Order by [DBId] Select [GLAccGLCaption].[DBId] as [ResDBId], [GLAccGLCaption].[GLCaptionId] as [ResGLCaptionId],...
by Administrator | Mar 5, 2019 | Non classé, Query
Select * from [GLAccGLCaption] where Not [TableName] in (‘(None)’, ‘ClientType’, ‘SupplierType’) Select [DBId], [GLAccountId], [TableId], [GLCaptionPlanId], [GLCaptionId], [DGLCaptionId], [CGLCaptionId] from [GLAccGLCaption] Group...
by Frédéric Lamain | Mar 4, 2019 | Non classé
SELECT * from [GLBankStatment] where [BCyAmount] = 0 and (Not [CyAmount] = 0 or Not [Amount] = 0)
by FLO | Mar 1, 2019 | Non classé
In order to use some functionnalities of DeMaSy in VBA module, you can use the DLL DeMaSyNET_COMObject. This dll needs to be placed in the same folder as the other DeMaSy dll ( C:\Program Files (x86)\Silicon DNA\DeMaSy ). This DLL is COM Compatible.You can register it...
by Administrator | Feb 21, 2019 | Non classé
Click on New Database menu In the list of databases, choose the STD database Enter a logical name and click OK => it will take a few minutes to create the new database Open the newly created database Go to Accounting periods screen to create a first initial period...
by Frédéric Lamain | Feb 12, 2019 | Non classé
In order to use applications on mobile device, you have to install a webservice on an IIS server with an public IP. 1) Go on Internet Information Services (IIS) manager. 2) Create a...