DocStatus to display as Cancelled or Closed in query

[Former Member]

Hi Experts,

How do I distinguish between Cancelled and Closed Documents in the following query:

 SELECT T0.[DocNum], T0.[DocStatus] FROM ORDR T0 

It brings back only a C.

Any help will be apprecaited.

Marli

[Former Member · Accepted solution]

Hi Marli,

It should be:

SELECT T0.DocNum, T0.Canceled, T0.DocStatus FROM ORDR T0

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon, I am learning a lot using your book Mastering SQL Queries for SAB B1. Thanks

I have a question; regarding closing a delivery using a mouse right click.

When you close a delivery using a mouse right click (the original intention was to void or return the items to the inventory), how you reverse that mistake and where the items are in the system?

I ran an Inventory Item Audit and the merchandize was no returned to stock.

Thanks in advance for you help, Bart

[Former Member · Accepted solution]

Please post a new thread. This is the forum rule.

Thanks,

Gordon