cancel
Showing results for 
Search instead for 
Did you mean: 

Document Status Name

kedalenechong
Participant
0 Kudos

Hi all

Is it possible to display in Query Document Status Name like in full instead of O and C?

Kedalene

View Entire Topic
Former Member
0 Kudos

Hi,

yes it is possible through case Statement.

Try below for AR Invoice

Select OINV.DocNum,OINV.Docdate,OINV.CardCode,OINV.DocStatus,

Case when OINV.DocStatus = 'O' then 'Open'

When OINV.DocStatus = 'C' then 'Closed'

end as DocStatus

from OINV

Thanks,

Harshal