cancel
Showing results for 
Search instead for 
Did you mean: 

Purchase order Document date in AP Downpayment invoice PLD

Former Member
0 Kudos
100

Dear All,

Is it possible to capture purchase order Document Date in AP Down payment invoice PLD.My client want like this.I have tried,but i am not able to capture this field in AP Down payment invoice PLD.please give me the solution for this,If it is possible.

Thanks,

Silpa.N

Accepted Solutions (1)

Accepted Solutions (1)

former_member187989
Active Contributor
0 Kudos

hi silpa,

Create a user defined field in row level of marketing documents.

Apply formatted search using query

Select $[OPOR.TaxDate]

select auto refresh

when changing field Document Date in header level.

On copying purchase order to ap downpayment invoice Document date will copy to it.

U can also bring it to PLD by creating database field with table DPO1,column U_XXX

Hope it will solve problem.

Jeyakanthan

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

Since there is no link between these tables. the solution is not simple unless otherwise if you are not having any UDF it is not possible to print the PO-> taxdate in the PLD. I had tried doing some tricky method but that is also not working....

So please create a UDF and Link the Purchase order TaxDate to that column by using Formatted Search.

Regards

PL.Chidambaram

former_member187989
Active Contributor
0 Kudos

hi silpa,

Create TaxDate as a user defined field(UDF) in marketing documents title/row level,

Apply formatted search to copy Document Date(ie. TaxDate) in row level UDF of purchase order,

this will copy tax date to ap downpayment invoice,Create a database field in PLD to dispaly it.

Jeyakanthan

Former Member
0 Kudos

Hi,

If PO is the base dcument for AP down payment , then there is docdate in rowlevel in AP down payment invoice , but if u made stand alone invoice then u have to manually lnked the PO with AP Down[paymwnt invoice for which u can use UDF and allow the uswer to enter PO ref .

rgds,

Premraj

former_member187989
Active Contributor
0 Kudos

hi,

R u doing ap down payment invoice from purchase order,If yes then

refer row level DocDate in ap downpayment invoice(ie) -DPI1 - DocDate,

Jeyakanthan

Former Member
0 Kudos

Hi Jeyakanthan,

Thanks for your replay.But what i want is Document Date(Taxdate) not Posting date(DocDate) of purchase order in AP Down payment invoice.

Thanks,

Silpa.N.

Former Member
0 Kudos

Hi ,

for this u have to use query on a udf , just try with ALD , might be these issue is resolved in ALD .

Rgds,

Premraj