Hi Jens,
Not being a real techincal person I was not aware the workings of the rename
could not be seen.
Anyway I think there have been previous posts about how to go through the
data dictionary AOT tree by code and so I guess it should still be possible
as long as you can code this and then the other part would then be coding
SQL to do the actual data rename of whatever tables are found...
My concern would be for tables that maybe dont use the custacc EDT ( such as
inventtrans account field) I guess you would have to also check the
relationships and not just the field EDTs....shame the rename code is not at
least available to review
All the best
James
-----Original Message-----
From: Jens Strandberg [mailto:[EMAIL PROTECTED]
Sent: 18 November 2004 17:19
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Joining two customers into one
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
----------------------------------------------------------------------------
--
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 | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.