Skip to Content
0
Former Member
Feb 17, 2009 at 05:24 AM

Help on SP_TRANSACTIONNOTIFICATION

21 Views

Hi All,

I am creating a SBO_SP_TransactionNotification message. The statement is as follows,

 
SELECT  T0.[DocNum], T0.[CardName], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity] 
FROM OINV T0  INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.DocEntry = cast(@list_of_cols_val_tab_del as int)

If i am not wrong this will return me the document no, BP Name, Posting Date, Item Code, Item Description and Item Quantity from the open document, as i am using @list_of_cols_val_tab_del on DocEntry.

But when i am debugging the same query the @list_of_cols_val_tab_del is returning the BP Name instead of DocEntry.

Can anybody clarify the same if I am right or not, as I want to have a reference to the Open Document Number in the Where Clause and Not BP Name.

Please help me resolve the issue.

Regards

Rohan S. K