on 09-05-2008 2:35 PM
Hi Experts,
Please help me with this scenario.
I need to print the invoice date and the item description and also the due date of the invoice in an outgoing payment in PLD.
I think this can be done through wring a query in UDF through the formatted search.
Could anyone help me with an alternate solution or a step by step procedure for writing the query.
Your help is highly appreciated.
Thanks,
Hari Dharen
Hi,
Are you really wanting to have invoice date, item description and invoice due date or it is also including payment date and payment means ?
Here is the query:
SELECT distinct T1.[DocDate], T2.[Dscription],
T1.[DocDueDate] FROM VPM2 T0 INNER
JOIN OPCH T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN PCH1 T2 ON
T1.DocEntry = T2.DocEntry
Let me know if you need to know other field.
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Jimmy,
That was helpful but I need to print these due date, Invoice No., Posting date of the invoice and then the description of any one of the item in the invoice in the outgoing payment.
For eg. I am making an outgoing payment to a vendor. I need to print the Invoice's due date and posting date and then the description of any one of the item in the invoice.
Can you be more clear on how to do this in the PLD?
Thanks.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.