on 06-30-2015 12:53 PM
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
Hi,
Why you need FMS?
System automatically updates PO number at Remarks column in AP Down payment invoice.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Justice,
Please explain your requirement clearly.
Thanks
Unnikrishnan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.