cancel
Showing results for 
Search instead for 
Did you mean: 

Link buttons are opening document of 2014 which is cancelled instead of opening 2016, SAP B1 9.1.

former_member183402
Participant
0 Kudos

Hi all,

I have a problem of purchase order in SAP B1 9.1.

I created a query which will display all open purchase orders the result of my query is correct, but the problem I have is if I click link button of document number of purchase order of 2015 or 2016 it opens the purchase order of 2014 which is cancelled, I do know why.

Let me use screenshot in order to understand

The all link buttons are opening that purchase order in first line.

How can I solve this the problem?

Please anyone can help me.

Accepted Solutions (1)

Accepted Solutions (1)

KennedyT21
Active Contributor
0 Kudos

Instead of Docnum you should go with Docentry..

Try with docentry...

Rgds

Answers (3)

Answers (3)

Former Member
0 Kudos

try DocEntry

agustin_marcoscividanes
Active Contributor
0 Kudos

Hi

modify the SELECT and include as first field the docentry.

The docnum may be not unique, and the docentry will be.

Kind regards

Agustín Marcos Cividanes

former_member183402
Participant
0 Kudos

Thank you all.

former_member237214
Participant
0 Kudos

Hi,

Please put one more condition Purchase order status ='O'..

Thanks..

former_member183402
Participant
0 Kudos

Yes, I tried to do that but the problem is still same.