[development-axapta] Data migration speed

Does anyone have any benchmarks for data import speed into Axapta from legacy systems? Specifically customers and business relations are taking a much longer time to import than I would anticipate. Are there any optimal configurations for the AOS server concerning data importing?

RE: [development-axapta] Virtual Company Accounts

I confirm that using virtual company accounts you can have 10 companies sharing the CustTable and others having their own CustTable. That's because you can select which companies should belong to the virtual company. I haven't heard of anything gone wrong so far. The only issues were when

RE: [development-axapta] Virtual Company Accounts

You are absolutely right. You define which company accounts that should share certain tables belonging to a virtual company. You will notice that the virtual company account ID will be the DataAreaID on the shared tables. And so not all company accounts needs to included in the virtual

AW: [development-axapta] Virtual Company Accounts

Hi Jens Actually the setup you describe is really possible. For the virtual company accounts, you create table collections where you define which tables are to be shared. In the virtual company, you select table collection(s) and companies which should be part of that virtual company. So

RE: [development-axapta] Select statement and month

Hi ukmar, You may try to code the select statement something like this: dtDate = str2date(strFmt('1/%1/2004', intMonth), 123); select sum(amount) from myTable where myTable.TransDate = dtDate myTable.TransDate = endmth(dtDate); Regards, Sonny Wibawa Adi [EMAIL PROTECTED]

RE: [development-axapta] Select statement and month

you probably have to use a temporary table and aggregate manually into that to achieve your goal in X++ it will however be much slower (on a big table) to do so. It is not so difficult to write connection statements for mssql oracle to retrieve the data regardless of back-end; you will

[development-axapta]

Hi, Can Someone please explain how we can create a report have it batched for a daily occurence, and have a date field in the query to represent the Previous two days from today, EG Run report this morning, at the moment I need to manual change the dates to the 241104..251104. PLEASE

RE: [development-axapta] Virtual Company Accounts

yes, you're right. You *can* ommit companies from sharing tables - which is pretty neat if you have companies that differ totally from your main ones no need to worry, just remember to assign all companies to the group pieter _ From: Jens Strandberg [mailto:[EMAIL PROTECTED] Sent:

[development-axapta] Re: SalesParmLine and SalesParmTable

Delete them: Accounts receivable\Periodic\Clean up\Sales update history clean up Regards, D. Higi --- In [EMAIL PROTECTED], Matt Benic [EMAIL PROTECTED] wrote: Hi All, We implemented Axapta to not keep sales line data but to delete the sales order lines and headers once invoiced.

[development-axapta] Retrieve user name of logged on user

Hi All, What method would I use to retrieve the user name of a logged on user? Thanx Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group,

RE: [development-axapta] Virtual Company Accounts

Thanks for all the feedback regarding this issue. Any real life experience with the fact that bringing many customers into one shared table may confuse users ? Example: Company A: 25 customers Company B: 800 customers Company C: 175 customers After putting these customers into a shared

[development-axapta] Re: Retrieve user name of logged on user

Hi, You can use CurUserId() You can view all the built-in functions under system documentation\Functions regards, Karsten Wollesen Clausen Thy Data Center Development A/S --- In [EMAIL PROTECTED], Gundwale [EMAIL PROTECTED] wrote: Hi All, What method would I use to retrieve the

AW: [development-axapta] Virtual Company Accounts

Hi Jens, you could use record level security to filter the required custtable records and use a dimension therefore. But what would be the benefit of the shared table then? Regards Andreas Gahr -Ursprüngliche Nachricht- Von: Jens Strandberg [mailto:[EMAIL PROTECTED] Gesendet:

RE: [development-axapta] Retrieve user name of logged on user

(select firstonly Name from UserInfo where UserInfo.id == curUserId()).name -Original Message- From: Gundwale [mailto:[EMAIL PROTECTED] Sent: Thu 11/25/2004 12:09 To: [EMAIL PROTECTED] Cc: Subject: [development-axapta] Retrieve user name of logged on user Hi All,

Re: [development-axapta] Retrieve user name of logged on user

curuserid() should help you here... --- Gundwale [EMAIL PROTECTED] wrote: Hi All, What method would I use to retrieve the user name of a logged on user? Thanx = Paulius Cerniauskas Phone: +37065923155 ICQ: 280959446 __ Do you

[development-axapta] Axapta SP2 Problem.

dear all, i m new to axapta, so please forgive if i have asked a stupid question. i have enabled the 'print grand total' check box under the print options to print a report, however, one of the colunm seems did not sum up the values, but the others did. what will be the possible cause of

RE: [development-axapta] Virtual Company Accounts

One of the advantages for sharing the table is to avoid duplicating customers because some of them may be common to several companies. So it could be necessary that every company be allowed to access the whole list. The users can filter the records that they want to see by using the

[development-axapta] Com+ Connector

Hello, at the moment I am running a system online with one com connector. Has anybody expierence how to use more than one com connector on one system ? Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go

Re: [development-axapta] Re: Retrieve user name of logged on user

Thanx On Thu, 25 Nov 2004 09:19:05 -, kwc_thydev [EMAIL PROTECTED] wrote: Hi, You can use CurUserId() You can view all the built-in functions under system documentation\Functions regards, Karsten Wollesen Clausen Thy Data Center Development A/S --- In [EMAIL

SV: [development-axapta] Virtual Company Accounts

Andreas, Shared tables are - in my opinion at least - beneficial to the accounting department, when you run centralized book-keeping for many companies. This is the case here. It would be nice sometimes to have features and setup's that _all_ users will be happy about ... :-) Best

[development-axapta] StringEdit in form

I need to assign a value to a StringEdit in a method under the form. The name of the StringEdit is StringEdit:Komp1 but i dosn't work to do this StringEdit:komp1 = a; in a method under the StringEdit Thanks in adv. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo!

SV: [development-axapta] Add a new field to a table from X++ code

Hi! Does anyone know how to add a new field to a table using the Treenode-class? I want to do something like this: First locate the fields-path in the AOT for a given table; treenode = treeNode::findNode(#TablesPath + '\\' + dicttable.name() + \\Fields); Then I want to add a field like

[development-axapta] Re: StringEdit in form

It works fine when i put the komp1.text(dgfsgsg); under a button but how do i updated the stringedit so there are values for the user when the form is opened. --- In [EMAIL PROTECTED], Palle Mølgaard [EMAIL PROTECTED] wrote: In the methods under a control (a stringedit or any other

[development-axapta] Load form from a object

Can any one tell me how to load a form from a object this dosn't seem to work: KompForm Komp; Komp = new kompform; Anything else that i should be aware of ? Thanks in adv. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group

RE : [development-axapta] Re: StringEdit in form

Take a look at ForecastSales form. The macro part at the end of the ClassDeclaration list saved values. You'll need both lines in init() and close() that starts with xsysLastValue. Methods you'll also need on your form : lastValueDataAreaId() pack() unpack() lastValueDesignName()

RE: [development-axapta] Load form from a object

FormRun fr; Args arg = new Args(); ; arg.name(formstr('FormNAme')); fr = ClassFactory.formRunClass(arg); fr.init(); fr.run(); //fr.detach(); //fr.wait(); -- Roberto Ukmar Indis S.p.A. Can any one tell me how to load a form from a object this dosn't seem to work: KompForm Komp; Komp

[development-axapta] send email from EP

Hi, I need to send an email from enterprise portal. how to do that? are there any examples in axapta or in EP webForms? I try to do like this: SysInetMail sysInetMail = new sysInetMail(); ; sysInetMail.sendMail([EMAIL PROTECTED], hee, some txt, false); but system hangs up when reaches this

RE: [development-axapta] Load form from a object

FormRun fr; Args arg = new Args(); ; arg.name(formstr('FormNAme')); fr = ClassFactory.formRunClass(arg); fr.init(); fr.run(); //fr.detach(); //fr.wait(); -- Roberto Ukmar Indis S.p.A. Can any one tell me how to load a form from a object this dosn't seem to work: KompForm Komp; Komp

RE: [development-axapta] network folders

if your example is real life it will fail as you try to make a share on the server - not a directory you can only create a new directory under a share (and must have permissions on the share to do so) ie pad = MyServer\\MyShare\\Temp; Pieter _ From: byteway_so

[development-axapta] Re: network folders

You are right peter ;-) But even then when this MyShare is dedicated to me (with all rights + grant options) It is still not possible to check wether this directory exists (and create it if it's missing) or not. When debugging the WinApi::PathExists(), there was something I noticed: the

RE: [development-axapta] send email from EP

I would check out the dundas (free) mailer program to achieve your goal Pieter _ From: Paulius Cerniauskas [mailto:[EMAIL PROTECTED] Sent: 25. november 2004 15:35 To: [EMAIL PROTECTED] Subject: [development-axapta] send email from EP Hi, I need to send an email from

[development-axapta] Select distinct

Hi, How can i implement Select distinct SQL clause in Axapta or is there any possibility to do so. Thanks in advance... Ýbrahim Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go

RE: [development-axapta] Select distinct

With Current Axapta version, I am under the belief that you have to use group by. I think, that in later future versions it will be implemented. Tony = Tony DePalo B.Comp. Technical Services Consultant Moore Stephens Technology Australia Business

Re: [development-axapta] Select distinct

Hello, Ibrahim. Try do this: while select Field from Table group by Field Alexandr - Original Message - From: Ibrahim Kilicarslan To: [EMAIL PROTECTED] Sent: Thursday, November 25, 2004 10:46 PM Subject: [development-axapta] Select distinct Hi, How can i implement

RE: [development-axapta] Select distinct

Not really possible Maybe redefine your where clause or use ”firstonly”, if you only want one row Or use a direct SQL statement Best Steen _ From: Ibrahim Kilicarslan [mailto:[EMAIL PROTECTED] Sent: 25. november 2004 21:47 To: [EMAIL PROTECTED] Subject:

YNT: [development-axapta] Select distinct

Dear Ibrahim, You can use Group by. select field from table group by field _ Kimden: Ibrahim Kilicarslan [mailto:[EMAIL PROTECTED] Tarih: 25 Kasm 2004 Perembe 21:47 Kime: [EMAIL PROTECTED] Konu: [development-axapta] Select distinct Hi, How can i implement Select