cancel
Showing results for 
Search instead for 
Did you mean: 

Purchase Order Number Copy

millicentdark
Contributor
0 Kudos

Hi Experts,

i want a query i can use for FMS to copy or replicate a purchase order number when i am copying from PO to Down payment AP invoice

regards

Justice

Accepted Solutions (0)

Answers (2)

Answers (2)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Why you need FMS?

System automatically updates PO number at Remarks column in AP Down payment invoice.

Thanks.

former_member212181
Active Contributor
0 Kudos

Hi Justice,

Please explain your requirement clearly.

Thanks

Unnikrishnan

millicentdark
Contributor
0 Kudos

i want to do a formatted search on an invoice with a purchase order number;

i wrote this

select $[$8.0.0] but it did not work

Regards

Justice

former_member212181
Active Contributor
0 Kudos

Hi,

Please try below query for FMS.

Select Top 1 PONo from

(

SELECT Top 1 T0.[DocNum] [PONo]

FROM OPOR T0

WHERE $[$38.43.0] ='22'  and $[$38.45.0] =T0.DocEntry

Union

SELECT Top 1 T0.[DocNum] [PONo]

FROM OPOR T0

Inner Join POR1 T1 On T0.DocEntry = T1.DocEntry

Left Outer Join PDN1 T2 on T2.BaseType =22 and T2.BaseEntry = T1.DocEntry and T2.BaseLine = T1.LineNum

WHERE $[$38.43.0] ='20'  and $[$38.45.0] = T2.DocEntry and $[$38.46.0] = T2.LineNum

)

A

Thanks

Unnikrishnan