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)