Hi,
As an analyst, I want to exclude from the analysis pairs of invoices that have resulted in a credit note / (canceled invoices)
Can you help with PQL query?
Thanks,
Guilherme
Page 1 / 1
You can go trough the Data with LAG(..) and order through Postin D.., when you have different status in "BSEG"."SHKZG" you can set it to 1. If you have only S or only H you set it to 0.
You can set this as a component Filter and make Invoice != (FIlter with LAG() + CASE WHEN (...)).. so you will get only the invoices which have only S or only H.
That should give you an idea how to solve it.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.