by SEP | Oct 4, 2022 | Query
select [DBId], count(*) from [Supplier] where [SupplierGLAccountId] = 0 or [SupplierGLAccountId] is null group by [DBId]
by SEP | Oct 4, 2022 | Query
Select [DBId], count(*) from [Client] where [ClientGLAccountId] = 0 or [ClientGLAccountId] is null Group by [DBId]
by SEP | Sep 22, 2022 | Non classé
GroupActionShortcutCommentProgram operationsReport selectF12Historical Report selectAlt+F12Display all reports already launched in the current DeMasy session, and entered criteria.Exit mode or screenEscapeExit add or edit mode, if it is pending, or exit...
by SEP | Jul 4, 2022 | Query
Select [Org].[DBId] as [ResDBId], [Org].[GLAccountId] as [ResGLAccountId], [Org].[CurrencyId] as [ResCurrencyId], [Org].[Type] as [ResType], [Dest].[CyStartBalance] as [ResCyStartBalance], [Org].[CyEndBalance] as [ResCyEndBalance], [Org].[Value] as [ResOptionValue]...
by SEP | Feb 22, 2022 | Query
Select [ResInvoiceT].[DBId], [ResInvoiceT].[Number], [ResInvoiceT].[Id], [ResInvoiceT].[Type], [ResGLMovement].*, [ResInvoiceT].[Total] from (Select [GLMovement].[DBId], [GLMovement].[GLPeriodId], [GLMovement].[EntryNumber], [GLMovement].[InvoiceTId], Sum(Round(Case...