SAP business one Line Remarks in Journal Entry Remarks

 one of the biggest challenge every SAP  B1 Client ask . the Line Remarks (Description) to updated in

 Journal Entry .  

there is a solution available using SAP POST Transaction Notification  . 

IF @transaction_type IN ('A') AND @object_type = '13'

begin 

 UPDATE JDT1 

 SET JDT1.LineMemo=(Select INV1.Dscription from INV1  

                     inner join OINV ON INV1.DocEntry=OINV.DocEntry

Where INV1.AcctCode=JDT1.Account and INV1.LineNum=JDT1.DocLine and 

OINV.DocEntry=@list_of_cols_val_tab_del)

 FROM JDT1

 INNER JOIN OJDT ON OJDT.TransId=JDT1.TransId

 inner join OINV ON OINV.TransId=OJDT.TransId 

 inner join INV1 ON INV1.DocEntry=OINV.DocEntry

 

 Where OINV.DocEntry=@list_of_cols_val_tab_del

end

after executing the POST Transaction Notification the Journal Entry on each Add will be updated automatically with description from the Invoice .

Journal Entry Preview after Add: