Hi Tomasz,I would consider below scenario:Create AR Credit Memo against AR Invoice. Do NOT forget to check 'Without Qty Posting' column on item matrix as you will not physically receive inventory back at that moment.Create Return Request: When it is ...
Hi Nikunj,Please see my comments in below links:https://answers.sap.com/questions/13795327/orct-join-with-oinv-not-working-sap-business-one-h.html?source=email-global-notification-qa-new-in-tag-followed&childToView=13796434https://answers.sap.com/que...
Hi Nikunj,You probably are having an issue with DocNum.Please replace:left join ORCT T5 on T0."ReceiptNum"=T5."DocNum"with: left join ORCT T5 on T0."ReceiptNum"=T5."DocEntry"and try.Note: I wouldn't prefer using OINV."ReceiptNum" but joining RCT2 in ...
Hi Nur,I am sharing a sample below.IF @object_type = '4' and(@transaction_type='A' or @transaction_type='U' )
IF EXISTS
(
SELECT T0."ItemCode"
FROM OITM T0
WHERE T0."ItmsGrpCod" = 100 AND T0."InvntItem" <> 'Y' AND T0."ItemCode"= @list_of_...