pld

[Former Member]

Hi Experts,

Is it possible to get the A/P invoice Due date in the outgoing Payment............

Regards-

Mona.

[Former Member · Accepted solution]

Hi Mona,

Yes. It is possible. However, you may need to add UDF for this purpose.

Thanks,

Gordon

[Former Member · Accepted solution]

hi,

could u pls provide the query for the same...............

regards-

mona

[Former Member · Accepted solution]

hi,

could u pls provide the query for the same...............

regards-

mona

[Former Member · Accepted solution]

Hi Mona,

I am agree with Gordon. You have to create/use existing one UDF and set one FMS on that.

You can use below query for that FMS. pls change as per requirement.

select opch.docduedatae

from opvm inner join

vpm2 on ovpm.docentry = vpm2.docnum inner join

opch on vpm2.docentry = opch.docentry

where ovpm.transid = $[ovpm.transid]

I think it may help you.

With Best Regards,

Chintesh Soni

+91-94276 08674

[Former Member · Accepted solution]

The query which you have gave i tried it out but its not working ........

[Former Member · Accepted solution]

Hi,

Try this

select opch.docduedatae

from opvm inner join

vpm2 on ovpm.docentry = vpm2.docnum inner join

opch on vpm2.docentry = opch.docentry

where ovpm.transid = $(ovpm.transid)

user squere brackets insted of common bracket

Chintesh Soni

[Former Member · Accepted solution]

Hi ,

I tried out every possibility could anyone help me out in getting the query for the same......

mona

[Former Member · Accepted solution]

Hi ,

I tried out every possibility could anyone help me out in getting the query for the same......

mona

[Former Member]

Hello mona

Edit the PLD of outgoing payment

1.Do formsetting for Outgoing payment PLD --- Enable Due date option

2.Put the the due date(1) in the PLD.

3.Now, see the print preview and check the due date(AP Invoice ) is displaying .

Thanks

Santhosh.k