by SEP | Feb 22, 2022 | Query
Select [ResInvoiceF].[DBId], [ResInvoiceF].[Number], [ResInvoiceF].[Id], [ResInvoiceF].[Type], [ResGLMovement].*, [ResInvoiceF].[Total] from (Select [GLMovement].[DBId], [GLMovement].[GLPeriodId], [GLMovement].[EntryNumber], [GLMovement].[InvoiceFId], Sum(Round(Case...
by SEP | Aug 16, 2021 | Non classé
In DeMaSy, when you encode timereports, existing billing rate is used. Here you are the order of the priority (as soon as a rate is entered, it is used) :- Menu “Client”, on “Assign Employees to Job” screen (Doc 1)- Menu “Client”,...
by SEP | Oct 13, 2020 | Non classé
This screen can be launched from “General Ledger” screen (“Accounting” menu).On OK button, all the entries of the selected original GLAccount are copied. If a date is specified, the new entries will have this date, otherwise the original date...
by SEP | Aug 14, 2020 | Query
Select * from [ReminderDetail] where convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) in (Select convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) as [ResField] from [ReminderDetail] Group by [DBId], [ReminderId]...
by SEP | Jul 14, 2020 | Non classé
It is possible to create automatically credit note details based upon Invoice details. To do it, you must click on “Selection” button to prepare automation, but the details creation will be effective at the end of add mode. Then, according to the...