Transaction notification for Good Reciept PO can't be enter before AP Down Payment against PO

[Former Member]

Hi Everyone,

i want to make a store procedure for Good reciept PO would not be enter if AP down Payment is not enter for PO in case of Advance PO.i have problem in my query but it don't allow every PO .

IF @transaction_type IN ('A') AND @object_type = '20' begin IF EXISTS (Select DPO1.BaseRef from DPO1 INNER JOIN POR1 ON POR1.DocEntry = DPO1.BaseEntry AND POR1.LineNum = DPO1.BaseLine and DPO1.BaseType=POR1.ObjType INNER JOIN OPOR ON OPOR.DocEntry=POR1.DocEntry INNER join pdn1 on pdn1.BaseLine = por1.LineNum AND pdn1.BaseEntry = por1.DocEntry and pdn1.Basetype=por1 .ObjType where PDN1.DocEntry <> @list_of_cols_val_tab_del and OPOR.GroupNum=1) begin set @error =19 set @error_message = 'Please Enter Down Payment Invoice before GRN..' end end

[former_member233854]

Hi,

As far as I know you can`t connect a AP Down Payment to a Goods Receipt PO. The only document connect to a AP Down Payment in this case would be the AP Invoice.

Maybe I didn`t understand what are you trying to do.