SAP Business one Query For Unapproved Sales Orders.

[former_member551008]

I Need a query to produce results with a status of "Unapproved". What field do I look at for this?

[kvbalakumar · Accepted solution]

Hi,

It is wddstatus from ORDR table 🙂

Regards,

Bala

[former_member551008 · Accepted solution]

Hello I'm sorry that does not seem to give me what I need. All of the Sales Orders are not in ODRF.

I am On Business One version 8.82 PL 12

[kvbalakumar · Accepted solution]

Answer updated...

ODRF will give all the documents went for approval whereas ORDR will give you all approved and unapproved documents. You can use the wddstatus in where condition to filter the results based on your need

[former_member551008 · Accepted solution]

I apologize I may have not fully understood what I was asking. It turns out the field I was looking for was the ORDR.Confirmed field. I thank you for your help anyway.

[former_member551008]

Please See Comments of above answer If you are still stuck like I was.