Sales Order Doc Status

[Former Member]

Hi,

Where can I find the field that will report 'Open, Closed or Cancelled' in a query rather then 'O' or 'C'?

Thanks,

Robin

[jitin_chawla · Accepted solution]

Hi,

The field in the table is DocStatus in the header table i.e ORDR.

The same will be displayed in the report list as 'O' or 'C' as it is the field value. However, you can use the Case query and check whether for 'O', Open can be displayed as Alias name or not.

For example :

Select DocEntry, DocNum,

CASE when CANCELED = 'Y' then 'Cancelled' ELse 'Not Cancelled' END as [Canceled],

CASE when DocStatus = 'C' then 'Closed' Else 'Open' end as [DocStatus],

CardCode, CardName, DocTotal, VatSum

From ORDR

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Robin,

     I can't understand your problem, Can you explain

Thanks

Madeswaran P

[kothandaraman_nagarajan]

Hi Robin Bellion,

In query generator, under where clause you find open or closed status.

But in the query report, you can't see  as open, close or cancelled, it will show as C, O only and this is standard system design.