on 08-16-2016 11:44 AM
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.
Instead of Docnum you should go with Docentry..
Try with docentry...
Rgds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try DocEntry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please put one more condition Purchase order status ='O'..
Thanks..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.