Print Date of original invoice in credit note PLD

[former_member1133820]

Hi all.

I wish to print the number & date of the original invoice in credit note.

I can find RPC1.BaseDocNum as the original invoice number and trying to use FMS for the date of original invoice.

I have created one UDF, InvoiceDate at Marketing Documents Title and applied the following query:

SELECT T0.[DocDate] FROM OPCH T0 WHERE T0.[DocNum] =$[RPC1.BaseDocNum]

when DocNum field changes.

but how to get the original invoice date automatically when the user added the credit note? Which field should I use for the changes to be triggered?

First, I was managed to get the invoice date by manually refresh the UDF after added the credit note but suddenly it shows 'Incorrect syntax near 'RPC1.BaseDocNum'

Please guide me on the above issue.

Thanks & BR,

Leng

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this FMS and set auto refresh option to Refresh regularly.

SELECT T0.[DocDate] FROM OPCH T0 WHERE T0.[DocNum] = $[$38.44.number]

Thanks & Regards,

Nagarajan

[former_member1133820 · Accepted solution]

Thanks, Naga.

You are genius!

How about AR CN?

SELECT T0.[DocDate] FROM OINV T0 WHERE T0.[DocNum] = ???

Thanks & BR,

Leng

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try:

SELECT T0.[DocDate] FROM OINV T0 WHERE T0.[DocNum] = $[$38.44.number]

Thanks & Regards,

Nagarajan

[former_member1133820 · Accepted solution]

Hi Naga,

Just now I tried the same query and it shows error message but after a while the FMS is working fine.

Thanks & BR,

Leng