Re: [Axapta-Knowledge-Village] RE: Temp tables
Hi James, I do not think that SQL aggregate functions work for temp tables. I read that it does not work for set base operations (insert, update and delete). Set base operations are always down graded for all temp tables. This is because temp tables use the windows file system unlike SQL database requests that are passed to a server service that process the request and send back the result. The file system is a direct call to the data on disk without a middle tier service to enhance the performance. Regards, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 (780) 716-8604 (c) www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: James Flavell To: Axapta-Knowledge-Village@yahoogroups.com Sent: Fri, July 30, 2010 11:15:45 PM Subject: [Axapta-Knowledge-Village] RE: Temp tables Sorry I also meant to ask if I have a temp table and use SQL commands like sum and count is there still any benefits or actually this is the same as using a while select? Thanks J From:James Flavell [mailto:djf1994@ gmail.com] Sent: 31 July 2010 13:05 To: 'Axapta-Knowledge- vill...@yahoogro ups.com' Subject: Temp tables Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% … I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James
[Axapta-Knowledge-Village] Debugging DAX 2009 via SOAP client
Has anyone been able to step into the debugger via a soap client? I am using a soap client tool called eviware soapUI and I have done the setups for debugging via EP and I have no success to date. Thanks, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 (780) 716-8604 (c) www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
Re: [Axapta-Knowledge-Village] Re: How can I pass parameter from a form to a class?
Set the datasource property of the menuitem on the form to the required
datasource on the form. In the main method of the class there is an Args
parameter. Declare the table in the main method and set it to the record
property of the Args parameter. Something like this:
static void main(Args _args)
{
PurchTable purchTable;
;
if (_args.dataset() != tablenum(PurchTable)
throw error(strfmt("Method %1 was called with an invalid record",
funcname()));
purchTable = _args().record();
}
I assume that PurchTable is the table buffer being passed from the form
datasource.
Regards,
Varden Morris
Varalth Solutions Inc.
693 Abbottsfield Road NW
Edmonton, Alberta T5W 4R4
Canada
(780) 752-0406
(780) 716-8604 (c)
www.varalth.com
CONFIDENTIALITY NOTICE
This message and any attachments are confidential. If you have received this
transmission in error, please be advised that any disclosure, copying,
distribution or action taken in reliance upon this communication is strictly
prohibited. If you have received this communication in error, please contact
the sender immediately. Please note that any views or opinions presented in
this email are solely those of the author and do not necessarily represent
those of the company. Finally, the recipient should check this email and any
attachments for the presence of viruses. The company accepts no liability for
any damage caused by any virus transmitted by this email.
From: girac127
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, September 10, 2009 1:30:25 PM
Subject: [Axapta-Knowledge-Village] Re: How can I pass parameter from a form to
a class?
Anitha,
Thank you for your reply, On my form I have a grid with the PurchID as one
value. On this form I added a MenuAction to point my my class.
In my class I have the query "while select PurchTable where PurchTable.PurchId
== 'PurchIDValueFromFo rm'"
this create my text file as I expect. but I need to change the
"PurchIDValueFromFo rm" for each selected record that I create file from.
What is the way to accomplish this
I have tried your suggestion however it is not pulling the right data related
to the selected record.
Regards
G
--- In Axapta-Knowledge- vill...@yahoogro ups.com, Anitha S
wrote:
>
> I could not get the clear picture of ur query. I understood the first part
> of it.
> Try this.
> From your question , i understud PURCHID is in the datasource.
> So you can directly use it as *datasourcename. PurchID or
> FormControName. text()* and pass it as parameter to the class method.
> Else you can pass the Table as parameter.
>
> Hope it helps!!!
>
> Regards,
> Anitha
>
> On Thu, Sep 10, 2009 at 6:34 AM, girac127 wrote:
>
> >
> >
> > Hello all,
> >
> > I have created a job to query and create file. I will drag that into a
> > class.
> > Now I need to to pass a parameter from my form (the PurchTable.PurchID
> > field of the record that is selected) to the class and use that as my
> > parameter in my query.
> > How can I accomplish this?
> >
> > Best regards
> > G
> >
> >
> >
>
Re: [Axapta-Knowledge-Village] what is wrong with my display method
Where is this display method, on the BOM table? The problem is with BOM.ItemId.
You need to change it to this.ItemId.
Regards,
Varden Morris
Varalth Solutions Inc.
693 Abbottsfield Road NW
Edmonton, Alberta T5W 4R4
Canada
(780) 752-0406
(780) 716-8604 (c)
www.varalth.com
CONFIDENTIALITY NOTICE
This message and any attachments are confidential. If you have received this
transmission in error, please be advised that any disclosure, copying,
distribution or action taken in reliance upon this communication is strictly
prohibited. If you have received this communication in error, please contact
the sender immediately. Please note that any views or opinions presented in
this email are solely those of the author and do not necessarily represent
those of the company. Finally, the recipient should check this email and any
attachments for the presence of viruses. The company accepts no liability for
any damage caused by any virus transmitted by this email.
From: NITIN DESALE
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, August 20, 2009 9:38:00 PM
Subject: Re: [Axapta-Knowledge-Village] what is wrong with my display method
Hi Anitha,
LegacyBPNbr field not in InventTable, hence its throwing an error
or that field may be user define field which should added in InventTable ,if
its check the link.
Nitin
--- On Thu, 20/8/09, Anitha S wrote:
>From: Anitha S
>Subject: Re: [Axapta-Knowledge- Village] what is wrong with my display method
>To: Axapta-Knowledge- vill...@yahoogro ups.com
>Date: Thursday, 20 August, 2009, 5:21 PM
>
>
>
>Check if LegaacyBPNbr is in InventTable.
>
>
>On Wed, Aug 19, 2009 at 9:43 PM, riz_dynamics wrote:
>
>
>>display LegacyBPNbr LegacyBPNbr( )
>>{
>>
>>return inventTable: :find(BOM. ItemId).LegacyBP Nbr;
>>
>>}
>>I am getting the error that table does not contain this field, and I can see
>>the item Id field on Bom.
>>I really appreciate the help
>>
>>
>
Love Cricket? Check out live scores, photos, video highlights and more. Click
here.
Re: [Axapta-Knowledge-Village] Re: Not enough rights to use table 'Item configurations' (ConfigTable).
You are most welcome. -Varden From: Girac To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, July 31, 2009 12:39:28 PM Subject: [Axapta-Knowledge-Village] Re: Not enough rights to use table 'Item configurations' (ConfigTable). Thats what I had to set. Thank you Varden. --- In Axapta-Knowledge- vill...@yahoogro ups.com, Varden Morris wrote: > > Ok, the configuration key should be enabled. Otherwise you would not see the > table in the AOT. Did you try removing the security key value from the table? > The configuration keys associated with this table are in the Logistics > hierarchy. Go to Administration -> Setup -> Systems -> > Configuration.�Ensure that all the children nodes are enabled. > � > Regards, > � > Varden Morris > Varalth Solutions Inc.�� > 693 Abbottsfield Road NW > Edmonton, Alberta T5W 4R4 > Canada > (780) 752-0406 > (780) 716-8604 (c) > www.varalth. com� > > CONFIDENTIALITY NOTICE� > � > This message and any attachments are confidential.� If you have received > this transmission in error, please be advised that any disclosure, copying, > distribution or action taken in reliance upon this communication is strictly > prohibited.� If you have received this communication in error, please > contact the sender immediately. Please note that any views or opinions > presented in this email are solely those of the author and do not necessarily > represent those of the company.� Finally, the recipient should check this > email and any attachments for the presence of viruses. The company accepts no > liability for any damage caused by any virus transmitted by this email. > > > > > _ _ __ > From: Girac > To: Axapta-Knowledge- vill...@yahoogro ups.com > Sent: Friday, July 31, 2009 11:20:56 AM > Subject: [Axapta-Knowledge- Village] Re: Not enough rights to use table 'Item > configurations' (ConfigTable) . > > � > Here is a sillier question? How do I verify that it is enabled? I did remove > the key and was still unable to access the table through the TableBrowser in > AOT. > > Thanks > > G > > --- In Axapta-Knowledge- vill...@yahoogro ups.com, Varden Morris > wrote: > > > > This might be a silly question but do you know if the configuration > > key�used by that table is enabled? > > � > > Regards, > > � > > Varden Morris > > Varalth Solutions Inc.�� > > 693 Abbottsfield Road NW > > Edmonton, Alberta T5W 4R4 > > Canada > > (780) 752-0406 > > (780) 716-8604 (c) > > www.varalth. com� > > > > CONFIDENTIALITY NOTICE� > > � > > This message and any attachments are confidential.� If you have received > > this transmission in error, please be advised that any disclosure, copying, > > distribution or action taken in reliance upon this communication is > > strictly prohibited.� If you have received this communication in error, > > please contact the sender immediately. Please note that any views or > > opinions presented in this email are solely those of the author and do not > > necessarily represent those of the company.� Finally, the recipient > > should check this email and any attachments for the presence of viruses. > > The company accepts no liability for any damage caused by any virus > > transmitted by this email. > > > > > > > > > > _ _ __ > > From: Girac > > To: Axapta-Knowledge- vill...@yahoogro ups.com > > Sent: Friday, July 31, 2009 10:25:46 AM > > Subject: [Axapta-Knowledge- Village] Not enough rights to use table 'Item > > configurations' (ConfigTable) . > > > > � > > Hell all, > > I am logged in as admin and I have checked group permissions and all > > are set to full control. However I get this error when I try to access > > the ConfigTable. I cannot access this the table directly from the AOT > > or a form in the MRP area. Can anyone offer assistance on this, > > > > Regards > > > > G > > >
Re: [Axapta-Knowledge-Village] Re: Not enough rights to use table 'Item configurations' (ConfigTable).
Ok, the configuration key should be enabled. Otherwise you would not see the table in the AOT. Did you try removing the security key value from the table? The configuration keys associated with this table are in the Logistics hierarchy. Go to Administration -> Setup -> Systems -> Configuration. Ensure that all the children nodes are enabled. Regards, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 (780) 716-8604 (c) www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Girac To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, July 31, 2009 11:20:56 AM Subject: [Axapta-Knowledge-Village] Re: Not enough rights to use table 'Item configurations' (ConfigTable). Here is a sillier question? How do I verify that it is enabled? I did remove the key and was still unable to access the table through the TableBrowser in AOT. Thanks G --- In Axapta-Knowledge- vill...@yahoogro ups.com, Varden Morris wrote: > > This might be a silly question but do you know if the configuration key used > by that table is enabled? > > Regards, > > Varden Morris > Varalth Solutions Inc. > 693 Abbottsfield Road NW > Edmonton, Alberta T5W 4R4 > Canada > (780) 752-0406 > (780) 716-8604 (c) > www.varalth. com > > CONFIDENTIALITY NOTICE > > This message and any attachments are confidential. If you have received this > transmission in error, please be advised that any disclosure, copying, > distribution or action taken in reliance upon this communication is strictly > prohibited. If you have received this communication in error, please contact > the sender immediately. Please note that any views or opinions presented in > this email are solely those of the author and do not necessarily represent > those of the company. Finally, the recipient should check this email and any > attachments for the presence of viruses. The company accepts no liability for > any damage caused by any virus transmitted by this email. > > > > > _ _ __ > From: Girac > To: Axapta-Knowledge- vill...@yahoogro ups.com > Sent: Friday, July 31, 2009 10:25:46 AM > Subject: [Axapta-Knowledge- Village] Not enough rights to use table 'Item > configurations' (ConfigTable) . > > > Hell all, > I am logged in as admin and I have checked group permissions and all > are set to full control. However I get this error when I try to access > the ConfigTable. I cannot access this the table directly from the AOT > or a form in the MRP area. Can anyone offer assistance on this, > > Regards > > G >
Re: [Axapta-Knowledge-Village] Not enough rights to use table 'Item configurations' (ConfigTable).
This might be a silly question but do you know if the configuration key used by that table is enabled? Regards, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 (780) 716-8604 (c) www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Girac To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, July 31, 2009 10:25:46 AM Subject: [Axapta-Knowledge-Village] Not enough rights to use table 'Item configurations' (ConfigTable). Hell all, I am logged in as admin and I have checked group permissions and all are set to full control. However I get this error when I try to access the ConfigTable. I cannot access this the table directly from the AOT or a form in the MRP area. Can anyone offer assistance on this, Regards G
Re: [Axapta-Knowledge-Village] Re: Calling EXE file form Ax Menu
You are most welcome. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 (780) 716-8604 (c) www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: dgreatone123 To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, July 13, 2009 10:25:23 AM Subject: [Axapta-Knowledge-Village] Re: Calling EXE file form Ax Menu Hi Morris, Thanks for your reply. I'll try to do as you told me and see if it works. regards, D' great --- In Axapta-Knowledge- vill...@yahoogro ups.com, Varden Morris wrote: > > That method is designated to run on the client. As a matter of fact the > WinAPI class is designated to run on the client. If you are using 4.0 or > higher there is a WinAPIServer class that runs on the server but it does not > have all the methods that the WinAPI class has. Try copying the shellExecute > method to a new class and change the client modifier to server. This will > enable the method to run on the server. With that said I don’t think it is > best practice to execute DLL on the server. > > > Varden Morris > Varalth Solutions Inc.  > 693 Abbottsfield Road NW > Edmonton, Alberta T5W 4R4 > Canada > (780) 752-0406 > (780) 716-8604 (c) > www.varalth. com >  > > CONFIDENTIALITY NOTICE >  > This message and any attachments are confidential. If you have received > this transmission in error, please be advised that any disclosure, copying, > distribution or action taken in reliance upon this communication is strictly > prohibited. If you have received this communication in error, please > contact the sender immediately. Please note that any views or opinions > presented in this email are solely those of the author and do not necessarily > represent those of the company. Finally, the recipient should check this > email and any attachments for the presence of viruses. The company accepts no > liability for any damage caused by any virus transmitted by this email. > > --- On Sun, 7/12/09, dgreatone123 wrote: > > > From: dgreatone123 > Subject: [Axapta-Knowledge- Village] Re: Calling EXE file form Ax Menu > To: Axapta-Knowledge- vill...@yahoogro ups.com > Date: Sunday, July 12, 2009, 7:32 PM > > > > > > > > > I want to convert the client side batch to server side. > the batch call a bat file. In client mode it work fine, I used the > winapi:shellexecute method. But in server mode, this winapi:shellexecute is > not > available. > > The bat contain the ftp I.P. while the config file contain the user/password > to > the ftp and the directory where I want to move the file from my local drive to > ftp folder. > any idea how to convert this batch to server mode? > > thanks > > --- In Axapta-Knowledge- vill...@yahoogro ups.com, "Arijit Basu" > wrote: > > > > Hi Kapil, > > use WinAPI::shellExecut e(); > > > > Cheers > > > > Arijit Basu > > > > On Thu, May 1, 2008 at 6:47 PM, anuprkl wrote: > > > > > Hi! > > > Is it possible to call any EXE file from menu item in Axapta 3.0. > > > For example I want to call xyz.exe form AR>Report>"Call XYZ". > > > > > > If I click on this Menu then the xyz.exe file should run. > > > Thanks > > > Kapil > > > > > > > > > > > > > > > > > -- > > > > > > Arijit Basu > > >
Re: [Axapta-Knowledge-Village] Re: Calling EXE file form Ax Menu
That method is designated to run on the client. As a matter of fact the WinAPI class is designated to run on the client. If you are using 4.0 or higher there is a WinAPIServer class that runs on the server but it does not have all the methods that the WinAPI class has. Try copying the shellExecute method to a new class and change the client modifier to server. This will enable the method to run on the server. With that said I don’t think it is best practice to execute DLL on the server. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 (780) 716-8604 (c) www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. --- On Sun, 7/12/09, dgreatone123 wrote: From: dgreatone123 Subject: [Axapta-Knowledge-Village] Re: Calling EXE file form Ax Menu To: Axapta-Knowledge-Village@yahoogroups.com Date: Sunday, July 12, 2009, 7:32 PM I want to convert the client side batch to server side. the batch call a bat file. In client mode it work fine, I used the winapi:shellexecute method. But in server mode, this winapi:shellexecute is not available. The bat contain the ftp I.P. while the config file contain the user/password to the ftp and the directory where I want to move the file from my local drive to ftp folder. any idea how to convert this batch to server mode? thanks --- In Axapta-Knowledge- vill...@yahoogro ups.com, "Arijit Basu" wrote: > > Hi Kapil, > use WinAPI::shellExecut e(); > > Cheers > > Arijit Basu > > On Thu, May 1, 2008 at 6:47 PM, anuprkl wrote: > > > Hi! > > Is it possible to call any EXE file from menu item in Axapta 3.0. > > For example I want to call xyz.exe form AR>Report>"Call XYZ". > > > > If I click on this Menu then the xyz.exe file should run. > > Thanks > > Kapil > > > > > > > > > > -- > > > Arijit Basu >
Re: [Axapta-Knowledge-Village] Create a new form
For #2 you can actually use an existing security key in the application. For example, if the form will be in the inventory module in the same area as the item master table you may use the same security key as that on the inventory table. If you should do that the users who have access to the inventory table will have the same access to your new table. You should also have a security key on the menu item that opens the form. Regards, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Sunday, June 7, 2009 9:28:08 AM Subject: Re: [Axapta-Knowledge-Village] Create a new form 1) Set the Width and Height properties to Column Width and Column Height respectively and do likewise for all container controls such as Grid and Tabs. 2) Create a new security key in the AOT and select it as the Security Key property value for the table on the form. Create a User Group in the user interface and associate it with the security key selected on the table. Set the required access rights for the user group. You may need to create more than one user group for different access rights. 3) You could set your new EDT to extend the TransDate EDT. Look at the properties of the TransDate EDT to see how it’s done. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth. com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: tarek adel To: Axapta-Knowledge- vill...@yahoogro ups.com Sent: Sunday, June 7, 2009 7:33:54 AM Subject: [Axapta-Knowledge- Village] Create a new form Dear all, I have created a new form, but I need your help in couple of things: 1) What is the "Properties" I should adjust to make the "Form" resizable. 2) How I can active "User group permission" for the "Form" as of it's available and the choices for "No access, add, read, and full control" are dimmed. 3) I have created an "Extended Data Type" as a date, and choose with its properties (BottonImage) >> calendar. I added this to the table fields I have use as a data source for the form. But when I run the form it doesn't give the calendar click with the date field and I have to write the date manual, can you tell me what I may missing here? Thanks in advance for your contributions. Regards, Tarek
Re: [Axapta-Knowledge-Village] Create a new form
1) Set the Width and Height properties to Column Width and Column Height respectively and do likewise for all container controls such as Grid and Tabs. 2) Create a new security key in the AOT and select it as the Security Key property value for the table on the form. Create a User Group in the user interface and associate it with the security key selected on the table. Set the required access rights for the user group. You may need to create more than one user group for different access rights. 3) You could set your new EDT to extend the TransDate EDT. Look at the properties of the TransDate EDT to see how it’s done. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: tarek adel To: Axapta-Knowledge-Village@yahoogroups.com Sent: Sunday, June 7, 2009 7:33:54 AM Subject: [Axapta-Knowledge-Village] Create a new form Dear all, I have created a new form, but I need your help in couple of things: 1) What is the "Properties" I should adjust to make the "Form" resizable. 2) How I can active "User group permission" for the "Form" as of it's available and the choices for "No access, add, read, and full control" are dimmed. 3) I have created an "Extended Data Type" as a date, and choose with its properties (BottonImage) >> calendar. I added this to the table fields I have use as a data source for the form. But when I run the form it doesn't give the calendar click with the date field and I have to write the date manual, can you tell me what I may missing here? Thanks in advance for your contributions. Regards, Tarek
Re: [Axapta-Knowledge-Village] Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009
Usually in these kinds of data imports we assume that the data is clean and valid. So we would use the doInsert() method on the table buffer as oppose to the insert method. This method skips all validation and enhances performance. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Michael Franchino To: "Axapta-Knowledge-Village@yahoogroups.com" Sent: Tuesday, April 14, 2009 1:44:09 PMSubject: RE: [Axapta-Knowledge-Village] Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009 James, Did you have to remove the relationship validations on the tables to bring the data in? Specifically, how did you get around the fact that the salesOrder in the salesId did not exist in the SalesTable? mcaConnect Michael Franchino Office: 973-726-8809 X214 Mobile: 201-213-6079 Fax: 973-726-4552 www.mcaconnect. net Gold Certified Partner-Inner Circle Member Microsoft Dynamics AX--People Ready Software From: Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta- Knowledge- vill...@yahoogro ups.com] On Behalf Of James FlavellSent: Monday, April 13, 2009 9:37 PMTo: Axapta-Knowledge- vill...@yahoogro ups.comSubject: RE: [Axapta-Knowledge- Village] Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009 Hi Michael, I have loaded sales and purchase invoice directly into the cust/vendinvoicejou r and lines. The one thing to note is the cost is not available since this comes from inventtrans (which I did not bother to create). If the customer wants the cost (usually they will be willing to accept without if you tell them how much more it will cost) then either you have to create inventtrans records (possible either via code or via import data as SO and post invoices) or just modify so that there is a new field on the invoice lines called 'historical cost' and then modify the cost method on the lines such that if there is zero cost returned from inventtrans search then return the value in the historical cost (I have not done this but looked at doing it and it should be a nice and clean mod from what I saw of the code) All the best Let us know what you decide on Thanks James From: Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta- Knowledge- vill...@yahoogro ups.com] On Behalf Of Michael FranchinoSent: 14 April 2009 02:34To: Axapta-Knowledge- vill...@yahoogro ups.comSubject: [Axapta-Knowledge- Village] Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009 I have 2 customers that wish to take their legacy history and load it into AX. They don't want to have us create separate tables to view/report on this data. They would like to be able to run standard AX reports for Customer Invoices/Vendor Invoices. Has anyone successfully loaded this type of history into AX from a legacy system?
Re: [Axapta-Knowledge-Village] Re: Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009
Yes, anything beyond changing the sales order type from journal and posting will get a bit complicated. My intention was to give information about importing sales order history without inventory transaction. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Subbu To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, April 13, 2009 1:57:05 PM Subject: [Axapta-Knowledge-Village] Re: Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009 Yes Varden. if the sales order is in 'Journal' state, inventTrans records wont get created ( same as blanket ). But when we change from 'Journal' to Order, then InventTrans will get impacted which is subsequently followed by postings... --- In Axapta-Knowledge- vill...@yahoogro ups.com, Varden Morris wrote: > > Inventory transaction will not be affected if you load the sales orders using > the journal sales type. > > Regards, > > Varden Morris > Varalth Solutions Inc. > 693 Abbottsfield Road NW > Edmonton, Alberta T5W 4R4 > Canada > (780) 752-0406 > www.varalth. com > > CONFIDENTIALITY NOTICE > > This message and any attachments are confidential. If you have received this > transmission in error, please be advised that any disclosure, copying, > distribution or action taken in reliance upon this communication is strictly > prohibited. If you have received this communication in error, please contact > the sender immediately. Please note that any views or opinions presented in > this email are solely those of the author and do not necessarily represent > those of the company. Finally, the recipient should check this email and any > attachments for the presence of viruses. The company accepts no liability for > any damage caused by any virus transmitted by this email. > > > > > _ _ __ > From: MaryAnn Hand > To: Axapta-Knowledge- vill...@yahoogro ups.com > Sent: Monday, April 13, 2009 1:36:07 PM > Subject: Re: [Axapta-Knowledge- Village] Loading Legacy History (Sales > Invoices & Vendor Invoices) to standard AX 2009 > > > > > > Hi Michael, > > I once loaded legacy sales history for a customer -- but I did load it into > separate tables. I then modified the standard reports to join the legacy > sales history table with the AX sales records to produce reports that > appeared to have all of the information. > > The problem with loading the legacy data into AX is the posting that would > need to be done for invoices. It impact inventory as well. Hopefully you > can convince the customer to allow for separate tables provided that they can > get the reports that they need. > > Mary Ann Hand > > > On 4/13/09, Michael Franchino wrote: > > > > I have 2 customers that wish to take their legacy history and load it into > AX. They don't want to have us create separate tables to view/report on this > data. They would like to be able to run standard AX reports for Customer > Invoices/Vendor Invoices. > > Has anyone successfully loaded this type of history into AX from a legacy > system? >
Re: [Axapta-Knowledge-Village] Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009
Inventory transaction will not be affected if you load the sales orders using the journal sales type. Regards, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: MaryAnn Hand To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, April 13, 2009 1:36:07 PM Subject: Re: [Axapta-Knowledge-Village] Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009 Hi Michael, I once loaded legacy sales history for a customer -- but I did load it into separate tables. I then modified the standard reports to join the legacy sales history table with the AX sales records to produce reports that appeared to have all of the information. The problem with loading the legacy data into AX is the posting that would need to be done for invoices. It impact inventory as well. Hopefully you can convince the customer to allow for separate tables provided that they can get the reports that they need. Mary Ann Hand On 4/13/09, Michael Franchino wrote: I have 2 customers that wish to take their legacy history and load it into AX. They don't want to have us create separate tables to view/report on this data. They would like to be able to run standard AX reports for Customer Invoices/Vendor Invoices. Has anyone successfully loaded this type of history into AX from a legacy system?
Re: [Axapta-Knowledge-Village] Re: reg : BUS layer issue
Whenever you do this you should also delete the aoi file before restarting the AOS. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: r_ssh To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, April 2, 2009 8:02:18 PM Subject: [Axapta-Knowledge-Village] Re: reg : BUS layer issue Hi Rajaa, Could you please verify if the AX Server configuration has Application file location set to "Standard" folder OR ANY OTHER FOLDER?? If that is so... 1) Try to stop AOS server. 2) Paste AxBUS.aod file in the application folder. 3) Restart the AX services Hope this resolves the issue. Thanks Santosh.R --- In Axapta-Knowledge- vill...@yahoogro ups.com, Raja Mani wrote: > > Hi Everyone, > > Actually i was developed some form,reports and menuitems(like module) in BUS > Layer.. > > I just paste that AxBUS.AOD to my client machine(End User) standard folder. > > In EndUser machine not showing those customization. > > Note : I didn't import those customization. .I just paste that BUS Layer AOD > > anyone help me out that issue. > > Thanks, > Raja >
Re: [Axapta-Knowledge-Village] (unknown)
I believe this is possible after closing and adjustment. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Axapta Consultant To: Axapta Knowledge Village Sent: Sunday, March 22, 2009 3:06:25 AM Subject: [Axapta-Knowledge-Village] (unknown) Hi, How can I change the inventory model group from Standard Cost to FIFO of an Item which has got transaction and price is enabled with Standard Cost. If I change the inventory model group it prompts following message "The item is set to be evaluated by inventory model ‘Standard cost'. The system cannot convert the item to be evaluated by an inventory model of type ‘Transactions settled’ only inventory models of type ‘Transactions not settled’ can be selected." I'll be thankful for quick response and solution. Thanks
[Axapta-Knowledge-Village] Recent Scam
An email was recently sent out by me with the subject "Re: Hi". The body of the email is in bold below. I want you to know that I did NOT send out this email. Someone got access to my email via an unsecured wireless connection and sent out this SPAM email. Vanigo is a big SPAM as you can see from the following link: http://www.complaintsboard.com/complaints/vanigocom-c177386.html I know I sent out an email informing some of my contacts before but the list consisted of about 20% of all my contacts at the time. My entire contact list was deleted by the SPAM and it took me some time to recover my over 360 contacts from a backup. I apologize for any trouble that may have resulted from this. New shopping new life! How are u doing these days?Yesterday I found a web of a large trading company from china,which is an agent of all the well-known digital product factories,and facing to both wholesalers,retailsalers,and personal customer all over the world. They export all kinds of digital products and offer most competitive and reasonable price and high quality goods for our clients,so i think we you make a big profit if we do business with them.And they promise they will provide the best after-sales-service.In my opinion we can make a trial order to test that. Look forward to your early reply! The Web address: www.vanigo.com E-mail: van...@188.com MSN : van...@msn.cn Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
[Axapta-Knowledge-Village] Re:hi
New shopping new life! How are u doing these days?Yesterday I found a web of a large trading company from china,which is an agent of all the well-known digital product factories,and facing to both wholesalers,retailsalers,and personal customer all over the world. They export all kinds of digital products and offer most competitive and reasonable price and high quality goods for our clients,so i think we you make a big profit if we do business with them.And they promise they will provide the best after-sales-service.In my opinion we can make a trial order to test that. Look forward to your early reply! The Web address: www.vanigo.com E-mail: van...@188.com MSN : van...@msn.cn
Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid
Wow. It's a bit difficult to trace this way on the live system since the code could be anywhere in the app. It's possible that a query is not using the fields in the order of the index and since the kernel automatically adds the DataAreaId to the WHERE clause you do not need to specify it in code. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Agus Riyadi To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, March 4, 2009 9:22:32 PM Subject: Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid Thanks James, Yes perhaps this is not relevant to recalc/closing because there are users activity during recalc which might get captured in the profiler too, and profiler will not tell from which ax function this particular query comes from. I am just curious since DTA suggested several more indexes that have first column not dataareaid. My plan is to apply as many indexes as possible so then I can move forward to others area for improvement if performance still unacceptable. Thanks and best regards, Agus On Thu, Mar 5, 2009 at 10:46 AM, James Flavell wrote: I would double check why is recalc/closing looking at custpackingslipjour . As far as I am aware the std closing should not look at this table table so I would be a little careful...although I guess you can add the index and see but to me I would not expect any improvement in the recalc or closing From: Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta-Knowledge- vill...@yahoogro ups.com] On Behalf Of Agus Riyadi Sent: 05 March 2009 11:33 To: Axapta-Knowledge- vill...@yahoogro ups.com Subject: Re: [Axapta-Knowledge- Village] Create index with first column not dataareaid Hi Varden, Thanks for input. This comes from the profiler file during inventory recalculation process, so less likely that I will change the standard code. I will only add index from the DTA's recommendation. I think we need to concern the column order as suggested by DTA because otherwise the index will not be used and only makes additional write overhead. So we can't do anything for this kind of suggestion, can we? Just FYI, I have a client who runs recalculation for long hours (20 + hours). The only possibility is to tune the index because disk configuration (RAID etc.) will not be change in the near future. Thanks and best regards, Agus On Thu, Mar 5, 2009 at 12:04 AM, Varden Morris wrote: You are right about the DataAreaId being added to the index by the kernel. I am not sure that you need to concern yourself about the order of the fields as suggested in the backend but you need to ensure that any query coming from AX should have the fields listed in the WHERE clause in the order in which they are listed in the index. In the case below, if there is an index with the SalesId and RecId listed in that order then you should ensure that all queries sent to the database, that will possible use this index, have the fields in the WHERE clause listed in the same order. CustPackingSlipJour : salesid asc, dataareaid asc, recid asc. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth. com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Agus Riyadi To: axapta-knowledge- village Sent: Wednesday, March 4, 2009 12:27:29 AM Subject: [Axapta-Knowledge- V
Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid
You are right about the DataAreaId being added to the index by the kernel. I am not sure that you need to concern yourself about the order of the fields as suggested in the backend but you need to ensure that any query coming from AX should have the fields listed in the WHERE clause in the order in which they are listed in the index. In the case below, if there is an index with the SalesId and RecId listed in that order then you should ensure that all queries sent to the database, that will possible use this index, have the fields in the WHERE clause listed in the same order. CustPackingSlipJour : salesid asc, dataareaid asc, recid asc. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Agus Riyadi To: axapta-knowledge-village Sent: Wednesday, March 4, 2009 12:27:29 AM Subject: [Axapta-Knowledge-Village] Create index with first column not dataareaid Dear all, Using sql server database engine tuning advisor, I got a recommendation to add new index with the following scheme : CustPackingSlipJour : salesid asc, dataareaid asc, recid asc. Is it possible to achieve that in Ax ? As far as I know Ax always add dataareaid column as the first column of any index created from AOT. Thanks and best regards, Agus
Re: [Axapta-Knowledge-Village] Method to query application obejcts to see Created/Modified object properties
Yes. I don't have a copy of 3.0 now but there is a way to use the filter in the AOT to create a project for a given layer, user, date and other fields. Regards, Varden Morris Varalth Solutions Inc. 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 615-1604 (403) 366-8434 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: johnflick22 To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, February 24, 2009 11:28:21 AM Subject: [Axapta-Knowledge-Village] Method to query application obejcts to see Created/Modified object properties Is there a method or way to query all application objects in AX 3.0 to generate a list of application objects which were created and modified after a certain date? This is needed for SARBOX auditing. Any help would be greatly appreciated. Thanks in advance. John
Re: [Axapta-Knowledge-Village] Calling SQL Statement thru Axapta
What is nlslower? It would be great if you post the entire method for testing.
Varden Morris
Varalth Solutions Inc.
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 615-1604
(403) 366-8434
www.varalth.com
CONFIDENTIALITY NOTICE
This message and any attachments are confidential. If you have received this
transmission in error, please be advised that any disclosure, copying,
distribution or action taken in reliance upon this communication is strictly
prohibited. If you have received this communication in error, please contact
the sender immediately. Please note that any views or opinions presented in
this email are solely those of the author and do not necessarily represent
those of the company. Finally, the recipient should check this email and any
attachments for the presence of viruses. The company accepts no liability for
any damage caused by any virus transmitted by this email.
From: Pankaj Gupta
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, February 19, 2009 5:14:13 AM
Subject: [Axapta-Knowledge-Village] Calling SQL Statement thru Axapta
Hi Guys!
There is one requirement where i need to call a stored procedure of SQL
Database (SQL Server 2005) from Ax2009. I have copied my requirment to simplest
example below: During the execution of code it throws these errors
Request for the permission of type 'SqlStatementExecute Permission' failed.
(S)\Classes\ SqlStatementExec utePermission\ demand
(S)\Classes\ Statement\ executeQuery
(C)\Jobs\StoredProc edure - line 33
Cannot select a record in ().The SQL database has issued an error.
_ _ _ _ _ _
_ _ _
userConnection = new Connection() ;
stmt = userConnection. createStatement( );
sql = "select %1 from %2 where %3 = %4 and %5 = %6";//'SO-101245'";
sql = strfmt(sql,
ReleaseUpdateDB: :backendFieldNam e(tablenum( SalesTable)
, fieldnum(SalesTable , custaccount) ),
ReleaseUpdateDB: :backendTableNam e(tablenum( SalesTable)
),
strfmt(nlslower, ReleaseUpdateDB: :backendFieldNam
e(tablenum( SalesTable) , fieldnum(SalesTable , SalesId))),
sqlSystem.sqlLitera l('SO-101245', true),
strfmt(nlslower, ReleaseUpdateDB: :backendFieldNam
e(tablenum( SalesTable) , fieldnum(SalesTable , DataAreaId)) ),
sqlSystem.sqlLitera l(Curext( ),true));
permission = new SqlStatementExecute Permission( sql);
permission.assert( );
sqlres = stmt.executeQuery( sql);
CodeAccessPermissio n::revertAssert( );
sqlres.next( );
info(sqlres. getString( 1));
_ _ _ _ _ _
_ _ ___
Guys I have tried using the LoginProperty class and ODBC connection but no
avail. Different error came at times but could not login thru Ax2009. My Sql
server is on another machine and m very much have access rights over that
machine and SQL Server.
Please help me out , wat m missing ?
Thnks in advance.
--
Pankaj Kumar Gupta
--
Software Developer | MBS Ax.
Tectura India. - +91 9953559549.
Re: [Axapta-Knowledge-Village] Field Size.
This field is using the ConfigName Extended Data Type (EDT) and the ConfigName EDT is using the Name EDT. I would first remove the Extends property value of the ConfigName EDT, which is Name. After saving the change the StringSize property value will be enabled on the ConfigName EDT. You can then change that value to 300. Varden Morris Varalth Solutions Inc. 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 615-1604 (403) 366-8434 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Khalil Rehman To: Knowlege Village Sent: Wednesday, February 18, 2009 2:26:58 AM Subject: [Axapta-Knowledge-Village] Field Size. Dear All, how can i set the NAME Field size of CONFIGTABLE upto 300 characters. thanks for your support. regards KHALIL UR REHMAN Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it!
Re: [Axapta-Knowledge-Village] syncronize AOS & Sql Server
Always start with the event log. Check it on the AOS server. As the others said, it is usually a user permission problem. Varden Morris Varalth Solutions Inc. 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 615-1604 (403) 366-8434 From: nanukuttan rinish To: Axapta-Knowledge-Village@yahoogroups.com Cc: vnin...@yahoo.com; raghu1...@rediffmail.com Sent: Thursday, January 15, 2009 9:15:02 AM Subject: Re: [Axapta-Knowledge-Village] syncronize AOS & Sql Server hi Amit, thank U very much for the help... at first i tried with 3-tier ..may be that's y i was getting this error ...today we tried with 2-tier and we also installed kernel roll up -3..and now its working ...i will let u all know if i am getting any more problems once again thans for the suggestion Thanks Regards Rinish --- On Thu, 15/1/09, Amit Jain wrote: From: Amit Jain Subject: Re: [Axapta-Knowledge- Village] syncronize AOS & Sql Server To: Axapta-Knowledge- vill...@yahoogro ups.com Cc: vnin...@yahoo. com, raghu1...@rediffmai l.com Date: Thursday, 15 January, 2009, 10:26 AM hi Nanu, If you are having 3- tier system setup, then try opening AX with 2-tier and then start AOS. If you are running 2-tier system, can you send me your screen shot of following components 1. Configuration utility first Tab 2. configuration utility SQL Server Tab Regards Amit --- On Tue, 13/1/09, nanukuttan rinish wrote: From: nanukuttan rinish Subject: Re: [Axapta-Knowledge- Village] syncronize AOS & Sql Server To: Axapta-Knowledge- vill...@yahoogro ups.com Cc: vnin...@yahoo. com, raghu1...@rediffmai l.com Date: Tuesday, 13 January, 2009, 5:44 PM Hi all, Thank u Tomi for your suggestion ...i tried changing the User name and password but still it did not worki have attached a word document with the screen shot and the error msg ...pls check the document and help me with this --- On Tue, 13/1/09, Tomi wrote: From: Tomi Subject: [Axapta-Knowledge- Village] syncronize AOS & Sql Server To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Tuesday, 13 January, 2009, 10:48 AM Hi, Try to check your sql server parameter at axapta server manager setting. Most of problem is userid and/or password not valid with database server. Hope this can help you. Regards, Tomi --- In Axapta-Knowledge- vill...@yahoogro ups.com, nanukuttan rinish wrote: > > hi all, > Â Â Â Â Â Â can anyone help me > Â Â Â Â Â Â I tried to install Axapta 3.0 ..but i was not able to synchronize it with the data base and the AOS is not starting ..I tried to start it manually but it stops after a second or 2can anyone get me a document for installing Axapta 3.0 > > Thank U > > regards > > > Rinish > > > > Add more friends to your messenger and enjoy! Go to http://messenger. yahoo.com/ invite/ > >From Chandigarh to Chennai - find friends all over India. Click here. Add more friends to your messenger and enjoy! Invite them now. Add more friends to your messenger and enjoy! Invite them now.
Re: [Axapta-Knowledge-Village] Re: record count
I think this is a nice solution. Just pass the table buffer as type common to a
parameter to a method.
CustTable tCustTable;
Common tCommon = tCustTable;
;
select count(RecId) from tCommon;
info(strfmt("%1", tCommon.RecId));
Regards,
Varden Morris
Varalth Solutions Inc.
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 615-1604
(403) 366-8434
From: André Santos
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, January 15, 2009 1:05:44 PM
Subject: Re: [Axapta-Knowledge-Village] Re: record count
oh, misunderstood your doubt.. sorry... just noticed !
- Original Message -
From: André Santos
To: Axapta-Knowledge- vill...@yahoogro ups.com
Sent: Thursday, January 15, 2009 6:03 PM
Subject: Re: [Axapta-Knowledge- Village] Re: record count
Both way works
It's a little weird, but if you do this :
static void AnyThing(Args args[])
{
select count(recId) from myTable;
info(strfmt( "%1",myTable. recId));
}
the field recId will hold the count. but I still prefer to use the CountTotal
as Hentz said
- Original Message -
From: Rodrigo Hentz
To: Axapta-Knowledge- vill...@yahoogro ups.com
Sent: Thursday, January 15, 2009 4:57 PM
Subject: RE: [Axapta-Knowledge- Village] Re: record count
Use SysQuery::countTota l
Example:
query = new Query();
queryBuildDataSourc e = query.addDataSource (tableNum( EmplTable) );
queryRun = new QueryRun(query) ;
info(int2str( SysQuery: :countTotal( queryRun) );
From:Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta- Knowledge-
vill...@yahoogro ups.com] On Behalf Of mane.shankar10
Sent: quinta-feira, 15 de janeiro de 2009 02:54
To: Axapta-Knowledge- vill...@yahoogro ups.com
Subject: [Axapta-Knowledge- Village] Re: record count
--- In Axapta-Knowledge- vill...@yahoogro ups.com, "dgreatone123"
wrote:
>
> Hi,
>
> sELECT count(recid) FROM EmplTable;
>
> I want to execute the above statement
>
> but the table will be variable, I will
> supply the table name. How can It be done?
>
> something like this.
>
> selec count(recid) from tname;
>
> where tname='EmplTable" ;
>
> Any help will be greatly appreciated.
>
> regards,
hI
> D' great
USE THE EDT TABLENAME FOR HAVING ALL TABLENAME LOOKUP
THEN USE A VARIABLE TO STORE SELECTED TABLE NAME
THEN DO AS FOLLOWS
common common;;
DICTTABLE DT;
;
dt=new dicttable(tablename 2id(SELECTEDTABL ENAME STORED IN VARIABLE));
common=dt.makeRecor d();
sELECT count(recid) FROM COMMON;
AND IT WILL WORK 100%
REGARDS;
Re: [Axapta-Knowledge-Village] SQL sync error
If you can afford to lose the data in the table, or do a backup of the data, you can try dropping the table from the SQL database and then re-sync it in DAX. Regards, Varden Morris MCDBA, MCT 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] From: rajpaltn <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, November 14, 2008 3:35:24 AM Subject: [Axapta-Knowledge-Village] SQL sync error Dear All, When i am synchonising the data dictionary, im getting the error 1)"Cannot execute the data definition language command on ().The SQL database has issued an error". 2)I have tried to synchronise the tables from SQL Administration -- >Synchonise 3)It says Syncronisation Failed on 1507 tables. 4)I have checked the event viewer and there are errors relating to evevry table sayin the object already exists and the error id is 117. I wld appreciate any help
Re: [Axapta-Knowledge-Village] Pass more than one value
Did you look at the args class? Varden Morris MCDBA, MCT 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] From: k_otickashka <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, November 14, 2008 8:10:07 AM Subject: [Axapta-Knowledge-Village] Pass more than one value How can I pass more than one value from a form to a next form?
[Axapta-Knowledge-Village] X++ Performance User Group
I started a user group devoted to X++ performance. This is an extensive topic and an area that I believe needs a lot of focus that comes with a number of years of coding experience in X++. I already uploaded one article on this topic in the files section of the group that you will find very interested. I will be creating other articles in my spare time as time goes by. If you would like to become a part of this group please do so by selecting the link http://groups.yahoo.com/group/XPP_Performance. Please feel free to open discussions in the performance areas of your concern and the articles that I will write over the period. Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: [Axapta-Knowledge-Village] Salestable -Sales line - Query
Check all tab pages, group and grid controls and ensure that the values, if selected, for the "DataSource" property is appropriately set to SalesTable for the header records and SalesLine for the line records. This problem takes place when the dataSource for the line record is automatically set to the header table by DAX. Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Siva kumar <[EMAIL PROTECTED]> To: Axapta Development <[EMAIL PROTECTED]>; MBS Axapta Sent: Friday, October 17, 2008 5:27:05 AM Subject: [Axapta-Knowledge-Village] Salestable -Sales line - Query Hi, I am using a query form where I have provided SalesId(salesTable) , ItemNumber(Saesline ) as selection criteria. I have joined the datasources Salestable and Salesline table with delay linktype.(As Sales order form). When I select SalesId from selection criteria, records are coming correctly. If I select 10001 in SalesId selection criteria: Salestable; 10001 salesline B-R14 B-R14 But when I select Itemnumber in the Salesline selection criteria, The Salestable grid is shows multiple SalesId(Same) based on the no lines the same item exist in the Salesline. Eg. SalesTable 10001 xx 10001 xxx Salesline B-R14 - --- B-R14 - I have tried all the Option. If anyone have come across this type of situation, Please let me know.. thanks advance MGS "Hands that Help is Holier than Lips that Pray" _ _ _ _ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail. yahoo.com __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: [Axapta-Knowledge-Village] Run Batch processing
You can execute the batch job as a Windows Service. There should be a document from Microsoft to do this but I am unable to locate it. Please look at the following link. http://coolhake.wordpress.com/2008/07/22/how-to-setup-axapta-batch-server-running-as-user-defined-windows-service/ Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Abdel-Rhman El-Kady <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, July 30, 2008 4:22:03 PM Subject: [Axapta-Knowledge-Village] Run Batch processing Dear consultants, kindly could you tell me how can i run batches automaticaly i want the batch processing to be run automaticaly with out going and run it. and also i want to run it in the backfront like the services. Regards.
Re: [Axapta-Knowledge-Village] SQL Slow response
The most common cause is missing index. But the following could also result in performance problems: (1) Mutilple database access code being executed on the client tier. This can be corrected by placing the code in a class or static method that is executed on the server. (2) Multiple calls to fetch data from a table requiring one or a few fields but the entire buffer is being fetched. In this case you should use field select. Do not get in the habit of making mutiple calls to the find method on a table to fetch different fields for the same record. Use a table buffer to do one find and use the buffer to fetch all required fields. If the number of fields in the table is large it will be better to do a field select instead of calling the find method that returns all fields. The less fields fetch the better the performance. (3) A table with a large number of records is placed on the form data source without a reltionship to another table. In this case all the records will be loaded when the form is open. Ensure that the table buffer is needed, otherwise remove it. Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Ali Jawad <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Sunday, June 22, 2008 1:14:54 AM Subject: RE: [Axapta-Knowledge-Village] SQL Slow response Hello Morris, I will try to do this, can you please share possible reasons for this so that I directly can target those. Thanks again……. Regards, Ali Jawad From:Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris Sent: Saturday, June 21, 2008 6:43 PM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: Re: [Axapta-Knowledge- Village] SQL Slow response Hi Ali, Do you know how to do a long query and multiple select statement trace? You should do this and analyze the resulting data to find the bottleneck. Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] com - Original Message From: Ali Jawad <[EMAIL PROTECTED] com> To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Saturday, June 21, 2008 1:04:59 AM Subject: [Axapta-Knowledge- Village] SQL Slow response Hello, I have a situation here. We have around 10,000 line items In a sales blanket order. This order has been imported using AX import Export facility. Now after import when we open AX and click on Sales Order, it takes minutes to open, which is not acceptable. Can anybody please help me to locate and solve this issue. Thank You, Ali Jawad
Re: [Axapta-Knowledge-Village] SQL Slow response
Hi Ali, Do you know how to do a long query and multiple select statement trace? You should do this and analyze the resulting data to find the bottleneck.Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Ali Jawad <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, June 21, 2008 1:04:59 AM Subject: [Axapta-Knowledge-Village] SQL Slow response Hello, I have a situation here. We have around 10,000 line items In a sales blanket order. This order has been imported using AX import Export facility. Now after import when we open AX and click on Sales Order, it takes minutes to open, which is not acceptable. Can anybody please help me to locate and solve this issue. Thank You, Ali Jawad
Re: [Axapta-Knowledge-Village] Re: Setting Reindexing as a batch process
Hi Satish, I am not aware of a connection between re-indexing and the growth of the log file. I however know that the growth of the log file can result from periodic transaction log backups. I am not particularly fun of DAX batch job processing since it requires the DAX client to be up for execution and several things can prevent this, such as a restart of the AOS and someone forget to restart the client or a failure of the DAX client for one reason or another. I also notice that re-index for large databases runs much faster on the database server when compared to executing it from DAX. With all of that said I believe it’s more feasible to schedule the re-index in the database maintenance plan along with backups, application of statistics (for enhanced performance) and any other DB required job(s). Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Satish <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, May 23, 2008 2:44:09 AM Subject: [Axapta-Knowledge-Village] Re: Setting Reindexing as a batch process Thanks Sumit and Varden, I apologize for a delayed response... Was caught up with some other issue... Th method suggeste by Sumit works like a charm! Varden - Any specific reason why we should include this in the MSSQL plan? I did try a DBCC reindex sometime back, but it made the log file grow like crazy... The reindexing from AX doesn't have this problem, so I thought of doing it from here... I would love to hear counter arguments! Thanks Satish --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Varden Morris <[EMAIL PROTECTED] > wrote: > > I believe it's better to have the DBA include this in the MSSQL maintenance plan. > > Varden Morris > > 276 Taralake Terrace N.E. > Calgary, Alberta T3J 0A1 > Canada > > (403) 366-8434 (H) > (403) 615-1604 (C) > [EMAIL PROTECTED] > > > > > > - Original Message > From: Sumit Loya > To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com > Sent: Monday, May 19, 2008 1:47:10 AM > Subject: Re: [Axapta-Knowledge- Village] Setting Reindexing as a batch process > > > Hi, > > I have a small code with which you can create a batch class and schedule it for batch run. > > Below is the piece of code: > > SqlDataDictionary sqlDict = new SqlDataDictionary( ); > ; > new SqlDataDictionaryPe rmission( methodstr( SqlDataDictionar y, tableReindex) ).assert( ); > sqlDict.tableReinde x(); > CodeAccessPermissio n::revertAssert( ); > > Ensure that you run the code on server otherwise the SqlDataDictionaryPe rmission will fail. > > Hope this is of some help to you. > > Regards, > Sumit > > On Sat, May 17, 2008 at 9:02 AM, Satish wrote: > > Hi All, > > Would appreciate any pointers to setup reindexing (Administration | > Periodic | SQL Administration | Index Actions > Reindex) as a batch > process in AX? > > Also what would be a optimal schedule for reindexing the tables? I was > thinking of a daily reindex of all the tables. > > Looking forward to any views, comments, pointers... > > Thanks, > Satish >
Re: SV: [Axapta-Knowledge-Village] not more than 100 %
You just need to override the validateField method.
public boolean validateField(fieldId _fieldIdToCheck)
{
boolean ret;
ret = super(_fieldIdToCheck);
if (ret)
{
switch (_fieldIdToCheck)
{
case fieldnum(TableName, Percent) :
if (this.Percent > 100)
{
ret = checkFailed("Error message goes here.");
}
break;
}
}
return ret;
}
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: Søren Ager <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, May 20, 2008 3:07:40 AM
Subject: SV: [Axapta-Knowledge-Village] not more than 100 %
Den 20. maj 2008 11:03 skrev Axapta-Knowledge- [EMAIL PROTECTED] ups.com:
> Den 7. maj 2008 12:31 skrev Axapta-Knowledge- [EMAIL PROTECTED] ups.com
> <mailto:Axapta- Knowledge- Village%40yahoog roups.com> :
>
>> Has anyone come across this situation in standard AX, suppose you
>> have field called percentage in your form and the total percentage
>> should not be more than 100% if it exceeds so system should throw
>> the error, percentage should be some of values in all the rows.
>
> In ValidateWrite on the table do something like:
>
Actually it should probably be:
Table.update
if ((select sum(percent) from mytable).percent> 100)
throw error("Percent over 100");
Table.insert
if ((select sum(percent) from mytable).percent+ this.percent> 100)
throw error("Percent over 100");
Greetings
Søren
Re: [Axapta-Knowledge-Village] Setting Reindexing as a batch process
I believe it's better to have the DBA include this in the MSSQL maintenance plan. Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Sumit Loya <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, May 19, 2008 1:47:10 AM Subject: Re: [Axapta-Knowledge-Village] Setting Reindexing as a batch process Hi, I have a small code with which you can create a batch class and schedule it for batch run. Below is the piece of code: SqlDataDictionary sqlDict = new SqlDataDictionary( ); ; new SqlDataDictionaryPe rmission( methodstr( SqlDataDictionar y, tableReindex) ).assert( ); sqlDict.tableReinde x(); CodeAccessPermissio n::revertAssert( ); Ensure that you run the code on server otherwise the SqlDataDictionaryPe rmission will fail. Hope this is of some help to you. Regards, Sumit On Sat, May 17, 2008 at 9:02 AM, Satish wrote: Hi All, Would appreciate any pointers to setup reindexing (Administration | Periodic | SQL Administration | Index Actions > Reindex) as a batch process in AX? Also what would be a optimal schedule for reindexing the tables? I was thinking of a daily reindex of all the tables. Looking forward to any views, comments, pointers... Thanks, Satish
Re: [Axapta-Knowledge-Village] Example of Map Class
Just do a search on the class node in the AOT for map. There are several examples your can learn from. The Map class is one of the foundation classes in DAX. The others are List, Set, Struct and Array. These classes allow you to save object instances and table buffers to the database. From a performance perspective, the foundation classes are good to store up to ten items. Over that limit it's better to use a temporary table. Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: jubon_gatana <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, April 2, 2008 6:34:00 AM Subject: [Axapta-Knowledge-Village] Example of Map Class Dear all, I'm newbie in Dynamics Axapta 4. I just want to know example of map class usage. As far as I know, using map is better than temporary table. But I couldn't find real example how to use it. Maybe there is some short code about map class usage to make easier for me understand the process. Sorry for my bad english. You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com
Re: [Axapta-Knowledge-Village] Order by & Group by
You should try and populate the temp table with the aggregates and then use the
order by clause. I do not think you can use the order by clause for an
aggregated field in the way you are trying to do it.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: Anjali Kanna <[EMAIL PROTECTED]>
To: axapta-knowledge-village@yahoogroups.com
Sent: Monday, March 24, 2008 2:13:05 AM
Subject: [Axapta-Knowledge-Village] Order by & Group by
Hi To all,
Is it possible to use Order by and group by in a single select statement?
I want to retreive the records from tabel , so i used the follwoing query
while select ItemId,ItemDesc, sum(Cost) ,sum(Qty) form tmpmodeltable group by
ItemId //Order by qty desc
{
element.execute( 5);
}
here we want to retreive the values in descening order by qty and also group by
the value by ItemId..that's why i use the above statements but this issue
is yet to be complete...
Friends ..Give me the idea to finish this .
Thanks in advance. .
by,
Anjali.
5, 50, 500, 5000 - Store N number of mails in your inbox. Click here.
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
Re: [Axapta-Knowledge-Village] Customer Balance
Please the the attached XPO.
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: Alaa Assem <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, March 6, 2008 12:42:14 AM
Subject: RE: [Axapta-Knowledge-Village] Customer Balance
Varden, thank you so much J
But when I compiled the code it gave me an error which is "on the report
design.
*/
TmpCustLedger. AccountNum = tTmpCustLedger. AccountNum;
TmpCustLedger. Name = tTmpCustLedger. Name;
TmpCustLedger. Balance01 = tTmpCustLedger. Balance01;
"
The table does not contain this field!!
What should I do? I already made it work and correct but I don't know
whether my action was right or wrong!
One other thing plz, how could I display the report with specified balance
range?
Ex. Display the cust. whom their balance is between 1000-1 only
Once again A BIG TAHNK TO U J
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Monday, 03 March, 2008 6:01 PM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] Customer Balance
You are most welcome. Here you go:
//Override the fetch method as follows
public boolean fetch()
{
CustTrans tCustTrans;
CustTable tCustTable;
TmpCustLedger tTmpCustLedger;
int cnt;
QueryRun qr = new QueryRun(this) ;
;
while select AccountNum, Name from tCustTable
group by AccountNum, Name
join sum(AmountMST) from tCustTrans
where tCustTrans.AccountN um == tCustTable.AccountN um
{
tTmpCustLedger. Name = tCustTable.Name;
tTmpCustLedger. AccountNum = tCustTable.AccountN um;
tTmpCustLedger. Balance01 = tCustTrans.AmountMS T;
tTmpCustLedger. insert();
}
if (qr.prompt() )
{
while select tTmpCustLedger
order by Balance01 desc
{
cnt += 1;
if (cnt <= 10)
{
/*
The buffer used in the report will be populated here
and send to the design for printing. I used the
TmpCustLedger buffer from stabdard DAX. I placed the
AccountNum, Name and Balance01 fields from the buffer
on the report design.
*/
TmpCustLedger. AccountNum = tTmpCustLedger. AccountNum;
TmpCustLedger. Name = tTmpCustLedger. Name;
TmpCustLedger. Balance01 = tTmpCustLedger. Balance01;
element.send( TmpCustLedger) ;
}
}
}
else
{
return false;
}
return true;
}
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com <mailto:vardenm% 40yahoo.com>
- Original Message
From: Alaa Assem <[EMAIL PROTECTED] .com <mailto:alaa. assem%40upcegypt .com>
>
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
<mailto:Axapta- Knowledge- Village%40yahoog roups.com>
Sent: Monday, March 3, 2008 3:55:43 AM
Subject: RE: [Axapta-Knowledge- Village] Customer Balance
First of all thaank you Varden so much,
But how do I use the temp table
Could you plz explain more how to do what I want? plz
Thnx in advance
Alaa Assem
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden
Morris
Sent: Monday, 03 March, 2008 2:34 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] Customer Balance
Override the fetch method and try the following by using a temp table. This
is just a basic idea that works, so you can make your personal enhancement
for performance and otherwise.
static void Job1(Args _args)
{
CustTrans tCustTrans;
CustTable tCustTable;
TmpCustLedger tTmpCustLedger;
int cnt;
;
while select AccountNum, Name from tCustTable
group by AccountNum, Name
join sum(AmountMST) from tCustTrans
where tCustTrans.AccountN um == tCustTable.AccountN um
{
tTmpCustLedger. Name = tCustTable.Name;
tTmpCustLedger. AccountNum = tCustTable.AccountN um;
tTmpCustLedger. Balance01 = tCustTrans.AmountMS T;
tTmpCustLedger. insert();
}
while select tTmpCustLedger
order by Balance01 desc
{
cnt += 1;
if (cnt <= 10)
{
info(strfmt( "%1 %2 %3", tTmpCustLedger. AccountNum, tTmpCustLedger. Name,
tTmpCustLedger. Balance01) );
}
}
}
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com <mailto:vardenm% 40yahoo.com>
- Original Message
From: Alaa Assem mailto:alaa. assem%40upcegypt
.com>
>
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
<mailto:Axapta- Knowledge- Village%40yahoog roups.com>
Sent: Sunday, March 2, 2008 1:25:46 AM
Subject: [Axapta-Knowledge- Village] Customer Balance
__,_._,_Hello,
I am trying to create a new report to display only the customer with their
balance, so I got it working but I want to filter by the highest cutomer's
balance I cant put the balance in the range to filter on!!
Any suggestions? ? plz help!__
Thanks in a
Re: [Axapta-Knowledge-Village] Customer Balance
You are most welcome. Here you go:
//Override the fetch method as follows
public boolean fetch()
{
CustTrans tCustTrans;
CustTable tCustTable;
TmpCustLedger tTmpCustLedger;
int cnt;
QueryRunqr = new QueryRun(this);
;
while select AccountNum, Name from tCustTable
group by AccountNum, Name
join sum(AmountMST) from tCustTrans
where tCustTrans.AccountNum == tCustTable.AccountNum
{
tTmpCustLedger.Name = tCustTable.Name;
tTmpCustLedger.AccountNum = tCustTable.AccountNum;
tTmpCustLedger.Balance01= tCustTrans.AmountMST;
tTmpCustLedger.insert();
}
if (qr.prompt())
{
while select tTmpCustLedger
order by Balance01 desc
{
cnt += 1;
if (cnt <= 10)
{
/*
The buffer used in the report will be populated here
and send to the design for printing. I used the
TmpCustLedger buffer from stabdard DAX. I placed the
AccountNum, Name and Balance01 fields from the buffer
on the report design.
*/
TmpCustLedger.AccountNum= tTmpCustLedger.AccountNum;
TmpCustLedger.Name = tTmpCustLedger.Name;
TmpCustLedger.Balance01 = tTmpCustLedger.Balance01;
element.send(TmpCustLedger);
}
}
}
else
{
return false;
}
return true;
}
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: Alaa Assem <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Monday, March 3, 2008 3:55:43 AM
Subject: RE: [Axapta-Knowledge-Village] Customer Balance
First of all thaank you Varden so much,
But how do I use the temp table
Could you plz explain more how to do what I want? plz
Thnx in advance
Alaa Assem
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Monday, 03 March, 2008 2:34 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] Customer Balance
Override the fetch method and try the following by using a temp table. This
is just a basic idea that works, so you can make your personal enhancement
for performance and otherwise.
static void Job1(Args _args)
{
CustTrans tCustTrans;
CustTable tCustTable;
TmpCustLedger tTmpCustLedger;
int cnt;
;
while select AccountNum, Name from tCustTable
group by AccountNum, Name
join sum(AmountMST) from tCustTrans
where tCustTrans.AccountN um == tCustTable.AccountN um
{
tTmpCustLedger. Name = tCustTable.Name;
tTmpCustLedger. AccountNum = tCustTable.AccountN um;
tTmpCustLedger. Balance01 = tCustTrans.AmountMS T;
tTmpCustLedger. insert();
}
while select tTmpCustLedger
order by Balance01 desc
{
cnt += 1;
if (cnt <= 10)
{
info(strfmt( "%1 %2 %3", tTmpCustLedger. AccountNum, tTmpCustLedger. Name,
tTmpCustLedger. Balance01) );
}
}
}
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com <mailto:vardenm% 40yahoo.com>
- Original Message
From: Alaa Assem <[EMAIL PROTECTED] .com <mailto:alaa. assem%40upcegypt .com>
>
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
<mailto:Axapta- Knowledge- Village%40yahoog roups.com>
Sent: Sunday, March 2, 2008 1:25:46 AM
Subject: [Axapta-Knowledge- Village] Customer Balance
__,_._,_Hello,
I am trying to create a new report to display only the customer with their
balance, so I got it working but I want to filter by the highest cutomer's
balance I cant put the balance in the range to filter on!!
Any suggestions? ? plz help!__
Thanks in advance to you all.
Alaa Assem
[Non-text portions of this message have been removed]
_ _ _ _ _ _
Never miss a thing. Make Yahoo your home page.
http://www.yahoo. com/r/hs
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Customer Balance
Override the fetch method and try the following by using a temp table. This is
just a basic idea that works, so you can make your personal enhancement for
performance and otherwise.
static void Job1(Args _args)
{
CustTrans tCustTrans;
CustTable tCustTable;
TmpCustLedger tTmpCustLedger;
int cnt;
;
while select AccountNum, Name from tCustTable
group by AccountNum, Name
join sum(AmountMST) from tCustTrans
where tCustTrans.AccountNum == tCustTable.AccountNum
{
tTmpCustLedger.Name = tCustTable.Name;
tTmpCustLedger.AccountNum = tCustTable.AccountNum;
tTmpCustLedger.Balance01= tCustTrans.AmountMST;
tTmpCustLedger.insert();
}
while select tTmpCustLedger
order by Balance01 desc
{
cnt += 1;
if (cnt <= 10)
{
info(strfmt("%1 %2 %3", tTmpCustLedger.AccountNum,
tTmpCustLedger.Name, tTmpCustLedger.Balance01));
}
}
}
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: Alaa Assem <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Sunday, March 2, 2008 1:25:46 AM
Subject: [Axapta-Knowledge-Village] Customer Balance
__,_._,_Hello,
I am trying to create a new report to display only the customer with their
balance, so I got it working but I want to filter by the highest cutomer's
balance I cant put the balance in the range to filter on!!
Any suggestions? ? plz help!__
Thanks in advance to you all.
Alaa Assem
[Non-text portions of this message have been removed]
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Reading COM Port from Dynamics AX 3.0
You could use the MSCOMM OCX file to do this. You can Google an example in a programming language that you are familiar with. For example, VB6 is shipped with a VB terminal event driven program that uses this control to read data from the communication port. You can covert the code to X++ and if you know what you are doing it will work. I used this control to read data from an electronic scale in DAX 3.0 some years ago. This control is packaged with MS Windows and is therefore free to use. If you wish you may purchase a higher level ActiveX control that would make the coding job far easier. Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: khalid_akkawi <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, February 28, 2008 4:38:06 PM Subject: [Axapta-Knowledge-Village] Re: Reading COM Port from Dynamics AX 3.0 Hi Anil, Please check [ AOT -> Classes -> SysMicrosoftAgent ] and use it as [ AOT -> Forms -> tutorial_COMAgent ] The SysMicrosoftAgent uses the COM and COMVariant classes for dealing with COM object. review this : http://msdn2. microsoft. com/en-us/ library/ms913028 .aspx I hope that would help you. Please let us know. Best Regards, Khalid Akkawi Dynamics AX Developer Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Where is the dataarea table?
You can look at system tables in the AOT under System Documentation -> Tables. You can browse them from there like any other table but you will not be able to change the definition. Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Tarek Saleh <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, January 8, 2008 2:24:03 AM Subject: Re: [Axapta-Knowledge-Village] Where is the dataarea table? Thanks again, Arijit Basu wrote: SSMS is SQL Server Management Studio (SQL 2005). If you are using SQL 2000, use the Query Analyzer to view the table. Cheers Arijit On Jan 8, 2008 2:39 PM, Tarek Saleh <[EMAIL PROTECTED] com> wrote: > Thanks my friend, > > But where i can find the SSMS? > > Regards, > Tarek > > > Arijit Basu > wrote: > Hi, > That is a system table and you will NOT find in the AOT. You can open SSMS > and see the table but its better if you dont try to modify it. > > Regards, > > Arijit > > On Jan 8, 2008 12:18 PM, Tarek Saleh <[EMAIL PROTECTED] > com> > wrote: > > > Dear All, > > > > can we customize in the dataarea table,by adding new field represent the > > company group. > > > > So far i was not able to find the table under the AOT table anybody > knowes > > were i can find the table? and is it possible to add in new field in it. > > > > Thanks a lot > > Tarek > > > > - - --- > > Looking for last minute shopping deals? Find them fast with Yahoo! > Search. > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > > Arijit Basu > > [Non-text portions of this message have been removed] > > - - --- > Never miss a thing. Make Yahoo your homepage. > > [Non-text portions of this message have been removed] > > > -- Arijit Basu [Non-text portions of this message have been removed] - - --- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. [Non-text portions of this message have been removed] Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Strings and Enum Type
Place the following in a job and see what you can get from it:
DictTable dictTable;
int FieldCount;
int NumOfFields;
FieldId fieldId;
TableId tableId;
DictField dictField;
DictEnumdictEnum;
int enumCount;
;
tableId = tableNum(CustInvoiceJour);
dictTable = new DictTable(tableId);
NumOfFields = dictTable.fieldCnt();
setPrefix(TableId2Name(tableId));
for (FieldCount = 1; FieldCount <= NumOfFields; FieldCount++)
{
fieldId = dictTable.fieldCnt2Id(FieldCount);
dictField = new DictField(tableId, fieldId);
if (dictField.baseType() == Types::Enum)
{
dictEnum = new DictEnum(dictField.enumId());
info(strfmt('Field Name - %1', dictTable.fieldName(FieldId)));
info(strfmt(' Enum Name - %1', dictEnum.name()));
for (enumCount=0;enumCount<=dictEnum.values() - 1;enumCount++)
{
info(strfmt(' %1 %2', enumCount,
dictEnum.index2Label(enumCount)));
}
}
}
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: neela gandan <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, December 4, 2007 8:45:12 PM
Subject: Re: [Axapta-Knowledge-Village] Strings and Enum Type
Hi ricardo,
can you use substr method, to get the alpha value alone.
ricardodegouveia wrote:
Hi all,
I have a problem, i currently have a string which i read from a file
that contains both alpha and numeric values. eg
"GA12312.12 FR3123 ER<1211"
How do i just get the alpha characters ie "GA" or "FR" out of the
string?
And how do i then compare to a Enum type i have created? how do i loop
through enum values in code?
Thanking you in advance
Ricardo
K.Neelagandan.
9994307471.
- - ---
Get easy, one-click access to your favorites. Make Yahoo! your homepage.
[Non-text portions of this message have been removed]
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: How to do groupings in AX Report?
You do not need to use code to do this unless you are building the query using code. You can change the Order Mode property of the data source node to Group By and add the sort field(s) to the Sorting node under the data source node. Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: rmrallistan <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, November 2, 2007 8:51:19 AM Subject: [Axapta-Knowledge-Village] Re: How to do groupings in AX Report? Hi Juan, Thank you very much for your help but please tell me as to which class you usually put this code? Thanks. Yna --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, "juan_garcia_ salas" wrote: > > HI Yna you can try this > > query.dataSourceNo( 2).orderMode( OrderMode: :GroupBy) ; > query.dataSourceNo( 2).addSortField( FieldNum( tmpBancos, AccountID)) > > regadrs > > --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, "rmrallistan" > wrote: > > > > Hello, > > > > I'm designing a new report from scratch and would like to do group by > > from a certain field. How can I do this? A sample code will be much > > appreciated. Thank you very much! > > > > Yna > > AX Newbie > > > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] select firstonly
Ok, this seems to be a very healthy conversation. I know that the dataAreaId is
apart of all indexes so this should lead to a performance boast if we select
the dataAreaId in cases where no field is required from the database.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: Harry Deshpande <[EMAIL PROTECTED]>
To: "Axapta-Knowledge-Village@yahoogroups.com"
Sent: Thursday, November 1, 2007 10:37:28 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
No, I don't think tableId is part of the index. Let me check the actual SQL
syntax generated and get back to you.
Regards
harry
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge-
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 9:36 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
Ok, I think I may understand what you are saying. Are you refering to a cover
index where the database uses the fields in the index page as the data without
using the data page (provided that all the required data fields are in the
index)? If this is so, are you saying that the tableId is usually apart of all
indexes created for tables in DAX?
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com<mailto:vardenm% 40yahoo.com>
- Original Message
From: Harry Deshpande <[EMAIL PROTECTED] com<mailto:harryd% 40microsoft. com>>
To: "Axapta-Knowledge- [EMAIL PROTECTED] ups.com<mailto:Axapta- Knowledge-
Village%40yahoog roups.com> " mailto:Axapta- Knowledge- Village%40yahoog roups.com> >
Sent: Thursday, November 1, 2007 10:29:52 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly
Hi
If recid is not part of the index then the logic has to do one more lookup to
get the recid. With tableId you get rid of this problem.
There are some inventory report where I remember this design has been
implemented.
Regards
Harry
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge-
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 9:27 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
Hey Harry,
This sounds new and unclear to me. Can you please give me some more details on
what you are saying here?
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com<mailto:vardenm% 40yahoo.com>
- Original Message
From: Harry Deshpande <[EMAIL PROTECTED] com<mailto:harryd% 40microsoft. com>>
To: "Axapta-Knowledge- [EMAIL PROTECTED] ups.com " >
Sent: Thursday, November 1, 2007 10:15:56 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly
Hi
May be worthwhile to ' join tableid from inventTable' . This will help slightly
with indexes that do not have recId.
Regards
Harry
-Original Message-
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge-
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 8:37 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You are most welcome. I have done countless tuning with joins as oppose to
individual selects and see major improvement in performance when the dataset is
large. Another thing you could do is "field select" instead of selecting all
the fields from each table. This can lead to major performance improvement. If
a table is needed in a join for a filter condition and the fields are not being
used I usually select the RecId field only to improve performance instead of
selecting all the fields. For example,
while select ItemId, LineAmount from salesLine
join recId from inventTable
where inventTable. ItemId == salesLine.ItemId
&& inventTable. ItemGroupId == ""
{
//Use ItemID and LineAmount (only) here
}
Selecting two out of 60 fields means a significant reduction in the amount of
data being fetched from the database sitting on one server to the AOS and/or
client on other computers across a network. You have to be careful with the
field select at times. It can lead to a bug if you decide to use an additional
field and you forget to add it to the select statement.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com
- Original Message
From: James Flavell <[EMAIL PROTECTED] com>
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Thursday, November 1, 2007 9:17:25 AM
Subject: RE: [Axapta-
Re: [Axapta-Knowledge-Village] select firstonly
Ok, I think I may understand what you are saying. Are you refering to a cover
index where the database uses the fields in the index page as the data without
using the data page (provided that all the required data fields are in the
index)? If this is so, are you saying that the tableId is usually apart of all
indexes created for tables in DAX?
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: Harry Deshpande <[EMAIL PROTECTED]>
To: "Axapta-Knowledge-Village@yahoogroups.com"
Sent: Thursday, November 1, 2007 10:29:52 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
Hi
If recid is not part of the index then the logic has to do one more lookup to
get the recid. With tableId you get rid of this problem.
There are some inventory report where I remember this design has been
implemented.
Regards
Harry
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge-
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 9:27 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
Hey Harry,
This sounds new and unclear to me. Can you please give me some more details on
what you are saying here?
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com<mailto:vardenm% 40yahoo.com>
- Original Message
From: Harry Deshpande <[EMAIL PROTECTED] com<mailto:harryd% 40microsoft. com>>
To: "Axapta-Knowledge- [EMAIL PROTECTED] ups.com<mailto:Axapta- Knowledge-
Village%40yahoog roups.com> " mailto:Axapta- Knowledge- Village%40yahoog roups.com> >
Sent: Thursday, November 1, 2007 10:15:56 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly
Hi
May be worthwhile to ' join tableid from inventTable' . This will help slightly
with indexes that do not have recId.
Regards
Harry
-Original Message-
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge-
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 8:37 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You are most welcome. I have done countless tuning with joins as oppose to
individual selects and see major improvement in performance when the dataset is
large. Another thing you could do is "field select" instead of selecting all
the fields from each table. This can lead to major performance improvement. If
a table is needed in a join for a filter condition and the fields are not being
used I usually select the RecId field only to improve performance instead of
selecting all the fields. For example,
while select ItemId, LineAmount from salesLine
join recId from inventTable
where inventTable. ItemId == salesLine.ItemId
&& inventTable. ItemGroupId == ""
{
//Use ItemID and LineAmount (only) here
}
Selecting two out of 60 fields means a significant reduction in the amount of
data being fetched from the database sitting on one server to the AOS and/or
client on other computers across a network. You have to be careful with the
field select at times. It can lead to a bug if you decide to use an additional
field and you forget to add it to the select statement.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com
- Original Message
From: James Flavell <[EMAIL PROTECTED] com>
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Thursday, November 1, 2007 9:17:25 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly
Thanks Varden,
Yes you are very correct.
I guess I will test with the join. The concern I had was both tables are
quite large in number of transactions so I was not sure join would work out
to be the best approach but I think yes I should test it out to see. :)
Thanks
James
_
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You can surely save on the number of calls being made to the database by
joining the two tables in the while select instead of separate calls to the
database for the while select followed by another select. If you do not use
the index hint the database will choose an optimum index, provided that
indexes exist and the database is configured to collect and update the
statistics periodically.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL P
Re: [Axapta-Knowledge-Village] select firstonly
Ok, I think I may understand what you are saying. Are you refering to a cover
index where the database uses the fields in the index page as the data without
using the data page (provided that all the required data fields are in the
index)? If this is so, are you saying that the tableId is usually apart of all
indexes created for tables in DAX?
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: Harry Deshpande <[EMAIL PROTECTED]>
To: "Axapta-Knowledge-Village@yahoogroups.com"
Sent: Thursday, November 1, 2007 10:29:52 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
Hi
If recid is not part of the index then the logic has to do one more lookup to
get the recid. With tableId you get rid of this problem.
There are some inventory report where I remember this design has been
implemented.
Regards
Harry
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge-
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 9:27 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
Hey Harry,
This sounds new and unclear to me. Can you please give me some more details on
what you are saying here?
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com<mailto:vardenm% 40yahoo.com>
- Original Message
From: Harry Deshpande <[EMAIL PROTECTED] com<mailto:harryd% 40microsoft. com>>
To: "Axapta-Knowledge- [EMAIL PROTECTED] ups.com<mailto:Axapta- Knowledge-
Village%40yahoog roups.com> " mailto:Axapta- Knowledge- Village%40yahoog roups.com> >
Sent: Thursday, November 1, 2007 10:15:56 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly
Hi
May be worthwhile to ' join tableid from inventTable' . This will help slightly
with indexes that do not have recId.
Regards
Harry
-Original Message-
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge-
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 8:37 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You are most welcome. I have done countless tuning with joins as oppose to
individual selects and see major improvement in performance when the dataset is
large. Another thing you could do is "field select" instead of selecting all
the fields from each table. This can lead to major performance improvement. If
a table is needed in a join for a filter condition and the fields are not being
used I usually select the RecId field only to improve performance instead of
selecting all the fields. For example,
while select ItemId, LineAmount from salesLine
join recId from inventTable
where inventTable. ItemId == salesLine.ItemId
&& inventTable. ItemGroupId == ""
{
//Use ItemID and LineAmount (only) here
}
Selecting two out of 60 fields means a significant reduction in the amount of
data being fetched from the database sitting on one server to the AOS and/or
client on other computers across a network. You have to be careful with the
field select at times. It can lead to a bug if you decide to use an additional
field and you forget to add it to the select statement.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com
- Original Message
From: James Flavell <[EMAIL PROTECTED] com>
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Thursday, November 1, 2007 9:17:25 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly
Thanks Varden,
Yes you are very correct.
I guess I will test with the join. The concern I had was both tables are
quite large in number of transactions so I was not sure join would work out
to be the best approach but I think yes I should test it out to see. :)
Thanks
James
_
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You can surely save on the number of calls being made to the database by
joining the two tables in the while select instead of separate calls to the
database for the while select followed by another select. If you do not use
the index hint the database will choose an optimum index, provided that
indexes exist and the database is configured to collect and update the
statistics periodically.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL P
Re: [Axapta-Knowledge-Village] select firstonly
Hey Harry,
This sounds new and unclear to me. Can you please give me some more details on
what you are saying here?
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: Harry Deshpande <[EMAIL PROTECTED]>
To: "Axapta-Knowledge-Village@yahoogroups.com"
Sent: Thursday, November 1, 2007 10:15:56 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
Hi
May be worthwhile to ' join tableid from inventTable' . This will help slightly
with indexes that do not have recId.
Regards
Harry
-Original Message-
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge-
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 8:37 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You are most welcome. I have done countless tuning with joins as oppose to
individual selects and see major improvement in performance when the dataset is
large. Another thing you could do is "field select" instead of selecting all
the fields from each table. This can lead to major performance improvement. If
a table is needed in a join for a filter condition and the fields are not being
used I usually select the RecId field only to improve performance instead of
selecting all the fields. For example,
while select ItemId, LineAmount from salesLine
join recId from inventTable
where inventTable. ItemId == salesLine.ItemId
&& inventTable. ItemGroupId == ""
{
//Use ItemID and LineAmount (only) here
}
Selecting two out of 60 fields means a significant reduction in the amount of
data being fetched from the database sitting on one server to the AOS and/or
client on other computers across a network. You have to be careful with the
field select at times. It can lead to a bug if you decide to use an additional
field and you forget to add it to the select statement.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com
- Original Message
From: James Flavell <[EMAIL PROTECTED] com>
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Thursday, November 1, 2007 9:17:25 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly
Thanks Varden,
Yes you are very correct.
I guess I will test with the join. The concern I had was both tables are
quite large in number of transactions so I was not sure join would work out
to be the best approach but I think yes I should test it out to see. :)
Thanks
James
_
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You can surely save on the number of calls being made to the database by
joining the two tables in the while select instead of separate calls to the
database for the while select followed by another select. If you do not use
the index hint the database will choose an optimum index, provided that
indexes exist and the database is configured to collect and update the
statistics periodically.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] <mailto:vardenm% 40yahoo.com> com
- Original Message
From: James Flavell <[EMAIL PROTECTED] <mailto:djf1994% 40gmail.com> com>
To: Axapta-Knowledge- <mailto:Axapta- Knowledge- Village%40yahoog roups.com>
[EMAIL PROTECTED] .com
Sent: Thursday, November 1, 2007 8:05:29 AM
Subject: [Axapta-Knowledge- Village] select firstonly
Hi again everyone,
Thanks Christoph for the feebdack on index. I have added indexes just to
play safe.
Another query I have is with the firstonly command. I understand basically
how it works but want to know how it really works in practice
Given this code:
while select WMSPallet
order by WMSPalletId
{
select firstonly InventPalletBP
where InventPalletBP. PalletId ==
WMSPallet.wMSPallet Id;
}
Is it better to use firstonly in such a situation?
I mean I am going to be looping through pallets so if I dont use firstonly a
number of inventpalletbp table records will be fetched together which in
theory would be a good thing to save on database calls. But then i am
wondering will the records that are fetched be in any particualr order (e.g.
by palletid) or just from the same page in the SQL server? I guess it
should be read ahead according to the where clause or do I need to
explicitly put an order by or index command against the InventPalletBP
select statement to be sure of this?
Looking forward to your input
Thanks
James
[Non-text portions of this message have been remov
Re: [Axapta-Knowledge-Village] select firstonly
You are most welcome. I have never looked into the problem with the journal
posting but I can point you in the required direction to look at it. You can
enable database tracing in DAX by selecting the SQL statements checkbox on
the tracing tab page of the Server Configuration Utility. On the DAX client
that you will be using to do the trace you should enable SQL trace on the SQL
tab page of the Options form and use a value of about 5000 milliseconds for the
threshold of long queries. Do the latter just before executing the bottleneck
process and disable it immediately after execution. You should then look
through the trace log for possible problems.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: James Flavell <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, November 1, 2007 9:49:52 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
Thanks a lot Varden,
I have not done much 'tunning' so thinking and trying various bits out so
your advice is great and will save me a lot of time in trial and testings
I am trying to imporve the data import and posting of inventory journals
(P/L and BOM journals) for some data migration scripts
One other thing I am not sure anyone can explain is why does the
JournalCheckPost class take longer to run if I set the DoNotCheck = true? I
would have thought skipping the check procedure would have made the posting
of a journal quicker but it seems to have the opposite effect...
Thanks again Varden
James
-Original Message-
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: 01 November 2007 11:37
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You are most welcome. I have done countless tuning with joins as oppose to
individual selects and see major improvement in performance when the dataset
is large. Another thing you could do is "field select" instead of selecting
all the fields from each table. This can lead to major performance
improvement. If a table is needed in a join for a filter condition and the
fields are not being used I usually select the RecId field only to improve
performance instead of selecting all the fields. For example,
while select ItemId, LineAmount from salesLine
join recId from inventTable
where inventTable. ItemId == salesLine.ItemId
&& inventTable. ItemGroupId == ""
{
//Use ItemID and LineAmount (only) here
}
Selecting two out of 60 fields means a significant reduction in the amount
of data being fetched from the database sitting on one server to the AOS
and/or client on other computers across a network. You have to be careful
with the field select at times. It can lead to a bug if you decide to use an
additional field and you forget to add it to the select statement.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com
- Original Message
From: James Flavell <[EMAIL PROTECTED] com>
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Thursday, November 1, 2007 9:17:25 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly
Thanks Varden,
Yes you are very correct.
I guess I will test with the join. The concern I had was both tables are
quite large in number of transactions so I was not sure join would work out
to be the best approach but I think yes I should test it out to see. :)
Thanks
James
_
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden
Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You can surely save on the number of calls being made to the database by
joining the two tables in the while select instead of separate calls to the
database for the while select followed by another select. If you do not use
the index hint the database will choose an optimum index, provided that
indexes exist and the database is configured to collect and update the
statistics periodically.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] <mailto:vardenm% 40yahoo.com> com
- Original Message
From: James Flavell <[EMAIL PROTECTED] <mailto:djf1994% 40gmail.com> com>
To: Axapta-Knowledge- <mailto:Axapta- Knowledge- Village%40yahoog roups.com>
[EMAIL PROTECTED] .com
Sent: Thursday, November 1, 2007 8:05:29 AM
Subject: [Axapta-Knowledge- Village] select firstonly
Hi again everyone,
Thanks Christoph for the feebdack on index. I have added indexes just to
pl
Re: [Axapta-Knowledge-Village] select firstonly
You are most welcome. I have done countless tuning with joins as oppose to
individual selects and see major improvement in performance when the dataset is
large. Another thing you could do is field select instead of selecting all
the fields from each table. This can lead to major performance improvement. If
a table is needed in a join for a filter condition and the fields are not being
used I usually select the RecId field only to improve performance instead of
selecting all the fields. For example,
while select ItemId, LineAmount from salesLine
join recId from inventTable
where inventTable.ItemId== salesLine.ItemId
&& inventTable.ItemGroupId == ""
{
//Use ItemID and LineAmount (only) here
}
Selecting two out of 60 fields means a significant reduction in the amount of
data being fetched from the database sitting on one server to the AOS and/or
client on other computers across a network. You have to be careful with the
field select at times. It can lead to a bug if you decide to use an additional
field and you forget to add it to the select statement.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: James Flavell <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, November 1, 2007 9:17:25 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
Thanks Varden,
Yes you are very correct.
I guess I will test with the join. The concern I had was both tables are
quite large in number of transactions so I was not sure join would work out
to be the best approach but I think yes I should test it out to see. :)
Thanks
James
_
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You can surely save on the number of calls being made to the database by
joining the two tables in the while select instead of separate calls to the
database for the while select followed by another select. If you do not use
the index hint the database will choose an optimum index, provided that
indexes exist and the database is configured to collect and update the
statistics periodically.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] <mailto:vardenm% 40yahoo.com> com
- Original Message
From: James Flavell <[EMAIL PROTECTED] <mailto:djf1994% 40gmail.com> com>
To: Axapta-Knowledge- <mailto:Axapta- Knowledge- Village%40yahoog roups.com>
[EMAIL PROTECTED] .com
Sent: Thursday, November 1, 2007 8:05:29 AM
Subject: [Axapta-Knowledge- Village] select firstonly
Hi again everyone,
Thanks Christoph for the feebdack on index. I have added indexes just to
play safe.
Another query I have is with the firstonly command. I understand basically
how it works but want to know how it really works in practice
Given this code:
while select WMSPallet
order by WMSPalletId
{
select firstonly InventPalletBP
where InventPalletBP. PalletId ==
WMSPallet.wMSPallet Id;
}
Is it better to use firstonly in such a situation?
I mean I am going to be looping through pallets so if I dont use firstonly a
number of inventpalletbp table records will be fetched together which in
theory would be a good thing to save on database calls. But then i am
wondering will the records that are fetched be in any particualr order (e.g.
by palletid) or just from the same page in the SQL server? I guess it
should be read ahead according to the where clause or do I need to
explicitly put an order by or index command against the InventPalletBP
select statement to be sure of this?
Looking forward to your input
Thanks
James
[Non-text portions of this message have been removed]
_ _ _ _ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. <http://mail. yahoo.com> yahoo.com
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Come and choose your preferred name for Microsoft Dynamics AX on the Axapta
Knowledge Village, Visit www.axapta-knowledge-village.tk
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> Your email settings:
Individual
Re: [Axapta-Knowledge-Village] select firstonly
You can surely save on the number of calls being made to the database by
joining the two tables in the while select instead of separate calls to the
database for the while select followed by another select. If you do not use the
index hint the database will choose an optimum index, provided that indexes
exist and the database is configured to collect and update the statistics
periodically.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: James Flavell <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, November 1, 2007 8:05:29 AM
Subject: [Axapta-Knowledge-Village] select firstonly
Hi again everyone,
Thanks Christoph for the feebdack on index. I have added indexes just to
play safe.
Another query I have is with the firstonly command. I understand basically
how it works but want to know how it really works in practice
Given this code:
while select WMSPallet
order by WMSPalletId
{
select firstonly InventPalletBP
where InventPalletBP. PalletId ==
WMSPallet.wMSPallet Id;
}
Is it better to use firstonly in such a situation?
I mean I am going to be looping through pallets so if I dont use firstonly a
number of inventpalletbp table records will be fetched together which in
theory would be a good thing to save on database calls. But then i am
wondering will the records that are fetched be in any particualr order (e.g.
by palletid) or just from the same page in the SQL server? I guess it
should be read ahead according to the where clause or do I need to
explicitly put an order by or index command against the InventPalletBP
select statement to be sure of this?
Looking forward to your input
Thanks
James
[Non-text portions of this message have been removed]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Display method on data source and table
You do not need the parameter for display method on the data source. Table
buffers on the data source are available throughout the form, so you can use
the buffer name to reference the fields.
display InventQty salesQty()
{
BufferName.fieldName;
}
Having the display method on the table is all about reusability. This means
that you will write the method once and reuse it anywhere required in the
application. If you create the method on a data source it will only be
available throughout the form that contains the data source.
Regards,
Varden Morris
276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Friday, October 26, 2007 3:38:57 AM
Subject: Re: [Axapta-Knowledge-Village] Display method on data source and table
Hi,
on Form Datasource you need the record as parameter:
display InventQty salesQty(myTable _myTable)
{
return _myTable.qty
}
...if you forgott, same value for each record in grid.
on Table you can simply use this:
display InventQty salesQty()
{
return this.qty
}
Best regards
Michael
- Original Message -
From: pradeep itnal
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Friday, October 26, 2007 10:55 AM
Subject: [Axapta-Knowledge- Village] Display method on data source and table
Hi all
What difference it makes if i write my "Display method " on Datasource and if i
write it on Table methods please tell me.
Thanks in advance.
Thanks & Regards
Pradeep S.Itnal
mob:+91-9886529409
- - ---
Now you can chat without downloading messenger. Click here to know how.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Regarding Reports
I believe the use of a temp table can solve this. Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: prasad pendyala <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, September 21, 2007 11:50:33 PM Subject: [Axapta-Knowledge-Village] Regarding Reports Hi I want to print data Verticallay in my report like 2004 2005 2006 - - - - - - TotalSales 1 1 10 Amount 32000 0 50 XXY 12 120 130 --- --- TOT 162000 121 190 -- --- - I need to pick the values for year wise from COA in Ax 4.0 Can anyone help me in this regard Thanks Prasad.Pendyala - - --- Chat on a cool, new interface. No download required. Click here. [Non-text portions of this message have been removed] Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] DAX4.0 client unable to start
Hi All, I have a problem where DAX4.0 closes immediately after startup. This is a result of a modification that added two menu items to a menu. If I hit control break before the client terminates I get a message saying too many menu levels. The modification was done in the cus layer and I do not have a backup of this layer. I am wondering if there is some startup command that I can possible use to bypass the rendering of the menu and give me access to the AOT to remove the change. Thanks in advance, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] Tonight's top picks. What will you watch tonight? Preview the hottest shows on Yahoo! TV. http://tv.yahoo.com/ [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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] Re: Group by in X++ ??
Thanks. That was an oversight by me. When using group by the field has to be
apart of an aggregation before it can be selected.
Varden Morris
85 Saddleland Close N.E.
Calgary, Alberta T3J 5J5
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
- Original Message
From: gomezdegomera <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Monday, July 30, 2007 2:51:10 PM
Subject: [Axapta-Knowledge-Village] Re: Group by in X++ ??
Hi Varden, the query you posted doesn't work
Query q = new Query();
QueryBuildDataSourc e dsSalesTable;
QueryBuildDataSourc e dsSalesLine;
QueryRun qr;
SalesTable SalesTable;
dsSalesTable = q.addDataSource( tablenum( SalesTable) );
dsSalesLine = dsSalesTable. addDataSource( tablenum( SalesLine) );
dsSalesLine. addLink(FieldNum (SalesTable, SalesId), FieldNum
(SalesLine,SalesId) );
dsSalesLine. JoinMode( JoinMode: :InnerJoin) ;
dsSalesLine. addSortField( FieldNum( SalesLine, SalesId));
dsSalesLine. orderMode( ordermode: :GroupBy) ;
dsSalesLine. addSelectionFiel d(FieldNum( SalesLine, LineAmount),
SelectionField: :Sum);
qr = new QueryRun(q);
while (qr.next())
{
SalesTable = qr.get(tablenum( SalesTable) );
print SalesTable.Delivery Address;
}
pause;
You will see that SalesTable.Delivery Address is `', no fields are filled
I was going to asking you a different way to make the query to work
when I found the problem
You missed an istruction like this
dsSalesLine. addSelectionFiel d(FieldNum( SalesTable, DeliveryAddress,
SelectionField: :Min);
Notice that you have to specify a type different than
SelectionField: :Database
Bye
--- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Varden Morris
<[EMAIL PROTECTED] > wrote:
>
> Hi Anton,
>
> I tried this in a job andI didn't get any error:
>
> Query q = new Query();
> QueryBuildDataSourc e dsSalesTable;
> QueryBuildDataSourc e dsSalesLine;
> QueryRun qr;
> SalesTable SalesTable;
> dsSalesTable = q.addDataSource( tablenum( SalesTable) );
> dsSalesLine = dsSalesTable. addDataSource( tablenum( SalesLine) );
> dsSalesLine. addLink(FieldNum (SalesTable, SalesId), FieldNum
> (SalesLine,SalesId) );
> dsSalesLine. JoinMode( JoinMode: :InnerJoin) ;
> dsSalesLine. addSortField( FieldNum( SalesLine, SalesId));
> dsSalesLine. orderMode( ordermode: :GroupBy) ;
> dsSalesLine. addSelectionFiel d(FieldNum( SalesLine, LineAmount),
> SelectionField: :Sum);
> qr = new QueryRun(q);
> while (qr.next())
> {
> SalesTable = qr.get(tablenum( SalesTable) );
> print SalesTable.Delivery Address;
> }
> pause;
>
> anton_tjiptadi wrote:
>
> Hi,
> How to create X++ query for Group By ??
>
> My select statement is simply like this (in Transact SQL)
>
> select a.salesid, sum(b.lineamount) from salestable a, salesline b
> where a.salesid=b. salesid
> group by a.salesid
>
> I try to build in X++ like this, but it cause error said that there's
> no Group by
>
> dsSalesTable = q.addDataSource( tablenum( SalesTable) );
> dsSalesLine = dsSalesTable. addDataSource( tablenum( SalesLine) );
> dsSalesLine. addLink(FieldNum (SalesTable, SalesId), FieldNum
> (SalesLine,SalesId) );
> dsSalesLine. JoinMode( JoinMode: :InnerJoin) ;
> dsSalesLine. addSortField( FieldNum( SalesLine, SalesId));
> dsSalesLine. orderMode( ordermode: :GroupBy) ;
> dsSalesLine. addSelectionFiel d(FieldNum( SalesLine, LineAmount),
> SelectionField: :Sum);
>
> Thanks in advance,
>
>
>
>
>
>
> 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:
> Axapta-Knowledge- Village-unsubscr [EMAIL PROTECTED] com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
> - - ---
> Do you Yahoo!?
> Take Yahoo! Mail with you! Get it on your mobile phone.
>
Shape Yahoo! in your own image. Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Come and choose your preferred name for Microsoft Dynamics AX on the Axapta
Knowledge Village, Visit www.axapta-knowledge-village.tk
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com
Re: [Axapta-Knowledge-Village] Help on Header-Line Style Form Development
Ensure that the data source property value for the detail line is correctly set to the detail table and not the master table. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: XeN <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 30, 2007 6:28:33 AM Subject: [Axapta-Knowledge-Village] Help on Header-Line Style Form Development I have created two tables with master-detail relationship, and put them on a form which consist of two groups, and two grids and outer-join relation between two tables. The problem is, when I press the New button on toolbar, both grids create a new record whereas the same- style Purchase and Sales forms of axapta do not. How can it be solved? Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. http://autos.yahoo.com/green_center/ [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] How to call Stored Procedure From Axapta 4.0
I think it should be possible to do it the same way as in 3.0. Have a look at the Statement class. There is no documentation for this class in 4.0 so if you have access to a 3.0 install you can take a look at the documentation. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: nitinmathur_jpr <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 16, 2007 6:11:14 AM Subject: [Axapta-Knowledge-Village] How to call Stored Procedure From Axapta 4.0 Hello Friends Can Any one tell me How to call Stored Procedure From Axapta 4.0? Nitin Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Current UserId
Use the function CurUserId(). Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: febinpc <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 9, 2007 11:36:12 AM Subject: [Axapta-Knowledge-Village] Current UserId Hi friends I'm working on AX 4.0, I want catch the Current Userid of application, or in simple language we can say ,I want to print the Current user ID Can anybody help me to solve it... Reagrds Febin Chiramel The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Axapta training
Hi Subbu, I think I now understand what you are saying after a few emails. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: "Subrahmanyam,Mamidi" <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Sunday, February 25, 2007 2:58:57 PM Subject: Re: [Axapta-Knowledge-Village] Axapta training Hi Laxman/Varden, All what I am doing is just - advising Tajudeen to check the credentials of the trainer/institution . I KNOW how the most training instituions work in India. FYI, I was trained from MS guys, USA. I just felt little fishy/pushy when Ashwathi said "They are ready to provide and undertake training related for axapta 4.0 "also" " . 4.0 is just couple of months old. Again, tajudden as i said 'if the trainer is so trained o train you, he wont be sitting in the training institute'. They normally quarentee you the placement, obviously end up the tutor for the next batch...just kidding... As I informed I am just advising Tajudeen to get trained from MS partners . We wish Tajudeen good luck and welcome to Axapta and I feel its better not to scare tajudeen further. We can stop here unless Ashwathi declaress the Instituion,. -Subbu MS double Certifed Master Varden Morris <[EMAIL PROTECTED] com> wrote: My honest opinion on this is that I believe that training in Dynamics AX is great in giving you a jump start. What you get out of the training can be dependent on several factors. The more practical experience you have the better it will be, plus the way how the instructor delivers the course. I realize that teaching is an art that some people do a great job at while others do not. Personally, I have gone to one instructor lead training and it was a great jump start, but it was only a fraction of what needed to pass the exam. The majority of the preparation for the exam came from my practical experience. It took me three tries to pass that exam. I took about three months after the second try and went back through the hard to understand course materials. During my practices it came to me and I passed the exam hands down on the third try. I have also passed other MBS exams without instructor lead training. I purchase or acquire the material from MCTs in organizations that I have worked. I install the software and practice from it. For one of the exams it took me three tries to pass, same as when I did the instructor lead course. For another it took me one shot as a result of my experience in that area. This can take a few months but it worth the practice to ensure that you will be prepared to deal with real life situations on the job. It also takes a lot of discipline and determination to get this done. In saying all of this, I believe that instructor lead courses that are properly delivered are great in helping people to understand what is expected of them, and a lot is also dependent on practical experience. I have personally lead a number training and I realize that mentorship can be a big help as people go off on there own and questions start coming to their heads. Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] com - Original Message From: meena lakshmanan <[EMAIL PROTECTED] co.in> To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Saturday, February 24, 2007 9:49:49 PM Subject: Re: [Axapta-Knowledge- Village] Axapta training Hi Subbu, I have gone through your comments regarding training. I strongly advise you that you don't discourage others to take training from MS learning solutions competency partners. May be in US, you do not find any trusted source for training or I do not know how you have got succeeded either by having gone through the manuals or some other source which I am not supposed to tell since it may not be good for you. Moreover, I am of the opinion, no body can get certified if he or she has not undergone training provided by the MS partner wherein the students courseware and intensive lab training will be provided as per the guidelines of Microsoft.As per your advise ie., studying manual alone, no body will get succeed and will not have a exposure to application part which is most important. Financial series alone will comprise of General Ledger, Accounts Receivable, Accounts Payable and Fixed Assets which require extensive lab training and by looking at the manual ( As per your advise ), he may get succeed only if he has got practical knowledge of applying all the parameters etc., Even if he gets certified by studying manual and/or through some other source, he may find difficulty once he gets offer based on the ceritification. This is for your information, please and also I strongly advise all the one who want to be axapta pr
Re: [Axapta-Knowledge-Village] Axapta training
My honest opinion on this is that I believe that training in Dynamics AX is great in giving you a jump start. What you get out of the training can be dependent on several factors. The more practical experience you have the better it will be, plus the way how the instructor delivers the course. I realize that teaching is an art that some people do a great job at while others do not. Personally, I have gone to one instructor lead training and it was a great jump start, but it was only a fraction of what needed to pass the exam. The majority of the preparation for the exam came from my practical experience. It took me three tries to pass that exam. I took about three months after the second try and went back through the hard to understand course materials. During my practices it came to me and I passed the exam hands down on the third try. I have also passed other MBS exams without instructor lead training. I purchase or acquire the material from MCTs in organizations that I have worked. I install the software and practice from it. For one of the exams it took me three tries to pass, same as when I did the instructor lead course. For another it took me one shot as a result of my experience in that area. This can take a few months but it worth the practice to ensure that you will be prepared to deal with real life situations on the job. It also takes a lot of discipline and determination to get this done. In saying all of this, I believe that instructor lead courses that are properly delivered are great in helping people to understand what is expected of them, and a lot is also dependent on practical experience. I have personally lead a number training and I realize that mentorship can be a big help as people go off on there own and questions start coming to their heads. Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: meena lakshmanan <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, February 24, 2007 9:49:49 PM Subject: Re: [Axapta-Knowledge-Village] Axapta training Hi Subbu, I have gone through your comments regarding training. I strongly advise you that you don't discourage others to take training from MS learning solutions competency partners. May be in US, you do not find any trusted source for training or I do not know how you have got succeeded either by having gone through the manuals or some other source which I am not supposed to tell since it may not be good for you. Moreover, I am of the opinion, no body can get certified if he or she has not undergone training provided by the MS partner wherein the students courseware and intensive lab training will be provided as per the guidelines of Microsoft.As per your advise ie., studying manual alone, no body will get succeed and will not have a exposure to application part which is most important. Financial series alone will comprise of General Ledger, Accounts Receivable, Accounts Payable and Fixed Assets which require extensive lab training and by looking at the manual ( As per your advise ), he may get succeed only if he has got practical knowledge of applying all the parameters etc., Even if he gets certified by studying manual and/or through some other source, he may find difficulty once he gets offer based on the ceritification. This is for your information, please and also I strongly advise all the one who want to be axapta professional to take training in MS Learning Solutions Competency Partners who are specialised in giving training for Microsoft Dynamics - AX. Regards, Lakshmanan. --- "Subrahmanyam, Mamidi" <[EMAIL PROTECTED] com> wrote: > Hi Tajudeen, > > I stringly advise to get the training from MS or > from a local MS partner in India. Dont get fooled > by some money milking guys in Inida. I know how it > works in Training centers in India. The logic is > very simple. if the trainer is so trainined to train > you, he wont be sitting there to train you for 10 to > 20K INR (salary) in the training company. He would > be better working in the implemetations for > companies. Trust me, if it rains in US ( software > boom) , all the one man armed (some uneducated too) > training companies open shelters or umbrellas ( > Training centers ) and corrupt the system. I dont > have anything aginst in bangalore/hyderabad /chennai. > I am from Indai too. So giving a hint to watch out > the outcome fr your money. if you read the manuals > for 2 monhs , anybody can get certifed :-). So get > trained from MS educational institution. I never > watsed my money in india. > > My 2 US cents. > > Thanks & Regards, > subbu > Double Certified Axapta Master ( Both tech and > functional ) > > > "tajudeen M.A" <[EMAIL PROTECTED] com> wro
Re: Re: Re: [Axapta-Knowledge-Village] How to read data from weighing instrument?SOS!!!
You are most welcome. Please let me know if you have any problem. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: "[EMAIL PROTECTED]" ; "[EMAIL PROTECTED]" Sent: Sunday, February 11, 2007 5:57:51 PM Subject: Re: Re: Re: [Axapta-Knowledge-Village] How to read data from weighing instrument?SOS!!! HI, Morris, Thank you very much! I will try to use it in ax. In fact i know how to call com port in VB, but i am not sure how to handdle it in ax. andy. [EMAIL PROTECTED] 2007-02-12 发件人： Varden Morris 发送时间： 2007-02-10 13:28:26 收件人： Axapta-Knowledge- [EMAIL PROTECTED] ups.com 抄送： 主题： Re: Re: [Axapta-Knowledge- Village] How to read data from weighing instrument?SOS! !! Hi Buddy, Do a search on ActiveX in the Developer's Guide. There is a section that shows you how to add an ActiveX control to a form. The next thing you should do is look for sample code that shows you how to use the MSCOMM control. This is available in VB6 and you may look at this link http://www.microsof t.com/downloads/ details.aspx? familyid= 01efe663- e0ff-4147- aa8b-ab9549605ea 2&displaylang= en. Once you understand the VB6 code you should have a head start to do what you would like to do in X++. In VB6 you set a property value of the ActiveX control as follows: MSCOMM.ComPort = 1 But remember that the comparable code in X++ whould be: MSCOMM.ComPort( 1); This is important to know because it may frustrate you if you forget that X++ uses function calls to set and get property values of a variable in an object, as a result of the encapsulation of variables in the object. Hope this gives you a kick start. One final thing, in order for you to trigger the value from the scale on the comport you should output an end-of-line character to the port. This will trigger the OnEvent method/event of the ActiveX control, where you should read the value. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] com - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: "Axapta-Knowledge- [EMAIL PROTECTED]" ; "Axapta-Knowledge- [EMAIL PROTECTED]" Sent: Thursday, February 8, 2007 5:29:36 PM Subject: Re: Re: [Axapta-Knowledge- Village] How to read data from weighing instrument?SOS! !! HI,Morris yes,i want to use MSCOM activeX to read data from the COM port, but could you tell me how to call MSCOM ActiveX in axapta? thank you very much. [EMAIL PROTECTED] 2007-02-09 发件人： Varden Morris 发送时间： 2007-02-07 00:41:16 收件人： Axapta-Knowledge- [EMAIL PROTECTED] ups.com 抄送： 主题： Re: [Axapta-Knowledge- Village] How to read data from weighing instrument?SOS! !! You can use the MSCOM activeX control to read data from the COM port of the computer where the scale is connected. If you are using Citrix or Terminal Server to launch the AX client you can configure them to map the client computer port, instead of the Citrix or Terminal Server, to the AX client. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] com - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: Axapta-Knowledge- Village Sent: Monday, February 5, 2007 5:58:00 PM Subject: [Axapta-Knowledge- Village] How to read data from weighing instrument?SOS! !! Dear all I want to read data from weighting instrumnet to Axapta, do you have any souce code or expirement or suggestion?? ? thanks you very much!!! -- qhpeng 2007-02-06 _ _ _ _ _ _ Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames. yahoo.com/ platform? platform= 120121 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] _ _ _ _ _ _ Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. http://tools. search.yahoo. com/toolbar/ features/ mail/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now. [Non-text portions of this message have been removed]
Re: Re: [Axapta-Knowledge-Village] How to read data from weighing instrument?SOS!!!
Hi Buddy, Do a search on ActiveX in the Developer's Guide. There is a section that shows you how to add an ActiveX control to a form. The next thing you should do is look for sample code that shows you how to use the MSCOMM control. This is available in VB6 and you may look at this link http://www.microsoft.com/downloads/details.aspx?familyid=01efe663-e0ff-4147-aa8b-ab9549605ea2&displaylang=en. Once you understand the VB6 code you should have a head start to do what you would like to do in X++. In VB6 you set a property value of the ActiveX control as follows: MSCOMM.ComPort = 1 But remember that the comparable code in X++ whould be: MSCOMM.ComPort(1); This is important to know because it may frustrate you if you forget that X++ uses function calls to set and get property values of a variable in an object, as a result of the encapsulation of variables in the object. Hope this gives you a kick start. One final thing, in order for you to trigger the value from the scale on the comport you should output an end-of-line character to the port. This will trigger the OnEvent method/event of the ActiveX control, where you should read the value. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: "[EMAIL PROTECTED]" ; "[EMAIL PROTECTED]" Sent: Thursday, February 8, 2007 5:29:36 PM Subject: Re: Re: [Axapta-Knowledge-Village] How to read data from weighing instrument?SOS!!! HI,Morris yes,i want to use MSCOM activeX to read data from the COM port, but could you tell me how to call MSCOM ActiveX in axapta? thank you very much. [EMAIL PROTECTED] 2007-02-09 发件人： Varden Morris 发送时间： 2007-02-07 00:41:16 收件人： Axapta-Knowledge- [EMAIL PROTECTED] ups.com 抄送： 主题： Re: [Axapta-Knowledge- Village] How to read data from weighing instrument?SOS! !! You can use the MSCOM activeX control to read data from the COM port of the computer where the scale is connected. If you are using Citrix or Terminal Server to launch the AX client you can configure them to map the client computer port, instead of the Citrix or Terminal Server, to the AX client. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] com - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: Axapta-Knowledge- Village Sent: Monday, February 5, 2007 5:58:00 PM Subject: [Axapta-Knowledge- Village] How to read data from weighing instrument?SOS! !! Dear all I want to read data from weighting instrumnet to Axapta, do you have any souce code or expirement or suggestion?? ? thanks you very much!!! -- qhpeng 2007-02-06 _ _ _ _ _ _ Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames. yahoo.com/ platform? platform= 120121 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. http://tools.search.yahoo.com/toolbar/features/mail/ [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] how can we achieve to get data from table on report ?
Use a programmable section. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: inan celik <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, February 6, 2007 10:22:57 AM Subject: [Axapta-Knowledge-Village] how can we achieve to get data from table on report ? Hi All , I have a got a problem that is related with reports .I want to put an area about dynamic datas and this area can support an option to select a record after that the record should write on the specific area on Report . For example this area is consist of employees names but i need to select the right name then to write on there . How can i solve this problem ? - - --- Have a burning question? Go to Yahoo! Answers and get answers from real people who know. [Non-text portions of this message have been removed] Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. http://autos.yahoo.com/new_cars.html [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] How to read data from weighing instrument?SOS!!!
You can use the MSCOM activeX control to read data from the COM port of the computer where the scale is connected. If you are using Citrix or Terminal Server to launch the AX client you can configure them to map the client computer port, instead of the Citrix or Terminal Server, to the AX client. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village Sent: Monday, February 5, 2007 5:58:00 PM Subject: [Axapta-Knowledge-Village] How to read data from weighing instrument?SOS!!! Dear all I want to read data from weighting instrumnet to Axapta, do you have any souce code or expirement or suggestion?? ? thanks you very much!!! -- qhpeng 2007-02-06 Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Locking forms in Axapta 3.0 SP4
My mistake. This only makes the form stay on top. This may not be the solution you are looking for. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Varden Morris <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, February 5, 2007 4:48:07 PM Subject: Re: [Axapta-Knowledge-Village] Locking forms in Axapta 3.0 SP4 On the Design node of the form, change the WindowType property to the value popup. This will make the form modal. Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] com - Original Message From: Jorge HS <[EMAIL PROTECTED] com.ar> To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com; Axapta_Documentatio [EMAIL PROTECTED] com; 4AxaptaProfessional [EMAIL PROTECTED] com; development- [EMAIL PROTECTED] ps.com Sent: Monday, February 5, 2007 7:59:10 AM Subject: [Axapta-Knowledge- Village] Locking forms in Axapta 3.0 SP4 Hello everybody, I'm opening a Form from a Class, and I need lock all anothers forms that are opened. Then when I close the actually form, unlock all anothers forms. That I need do is the same that happen when I call the DialogBox (this function open a dialog and lock all the others form that are opened, and when this dialog is close, the others forms are unlocked). I can't use the DialogBox, because I need use a form for data entry. Somebody know how I can do this?? Thanks in advance to all. Jorge - - --- Preguntá. Respondé. Descubrí. Todo lo que querías saber, y lo que ni imaginabas, está en Yahoo! Respuestas (Beta). Probalo ya! [Non-text portions of this message have been removed] _ _ _ _ _ _ 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] Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Locking forms in Axapta 3.0 SP4
On the Design node of the form, change the WindowType property to the value popup. This will make the form modal. Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: Jorge HS <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com; Axapta_Documentation@yahoogroups.com; [EMAIL PROTECTED]; development-axapta@yahoogroups.com Sent: Monday, February 5, 2007 7:59:10 AM Subject: [Axapta-Knowledge-Village] Locking forms in Axapta 3.0 SP4 Hello everybody, I'm opening a Form from a Class, and I need lock all anothers forms that are opened. Then when I close the actually form, unlock all anothers forms. That I need do is the same that happen when I call the DialogBox (this function open a dialog and lock all the others form that are opened, and when this dialog is close, the others forms are unlocked). I can't use the DialogBox, because I need use a form for data entry. Somebody know how I can do this?? Thanks in advance to all. Jorge - - --- Preguntá. Respondé. Descubrí. Todo lo que querías saber, y lo que ni imaginabas, está en Yahoo! Respuestas (Beta). Probalo ya! [Non-text portions of this message have been removed] 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] Converting from base64 string to binary
Hi Group, In Dynamics AX 4.0 the loadFromBase64 method on the BinData class allows you to convert a base64 string to binary format. However, in version 3.0 this method does not exist on the class. I reach as far as coding a class that converts a base64 string to a binary STRING, but I am not sure how to get this into binary format. Does anyone have any suggestion or code that could help in doing this? Your help will be appreciated. Thanks, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] System Monitor in 4.0
Does anyone know the reason for the removal of this tool from 4.0? Harry, you might know more than the rest of us. I think this is a really cool tool that should be in 4.0. Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] Don't get soaked. Take a quick peak at the forecast with the Yahoo! Search weather shortcut. http://tools.search.yahoo.com/shortcuts/#loc_weather [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Axapta vs SAP
The only thing I have done concerning SAP is buying and reading a book for the ABAP/4 programming language. Someone can correct me if I am wrong on this one but as far as I know SAP does not have the high level of flexibility for customization that Dynamics AX has and from my reading and comparison the interface is not as intuitive for the developer and user as Dynamics AX. To a large extent I think people want to be able to customize their unique business processes instead of being forced to use something out of the box that may fail as a result inflexibility. With Dynamics AX, if you have an idea you have an opportunity. Regards, Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: axaptos <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, January 10, 2007 12:06:26 AM Subject: [Axapta-Knowledge-Village] Axapta vs SAP Hallo Gurus, Have anyone ever compared between Axapta 4 and SAP features, especially in Financial modules? Things that Ax can't do but SAP can and vise versa. What i know SAP has Fund management and need customization in Ax. Others? Regards, John __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Visit www.axapta-knowledge-village.tk Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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] Item attribute personalization and store
I think item groups should be good enough to categorize the items as air, sold or gas. For the variation of each item you should look into creating a configuration group for each item as required. Arijit Basu <[EMAIL PROTECTED]> wrote: Hi, Can u tell me if these attributes decide the Prices/ Cost for these items. If these are for information & reporting only, you may consider to add an field which determine the item type and based on the item type (Air/ Solid/Gas) , you may add new fields which describe the attributes of these items. Based on the selection, you can enable/disable these fileds in the item master. Hope it helps :) Cheers On 12/4/06, dj3mb3 <[EMAIL PROTECTED]> wrote: > > I wish to fit Axapta 3.0 production for three kind of items. > A solid (ex. Iron), a gas (ex. air) and a liquid (ex. Color). > > Every Item has own attrib: > > Iron: Atomic mass [g/mol] > Melting point [°C] > ... > > air: oxygen min. [%] > azote min. [%] > other gas. [%] > ... > > Color: Viscosity [mm²/s] > Pantone [number] > ... > > In the Item form how can I create a group of attribute for every > typology of article and store its appropriate values. > > (For example I want to store 3 kind of iron, 2 kind of air and 5 color) > > thank you, Luca > > > -- Arijit Basu [Non-text portions of this message have been removed] Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Have a burning question? Go to Yahoo! Answers and get answers from real people who know. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Help - Getting MBS Certificate from Microsoft
I called 800.456.0025 today and it was great that I was able to get thru to someone. My certificate is now on its way. Jake <[EMAIL PROTECTED]> wrote: I had to contact MBS to get a hold of my cert as well. Bugging them got them to send out the cert finally. Hope that helps! Thanks, Jake http://axaptasource.com --- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris <[EMAIL PROTECTED]> wrote: > > Hi Vijay, > > I have the same problem with an exam I passed recently and I hate the fact that I do not get a response from Microsoft after sending an email to the same address. What is even worse is the fact that I had two problems and I got a response for one problem with my second problem being totally ignored. I am going to send an email to [EMAIL PROTECTED] and see if it makes a difference. > > I passed my first exam on March 9, 2005 and I had to write Microsoft ([EMAIL PROTECTED]) on June 21, 2005 about my certificate. This is the response I got the day after sending the email and I got the certificate shortly after: > > Thank your for your inquiry! > > Upon researching your exams, unfortunately we have been unable to locate > a profile for you in the MBS Voice system to Verify a shipping address. > If you could kindly provide us with the following information, we will > be sure these are printed up and sent out with our next shipping date! > > * Please provide the Registration and Validation Numbers, > or a screenshot of the passing information from VUE, and we will > research as much as possible to try and locate this. > * > Please provide the complete shipping address where this > Certificate should be mailed to once we get the information updated > > * > Street address: > * City: > * State (if applicable): > * Postal Code: > * Country: > > ***If you are with an MBS Partner, please read the information below > > Currently, all exams taken at testing centers are automatically matched > up with the Partner and Profile information in Voice, and transferred > over into the appropriate accounts, and Certificates are automatically > printed, based on the information filled out on the exam. Unfortunately, > if the information filled out on the exams does not match with your > Voice System's Partner information (i.e., nicknames, spelling > variations, etc..), or if the student taking the exam does not have a > current profile setup in Voice, the exams cannot automatically update. > > If you are currently with an MBS Partner, you will want to be sure and > setup a profile before your next exam. This will not only ensure your > exams are automatically updated to your Partner's account, but will also > automatically pull your Certificate typically within 30 days of your > exam completion. You can work with your company's Voice administrator or > the Voice Team directly at [EMAIL PROTECTED] > to assist in setting this up. > > Thank you again, and we will keep an eye out for your response so we may > further assist! > > ___ > Cristina Guhman | Microsoft Business Solutions > Customer Service: Training, Certification, eLearning > ph: 800.456.0025, option 4 | Fx: 425.936.7329 - Attn: MBSUNIV > [EMAIL PROTECTED] - inquiries > about exams, certifications, exam preparation > [EMAIL PROTECTED] - inquiries > about eCourses, online training > [EMAIL PROTECTED] - training > registration > [EMAIL PROTECTED] - Inquiries > about MBS Courseware/Training Materials > > > vijay karthik <[EMAIL PROTECTED]> wrote: > Hi, > I passed the MBS axapta programming certificate 3 months before(20/09/2006). but still not yet getting the certificate from microsoft. i sent the mail to [EMAIL PROTECTED] .i got the reply also, but not yet getting the certificate. > now i tried to send mail to [EMAIL PROTECTED], it has bounced/ failure delivary. have any one having alternate mail id / what is the way to get the certificate for my cleared Axapta Programming exam. > > Thanks & Regards, > Vijay Kartik.K > > Send instant messages to your online friends http://uk.messenger.yahoo.com > > [Non-text portions of this message have been removed] > > > > > > > Varden Morris > > 85 Saddleland Close N.E. > Calgary, Alberta T3J 5J5 > Canada > > (403) 366-8434 (H) > (403) 615-1604 (C) > [EMAIL PROTECTED] > > > > > - > Want to start your own business? Learn how on Yahoo! Small Business. > > [Non-text portions of this message have been removed] > Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Everyone is raving about the all-new Yahoo! Mail beta. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Help - Getting MBS Certificate from Microsoft
Hi Vijay, I have the same problem with an exam I passed recently and I hate the fact that I do not get a response from Microsoft after sending an email to the same address. What is even worse is the fact that I had two problems and I got a response for one problem with my second problem being totally ignored. I am going to send an email to [EMAIL PROTECTED] and see if it makes a difference. I passed my first exam on March 9, 2005 and I had to write Microsoft ([EMAIL PROTECTED]) on June 21, 2005 about my certificate. This is the response I got the day after sending the email and I got the certificate shortly after: Thank your for your inquiry! Upon researching your exams, unfortunately we have been unable to locate a profile for you in the MBS Voice system to Verify a shipping address. If you could kindly provide us with the following information, we will be sure these are printed up and sent out with our next shipping date! * Please provide the Registration and Validation Numbers, or a screenshot of the passing information from VUE, and we will research as much as possible to try and locate this. * Please provide the complete shipping address where this Certificate should be mailed to once we get the information updated * Street address: * City: * State (if applicable): * Postal Code: * Country: ***If you are with an MBS Partner, please read the information below Currently, all exams taken at testing centers are automatically matched up with the Partner and Profile information in Voice, and transferred over into the appropriate accounts, and Certificates are automatically printed, based on the information filled out on the exam. Unfortunately, if the information filled out on the exams does not match with your Voice System's Partner information (i.e., nicknames, spelling variations, etc..), or if the student taking the exam does not have a current profile setup in Voice, the exams cannot automatically update. If you are currently with an MBS Partner, you will want to be sure and setup a profile before your next exam. This will not only ensure your exams are automatically updated to your Partner's account, but will also automatically pull your Certificate typically within 30 days of your exam completion. You can work with your company's Voice administrator or the Voice Team directly at [EMAIL PROTECTED] to assist in setting this up. Thank you again, and we will keep an eye out for your response so we may further assist! ___ Cristina Guhman | Microsoft Business Solutions Customer Service: Training, Certification, eLearning ph: 800.456.0025, option 4 | Fx: 425.936.7329 - Attn: MBSUNIV [EMAIL PROTECTED] - inquiries about exams, certifications, exam preparation [EMAIL PROTECTED] - inquiries about eCourses, online training [EMAIL PROTECTED] - training registration [EMAIL PROTECTED] - Inquiries about MBS Courseware/Training Materials vijay karthik <[EMAIL PROTECTED]> wrote: Hi, I passed the MBS axapta programming certificate 3 months before(20/09/2006). but still not yet getting the certificate from microsoft. i sent the mail to [EMAIL PROTECTED] .i got the reply also, but not yet getting the certificate. now i tried to send mail to [EMAIL PROTECTED], it has bounced/ failure delivary. have any one having alternate mail id / what is the way to get the certificate for my cleared Axapta Programming exam. Thanks & Regards, Vijay Kartik.K Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Want to start your own business? Learn how on Yahoo! Small Business. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Disable a field on the form
Change the "allowEdit" property of the field on the form data source node to "No". This will disable the field everywhere it's being used on the form. To disable the field on all user interface in the application you should set the "AllowEdit" property of the field on the TABLE to "No". V G <[EMAIL PROTECTED]> wrote: Hi I want to disable a field on the form which is in auto group. Thanks in advance for help Regards [Non-text portions of this message have been removed] Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Inserting data from other application.REc id generate...
Here is an idea. You canb use COM to get the RECID from AX.
static void RecIDs()
{
SystemSequence systemSequence = new SystemSequence();
int recIdValue;
int tableId;
str table = 'CustTable';
int numberIDs = 1; // Number of RecIDs to reserve
;
tableId = TableName2Id(table);
if( tableId )
{
recIdValue = systemSequence.reserveValues(numberIDs, tableId );
}
info(strfmt('%1', recIdValue));
}
Ramazan GÝRGÝN <[EMAIL PROTECTED]> wrote:
Hi all,
I want to insrt data from other application directly SQL database. But while
inserting data i need next recid from Axapta. How can i take next recid from
axapta in other application .???
Thanks in advance
[Non-text portions of this message have been removed]
Varden Morris
85 Saddleland Close N.E.
Calgary, Alberta T3J 5J5
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Axapta programming book � MORPHX IT
Hi Steen, Is there a hard copy to this book? Is there an option to purchase and download instead of having it shipped to an address? Steen Andreasen <[EMAIL PROTECTED]> wrote: I have written an introduction book on how to use the Axapta development environment. The target group is newbie's to Axapta development. If you are a programmer, a technical person, a consultant who wants to learn about the Axapta development environment or simply just want to catch up on a specific area, the book will be useful for you. MORPHX IT is not just a walk-through of the development environment in Axapta, as the book is based on my more than 8 years of experience on programming in Axapta. You can get the book from here: www.morphxit.com For more information, reviews and download of samples from the book: www.steenandreasen.com Br, Steen Andreasen [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. ----- Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [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] How to find the data type of the field
Here is an example:
static void Job12(Args _args)
{
SysDictField df;
TableId tableId = tablenum(custTable);
FieldId fieldId = fieldnum(custTable, AccountNum);
;
df = new SysDictField(tableId, fieldId);
switch (df.baseType())
{
case Types::Date:
info('Date');
break;
case Types::Integer:
info('Integer');
break;
case Types::String:
info('String');
break;
}
}
V G <[EMAIL PROTECTED]> wrote:
Hello
Can anyone help me find the datatype of the field if I have table Id and
FieldId.
Thanks
VG
[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.
-----
Varden Morris
85 Saddleland Close N.E.
Calgary, Alberta T3J 5J5
Canada
(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]
-
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
[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] system administration question
Thaks Harry.
Harry Deshpande <[EMAIL PROTECTED]> wrote: void active()
{
element.setCaption();
if (!saving)
element.updateDisplay();
if (this.isAdmin())
{
import.enabled(false);
}
else
{
import.enabled(true);
}
}
#admin
boolean isAdmin()
{
if (userGroupInfo.id == #AdminUserGroup &&
(domainInfo.id== #AdminDomain || !useDomains))
{
return true;
}
return false;
}
Hope this helps
Regards
Harry
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Hlavnicka
Karel
Sent: 14 March 2006 10:05
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] system administration question
Hello,
Maybe a silly question, but have you checked the "Include system and
shared tables" option on the advanced Tab ?
karel
_
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Varden
Morris
Sent: Tuesday, March 14, 2006 3:23 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] system administration question
Thanks for your reply. I am not sure why my import button is disabled.
When I import users, user groups etc. the import does not give any error
but it always ends up with zero records imported. I basically developed
a customized routine to get the job done.
Malcolm Burtt <[EMAIL PROTECTED]> wrote: Hi Varden
Yes, I've managed to import permissions before and it worked fine (my
Import button isn't ever greyed out so far as I can see). I've never
tried to import users & groups but cannot see any reason why it wouldn't
work, especially if it doesn't display errors when you try and do it.
Regards
Malcolm Burtt
Touchstone
People, Partnerships, Solutions
_
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Varden
Morris
Sent: 10 March 2006 18:05
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] system administration question
The export of the user group permissions works fine. Has anyone ever
been able to import the user group permission? The import button is
always grayed out.
Also the standard export/import for the tables UserInfo, UserGroupList
and UserGroupInfo works fine to export these tables but it never seems
to work on the import. Is this the same observation for everyone? Is
this intentional for security reasons?
Mike Matta <[EMAIL PROTECTED]> wrote: Malcolm,
That's great for exporting the group permissions. Thanks! Any idea
how I could I export the users?
We have setup over 100 users on one system and would like to copy those
users over to the other installations.
Thanks,
Mike
- Original Message -
From: Malcolm Burtt
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Friday, March 10, 2006 10:27 AM
Subject: RE: [Axapta-Knowledge-Village] system administration question
Mike
As I said, the security import/export function is on User Group
Permissions form itself (Administration -> Setup -> Security). There
are
buttons there for Export and Import. You don't need to use the
database
import/export tools that you're referring to. Just open the user group
permissions form, select the user group you want to export and click
Export, enter a filename and the job is done. To import do the same,
select the user group click import and select the file to import.
Malcolm
_
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Mike
Matta
Sent: 10 March 2006 15:16
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] system administration question
Hi Malcolm,
We are using AX3.0, SP4.
I am trying to learn more about the export/import function. It
appears
that you have to setup a definition group and use the "table setup"
feature to indicate what tables you want to export. I don't know what
tables contain this info. Do you? or does anyone else?
Thank you very much for your help!
Sincerely,
Mike
- Original Message -
From: Malcolm Burtt
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Friday, March 10, 2006 9:36 AM
Subject: RE: [Axapta-Knowledge-Village] system administration
question
Hi Mike
What version are you using? Axapta 3.0 has an import/export option
on
the user group permissions setup form which allows you to write the
permission of one user group to a file and then import that file to
another user group. There is no reason why those user groups need be
in
the same Axapta instance.
Regards
Malcolm Burtt
Touchstone
People, Partnership, Solutions
_
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto
RE: [Axapta-Knowledge-Village] system administration question
No, it's not a silly question. That was exactly the problem. Thanks. Hlavnièka Karel <[EMAIL PROTECTED]> wrote: Hello, Maybe a silly question, but have you checked the "Include system and shared tables" option on the advanced Tab ? karel _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: Tuesday, March 14, 2006 3:23 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] system administration question Thanks for your reply. I am not sure why my import button is disabled. When I import users, user groups etc. the import does not give any error but it always ends up with zero records imported. I basically developed a customized routine to get the job done. Malcolm Burtt <[EMAIL PROTECTED]> wrote: Hi Varden Yes, I've managed to import permissions before and it worked fine (my Import button isn't ever greyed out so far as I can see). I've never tried to import users & groups but cannot see any reason why it wouldn't work, especially if it doesn't display errors when you try and do it. Regards Malcolm Burtt Touchstone People, Partnerships, Solutions _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: 10 March 2006 18:05 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] system administration question The export of the user group permissions works fine. Has anyone ever been able to import the user group permission? The import button is always grayed out. Also the standard export/import for the tables UserInfo, UserGroupList and UserGroupInfo works fine to export these tables but it never seems to work on the import. Is this the same observation for everyone? Is this intentional for security reasons? Mike Matta <[EMAIL PROTECTED]> wrote: Malcolm, That's great for exporting the group permissions. Thanks! Any idea how I could I export the users? We have setup over 100 users on one system and would like to copy those users over to the other installations. Thanks, Mike - Original Message - From: Malcolm Burtt To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 10, 2006 10:27 AM Subject: RE: [Axapta-Knowledge-Village] system administration question Mike As I said, the security import/export function is on User Group Permissions form itself (Administration -> Setup -> Security). There are buttons there for Export and Import. You don't need to use the database import/export tools that you're referring to. Just open the user group permissions form, select the user group you want to export and click Export, enter a filename and the job is done. To import do the same, select the user group click import and select the file to import. Malcolm _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Matta Sent: 10 March 2006 15:16 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] system administration question Hi Malcolm, We are using AX3.0, SP4. I am trying to learn more about the export/import function. It appears that you have to setup a definition group and use the "table setup" feature to indicate what tables you want to export. I don't know what tables contain this info. Do you? or does anyone else? Thank you very much for your help! Sincerely, Mike - Original Message - From: Malcolm Burtt To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 10, 2006 9:36 AM Subject: RE: [Axapta-Knowledge-Village] system administration question Hi Mike What version are you using? Axapta 3.0 has an import/export option on the user group permissions setup form which allows you to write the permission of one user group to a file and then import that file to another user group. There is no reason why those user groups need be in the same Axapta instance. Regards Malcolm Burtt Touchstone People, Partnership, Solutions _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Matta Sent: 10 March 2006 14:17 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] system administration question Hi All, I am new to Axapta and having trouble finding an easy way to copy user permissions from one instance of Axapta to another. Does anyone know of any easy way to export/import user permissions? Thanks, Mike [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 cour
RE: [Axapta-Knowledge-Village] system administration question
Thanks for your reply. I am not sure why my import button is disabled. When I import users, user groups etc. the import does not give any error but it always ends up with zero records imported. I basically developed a customized routine to get the job done. Malcolm Burtt <[EMAIL PROTECTED]> wrote: Hi Varden Yes, I've managed to import permissions before and it worked fine (my Import button isn't ever greyed out so far as I can see). I've never tried to import users & groups but cannot see any reason why it wouldn't work, especially if it doesn't display errors when you try and do it. Regards Malcolm Burtt Touchstone People, Partnerships, Solutions _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: 10 March 2006 18:05 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] system administration question The export of the user group permissions works fine. Has anyone ever been able to import the user group permission? The import button is always grayed out. Also the standard export/import for the tables UserInfo, UserGroupList and UserGroupInfo works fine to export these tables but it never seems to work on the import. Is this the same observation for everyone? Is this intentional for security reasons? Mike Matta <[EMAIL PROTECTED]> wrote: Malcolm, That's great for exporting the group permissions. Thanks! Any idea how I could I export the users? We have setup over 100 users on one system and would like to copy those users over to the other installations. Thanks, Mike - Original Message - From: Malcolm Burtt To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 10, 2006 10:27 AM Subject: RE: [Axapta-Knowledge-Village] system administration question Mike As I said, the security import/export function is on User Group Permissions form itself (Administration -> Setup -> Security). There are buttons there for Export and Import. You don't need to use the database import/export tools that you're referring to. Just open the user group permissions form, select the user group you want to export and click Export, enter a filename and the job is done. To import do the same, select the user group click import and select the file to import. Malcolm _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Matta Sent: 10 March 2006 15:16 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] system administration question Hi Malcolm, We are using AX3.0, SP4. I am trying to learn more about the export/import function. It appears that you have to setup a definition group and use the "table setup" feature to indicate what tables you want to export. I don't know what tables contain this info. Do you? or does anyone else? Thank you very much for your help! Sincerely, Mike - Original Message - From: Malcolm Burtt To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 10, 2006 9:36 AM Subject: RE: [Axapta-Knowledge-Village] system administration question Hi Mike What version are you using? Axapta 3.0 has an import/export option on the user group permissions setup form which allows you to write the permission of one user group to a file and then import that file to another user group. There is no reason why those user groups need be in the same Axapta instance. Regards Malcolm Burtt Touchstone People, Partnership, Solutions _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Matta Sent: 10 March 2006 14:17 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] system administration question Hi All, I am new to Axapta and having trouble finding an easy way to copy user permissions from one instance of Axapta to another. Does anyone know of any easy way to export/import user permissions? Thanks, Mike [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 <http://groups.yahoo.com/gads?t=ms&k=Business+finance+course&w1=Business +finance+course&w2=Business+to+business+finance&w3=Small+business+financ e&w4=Business+finance+consultant&w5=Business+finance+magazine&w6=Busines s+finance+schools&c=6&s=185&.sig=I8jDsORmsaYn0BeqghcJ2w> Business to business finance <http://groups.yahoo.com/gads?t=ms&k=Business+to+business+finance&w1=Bus iness+finance+course&w2=Business+to+business+finance&w3=Small+business+f inan
Re: [Axapta-Knowledge-Village] system administration question
r 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 a.. Visit your group "Axapta-Knowledge-Village" on the web. 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] 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. - Varden Morris 93 Arbour Ridge Circle N.W. Calgary, Alberta T3G3Y9 Canada (403) 208-1604 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [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] Record Level Security
I do not know of this being possible. The use of Security Keys also controls table level access. Nihar Saraiya <[EMAIL PROTECTED]> wrote: Hello Group [Not a Technical guy] Can we add tables to the Record Level Security form? Regards Nihar Saraiya, Synergy Software Systems, Dubai. Tel: +971 4 3374 282 Confidentiality Notice This email is confidential and may also be privileged. If you are not the intended recipient please notify the sender immediately. You must not copy or use it for any purpose or disclose its contents to any other person. The sender accepts no responsibility for viruses received with or changes made to this email after it was sent. Any opinion expressed in this email may be personal to the sender. [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. ----- Varden Morris 93 Arbour Ridge Circle N.W. Calgary, Alberta T3G3Y9 Canada (403) 208-1604 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [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] Re: Can Axapta handle automatic Bank Reconciliation?
A vendor payment can be posted either directly to the final ledger/bank account or you can use a bridging account for a two-step posting. In the first step of the two-step posting, the payment is posted to a temporary account or a bridging account. This means that the payment is recorded on the vendor account as usual, but the offset account is the bridging account instead of the bank account. This makes the reconciliation of the bank account less time consuming because the transactions that have been recorded by the company but not yet recorded by the bank are not included in the reconciliation. When a company receives notification from the bank saying that the payment has been completed, the second step of the two-step posting has to happen. The posting on the temporary account has to be reversed and the payment has to be posted to the bank account. "Bonk, David" <[EMAIL PROTECTED]> wrote: I fully understand the process and the options that a company has when using bridging accounts. They must be included in the reconciliation process if the company's policy is to affect the bank GL account when they are on the bank statement during the reconciliation. However you can also record them when you deposit the cheque which would mean that they are not part of the reconciliation process other than to acknowledge that they have cleared. Please explain how having to create a GL journal to record the fact that the cheque has cleared makes bank reconciliation easier. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: Monday, February 13, 2006 9:07 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: Can Axapta handle automatic Bank Reconciliation? How can you say that it has nothing to do with bank reconciliation. If you really understand the process you would see that it reduces the amount of work taken for the reconciliation process. And by the way I did not make this up, it is apart of the Financial II course for Microsoft Dynamics Ax. "Bonk, David" <[EMAIL PROTECTED]> wrote: Bridging accounts have nothing to do with the reconciliation process; they are used in cases where for example you receive a post dated cheque from a customer. You want to record this fact in the AR sub ledger but do not want it to affect the bank GL account. If the payment method uses a bridging account then the debit will be to the bridging account. You then need to go through a process using a GL journal to reverse the bridging account entry and affecting the bank when you deposit the cheque or it clears, depending on your process. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: Sunday, February 12, 2006 3:37 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Re: Can Axapta handle automatic Bank Reconciliation? I have not come across any such thing in the formal documents for Axapta but one thing I know is that you can set up Bridging Accounts in the COA and use these accounts as part of the method of payment to reduce the amount of work involve in bank reconciliation. nihar_saraiya <[EMAIL PROTECTED]> wrote: Hi Koh Meng Chiat If you have a solution to Automatic Bank Reconciliation, please do guide me for the same. I am also looking to import the bank statement for reconciliation for a client. I will be thankful for this. Regards Nihar --- In Axapta-Knowledge-Village@yahoogroups.com, Koh Meng Chiat <[EMAIL PROTECTED]> wrote: > > Hi all, > > Can Axapta handle Automatic Bank Reconciliation? I > heard there is a standard template for automatic > reconciliation that a bank should follow and we can > actually import the template into axapta after the > bank has filled in all the necessary information. > > Is there anyone has the template?? > > Thousand thanks in advance. > > Best Regards, > > Jack Koh > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > 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. - Varden Morris
RE: [Axapta-Knowledge-Village] Re: Can Axapta handle automatic Bank Reconciliation?
How can you say that it has nothing to do with bank reconciliation. If you really understand the process you would see that it reduces the amount of work taken for the reconciliation process. And by the way I did not make this up, it is apart of the Financial II course for Microsoft Dynamics Ax. "Bonk, David" <[EMAIL PROTECTED]> wrote: Bridging accounts have nothing to do with the reconciliation process; they are used in cases where for example you receive a post dated cheque from a customer. You want to record this fact in the AR sub ledger but do not want it to affect the bank GL account. If the payment method uses a bridging account then the debit will be to the bridging account. You then need to go through a process using a GL journal to reverse the bridging account entry and affecting the bank when you deposit the cheque or it clears, depending on your process. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: Sunday, February 12, 2006 3:37 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Re: Can Axapta handle automatic Bank Reconciliation? I have not come across any such thing in the formal documents for Axapta but one thing I know is that you can set up Bridging Accounts in the COA and use these accounts as part of the method of payment to reduce the amount of work involve in bank reconciliation. nihar_saraiya <[EMAIL PROTECTED]> wrote: Hi Koh Meng Chiat If you have a solution to Automatic Bank Reconciliation, please do guide me for the same. I am also looking to import the bank statement for reconciliation for a client. I will be thankful for this. Regards Nihar --- In Axapta-Knowledge-Village@yahoogroups.com, Koh Meng Chiat <[EMAIL PROTECTED]> wrote: > > Hi all, > > Can Axapta handle Automatic Bank Reconciliation? I > heard there is a standard template for automatic > reconciliation that a bank should follow and we can > actually import the template into axapta after the > bank has filled in all the necessary information. > > Is there anyone has the template?? > > Thousand thanks in advance. > > Best Regards, > > Jack Koh > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > 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. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - Yahoo! Mail Use Photomail to share photos without annoying attachments. [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 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. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - Yahoo! Mail Use Photomail to share photos without annoying attachments. [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] Re: Can Axapta handle automatic Bank Reconciliation?
I have not come across any such thing in the formal documents for Axapta but one thing I know is that you can set up Bridging Accounts in the COA and use these accounts as part of the method of payment to reduce the amount of work involve in bank reconciliation. nihar_saraiya <[EMAIL PROTECTED]> wrote: Hi Koh Meng Chiat If you have a solution to Automatic Bank Reconciliation, please do guide me for the same. I am also looking to import the bank statement for reconciliation for a client. I will be thankful for this. Regards Nihar --- In Axapta-Knowledge-Village@yahoogroups.com, Koh Meng Chiat <[EMAIL PROTECTED]> wrote: > > Hi all, > > Can Axapta handle Automatic Bank Reconciliation? I > heard there is a standard template for automatic > reconciliation that a bank should follow and we can > actually import the template into axapta after the > bank has filled in all the necessary information. > > Is there anyone has the template?? > > Thousand thanks in advance. > > Best Regards, > > Jack Koh > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > 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. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - Yahoo! Mail Use Photomail to share photos without annoying attachments. [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] Automate Cross-References update
You could probably try writing that code in the method of a class and then
create an instance of that class via COM and then call the method that contains
the code.
Steeve Gilbert <[EMAIL PROTECTED]> wrote: Hi group,
I'm trying to setup something so that the Cross-Reference update is
run every night on our Dev instance. I've tried calling the update from
a small app that run the COM Connector and calls xRefUpdate::main(new
Args(classStr(SysCompileAll))). But when I run it I endup with this :
Code execution error: TreeNode object not initialized.
Stack trace:
(C) \Classes\TreeNode\AOTrefresh
(C) \Classes\SysTreeNode\refreshAll - line 17
(C) \Classes\xRefUpdate\run - line 10
(C) \Classes\xRefUpdate\updateAll - line 9
(C) \Classes\xRefUpdate\main - line 18
(C) \Classes\BOAGlobal\UpdateXRef - line 8
Running xRefUpdate::main(new Args(classStr(SysCompileAll))); from an
interactive session (aka the normal login way), no problem appears.
Anyone tried to do something similar? I appreciate any tip and clue.
Have a nice day!
Steeve...
[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.
-----
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.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
<*> 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] Serious RunBaseReport problem
Try deleting your usage data.
Askeryd Thomas <[EMAIL PROTECTED]> wrote: I had a class extending
RunBaseReport which worked perfectly and run the report well.
I then added a container to a table to store a PrintJobSettings which I got
through calling the SysPrintForm.
Now the class will not run. It crasches when the .getLast() is called in the
class which calles the RunBaseReport.unpack.
case 1: // -> ver. 1.5
[version,packedReport] = packedClass;
if (packedReport)
{
packedReportRun = new ReportRun(packedReport); CRASH
// When GetLast is called, use report from tree instead
if (inGetSaveLast)
I suspect there is something with the storing of the PrintJobSetting which
causes this but what is really the problem and why is it only this class which
is effected since it crashes even though the code which fetches the container
is commented away.
The errors given are:
- wrong container
- object 'ReportRun' could not be created
I m all baffled and dont have a clue what to do. Any help will be highly
appreciated. If you need to see any more code I ll gladly post it.
Thomas.
[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.
-
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
[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] Temporary table
I am not sure what you mean by saying that temporary tables are completely local. However, a temporary table is created and exists on the tier where the first insert takes place. This means that if the first insert is on the client that's where the table will be created and remain until it goes out of scope or the user session that creates it is terminated. Likewise, if the first insert is on the server the table will be created and live on the server. Data will only be visible to the session in which the table was created. kumar gaurav <[EMAIL PROTECTED]> wrote: hi setiaji, The scope of temporary table is completly local. It is intialized the moment you add one record to it and it remains only upto the current procedure is in progress. So there only you can catch the data. Hope it will help, Bye Kumar Setiaji <[EMAIL PROTECTED]> wrote: Hi,all How can i see records in temporary table while im debugging ? I tried open 2 axapta application in the same time.But still cant see. - setiaji - 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. - - Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [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. ----- Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.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 <*> 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] Re: Retrieve Admin Password
Please note that you can browse and modify data in the UserInfo table from "System Documentation -> Tables -> UserInfo". You do not need to go directly to the backend database. sunil padhy <[EMAIL PROTECTED]> wrote: Hi, If you want to reterive the admin password then go to the SQL enterprise manager and there is userinfo table is there select all the records and delete all the records after that log on to axapta and it will not ask u the password then u set your password at the same. before doing this create the user and user name then change the password... Thanks Sunil padhy --- Kim Truelsen <[EMAIL PROTECTED]> wrote: > Hi > > It is only on Admin you can do that trick. This > option will not be > available in version 4.0 > > Best regards > > Kim Truelsen > Escalation Engineer II > Microsoft Dynamics Ax > EMEA Global Technical Support Center > Microsoft Dynamics > > > Direct / mobile_: +45 4489 0786 / +45 > 29499958 > E-mail: [EMAIL PROTECTED] > Online support at___: www.microsoft.com/support > MBS Partnersource at ___: > www.microsoft.com/BusinessSolutions/PartnerSource/default.mspx > > Security Updates at_: www.microsoft.com/protect > > Microsoft Denmark > Tuborg Boulevard 12 > DK-2900 Hellerup > Phone:+45 4489 0100 / Fax: +45 4468 5510 > > > > If you have any feedback about my work, please let > either myself or my > manager Kenneth Stubban know at > [EMAIL PROTECTED] or telephone +45 > 4489 0784 > Note: This email may contain confidential > information. If you are not > named on the addressee list, please take no action > in relation to this > email, do not open any attachment and please contact > the sender (details > above) immediately. > > > > > -Original Message- > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:[EMAIL PROTECTED] On > Behalf Of Sherin > Sent: 8. februar 2006 14:45 > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] Re: Retrieve > Admin Password > > Hi Stefan, > > Thanks... > I was expecting it wud encrypt the password if i > changed it blank... > But it didn't > > Thanks again > > --- In Axapta-Knowledge-Village@yahoogroups.com, > Stefan Osterburg > <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > go to the SQL Enterprise Manager find the table > UserInfo in your > > respective database browse the table for the Admin > user and empty > the > > "PASSWORD" field for that record. After that you > can log in to > Axapta > > without password for the Admin user (and set a new > password.) > > > > Stefan > > > > sherin francis wrote: > > > Hi All, > > > > > > Just a quick question... > > > Is there any way to retrieve the Admin > password. > > > Say, I have created 5 users but none of them > have access to the > Administration tab and can access the Users > form...neither can they > access the AOT... only the Admin.. whose password i > have forgotten... > > > > > > Is there any particular record or field i can > amend? > > > > > > Thanks > > > > > > > __ > > > Do You Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam > protection around > > > http://mail.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 > > > > > > > > > > > > > > > > > > > > > > > > > > > Sharing the knowledge on Axapta. > Visit www.frappr.com/axapta for axapta friends. > Yahoo! Groups Links > > > > > > > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 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: [
Re: [Axapta-Knowledge-Village] New field in custtable and salestable.
Hi Gayatri,
I am not sure why you would want to add the field to the SalesLine table
since the SalesTable stores information for each customer and you can get this
info thru the relationship from SlaesLine. Anyway, do modification to the
initFromCustTable method on the SalesTable and to the initFromSalesTable method
on the SalesLine table.
gayatringayatri <[EMAIL PROTECTED]> wrote:
Hi,
I have created a new field called RPD in custtable and salestable of
stringedit type. This field is an additional identificaton for the
customer and dont have any other impact.
The values for RPD in cust table will be unique.
I want the RPD field to be there in SalesForm header and sales line
and to be saved in salestable and salesline.
I have included that in the design in sales header and salesline.
When i create a new sales order how can i get value for RPD from
custtable for the corresponding customer and display in salesform
header and salesline.
In which forms, classes, i have to make changes.
Regards,
Gayatri.
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.
-
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
[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] Lookup Form
That is exactly what will happen. I never thought about it in that way but if
you changed the EnumValue property previously stored data will be affected.
In Memories <[EMAIL PROTECTED]> wrote: I wont swap, but suppose I did will
that effect already stored data i mean in the SQL table values are stored only
ya?? so 0 = days now it will be months if something in coding is based on this
or what?
thanks guys , its really helping.
"Subrahmanyam, Mamidi" <[EMAIL PROTECTED]> wrote:
Hi Varden,
Why dont we suggest in doing
Classes - LedgerJournalEngine_LedgerPeriodic so that it will not change
whereever LedgerJournalTrans is used.. I think I recommend in doing the period
class so that it applied for thet periodic journal only...
Varden Morris <[EMAIL PROTECTED]> wrote:
Hi In Memories,
The only side effect I can see from doing this is that everywhere this enum
is used the default value will be month. One Alternative is to insert the line
of code shown below in the initValue method on the ledgerJournalTrans data
source in the form. In order to get around the hard coding you could add a
parameter value to the GL module and set the required value from there. This
however involves some amount of coding.
Please note that if you want this to be the default whenever a line is
inserted in the ledgerJournalTrans table from any location in the application
the best place to place the code is in the initValue method of the
ledgerJournalTrans table.
void initValue()
{
super();
ledgerJournalTrans.FreqCode = PeriodUnit::Month;
ledgerJournalEngine.initValue(ledgerJournalTrans);
}
In Memories <[EMAIL PROTECTED]> wrote:
G.L module ---PeriodicPeriodic Journal - Lines Field Name = Unit
, next to the Currency.
Form Name = LedgerJounalTransPeriodic
in the general tab, Grid, ComboBox:LedgerJournalTrans_FreqCode, freqCode is
based in an Enum.
Thanks
Varden Morris <[EMAIL PROTECTED]> wrote:
You are most welcome. Could you please give me some more details on where to
find this control for the journal line of period journals? I looked through the
entire form and I think I am missing it.
In Memories <[EMAIL PROTECTED]> wrote: Thanks Varden for the reply i didnt
even know about this form. It worked. before i tried AssetTable lookup group
but didnt work.
one more thing if you please: in the peridic Journal line the Unit (Days,
Months, Year) is based on a Enum PeriodicUnit which by default is coming Days
whenever adding new line, how to change this default to Months? Its not a
property ya?? just coding?
Again thanks
Varden Morris <[EMAIL PROTECTED]> wrote:
For this particular case, the Lookup method for the control is overriden and
the form AssetLookup is being used to do the lookup. You should therfore modify
this form by dragging and dropping the required fields from the data source to
the grid control.
In Memories <[EMAIL PROTECTED]> wrote: Hi,
How can i add more columns to a standard lookup form? example in GL, Inventoy
to fixed assets lines journals, want to add more columns to the lookup form
that drops down to select Fixed asset number.
thanks in advance,
IN MEMORIES
-
What are the most popular cars? Find out at Yahoo! Autos
[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.
-----
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
What are the most popular cars? Find out at Yahoo! Autos
[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
Re: [Axapta-Knowledge-Village] Lookup Form
Yes. I see no reason why it should not be done your way. It is best to keep the
business logic in the class instead of putting it in the form or on the table.
The only thing I would prefer is to use a parameter that will set the value
instead of hard coding it.
"Subrahmanyam, Mamidi" <[EMAIL PROTECTED]> wrote:
Hi Varden,
Why dont we suggest in doing
Classes - LedgerJournalEngine_LedgerPeriodic so that it will not change
whereever LedgerJournalTrans is used.. I think I recommend in doing the period
class so that it applied for thet periodic journal only...
Varden Morris <[EMAIL PROTECTED]> wrote:
Hi In Memories,
The only side effect I can see from doing this is that everywhere this enum
is used the default value will be month. One Alternative is to insert the line
of code shown below in the initValue method on the ledgerJournalTrans data
source in the form. In order to get around the hard coding you could add a
parameter value to the GL module and set the required value from there. This
however involves some amount of coding.
Please note that if you want this to be the default whenever a line is
inserted in the ledgerJournalTrans table from any location in the application
the best place to place the code is in the initValue method of the
ledgerJournalTrans table.
void initValue()
{
super();
ledgerJournalTrans.FreqCode = PeriodUnit::Month;
ledgerJournalEngine.initValue(ledgerJournalTrans);
}
In Memories <[EMAIL PROTECTED]> wrote:
G.L module ---PeriodicPeriodic Journal - Lines Field Name = Unit
, next to the Currency.
Form Name = LedgerJounalTransPeriodic
in the general tab, Grid, ComboBox:LedgerJournalTrans_FreqCode, freqCode is
based in an Enum.
Thanks
Varden Morris <[EMAIL PROTECTED]> wrote:
You are most welcome. Could you please give me some more details on where to
find this control for the journal line of period journals? I looked through the
entire form and I think I am missing it.
In Memories <[EMAIL PROTECTED]> wrote: Thanks Varden for the reply i didnt
even know about this form. It worked. before i tried AssetTable lookup group
but didnt work.
one more thing if you please: in the peridic Journal line the Unit (Days,
Months, Year) is based on a Enum PeriodicUnit which by default is coming Days
whenever adding new line, how to change this default to Months? Its not a
property ya?? just coding?
Again thanks
Varden Morris <[EMAIL PROTECTED]> wrote:
For this particular case, the Lookup method for the control is overriden and
the form AssetLookup is being used to do the lookup. You should therfore modify
this form by dragging and dropping the required fields from the data source to
the grid control.
In Memories <[EMAIL PROTECTED]> wrote: Hi,
How can i add more columns to a standard lookup form? example in GL, Inventoy
to fixed assets lines journals, want to add more columns to the lookup form
that drops down to select Fixed asset number.
thanks in advance,
IN MEMORIES
-
What are the most popular cars? Find out at Yahoo! Autos
[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.
-----
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
What are the most popular cars? Find out at Yahoo! Autos
[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.
-
IN MEMORIES
-
Bring
Re: [Axapta-Knowledge-Village] Lookup Form
Hi In Memories,
The only side effect I can see from doing this is that everywhere this enum
is used the default value will be month. One Alternative is to insert the line
of code shown below in the initValue method on the ledgerJournalTrans data
source in the form. In order to get around the hard coding you could add a
parameter value to the GL module and set the required value from there. This
however involves some amount of coding.
Please note that if you want this to be the default whenever a line is
inserted in the ledgerJournalTrans table from any location in the application
the best place to place the code is in the initValue method of the
ledgerJournalTrans table.
void initValue()
{
super();
ledgerJournalTrans.FreqCode = PeriodUnit::Month;
ledgerJournalEngine.initValue(ledgerJournalTrans);
}
In Memories <[EMAIL PROTECTED]> wrote:
G.L module ---PeriodicPeriodic Journal - Lines Field Name = Unit
, next to the Currency.
Form Name = LedgerJounalTransPeriodic
in the general tab, Grid, ComboBox:LedgerJournalTrans_FreqCode, freqCode is
based in an Enum.
Thanks
Varden Morris <[EMAIL PROTECTED]> wrote:
You are most welcome. Could you please give me some more details on where to
find this control for the journal line of period journals? I looked through the
entire form and I think I am missing it.
In Memories <[EMAIL PROTECTED]> wrote: Thanks Varden for the reply i didnt
even know about this form. It worked. before i tried AssetTable lookup group
but didnt work.
one more thing if you please: in the peridic Journal line the Unit (Days,
Months, Year) is based on a Enum PeriodicUnit which by default is coming Days
whenever adding new line, how to change this default to Months? Its not a
property ya?? just coding?
Again thanks
Varden Morris <[EMAIL PROTECTED]> wrote:
For this particular case, the Lookup method for the control is overriden and
the form AssetLookup is being used to do the lookup. You should therfore modify
this form by dragging and dropping the required fields from the data source to
the grid control.
In Memories <[EMAIL PROTECTED]> wrote: Hi,
How can i add more columns to a standard lookup form? example in GL, Inventoy
to fixed assets lines journals, want to add more columns to the lookup form
that drops down to select Fixed asset number.
thanks in advance,
IN MEMORIES
-
What are the most popular cars? Find out at Yahoo! Autos
[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.
---------
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
What are the most popular cars? Find out at Yahoo! Autos
[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.
-
IN MEMORIES
-
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
[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.
-----
Varden Morris
Senior Developer
WellPoint Systems Inc
Re: [Axapta-Knowledge-Village] Lookup Form
You are most welcome. Could you please give me some more details on where to
find this control for the journal line of period journals? I looked through the
entire form and I think I am missing it.
In Memories <[EMAIL PROTECTED]> wrote: Thanks Varden for the reply i didnt
even know about this form. It worked. before i tried AssetTable lookup group
but didnt work.
one more thing if you please: in the peridic Journal line the Unit (Days,
Months, Year) is based on a Enum PeriodicUnit which by default is coming Days
whenever adding new line, how to change this default to Months? Its not a
property ya?? just coding?
Again thanks
Varden Morris <[EMAIL PROTECTED]> wrote:
For this particular case, the Lookup method for the control is overriden and
the form AssetLookup is being used to do the lookup. You should therfore modify
this form by dragging and dropping the required fields from the data source to
the grid control.
In Memories <[EMAIL PROTECTED]> wrote: Hi,
How can i add more columns to a standard lookup form? example in GL, Inventoy
to fixed assets lines journals, want to add more columns to the lookup form
that drops down to select Fixed asset number.
thanks in advance,
IN MEMORIES
-
What are the most popular cars? Find out at Yahoo! Autos
[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.
-----
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
What are the most popular cars? Find out at Yahoo! Autos
[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.
-
IN MEMORIES
-
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
[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.
---------
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new
and used cars.
[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] Lookup Form
For this particular case, the Lookup method for the control is overriden and
the form AssetLookup is being used to do the lookup. You should therfore modify
this form by dragging and dropping the required fields from the data source to
the grid control.
In Memories <[EMAIL PROTECTED]> wrote: Hi,
How can i add more columns to a standard lookup form? example in GL, Inventoy
to fixed assets lines journals, want to add more columns to the lookup form
that drops down to select Fixed asset number.
thanks in advance,
IN MEMORIES
-
What are the most popular cars? Find out at Yahoo! Autos
[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.
-
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
What are the most popular cars? Find out at Yahoo! Autos
[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] Display field question
Try placing the field in a field group on a form and then selecting a security
key for the group on the form. Only users who are apart of the security key
will see the field group and its content (Fields).
tj_jayson <[EMAIL PROTECTED]> wrote: Hi All,
The following are the requirement.
Is there any way (Axclass or some thing) to show a field from a data
base in a different way.
I want to encrypt Phone number with a key and then decrypt for
certain users only. How I can acheive this with out using "edit"
method.
Thanks for your help
TJJ
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.
-
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
What are the most popular cars? Find out at Yahoo! Autos
[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] Re: How to trigger a Method in PurchLine?
No problem buddy... hklwaihong <[EMAIL PROTECTED]> wrote: Hi Varden Morris , It works. Thank you for your help. Regards hklwaihong --- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris <[EMAIL PROTECTED]> wrote: > > Hi Hklwaihong, > > Do the check and set the button's enable property in the active method of the Purchline data source. > > > hklwaihong <[EMAIL PROTECTED]> wrote: > Hi champion, > > I want to disable a button on PurchTable Form when user select a > PurchLine record in which the condition(s) is /are hit. The button is > enabled once user leave the Purchline record to another Purchline > record. > > Regards > hklwaihong > > > > > > > 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. > > > - > > > > > > > Varden Morris > Senior Developer > WellPoint Systems Inc. > > > > Microsoft Gold Certified Partner > > (403) 444-5848 direct > (403) 444-3900 main > (403) 615-1604 cell > www.wellpoint.ca > [EMAIL PROTECTED] > > > > > > > > - > Do you Yahoo!? > With a free 1 GB, there's more in store with Yahoo! Mail. > > [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. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars. [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] How to trigger a Method in PurchLine?
Hi Hklwaihong,
Do the check and set the button's enable property in the active method of the
Purchline data source.
hklwaihong <[EMAIL PROTECTED]> wrote:
Hi champion,
I want to disable a button on PurchTable Form when user select a
PurchLine record in which the condition(s) is /are hit. The button is
enabled once user leave the Purchline record to another Purchline
record.
Regards
hklwaihong
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.
-
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
Do you Yahoo!?
With a free 1 GB, there's more in store with Yahoo! Mail.
[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] Concatenate two fields
Create a display method on the table, then create a control on the form design
with the table as the datasource and the display method as the datamethod for
the property of the control.
manojkumar_asp <[EMAIL PROTECTED]> wrote: Hi All,
I want to concatenate two fields in form to third field which is used
for display.How can i do it. Any help would be of great use.
thanks in advance,
regards,
MK
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.
-
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
[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] Go to main table form
You are most welcome.
daniel lim <[EMAIL PROTECTED]> wrote: hi Varden,
thx for reply.im clear now. :-)
daniel
Varden Morris <[EMAIL PROTECTED]> wrote:
Hi Daniel,
The Go to main table?menu option that appears when you right-click a field
on a form is as a result of the relationship set up on the EDT of the field
concerned. The table for which the relationship is set up for the EDT should
have its FormRef property set to the name of the form that should be open when
Go to main table?is selected. The form must also have a menu item to launch it
in the process, otherwise an error will result.
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
Suite 2000, 500 - 4th Ave SW
Calgary, Alberta, Canada
T2P 2V6
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
daniellim_yh <[EMAIL PROTECTED]> wrote:
hi all,
in Ax, when we click "Go to main table" in a field, how system can know
which form it should display?where we can define that?and how we can
change to another form?
thanks.
daniel
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.
-
-
Do you Yahoo!?
With a free 1 GB, there's more in store with Yahoo! Mail.
[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.
-
-
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
[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.
-----
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca
[EMAIL PROTECTED]
-
Do you Yahoo!?
With a free 1 GB, there's more in store with Yahoo! Mail.
[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] Go to main table form
Hi Daniel, The Go to main table menu option that appears when you right-click a field on a form is as a result of the relationship set up on the EDT of the field concerned. The table for which the relationship is set up for the EDT should have its FormRef property set to the name of the form that should be open when Go to main table is selected. The form must also have a menu item to launch it in the process, otherwise an error will result. Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner Suite 2000, 500 - 4th Ave SW Calgary, Alberta, Canada T2P 2V6 (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca daniellim_yh <[EMAIL PROTECTED]> wrote: hi all, in Ax, when we click "Go to main table" in a field, how system can know which form it should display?where we can define that?and how we can change to another form? thanks. daniel 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. - - Do you Yahoo!? With a free 1 GB, there's more in store with Yahoo! Mail. [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/
