hi Brandon
this email is just for the sakes of complete discussion.
it is not necessary tha the update and insert methods on a table will be executed. The logic may go for doInsert and doUpdate. though I cant think of a scenario where doInsert/Update methods are called for sales table it may be worthwhile to check this out especially the modifications developed by your programmers (I have seen a lot of times that programmers will uncessarily call the doInsert/update methods).
Another problem that you are going to face is ttsabort. If a transaction is inserted into the database and later aborted then there is no easy way to get hold of this abort statement. You can avoid this problem to a great extent by putting your code after the ttscommit statement (if any) in the insert/update method
I have not checked all the code but one place where you will be completely lost will be if a piece of code is creating a sales order and there is a tts loop at the higher level. For e.g. may be creation of inter-company orders etc. Or may be auto creation of sales lines.
I would give a serious thought to writing triggers in sql server. I am aware that sql server is a black box for Axapta and believe me I personally hate doing such triggers but in your case it may be the correct way to go.
regards
harry
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Brandon George
Sent: Thursday, 30 June 2005 8:39 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Sales Order - QuestionHello all,Ok let me give you some information, that will hopefully help explain what I am trying to do. You see we have a Web Site and Database structure for that website in place. We are currently implementing Axapta, and in order not to change to much at once, we are wanting to replicate data from Axapta to our Web site database.In order to do this, I am wanting to run a piece of code every time a Sales Order is created that would replicate that Sales Order to our web site database.Does anyone have a clue as to the best way to do this? Is there a class that is always called when a new Sales Order is created? I figure SalesAutoCreate, but I am not so sure.Anyway thanks in advance! And please let me know if you don't understand that question and I can give more details!thanks,Brandon
Sharing the knowledge on Axapta.
---- LSpots keywords ?>---- HM ADS ?>
Sharing the knowledge on Axapta.
---- LSpots keywords ?>---- HM ADS ?>
Sharing the knowledge on Axapta.
---- LSpots keywords ?>---- HM ADS ?>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Sharing the knowledge on Axapta.
---- LSpots keywords ?>
---- HM ADS ?>
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.