Fixed - Layout files - MSSQL
Syntax near errors
CONCATENATE function {concat}
DOCUMENTLINE:Incorrect syntax near '|'.
messages.sdescription || coalesce(messages.sExtradescription,'') Description,
Change to
messages.sdescription {concat} coalesce(messages.sExtradescription,'') Description,stock.sdescription stockdesc,
Fixed all 90 document layout files in TurboCASH5.2
Fixed in document layout files in osFinancials5
TRN_1313 Delivery note
Kassabon VM - TABLENO:Invalid object name 'horecapos_seats'. (Guess it neds Horeca POS activation
DOCUMENTLINE:CLIENTLANG:'getuserlang' is not a recognized built-in function name.
Document layout TRN_906276 , TRN_906277 , TRN_906278 + TRN_1910 Layout file also in osFinancials)
NOTE Document layout (10 code) overlaps in Document lines
select {if interbase}* from GETUSERLANG {else}getuserlang() from rdb$database{endif}
added dbo.
select {if interbase}* from GETUSERLANG {else}dbo.getuserlang() from rdb$database{endif}
Data Preview OK in Reportman
CLIENTDEFLANG
select {if interbase}* from GETUSERLANG {else}getuserlang() from rdb$database{endif})
select {if interbase}* from GETUSERLANG {else}dbo.getuserlang() from rdb$database{endif}
select {if interbase}* from GETUSERLANG {else}dbo.getuserlang() from rdb$database{endif}
FIXED - Prints 0 values in Document lines Replicated in MSSQL databases
Fixed

POS A4
Purchase A4 (no codes)
Supplier return A4 (no codes)
Order A4 (no codes)
Purchase A4 (10 code)
Supplier return A4 (10 code)
Purchase A4 (15 code)
Supplier return A4 (15 code)
Order A4 (15 code)
Purchase A4 Plain (no codes)
Supplier return A4 Plain (no codes)
Order A4 Plain (no codes)
Purchase A4 Plain (10 code)
Supplier return A4 Plain (10 code)
Order A4 Plain (10 code)
Purchase A4 Plain (15 code)
Supplier return A4 Plain (15 code)
Order A4 Plain (15 code)