[Axapta-Knowledge-Village] AIF outbound acknowledgements

2010-01-30 Thread Ax Dev
Hi Friends,

It's regarding outbound acknowledgements. I am trying to understand if I
send some XML (let’s say COA outbound- send electronically) to external
system (let’s say using file adapter), AIF framework will create XML with
unique message id. I need the receive the acknowledgement for this message
to ensure proper delivery. How-ever, if I develop new service to receive
acknowledgement (new inbound service) from external system, how the AX AIF
will be able to understand that this XML is related to what I sent? I can
think of getting the same message id as request message id in acknowledgment
but where these message ids are being stored in AX to correlate?

It would be great if you can let me know the standard AX example that gives
acknowledgment for outbound process so that I can look into it for better
understanding. Thank you!

Regards,
HB


[Axapta-Knowledge-Village] AIF outbound acknowledgement

2010-01-30 Thread Ax Dev
Hi Friends,

It's regarding outbound acknowledgements. I am trying to understand if I
send some XML (let’s say COA outbound- send electronically) to external
system (let’s say using file adapter), AIF framework will create XML with
unique message id. I need the receive the acknowledgement for this message
to ensure proper delivery. How-ever, if I develop new service to receive
acknowledgement (new inbound service) from external system, how the AX AIF
will be able to understand that this XML is related to what I sent? I can
think of getting the same message id as request message id in acknowledgment
but where these message ids are being stored in AX to correlate?

It would be great if you can let me know the standard AX example that gives
acknowledgment for outbound process so that I can look into it for better
understanding. Thank you!

Regards,
HB


[Axapta-Knowledge-Village] Help - AIF

2010-01-26 Thread Ax Dev
Hi Friends,

I need your help to evaluate the best solution to integrate various external
systems with Dynamics AX 2009 by using AIF functionality (BizTalk/File
adaper/MSMQ). Can anyone please help to direct me to:

(a) pros  cons of using BizTalk v/s File adapter v/s MSMQ?
(b) Are all of them able to handle fail over scenarios? We need to ensure no
XML should be missed.
(c) There should be a mechanism for acknowledgement timer for example, if
acknowledgement is not received from external systems in 60 minutes, alert
(email) should be thrown.
(d) Performance benchmark.

Can you please help me in this regard? Thanks a lot in advance.

Best Regards,
PS


Re: [Axapta-Knowledge-Village] Hi

2007-11-28 Thread Ax Dev
Hi Kamaraju,

It is possible to view unposted transactions in FRx. When you open Report
designer and choose report to open, on catalog dialog box, there is a field
called Provisional. You can choose Posted + unposted activity option. Hope
it helps...

Regards,
Harsh

On Nov 22, 2007 7:16 PM, Ax Dev [EMAIL PROTECTED] wrote:

 Hi Kamaraju:

 I never tried getting UNPOSTED Transactions in FRx and also not sure
 whether it's feasibleSo it's still an open issue.

 I again tried installing seperate FRx 6.7 SP9 on seperate machine and
 integrated with Axapta 3.0, but when I am importing metadata XML, it is
 not processing that.Giving the following error in event viewer:

 'The description for Event ID ( 0 ) in Source ( FRx Dimension Wizard )
 cannot be found. The local computer may not have the necessary registry
 information or message DLL files to display messages from a remote computer.
 You may be able to use the /AUXSOURCE= flag to retrieve this description;
 see Help and Support for details. The following information is part of the
 event: Metadata processing failed. See the event log for error information.:


 TimeStamp: 11/22/2007 7:12:07 PM

 Text: Metadata processing failed. See the event log for error

 Any idea how to integration FRx 6.7 SP9 version with Axapta 3.0. It's
 failing during Meta Data processing step. Any help is really appreciated.
 Thanks!
 Regards,
 Harsh


   On 11/22/07, KamaRaju Vudata [EMAIL PROTECTED] wrote:
 
HI,
 
  Has any one worked and succeeded in getting the Un-posted Transactions
  in FRx reports ( On any version of Axapta)
 
  Please let me know ASAP.
 
  Regards,
 
  Kamaraju V
 
  [Non-text portions of this message have been removed]
 
  
 




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



[Axapta-Knowledge-Village] FRx with Dynamics Ax 4.0 Axapta 3.0 (Simultaneously)

2007-11-22 Thread Ax Dev
Hi Friends:

We have a requirement where we need to integrate FRx 6.7 SP9 with both
Dynamics Axapta 4.0 SP1 and Axapta 3.0 SP1 simultaneously. We have installed
FRx 6.7 SP9 and successfully integrated with Dyanamics Axapta 4.0 SP1, but
when I am trying to run Dimension Wizard for Axapta 3.0 and importing the
Meta Data XML file and click on process button, it is giving me error.
BottomLine is; I am not able to integrate FRx with Axapta 3.0, at the same
time it is allready working with Dynamics Ax 4.0 SP1.

Is it possible to integrate both Axapta 3.0  Dynamics Ax 4.0 at same time
with FRx 6.7 SP9? Please help if anyone has already done this.

Thanks for all your help.

Regards,
Harsh


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



Re: [Axapta-Knowledge-Village] Hi

2007-11-22 Thread Ax Dev
Hi Kamaraju:

I never tried getting UNPOSTED Transactions in FRx and also not sure whether
it's feasibleSo it's still an open issue.

I again tried installing seperate FRx 6.7 SP9 on seperate machine and
integrated with Axapta 3.0, but when I am importing metadata XML, it is not
processing that.Giving the following error in event viewer:

'The description for Event ID ( 0 ) in Source ( FRx Dimension Wizard )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description;
see Help and Support for details. The following information is part of the
event: Metadata processing failed. See the event log for error information.:


TimeStamp: 11/22/2007 7:12:07 PM

Text: Metadata processing failed. See the event log for error

Any idea how to integration FRx 6.7 SP9 version with Axapta 3.0. It's
failing during Meta Data processing step. Any help is really appreciated.
Thanks!
Regards,
Harsh


On 11/22/07, KamaRaju Vudata [EMAIL PROTECTED] wrote:

   HI,

 Has any one worked and succeeded in getting the Un-posted Transactions
 in FRx reports ( On any version of Axapta)

 Please let me know ASAP.

 Regards,

 Kamaraju V

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

 



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



Re: [Axapta-Knowledge-Village] FRx with Dynamics Ax 4.0 Axapta 3.0 (Simultaneously)

2007-11-22 Thread Ax Dev
Hi Kamaraju:

I never tried getting UNPOSTED Transactions in FRx and also not sure whether
it's feasibleSo it's still an open issue.

I again tried installing seperate FRx 6.7 SP9 on seperate machine and
integrated with Axapta 3.0, but when I am importing metadata XML, it is not
processing that.Giving the following error in event viewer:

'The description for Event ID ( 0 ) in Source ( FRx Dimension Wizard )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description;
see Help and Support for details. The following information is part of the
event: Metadata processing failed. See the event log for error information.:


TimeStamp: 11/22/2007 7:12:07 PM

Text: Metadata processing failed. See the event log for error

Any idea how to integration FRx 6.7 SP9 version with Axapta 3.0. It's
failing during Meta Data processing step. Any help is really appreciated.
Thanks!
Regards,
Harsh



On 11/22/07, KamaRaju Vudata [EMAIL PROTECTED] wrote:

   Hi all,

 I have two queries on FRx.

 Does FRx support sub ledger reporting?

 I have created a new account and posted transactions, but I am not able to
 view them in the Frx Reports.

 Please help me.

 Regards,

 Kamaraju

 _

 From: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ax Dev
 Sent: Thursday, November 22, 2007 1:47 PM
 To: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] FRx with Dynamics Ax 4.0  Axapta 3.0
 (Simultaneously)

 Hi Friends:

 We have a requirement where we need to integrate FRx 6.7 SP9 with both
 Dynamics Axapta 4.0 SP1 and Axapta 3.0 SP1 simultaneously. We have
 installed
 FRx 6.7 SP9 and successfully integrated with Dyanamics Axapta 4.0 SP1, but
 when I am trying to run Dimension Wizard for Axapta 3.0 and importing the
 Meta Data XML file and click on process button, it is giving me error.
 BottomLine is; I am not able to integrate FRx with Axapta 3.0, at the same
 time it is allready working with Dynamics Ax 4.0 SP1.

 Is it possible to integrate both Axapta 3.0  Dynamics Ax 4.0 at same time
 with FRx 6.7 SP9? Please help if anyone has already done this.

 Thanks for all your help.

 Regards,
 Harsh

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

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

 



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



Re: AW: [Axapta-Knowledge-Village] COMPANY NAME ID 3 chars???

2007-02-25 Thread Ax Dev
We can't change the company code length from 3char.

Regards,
Harsh


On 2/22/07, sherin francis [EMAIL PROTECTED] wrote:

   And how would that be?

 p.saravanakumar [EMAIL PROTECTED]p.saravanakumar%40tvssons.com
 wrote: Thru AOT You can change it

 Regards

 P Saravanakumar
 Co-Its
 09894999281
 -Original Message-
 From: sherin francis [mailto:[EMAIL PROTECTED] sherin_gf%40yahoo.com]
 Sent: Wednesday, February 21, 2007 3:36 PM
 To: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: Re: AW: [Axapta-Knowledge-Village] COMPANY NAME ID  3 chars???

 Hi Tobias,

 Thanks for the reply... but just wondering... u had mentioned that an
 increase in this field would increase the whole database, how would this
 increase be possible? Would it be through SQL Server directly? since, i
 haven't found any way of increasing this field directly through the
 AOT...

 Rgds,
 Susy

 Andrae, Tobias tobias.andrae@
 mailto:tobias.andrae%40stz-loerrach.de stz-loerrach.de wrote:
 Hi Susy,
 the company ID (== DataAAreaID) is an system type and thus it cannot be
 changed. In addition, always keep in mind, that this field is part of
 *all* tables and any increasing would increase the whole database...
 hth Tobias

 

 Von: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com im Auftrag von dyna_ax
 Gesendet: Mi 21.02.2007 05:39
 An: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com
 Betreff: [Axapta-Knowledge-Village] COMPANY NAME ID  3 chars???

 Hi Group,

 Is it possible to have the company name id more than 3 characters?
 If so, any insight on how it is to be done would be helpful...

 Thanks,
 Susy

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

 -
 Don't be flakey. Get Yahoo! Mail for Mobile and
 always stay connected to friends.

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

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

 -
 Want to start your own business? Learn how on Yahoo! Small Business.

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

 



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



[Axapta-Knowledge-Village] Can we directly email reports(PDF Format) using configured OUTLOOK

2007-02-22 Thread Ax Dev
Hi Friends,

Can you please help me to handle this situation? We need general
functionality of sending emails (attachment or text body) using *OUTLOOK*.
(Outlook is to keep track of history in 'Sent items').

To broader the picture, we would be creating Sales order using AIF and
post(Invoice) it and invoice report needs to be send to customer's email id
without any manual intervention through configured OUTLOOK. We would just
like to use OUTLOOK only for maintaing some history in sent items. We would
be implementing this in Dynamics Ax 4.0 so we can use features available in
Dynamics.

Can you please help me with your valuable suggestions?

Thanks  Regards,
Harsh


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



Re: [Axapta-Knowledge-Village] Master Planning Help

2007-01-31 Thread Ax Dev
Hi Hemant,

Thanks for you suggestion. It really helped, but the customer doesn't want
Coverage planning by warehouse. In this case, Manual check box wouldn't
work.

Is there any other option? I explored ReqCalc class - newQueryInventTrans.
In this method, data is fetched from InventTrans by Grouping of few fields.
If I can place one more line of code to add sorting like:
qBSTrans.addSortField(FieldNum(InventTrans,InventDimId));

Then inventTrans would always have InventDimId, and we can have a seperate
table to store warehouses and can match warehouses and avoid those
transactions to enter in ReqTrans table. In this way, we can ignore
transaction of warehouses.

But i am just wondering how add a sorting on InventDimId can affect the MP
System? Can anybody suggest me please?

Thanks for your help.

Regards,
harsh


On 1/29/07, Hemant Kumthekar [EMAIL PROTECTED] wrote:

   Hi,

 Check the warehouse setupyou will find the check box to ignore
 Planning for that warehouse, and hope that you have your item dimension
 group to have coverage planning by warehouse.

 Hemant K

 - Original Message 
 From: Ax Dev [EMAIL PROTECTED] axdevl%40gmail.com
 To: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Sent: Monday, January 29, 2007 8:29:14 AM
 Subject: [Axapta-Knowledge-Village] Master Planning Help

 Hi Friends,

 I need your help releated to Master Planning. Is there a way to make MP
 ignore Purchase/Sales/ Inventory transactions that belongs to a particular
 warehouse during Master Scheduling run?

 Is there any setup kind of thing sothat MP should not look any transaction
 belong to a particular warehouse? I tried it through code and achieved it,
 but my concern is; if there is any such setup exists then why we need any
 customization.

 Please write me back your suggestions!

 Thanks  Regards,
 Harsh Birla

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

 __
 Need Mail bonding?
 Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users.
 http://answers.yahoo.com/dir/?link=listsid=396546091

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

 



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



[Axapta-Knowledge-Village] Master Planning Help

2007-01-29 Thread Ax Dev
Hi Friends,

I need your help releated to Master Planning. Is there a way to make MP
ignore Purchase/Sales/Inventory transactions that belongs to a particular
warehouse during Master Scheduling run?

Is there any setup kind of thing sothat MP should not look any transaction
belong to a particular warehouse? I tried it through code and achieved it,
but my concern is; if there is any such setup exists then why we need any
customization.

Please write me back your suggestions!

Thanks  Regards,
Harsh Birla


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



Re: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

2006-12-18 Thread Ax Dev
Hi Friends,


It was asked from one of our costumers as well. Does anyone has the
solution of how to provide the same kind of user input in Ax4.0 as we have
in Ax3.0?

It is something very interesting and we are curious to know about it. Please
share your views.

Thanks  Regards,
Harsh


On 12/18/06, John Lindsay [EMAIL PROTECTED] wrote:

   You can use the runas command to change the user

 Confidentiality Notice: This e-mail contains confidential and/or
 privileged
 information and is intended to be read only by the person or authorized
 representative of the organization to whom it is addressed. If you are
 neither of these persons, you have received this e-mail in error. Please
 do
 not print, copy, re-transmit, disseminate or otherwise use the
 information,
 all of which are prohibited. Please immediately notify the sender by
 return
 e-mail or by telephone at (303) 593-1246 that you have received this
 communication in error and delete this e-mail from your system. Thank you.

 MBS Dynamics AX Master

 John T. Lindsay

 Micro Sciences

 303 593-1246

 720 982-4620

 _

 From: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Andreas
 Rudischhauser
 Sent: Saturday, December 16, 2006 4:48 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: AW: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

 Please contact Mr. Schuster on schuster(AT)back2.biz.

 Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com]
 Im Auftrag von Hardi
 Gesendet: Samstag, 16. Dezember 2006 00:52
 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com
 Betreff: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

 As Ax40 is integrated with active directory, I think what is
 required is to prompt user to re-enter login/password when
 application started.
 This is something being asked too from my customer.

 Thanks

 Hardi

 --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoog
 roups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com , Jake
 [EMAIL PROTECTED] wrote:
 
  Hi Andreas -
 
  Do you have any info on how this is being done? Are you doing a
  second Active Directory login?
 
  Thanks, Jake
 
  http://axaptasource http://axaptasource.com .com
 
  --- In Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com , Andreas
  Rudischhauser Andreas.Rudischhauser@ wrote:
  
   We're currently in development. I will post the link here in a
 few
  days
  
  
  
   Von: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
   [mailto:Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com ] Im Auftrag von
  Agus
   Riyadi
   Gesendet: Donnerstag, 14. Dezember 2006 03:14
   An: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
   Betreff: [Axapta-Knowledge-Village] Ax 4.0 login screen as 3.0
  
  
  
   Hi All,
  
   Is there any setting or workaround so that user can have a login
  screen
   in
   Axapta 4.0 like in 3.0 ?
  
   Thanks,
  
   Agus
  
   [Non-text portions of this message have been removed]
  
  
  
  
  
   [Non-text portions of this message have been removed]
  
 

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

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

 



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



Re: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!

2006-12-18 Thread Ax Dev
Hi Harry,

I also have some problem related to Master Planning where InventSumLogTTS
table is the main culprit. We had a client with huge database, and they
tried to run Master Planning using Principle as Regeneration. It took more
than 8 hours for execution and at last it gives the error like Deletion of
records from InventSumLogTTS table exhausted the memory. We analyzed the
code and found that during Regeneration, we don't need the records in
InventSumLogTTS table(as these are required for Incremental Run). So we
created a truncate job to delete the records from InventSumLogTTS table
before Regeneration Run. And now it took around 1 hour and it executed
successfully. Now the problem is; if we are doing Incremental Run, it took
more than 3 hours, which is not exceptable from client's point of view, if
Regeneration is taking 1 hour, then Incremental Run should take less than
that. But Incremental Run is using records from InventSumLogTTS table, we
can't delete/truncate this table. Do you have any suggestions how to improve
the Incremental Run process, it would be really helpful.?


Thanks  Regards,
Harsh



On 12/18/06, Harry Deshpande [EMAIL PROTECTED] wrote:

   Hi

 It looks like the problem is with InventSumLogTTS and not with master
 planning.

 Check the records in inventsumlogtts after each step (the steps are
 slightly different)

 i.e

 1. create sales order
 2. create purchase order
 3. receive item
 4. post sales

 Ideally you should have records created in InventSumLogTTS after each
 step. Please also try this on standard installation.

 regards

 harry

 
 From: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com[mailto:
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ricardo Cortés
 Sent: 18 December 2006 02:00
 To: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature
 at the sales line

 Hi Harry,

 I'm running in ax 3.0 sp 5.

 After invoice the first sales order there isn't any record on that table
 (InventSumtts) for the item. There are only two records on inventSum table.
 The net requirement form for that item shows two lines with on hand, one
 with positive quantity and other with negative quantity.

 Do you know what is happening?

 Regards

 Ricardo Cortes

 Harry Deshpande [EMAIL PROTECTED] harryd%40microsoft.commailto:
 harryd% harryd%2540microsoft.com escribió:
 hi

 Which version are you running?

 You will have to do some investigation

 after you invoice the first sales order, what are the records in
 InventSumLogtts table?

 regards

 harry

 
 From: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com [
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo
 Cortés [EMAIL PROTECTED]ricardocortesrivero%40yahoo.com.mx
 mailto:ricardocortesrivero%40yahoo.com.mx]
 Sent: Friday, December 15, 2006 10:53 PM
 To: foro
 Subject: [Axapta-Knowledge-Village] Problem with the explosion feature at
 the sales line

 Hi all,

 I've been having troubles with the explosion at the sales line, it is
 showing that i have inventory on hand when there isn't.

 The scenario to reproduce teh problem is:

 Create a sales order for an item without inventory on hand
 Run the explosion from the sales line
 The explosion form will show you a planned purchased order, this is
 correct.
 Firm the planned purchased order, receive the item and invoice the sales
 order.

 Create a new sales order for the same item (the item don't have inventory)
 Run the explosion from the sales line again
 The explosion form will show that the item has inventory onhand when the
 reality there isn't.

 If you check the net requirement thru the sales order you can see that
 axapta is showing two lines in on hand one with a positive quantity and
 other with neative. So, like axapta is seeing lines with on hand for this
 item is not calculating the requirement and is not plannig the purchase
 order.

 I know that Axapta in the explosion only take into account a few
 transaction for the item, but in this case it seems that is not settling the
 previous transaction and that is why the result from the explosion is wrong.

 Only running the Master planning for all the items in the regeneration
 mode fix the problem.

 Does any one have an idea of what is happening or if this is a bug?

 Thanks in advance

 Ricardo Cortes

 __
 Correo Yahoo!
 Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
 Regístrate ya - http://correo.yahoo.com.mx/

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

 -
 Do You 

Re: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!

2006-12-18 Thread Ax Dev
Hi Harry,

Yes, I was referring 'Net Change'. We ran Regeneration for the whole system.
And after one week of last Regeneration Run, we were using 'Net change'
instead of 'Regeneration', because it make sense to run the master planning
for the last one week. But during the one week period, records are created
in InventSumLogTTS table very rapidly. So it took more than 3 hours which is
not acceptable from clients' point of view. So just curious to know is there
any way to improve the execution time of 'Net change' for this one week of
records?

Otherwise, we need to convince them to use Regeneration all the time as it
is taking 1 hour of time frame, after using the clean job of InventSumLogTTS
table.

Thanks  Regards,
Harsh


On 12/18/06, Harry Deshpande [EMAIL PROTECTED] wrote:

   Hi

 What is incremental run? Are you referring to net change? The assumption
 that incremental run should take less time that regeneration is not correct.
 If you have a huge number of records in InventSumLogTTS table then
 regeneration is faster than net change.

 Why do you run net change for the complete system at all? Why not just
 regeneration?

 Regards

 Harry

 
 From: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com[mailto:
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ax Dev
 Sent: 18 December 2006 12:18
 To: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] Problem with the explosion feature
 at the sales line

 Hi Harry,

 I also have some problem related to Master Planning where InventSumLogTTS
 table is the main culprit. We had a client with huge database, and they
 tried to run Master Planning using Principle as Regeneration. It took more
 than 8 hours for execution and at last it gives the error like Deletion of
 records from InventSumLogTTS table exhausted the memory. We analyzed the
 code and found that during Regeneration, we don't need the records in
 InventSumLogTTS table(as these are required for Incremental Run). So we
 created a truncate job to delete the records from InventSumLogTTS table
 before Regeneration Run. And now it took around 1 hour and it executed
 successfully. Now the problem is; if we are doing Incremental Run, it took
 more than 3 hours, which is not exceptable from client's point of view, if
 Regeneration is taking 1 hour, then Incremental Run should take less than
 that. But Incremental Run is using records from InventSumLogTTS table, we
 can't delete/truncate this table. Do you have any suggestions how to
 improve
 the Incremental Run process, it would be really helpful.?

 Thanks  Regards,
 Harsh

 On 12/18/06, Harry Deshpande [EMAIL PROTECTED]harryd%40microsoft.com
 mailto:harryd% harryd%2540microsoft.com wrote:
 
  Hi
 
  It looks like the problem is with InventSumLogTTS and not with master
  planning.
 
  Check the records in inventsumlogtts after each step (the steps are
  slightly different)
 
  i.e
 
  1. create sales order
  2. create purchase order
  3. receive item
  4. post sales
 
  Ideally you should have records created in InventSumLogTTS after each
  step. Please also try this on standard installation.
 
  regards
 
  harry
 
  
  From: 
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 Axapta-Knowledge-Village%40yahoogroups.com[mailto:
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 Axapta-Knowledge-Village%40yahoogroups.com]
  On Behalf Of Ricardo Cortés
  Sent: 18 December 2006 02:00
  To: 
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 Axapta-Knowledge-Village%40yahoogroups.com
  Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion
 feature
  at the sales line
 
  Hi Harry,
 
  I'm running in ax 3.0 sp 5.
 
  After invoice the first sales order there isn't any record on that table
  (InventSumtts) for the item. There are only two records on inventSum
 table.
  The net requirement form for that item shows two lines with on hand, one
  with positive quantity and other with negative quantity.
 
  Do you know what is happening?
 
  Regards
 
  Ricardo Cortes
 
  Harry Deshpande [EMAIL PROTECTED] harryd%40microsoft.commailto:
 harryd% harryd%2540microsoft.com harryd%40microsoft.commailto:
  harryd% harryd%2540microsoft.com escribió:
  hi
 
  Which version are you running?
 
  You will have to do some investigation
 
  after you invoice the first sales order, what are the records in
  InventSumLogtts table?
 
  regards
 
  harry
 
  
  From: 
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com

Re: [Axapta-Knowledge-Village] Re: RecId Query

2006-12-03 Thread Ax Dev
Hi Maverick,

In Axapta 3.0, the recid field is of 32bits (i.e. 4 bytes). In Dynamics 4.0,
there is an improvement for RecId. Now recid is of 64bits(i.e. 8 Bytes). So
it is a great improvement in terms of number of recid in 4.0.

Regards,
Harsh


On 11/29/06, joeinvcost [EMAIL PROTECTED] wrote:

   Maverick,
 As I understand it, RecId (in 3.0) goes from 0 to 20, then
 switches sign and proceeds from -20 back toward zero. When
 it passes zero and starts numbering forward again, you'll be OK until
 it tries to duplicate an ID already in the same table (RecID numbers
 are assigned globally but uniqueness is at the table level), at which
 point you will be screwed. I also understand this changes in later
 versions such that each table gets its own 4 billion RecIds. But I
 could be wrong about all of this.

 --- In 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
 Maverick
 [EMAIL PROTECTED] wrote:
 
  Hi Harryya pretty curious..till yet not reached the
 limit.but what to do with that problem if it happens...
  man has the power to reach anywhere..thats y man reached
 moon...recid will reach to the limit...share this issueand find
 the solution .and find reasons to celeberate and drink beers.
 
  Regards
  Maverick.
 
 
  - Original Message -
  From: Harry Deshpande
  To: 
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
  Sent: Monday, July 03, 2006 9:37 PM
  Subject: RE: [Axapta-Knowledge-Village] RecId Query
 
 
  Hi Maverik
 
  Curious, have you reached this limit?
 
  Regards
 
  harry
 
  
 
  From: 
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
  [mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of
 Maverick
  Sent: 3. juli 2006 09:15
  To: 
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
  Subject: [Axapta-Knowledge-Village] RecId Query
 
  Hi All,
  What are the consequenses if recid reaches to its limit and how to
  resolve the problem.
 
  Thanks
  Maverick
 
  [Non-text portions of this message have been removed]
 
  [Non-text portions of this message have been removed]
 
 
 
 
 
  [Non-text portions of this message have been removed]
 

 



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



Re: [Axapta-Knowledge-Village] AIF in Ax 4.0

2006-11-28 Thread Ax Dev
Hi Yogesh,

Thanks for your help. Let me try this wizard, then i will get back to you.

Regards,
Harsh Birla


On 11/27/06, yogesh kasat [EMAIL PROTECTED] wrote:

   Hi Harsh,

 This can be done using AXD Wizard.

 ToolsDevelopement toolsWizardsAxd wizard.

 Please get back, if you need any more info.

 Regards,
 Yogesh Kasat

 --- harshbirla_cse [EMAIL PROTECTED] axdevl%40gmail.com wrote:

  Hi Friends,
 
  We are trying to use AIF(Application Integration
  Framework) which is
  one of the special features of Dynamics Ax 4.0
 
  There are some predefined AIF functionality to
  Import/Export XML
  files. For example, we can create Sales Order
  through XML using AIF.
  But if I would like to import Customers through XML,
  there is no
  such predefined AIF class/function exists. Becasue
  we have to
  integrate Customers, Sales Orders, Fixed Assests,
  AR, AP through
  AIF, but only few predefined AIF classes exists.
 
  So we need to create our own customized classes
  based on predefined
  AIF classes for integration.
 
  Can you please suggest is it good to create
  customized AIF class
  (for example: Customers) or should we go with .NET
  COM connector?
 
  I appreciate your help. Thank You!
 
  Regards,
  Harsh
 
 

 __
 Do you Yahoo!?
 Everyone is raving about the all-new Yahoo! Mail beta.
 http://new.mail.yahoo.com

 



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



[Axapta-Knowledge-Village] Query: Data Upgradation from Ax 3.0 to Dynamics Ax

2006-05-19 Thread Ax Dev



Hi Friends,

I got stuck with a problem and need your valuable suggestions.

One of our clients is upgrading from Axapta 3.0(with SP2) to TAP Drop
3(Dynamics Ax 4.0). We have performed Code upgradation successfully. The
next step is: Data Upgradation.

As per the Aximpguide.chm(help book), two projects (provided in Tap Drop 3
DVD) needs to be imported.
1. For left justify all the fields in Database
2. In Ax 3.0 all recid's  Trans Id's are of 32 bits, but in Dynamics Ax,
these are of 64 bits.
**
*Now the problem is in the second step. In UpgradeColumnList.xpo, When i
open UpgradeColumnList form, it identifies all the tables  their relavent
fields that are based on RecId or TransId. But I can't understand how to
upgrade the memory allocation of these fields to 64 bits from 32 bits.*

Please share your experience and give me your suggestion what to do to solve
this. Also let me know what are the other things that needs more
consideration.

Thank you in anticipation.

-Harsh


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







Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  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.



  












Re: [Axapta-Knowledge-Village] beginner

2006-03-16 Thread Ax Dev
Hi Naushad,

Christoph wrote a well organized way to start learning Ax. Here are few more
suggestion, if you would be able to arrange this;

1. You can use Microsoft e-learning courses. These are paid, can ask yr
company admin to arrange for the same.
2. There are four Developers guides(manuals) provided by Microsoft. These
are really good. You can read it and then try to answer the questions at the
end of each chapter.

You know, there is no such book for Ax, but practise is more important.

Wish You all the Best
Harsh



On 3/17/06, Christoph Malherbe [EMAIL PROTECTED] wrote:

 Hi Naushad,

 There is no absolutely RIGHT WAY of obtaining knowledge about this or
 any
 other topic in life. You have to find something that works for you.

 I'm also still relatively green in the Ax space, but here goes some
 practical advice

 1. get the product installed
 2. read through the dev guide, best practice guide etc A FEW TIMES(don't
 worry if you don't catch on after reading these documents once or twice)
 3. look at the tutorials(objects starting with tutorial_ in the AOT)
 4. look at the postings on this and other forums that deal with Ax
 technicial topics on a daily basis. Try to understand what the issues and
 solutions are
 5. look at some historical postings on the forums.
 6. try to get a highlevel handle on the functional side of the
 application.
 7. most importantly : if you don't understand something, try it again and
 again and again...

 Good luck.

 Christoph


 -Original Message-
 From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On Behalf Of naushad2911
 Sent: 16 March 2006 12:24 PM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: [Axapta-Knowledge-Village] beginner



 Hi all
 I've just started a new job and i'll be trained to be an Axapta
 technical consultant but my team (of 6 peaple)is very busy in the
 ongoing projects.so they asked me to learn by myself.I'd like some
 advice on how to go about learning Axapta the Right way. Also tell me
 what are the pre-requisites for learning Axapta.
 I have a computer science degree before I started this job so I
 would appreciate anyone who has a bit of experience in Axapta saying hi
 and giving me a few pointers.

 Regards,
 Naushad









 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends.
 Yahoo! Groups Links











 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends.
 Yahoo! Groups Links









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



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

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

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 




Re: [Axapta-Knowledge-Village] Report needed to be printed on Excel

2006-01-24 Thread Ax Dev
Thanks Kumar,

As what i know, the methods related to COM  COMVariant classes can be find
under System Documentation-Classes-COM  System
Documentation-Classes-COMVariant, you will find all the supported methods.

Regards,
Harsh

On 1/25/06, kumar gaurav [EMAIL PROTECTED] wrote:

 Hi,

 I belive it is a runtime error and it is only because component object in
 excel doesn't support bookmark method. I think you can take a look at the
 methods which are supported by excel, the problem is that there is no
 compete lising of these methods in any axapta help file and you will have to
 explore it through ms excel macro library and any VB programmer could be
 more helpful.

 anyone ! can you please tell us that where we could find a listing of all
 the methods supported by com and com varient classes.

 bye

 Ax Dev [EMAIL PROTECTED] wrote:
 Thanks Kumar,

 I have generated a class using COM connection. I have created the
 bookmarks
 in the excel sheet itself. But when i am trying to use those labels using
 the method like this:


 COMCOMBookMarks,COMBookMark,COMRange;
 DictField  dictField;
 Label  label;
 ;

 COMBookMarks   =   _COMWorksheet.*bookMarks()*;
 if(COMBookMarks.exists('label_header'))
 {
 COMBookMark =  COMBookMarks.item('label_header');
 COMRange=  COMBookMarks.range();
 COMRange.insertAfter(InventoryList);
 }

 it shows the error that method *bookMarks() *doesn't exist in COM class.

 Can you plz provide solution for this?

 Thanks  Regards

 Harsh







 On 1/23/06, kumar gaurav [EMAIL PROTECTED] wrote:
 
  hi harsh,
 
  COM connector is the best way to do it, I don't see anyother way to
 print
  such report.
 
  You can use COM and COMVarient class for such report.
 
  bye
 
  Kumar
 
 
  Ax Dev [EMAIL PROTECTED] wrote:
  Hi Friends,
 
  There is a requirement of such a report form my client, that it needs to
  be
  directly open to Microsoft Excel sheet when we click on OK button when
  report interface opens.
 
  Is COM connection a good way to do so?
 
  Please suggest me how to do it?
 
  Thanks  Regards,
  Harsh
 
 
  [Non-text portions of this message have been removed]
 
 
 
  Sharing the knowledge on Axapta.
  Visit www.frappr.com/axapta for axapta friends.
 
 
 
  SPONSORED LINKS
 Business finance course   Business to business finance   Small
  business finance Business finance consultant   Business finance
  magazine   Business finance schools
 
  -
  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.
 
 
  -
 
 
 
 
 
  Send instant messages to your online friends
 http://in.messenger.yahoo.com
 
  [Non-text portions of this message have been removed]
 
 
 
  Sharing the knowledge on Axapta.
  Visit www.frappr.com/axapta for axapta friends.
  Yahoo! Groups Links
 
 
 
 
 
 
 


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



 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends.



 -
 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.


 -





 Send instant messages to your online friends http://in.messenger.yahoo.com

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



 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends.
 Yahoo! Groups Links









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



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

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

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





[Axapta-Knowledge-Village] Report needed to be printed on Excel

2006-01-23 Thread Ax Dev
Hi Friends,

There is a requirement of such a report form my client, that it needs to be
directly open to Microsoft Excel sheet when we click on OK button when
report interface opens.

Is COM connection a good way to do so?

Please suggest me how to do it?

Thanks  Regards,
Harsh


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



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

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

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 





Re: [Axapta-Knowledge-Village] Report needed to be printed on Excel

2006-01-23 Thread Ax Dev
Thanks Kumar,

I have generated a class using COM connection. I have created the bookmarks
in the excel sheet itself. But when i am trying to use those labels using
the method like this:


 COMCOMBookMarks,COMBookMark,COMRange;
 DictField  dictField;
 Label  label;
 ;

 COMBookMarks   =   _COMWorksheet.*bookMarks()*;
 if(COMBookMarks.exists('label_header'))
 {
 COMBookMark =  COMBookMarks.item('label_header');
 COMRange=  COMBookMarks.range();
 COMRange.insertAfter(InventoryList);
 }

it shows the error that method *bookMarks() *doesn't exist in COM class.

Can you plz provide solution for this?

Thanks  Regards

Harsh







On 1/23/06, kumar gaurav [EMAIL PROTECTED] wrote:

 hi harsh,

 COM connector is the best way to do it, I don't see anyother way to print
 such report.

 You can use COM and COMVarient class for such report.

 bye

 Kumar


 Ax Dev [EMAIL PROTECTED] wrote:
 Hi Friends,

 There is a requirement of such a report form my client, that it needs to
 be
 directly open to Microsoft Excel sheet when we click on OK button when
 report interface opens.

 Is COM connection a good way to do so?

 Please suggest me how to do it?

 Thanks  Regards,
 Harsh


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



 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends.



 SPONSORED LINKS
Business finance course   Business to business finance   Small
 business finance Business finance consultant   Business finance
 magazine   Business finance schools

 -
 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.


 -





 Send instant messages to your online friends http://in.messenger.yahoo.com

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



 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends.
 Yahoo! Groups Links









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



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends. 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

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

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 




Re: [Axapta-Knowledge-Village] Urgent

2006-01-02 Thread Ax Dev



Hi Dhanashree,

There are some2 types of Architecture available.

2 Tier: The2-tier architectureconsists of a database server that contains the business data, and a file server that contains application files and the client directly communicate with these two servers.Thats' whyrequires high-capability computers for the users(
FAT Client)and a strong network as well.

3 Tier: Here AOS(Appication Object Server) works as mediator. The client communicates bia AOS. The business logics execute on AOS and the client is only used for user interaction. 


The difference between this installation and the two-tieris that with three-tier architecture, part of the application is executed on the client and another part on the AOS.All user interface-related processes are executed on the thin client computers operated by the users, and all business logic is executed on the AOS. 

 In 3-tier architecture, you can have both the THIN and FAT clients. When using THIN client, the client communicates to AOS and the AOS communicates to DataBase Server. When using 
FAT client, the client communicates to AOS and DataBase Server directly.

While doing installation, you don't need to specify the AOS setting with 2-tier architecture and in case of 3 tier, you need to specify, the path of the application and the AOS server name.

Thanks  Regards,
Harsh Birla
On 1/2/06, dhanashreebhagwat16 [EMAIL PROTECTED] wrote:
Hello,What is the difference between two tier and three tier clientinstallation?Does ax32.exe have the capability to run the aod files?
thanks,Dhanashree.Sharing the knowledge on Axapta.Visit www.frappr.com/axapta for axapta friends.Yahoo! Groups Links* To visit your group on the web, go to:
 http://groups.yahoo.com/group/Axapta-Knowledge-Village/* To unsubscribe from this group, send an email to: 
[EMAIL PROTECTED]* Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/







Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  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.



  









Re: [Axapta-Knowledge-Village] Queries

2005-12-29 Thread Ax Dev



ThanksVarden,

Great, really a good knowledgable materail it is. 

Thanks  Regards,
Harsh Birla
On 12/30/05, Varden Morris [EMAIL PROTECTED] wrote:



What is the difference between Primary Index and Cluster Index? Where to use these two?

There are two main types of indexes that we can have on a Microsoft SQL Server backend Database. These are normal
 and clustered indexes. Normal index can be viewed as the index in the back of a book. We first look in the index for a topic. After finding the topic in alphabetical order we also find the page number or address of the topic in the book. We then use the address to easily find the topic. If we did not have this index we would have to search sequentially through the book and the larger the book the greater the effort and time to either find a topic or realize that it does not exist. 


This is similar to a normal index in the database where we have the data stored in one file and the index stored in another file in the order specified. The database engine using the index will first look in the index file then retrieve the address of the record that is used to locate the record in the data file.


For clustered index the records in the data file are sorted in the order of the index. We therefore do not have a separate index file from the data file as we have for 
normal index. You should also note that it is only possible to have one clustered index per table, since the records may only be sorted in one order at any time. You can have several normal indexes and one clustered index for each table. 
Clustered indexes are more efficient since the index is the actual data records and hence you do not need to seek in another file after finding the key.

The Primary Index of a table is the main index that is used to uniquely identify records in it. No duplicated values are allowed in this index and all fields in the index are required. You can designate a 
clustered or normal index as the primary index. Since the primary index is the main index you should gain optimum performance by designating a clustered index for this purpose.

Please note that indexes in general improve performance for search but not for inserts or update, since the overhead of organizing and or writing the index is involved.



Can we define Global Methods in Axapta? If yes then how and where?
 
Yes we can. Look at the Global class. Just write a static method in this class and you will be able to call is anywhere in the application.
 



What is difference between Axapta Kernel and Axapta Application?In a 3-tier installation Axpata Application is stored on AOS, what about the kernel?


I would say that the kernel is that part of the application that is not exposed to the developer for altering. The behavior of the kernel is encapsulated in the application and is automatically executed as originally intended. For example, when a record is saved the kernel automatically assigns a RECID to the RECID field.


The AOS is a windows service that loads and executes the application in memory on the local computer where it is installed. The application may be placed on a drive on the computer running the AOS or on a network share.
harshbirla_cse [EMAIL PROTECTED] wrote: 
Hi All,I am having some queries. Please write me back with your valuable suggestions:1. What is the difference between Primary Index and Cluster Index? 
Where to use these two? 2. Can we define Global Methods in Axapta? If yes then how and where?3. What is difference between Axapta Kernal and Axapta Application?In a 3-tier installation Axpata Application is stored on AOS, what 
about the kernal?Please write me back.Thanks a lotRegards,Harsh








Varden Morris Senior Developer WellPoint Systems Inc. 
Microsoft Gold Certified Partner
(403) 444-5848 direct (403) 444-3900 main 
(403) 615-1604 cellwww.wellpoint.ca 
[EMAIL PROTECTED]


Yahoo! ShoppingFind Great Deals on Holiday Gifts at 
Yahoo! Shopping Sharing the knowledge on Axapta.Visit www.frappr.com/axapta
 for axapta friends. 
SPONSORED LINKS 




Business finance course 

Business to business finance 

Small business finance 


Business finance consultant 

Business finance magazine 

Business finance schools 


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.











Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.





  




  
  
  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.



  









Re: [Axapta-Knowledge-Village] Query about RecID and ID

2005-12-12 Thread Ax Dev



Hi Gan,

Thanks a lot for your reply. This is really valuable for me. 

Thanks  Regards
Harsh
On 12/13/05, S.C.GAN [EMAIL PROTECTED] wrote:
Hi Harsh,1) The kernel generates the RecIds. Insert record.Rec id is a reference that each record in the database
gets.It is unique in each company.2) Id? you mean Object Id? Object id is an internalreference in Axapta to reference the objects in theapplication.3) Refer to CustTable.modifiedField public method.
Last statement --this.AddressMap::modifiedField(_fieldId);Regards,S.C.GAN--- harshbirla_cse [EMAIL PROTECTED] wrote: Hello Everyone,
 I am new to the Axapta world. I need your suggestions.I have some questions: 1. where(Application/Kernal/Database/Forms) and when the RecID is generated?Please also write us back why RecID's
 are useful? If you have any related material then plz provide it to me. 2. What is the difference between a RecID and an Id? 3. When we open the CustTable form, there is a tab Address. When we
 enter the street address and move out the cursor from that control, the address will get displayed in the adjacent box. Can you plz help me how it can be implemented? Thanks a lot.
 Regars, Harsh  Yahoo! Groups Sponsor ~-- Help Sudanese refugees rebuild their lives through
 GlobalGiving.http://us.click.yahoo.com/V42rFC/EbOLAA/cosFAA/kGEolB/TM~-
 Sharing the knowledge on Axapta. Yahoo! Groups Linkshttp://groups.yahoo.com/group/Axapta-Knowledge-Village/
 [EMAIL PROTECTED]__
Do You Yahoo!?Tired of spam?Yahoo! Mail has the best spam protection aroundhttp://mail.yahoo.com Yahoo! Groups Sponsor ~--
For $25, 15 Afghan women can learn to read. Your gift can make a difference.http://us.click.yahoo.com/rQ8GtB/SdGMAA/cosFAA/kGEolB/TM~-
Sharing the knowledge on Axapta.Yahoo! Groups Links* To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email to: [EMAIL PROTECTED]* Your use of Yahoo! Groups is subject to:
 http://docs.yahoo.com/info/terms/






Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  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.