Query RelationType

Nov 3, 2020

Select * from (Select [DBId], [Id], [Label], [Inverselabel] from [RelationType]) as [Res1] INNER JOIN (Select [DBId], [Id], [Label], [Inverselabel] from [RelationType]) as [Res2] ON ([Res1].[DBId] = [Res2].[DBId] and [Res1].[Label] = [Res2].[Inverselabel] and Not...

Help About

Oct 7, 2020

...

Query Select GLYEBalance records with incorrect Period

Sep 2, 2020

Select * from [GLYEBalance] LEFT JOIN [GLPeriod] ON ([GLYEBalance].[GLPeriodId] = [GLPeriod].[Id] and [GLYEBalance].[DBId] = [GLPeriod].[DBId]) where [GLPeriod].[Id] Is Null or Not [GLYEBalance].[StartDate] = [GLPeriod].[StartDate] or Not [GLYEBalance].[EndDate] =...

Query Select client invoice details with missing stock movements for article components

Aug 15, 2020

Select [InvoiceT].[Number], [invoiceT].[Date]from ((([InvoiceTDetail] LEFT JOIN [StockTransfer]ON ([InvoiceTDetail].[Id] = [StockTransfer].[InvoiceTDetailId] and [StockTransfer].[DBId] = 1))INNER JOIN [InvoiceT]ON ([InvoiceTDetail].[InvoiceTId] = [InvoiceT].[Id] and...

Supplier Invoice (TXT)

Aug 12, 2020

SUPPLIER INVOICE (header):   RecordType;DBId;Ref;Desc;Number;SupplierName;InvoiceDate;InvoiceFCurrency;CurrencyRate;Description;Type;SupplierNumber   Nr Name Type Description 1 RecordType Long Type of object to import. Type 24 is for supplier invoice 2 DBId...