#47 Migartion 2.5.0d to new Business Partner Sales Rep Def

R2.5.0
closed-fixed
5
2003-12-11
2003-12-11
Jorg Janke
No

On 12-10-2003 we changed/fixed the Sales Rep
definition in Business Partner.
It previously was linked to the Business Partner Sales
Rep whereas the SalesRep_ID in all other areas is a
synonym to AD_User_ID.
The following script should be run BEFORE the migration
to a later version than 2.5.0d (i.e. to CVS head/nightly
build)

Note that this script should be run only once and
BEFORE the migration.
You can run it anytime if you have a database with a
version of 1.5.0d or before.

Discussion

  • Jorg Janke

    Jorg Janke - 2003-12-11
    • summary: Migartion 2.5.0d to next Business Partner Sales Rep --> Migartion 2.5.0d to Business Partner Sales Rep
     
  • Jorg Janke

    Jorg Janke - 2003-12-11

    Logged In: YES
    user_id=87038

    You can run this script actually also after the migration.
    You would notice the need when you get 'invalid data' in
    Business Partner Sales Rep (Tab Customer).

     
  • Jorg Janke

    Jorg Janke - 2003-12-11
    • summary: Migartion 2.5.0d to Business Partner Sales Rep --> Migartion 2.5.0d to new Business Partner Sales Rep Def
    • status: open --> closed-fixed
     
  • Jorg Janke

    Jorg Janke - 2003-12-11

    BP SalesRep Data Migration Script

     
  • Jorg Janke

    Jorg Janke - 2003-12-11

    Logged In: YES
    user_id=87038

    This a SQL to check your (custom) references of SalesRep_ID

    SELECT c.AD_Column_ID, t.TableName, c.AD_Reference_ID,
    r1.Name, c.AD_Reference_Value_ID, r2.Name, c.DefaultValue
    FROM AD_Column c
    INNER JOIN AD_Table t ON (c.AD_Table_ID=t.AD_Table_ID)
    INNER JOIN AD_Reference r1 ON
    (c.AD_Reference_ID=r1.AD_Reference_ID)
    INNER JOIN AD_Reference r2 ON
    (c.AD_Reference_Value_ID=r2.AD_Reference_ID)
    WHERE ColumnName='SalesRep_ID'

    You may have to modify and run the script if you pointed
    SalesRep_ID to C_BPartner_ID.
    Note that the system assumes that SalesRep_ID is a synonym
    for AD_User_ID !

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks