a month ago
Hi experts,
I am trying to write an approval query to send vendor invoices without a base document for approval, but since the BaseType field is not a physical field, I cannot see the item and column numbers. How should I write the query? Writing it as $[$OPCH."BaseType"] does not work. Please help me.
Regards,
Request clarification before answering.
Hi,
BaseType is stored at document line level as a document may draw from multiple base documents.
When there is no base document the PCH1.BaseType will be -1. So your query could check for a MAX(PCH1.BaseType) = -1 to determine if there are no base documents. Or MIN(PCH1.BaseType) = -1 to determine if the are at least some lines without base documents.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
122 | |
10 | |
8 | |
5 | |
4 | |
4 | |
4 | |
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.