Wiki

MCM

None Defined

How to update linked BP Code on MCM Account record when BP Code is updated

The linked BP code on MCM record does not change when the BP Code is updated

Enhacements in recent SAP Business One versions allow the BP Code in the BP Master screen to be updated even when the record has associated activities and some marketing document transactions

* REQUIRED: THIS FIX NEEDS TO BE TESTED ON A TEST DATABASE PRIOR TO IMPLEMENTING IN A LIVE/PRODUCTION ENVIRONMENT * The fix described below can be implemeted by inserting the sql code privided below on the SBO_SP_PostTransactionNotice stored procedure in the SAP B1 database.

IF (@object_type = `2` AND @transaction_type in ( `U`)) BEGIN update [@twbs_mk_ocrd] set u_bpcode = @list_of_cols_val_tab_del where u_bpcode = (select cardcode from acrd where ACRD.docentry=(select docentry from ocrd where ocrd.cardcode=@list_of_cols_val_tab_del) and loginstanc = (select max(loginstanc) from ACRD where ACRD.docentry=(select docentry from ocrd where ocrd.cardcode=@list_of_cols_val_tab_del))) END

Solution

07 Jan 2014