James,

My thoughts exactly. It is the same approach that we use in our current
legacy system (developed in-house), so I have kind of figured that this
would be the way to go.

However, I was told that the "Rename" part is not available in any method,
but is hidden inside Axapta. This "show stopper" is very effective... :-(

/Jens
  -----Oprindelig meddelelse-----
  Fra: James Flavell [mailto:[EMAIL PROTECTED]
  Sendt: 18. november 2004 02:23
  Til: [EMAIL PROTECTED]
  Emne: RE: [development-axapta] Joining two customers into one



  How about using the same concept that is in the 'Rename' because I believe
  this uses the EDT to find every table and record in the database, just in
  your code delete the customer table record, the rest should be pretty much
  the same I would think.....

  Never tried it but its an idea for you :)

    -----Original Message-----
    From: Jens Strandberg [mailto:[EMAIL PROTECTED]
    Sent: 18 November 2004 05:18
    To: [EMAIL PROTECTED] Com (E-mail)
    Subject: [development-axapta] Joining two customers into one




    As you probably know standard Axapta does not allow you to join two
  customer
    (or supplier) records; i.e. if you have added customer A and later on by
    mistake added the same information as customer P, you cannot combine
these
    two - moving all related records from customer P to customer A.

    The only option you have is to change the primary key for a given
  customer,
    which is not very useful in this case.

    As I see it, the only way to join two customers into one is to develop
  some
    piece of code that would do the trick for you.

    Now, it would be easy to create such a script, if we could just see how
  the
    changing of the primary key is done. However, this is hidden well inside
    Axapta.

    I was wondering if any of you guys would have some ideas and pointers to
    this issue. Also, if you happen to know a solution to solve this, this
  would
    be very interesting piece of information.

    Thanks in advance.

    /Jens





          Yahoo! Groups Sponsor
                ADVERTISEMENT





  --------------------------------------------------------------------------
--
  --
    Yahoo! Groups Links

      a.. To visit your group on the web, go to:
      http://groups.yahoo.com/group/development-axapta/

      b.. To unsubscribe from this group, send an email to:
      [EMAIL PROTECTED]

      c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



  [Non-text portions of this message have been removed]





        Yahoo! Groups Sponsor
              ADVERTISEMENT





----------------------------------------------------------------------------
--
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/development-axapta/

    b.. To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]





Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links

Reply via email to