Skip to Content
0

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

Apr 26, 2017 at 06:37 AM

50

avatar image
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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Danilo Kasparian Apr 26, 2017 at 03:05 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded