Re: [Axapta-Knowledge-Village] Re: WkOfYr function bug ?
Thank you Allan, That answers my confusion definitely. Best Regards, Agus On Thu, Jul 29, 2010 at 11:20 PM, allanwallis all...@raven-computers.co.ukwrote: The AX documentation states that the WkofYr function calculates the week of the year in which a date is located according to the ISO 8601 specification. The ISO standard states:- The first week of the year is defined as beginning on the Monday of the week in which the first Thursday of January occurs. So 01/01/2010 ( a friday ) is week 53, i.e. the end of the last week of the previous year. It isn't a bug, it is working correctly. --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, Agus Riyadi agusa...@... wrote: Dear All, Using Ax built-in function WkOfYr I get the following result : 1 Jan 2005 = 53 1 Jan 2006 = 52 1 Jan 2007 = 1 1 Jan 2008 = 1 1 Jan 2009 = 1 1 Jan 2010 = 53 1 Jan 2011 = 52 1 Jan 2012 = 52 1 Jan 2013 = 1 1 Jan 2014 = 1 1 Jan 2015 = 1 1 Jan 2016 = 53 1 Jan 2017 = 52 1 Jan 2018 = 1 1 Jan 2019 = 1 1 Jan 2020 = 1 I thought it should always returns 1. Is there any fix on this ? Thanks and best regards, Agus
[Axapta-Knowledge-Village] WkOfYr function bug ?
Dear All, Using Ax built-in function WkOfYr I get the following result : 1 Jan 2005 = 53 1 Jan 2006 = 52 1 Jan 2007 = 1 1 Jan 2008 = 1 1 Jan 2009 = 1 1 Jan 2010 = 53 1 Jan 2011 = 52 1 Jan 2012 = 52 1 Jan 2013 = 1 1 Jan 2014 = 1 1 Jan 2015 = 1 1 Jan 2016 = 53 1 Jan 2017 = 52 1 Jan 2018 = 1 1 Jan 2019 = 1 1 Jan 2020 = 1 I thought it should always returns 1. Is there any fix on this ? Thanks and best regards, Agus
Re: [Axapta-Knowledge-Village] WkOfYr function bug ?
Thanks Steen for your reply. That site explains that 6th of Jan may be in different week depends on the year (which may fall between 1 or 2). It does make sense. But that does not explain why 1 Jan 2010 get week of year = 53. Best regards, Agus On Thu, Jul 29, 2010 at 3:25 PM, Steen Rabol sra...@mail.tele.dk wrote: http://msdn.microsoft.com/en-us/library/aa890352.aspx 2010/7/29 Agus Riyadi agusa...@gmail.com Dear All, Using Ax built-in function WkOfYr I get the following result : 1 Jan 2005 = 53 1 Jan 2006 = 52 1 Jan 2007 = 1 1 Jan 2008 = 1 1 Jan 2009 = 1 1 Jan 2010 = 53 1 Jan 2011 = 52 1 Jan 2012 = 52 1 Jan 2013 = 1 1 Jan 2014 = 1 1 Jan 2015 = 1 1 Jan 2016 = 53 1 Jan 2017 = 52 1 Jan 2018 = 1 1 Jan 2019 = 1 1 Jan 2020 = 1 I thought it should always returns 1. Is there any fix on this ? Thanks and best regards, Agus -- Med venlig hilsen / Kind regards Steen Rabøl LUX Mobil: +352 621 304 484
Re: [Axapta-Knowledge-Village] Re: Select Sum slow performance
Hi Donny, If your actual problem is why it is slow in Ax compared to direct sql in the database, I suggest you use sql server profiler to capture whether there is difference between your direct sql and the sql generated by Ax kernel. Regards, Agus On Fri, Jul 9, 2010 at 7:55 AM, mgk915 mae...@alrinach.net wrote: Yes, you do not want to change an existing index. Can you tell me what table and field you have the sum on? And tell me what fields you are using to group-by. - Maeve --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, Donny Wu Doni.Wu@ wrote: Hi, Yes I have 2 index, currently my cluster index is use another index but if I change the cluster into index that I use for select it will boost the performance and in this case it will slow the other query that use the other index. dwu
Re: [Axapta-Knowledge-Village] Trigger in Ax
Hi, You can see example in the InventTable table insert() method. Regards, Agus On Mon, Jul 5, 2010 at 10:42 AM, sai sharan saisharan@gmail.com wrote: can u please just send me a sample code for an insert. On Sun, Jul 4, 2010 at 9:28 PM, Agus Riyadi agusa...@gmail.com wrote: Hi, Ax does not support trigger in the database. You have to write your 'trigger' code in the Ax tables' method under the AOT Data Dictionary Tables. There are table methods (insert, update, delete) that you can override to satisfy your trigger needs. Constraint in the database is also not supported in Ax - except for index constraint which is generated also from the application. Foreign key relation and delete action constraints are also defined within the application, not in the database. Best regards, Agus Riyadi On Sat, Jul 3, 2010 at 6:22 PM, sai sharan saisharan@gmail.comwrote: sir , i am a beginner in Ax Programming, I had a situation where i need to reciprocate the changes made in a table in one database into the table in another database. i added a trigger in sql server for that table. but when i add a record in that table from Ax it shows an error . so i need to write a trigger in Ax itself. how ca i do that? please help me to get out of this situation. waiting for ur reply. -- Saisharan koka, ph:8121156190 -- Saisharan koka, ph:8121156190
Re: [Axapta-Knowledge-Village] update a field based on dates calculation
Hi, You can write a class with batch framework (see class tutorial_runbasebatch), that you set to run every night to check for all employee that has due one month since the last vacation day update. There should be a date field in the employee that show what is the last update date the vacation day was added. Addition and subtraction code should be straightforward. Regards, Agus On Mon, Jul 5, 2010 at 8:06 PM, kardo_ax kardo...@yahoo.com wrote: Dear All, I want your help regarding the following: Each employee is monthly eligible for X number of vacation days and from the day the employee joined the company. I want the system to accumalate the vacation days for each employee on monthly bases based on the employee's starting date. Accumalate the vacation days in VacationDays. As well it is required to update the vacationDays based on the Absence Journal once being approved and posted and the absence code is of type vacation. 05/07/2010:Employee A, starting date = 05/07/2010. VacationDays=0. Once the date is 05/08/2010, the system should add 2 for the vacationDays 05/08/2010Employee A, starting date = 05/07/2010. VacationDays=2. 05/09/2010Employee A, starting date = 05/07/2010. VacationDays=4. If the employee get approval and post an absence journal for 1 day vacation, the system than must subtract 1 from the vacation days. How can we establish this requirement? what is the code? and when will be triggered?
Re: [Axapta-Knowledge-Village] Trigger in Ax
Hi, Ax does not support trigger in the database. You have to write your 'trigger' code in the Ax tables' method under the AOT Data Dictionary Tables. There are table methods (insert, update, delete) that you can override to satisfy your trigger needs. Constraint in the database is also not supported in Ax - except for index constraint which is generated also from the application. Foreign key relation and delete action constraints are also defined within the application, not in the database. Best regards, Agus Riyadi On Sat, Jul 3, 2010 at 6:22 PM, sai sharan saisharan@gmail.com wrote: sir , i am a beginner in Ax Programming, I had a situation where i need to reciprocate the changes made in a table in one database into the table in another database. i added a trigger in sql server for that table. but when i add a record in that table from Ax it shows an error . so i need to write a trigger in Ax itself. how ca i do that? please help me to get out of this situation. waiting for ur reply. -- Saisharan koka, ph:8121156190
Re: [Axapta-Knowledge-Village] Ledger Account Categories
Hi, As far I know, it is used in SQL Server Analysis Service KPI, which is then shown in the Role Center / Enterprise Portal page. Regards, Agus On Mon, Jun 28, 2010 at 2:00 PM, Asrar Ahamed asrarsh...@yahoo.com wrote: These catageories are useful in FRx report tool. Thanks, Asrar --- On *Mon, 28/6/10, Hernan Madariaga zorfo...@yahoo.com.mx* wrote: From: Hernan Madariaga zorfo...@yahoo.com.mx Subject: Re: [Axapta-Knowledge-Village] Ledger Account Categories To: Axapta-Knowledge-Village@yahoogroups.com Cc: ab...@b2bsoftech.com Date: Monday, 28 June, 2010, 7:46 AX used the category for the KPI's for example... Regards, --- El *mié 20-ene-10, Abhay ab...@b2bsoftech. com* escribió: De: Abhay ab...@b2bsoftech. com Asunto: [Axapta-Knowledge- Village] Ledger Account Categories A: ax knowledge village Axapta-Knowledge- vill...@yahoogro ups.com, ax forumdev development- axa...@yahoogrou ps.com Fecha: miércoles, 20 de enero de 2010, 4:12 Dear All, Ledger Account categoreis in Ax 2009 are for reporting if I am not wrong. But, there are no default reports given in the base reports, are there any if so please give me the path. Or we have to customise all the reports like Cash flow using Ledger Account cagtegories. Thanks in advance. Regards Abhay THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed.
Re: [Axapta-Knowledge-Village] Table exists
Hi, Try open UtilElements and UtilIdElements (AOT System Documentation Tables UtilElements Right Click Add Ins Table browser). See if any record using the name there, try delete it and reimport (Always backup your database first). Regards, Agus On Fri, Jun 11, 2010 at 11:53 AM, abhishek mehta abhi_love...@yahoo.comwrote: Hi, Delete all Sys Last value and synchronize the table again. Regards Abhishek Mehta, -- *From:* thomas 'znal' ramdhan thomasramd...@gmail.com *To:* Axapta-Knowledge-Village@yahoogroups.com *Sent:* Thu, June 10, 2010 2:35:31 PM *Subject:* [Axapta-Knowledge-Village] Table exists Dear all, I got error message when I imported a table. The message told me that the table/EDT/Base Enum name exists, since there's no table/EDT/Base Enum using that name. I also have checked in SQL Server and SQLDictionary and the result I don't get any table that using that name. Before that, user deleted the table and synchronize it. When user synhcronize it, AX got hang, and then user just close the AX. Do anyone know what table I should check again? Thanks and Regards, Afin
[Axapta-Knowledge-Village] AX 2009 client hang
Dear All, I have Ax client that freezing frequently on purchase order invoice on certain users, There is no blocking of the resources used by this client's session. The users used to be able to do the work, no permission setting changed recently. Event viewer shows the following message : Object Server 01: No ping from 8. Terminating the session. Object Server 01: RPC error: Client provided an invalid session ID 21 There is no such information in the event viewer about hanging application. I wonder what may cause application hang while no one else block resources that it needs. This happen to some users. Another user works just fine on the same computer. I have deleted usage data of the troubling users but no avail. Hope someone can show direction on this matter. Ax 5.0.1000.52 SQL Server 2005 Standard SP2. Thanks and best regards, Agus Riyadi
Re: [Axapta-Knowledge-Village] Adding a dimension at a later stage, on demand and what effort it requires
Hi Anitha, Yes that is straighforward and possible to add. So you don't experience any problem (e.g. due to unlicensed dimension then a certain process doesn't work) ? If all work just fine then the license is a more legal matter, not really a technical restriction. Regards, Agus On Mon, Apr 12, 2010 at 1:10 PM, Anitha Santosh mail2eani...@gmail.comwrote: Agus, Check if you are able to add a new element to the Base Enum SysDimension. Regards, anithaSantosh On Mon, Apr 12, 2010 at 10:25 AM, Agus Riyadi agusa...@gmail.com wrote: Hi Anitha, Very interesting. How long does it take to add a new dimension manually? The standard wizard will throw error if you don't have additional license. Regards, Agus On Mon, Apr 12, 2010 at 11:26 AM, Anitha Santosh mail2eani...@gmail.comwrote: As you said, I have not tried with the wizard. The additional dimensions were created manually . I guess if we are opting the above method for creating new ones,there is no need to go for new license concept. Regards, AnithaSantosh On Mon, Apr 12, 2010 at 9:48 AM, Agus Riyadi agusa...@gmail.comwrote: Hi, Rename can be done quite straightforward in the label properties. There are one enum (SysDimension) and several *dimension* EDTs which the label need to be changed. Use find tool to find all objects with that name. To add new financial dimension,from Ax 4.0 there is add new dimension wizard (Tools Development Tools Wizard Fin dimension Wizard). Run it in a development layer e.g. VAR,CUS. This wizard will only run if you have bought additional license. After complete you need to compile and synchronize. Not sure if Anitha Santosh managed to do it manually without having to buy additional license. Regards, Agus On Mon, Apr 12, 2010 at 11:00 AM, Anitha Santosh mail2eani...@gmail.com wrote: Kishore, It is not necessary to buy license for creating a new dimension. You need to add a new element in the Base Enum SysDimensions and add the new element in the respoective EDTs like Dimension,DimensionPriority,DimensionLedgerJournal etc., You can find which EDTs to be modified as and when you use the forms. Hope this helps!!! Regards, AnithaSantosh On Sat, Apr 10, 2010 at 10:42 AM, kishore kishore_jy...@yahoo.co.inwrote: hai all, I have a one issue I want to add a new dimension to ax later stage, I already having 3 dimensions issue is that I want to add new dimension as per requriment at later stage , I will buy license for it , Can i rename the dimension and use , It is technicaly possible then what the efforts for that, can u please help me, It very Urgent waiting for ur valuable suggestions regards kishore
Re: [Axapta-Knowledge-Village] Adding a dimension at a later stage, on demand and what effort it requires
Hi, Rename can be done quite straightforward in the label properties. There are one enum (SysDimension) and several *dimension* EDTs which the label need to be changed. Use find tool to find all objects with that name. To add new financial dimension,from Ax 4.0 there is add new dimension wizard (Tools Development Tools Wizard Fin dimension Wizard). Run it in a development layer e.g. VAR,CUS. This wizard will only run if you have bought additional license. After complete you need to compile and synchronize. Not sure if Anitha Santosh managed to do it manually without having to buy additional license. Regards, Agus On Mon, Apr 12, 2010 at 11:00 AM, Anitha Santosh mail2eani...@gmail.comwrote: Kishore, It is not necessary to buy license for creating a new dimension. You need to add a new element in the Base Enum SysDimensions and add the new element in the respoective EDTs like Dimension,DimensionPriority,DimensionLedgerJournal etc., You can find which EDTs to be modified as and when you use the forms. Hope this helps!!! Regards, AnithaSantosh On Sat, Apr 10, 2010 at 10:42 AM, kishore kishore_jy...@yahoo.co.inwrote: hai all, I have a one issue I want to add a new dimension to ax later stage, I already having 3 dimensions issue is that I want to add new dimension as per requriment at later stage , I will buy license for it , Can i rename the dimension and use , It is technicaly possible then what the efforts for that, can u please help me, It very Urgent waiting for ur valuable suggestions regards kishore
Re: [Axapta-Knowledge-Village] Adding a dimension at a later stage, on demand and what effort it requires
Hi Anitha, Very interesting. How long does it take to add a new dimension manually? The standard wizard will throw error if you don't have additional license. Regards, Agus On Mon, Apr 12, 2010 at 11:26 AM, Anitha Santosh mail2eani...@gmail.comwrote: As you said, I have not tried with the wizard. The additional dimensions were created manually . I guess if we are opting the above method for creating new ones,there is no need to go for new license concept. Regards, AnithaSantosh On Mon, Apr 12, 2010 at 9:48 AM, Agus Riyadi agusa...@gmail.com wrote: Hi, Rename can be done quite straightforward in the label properties. There are one enum (SysDimension) and several *dimension* EDTs which the label need to be changed. Use find tool to find all objects with that name. To add new financial dimension,from Ax 4.0 there is add new dimension wizard (Tools Development Tools Wizard Fin dimension Wizard). Run it in a development layer e.g. VAR,CUS. This wizard will only run if you have bought additional license. After complete you need to compile and synchronize. Not sure if Anitha Santosh managed to do it manually without having to buy additional license. Regards, Agus On Mon, Apr 12, 2010 at 11:00 AM, Anitha Santosh mail2eani...@gmail.comwrote: Kishore, It is not necessary to buy license for creating a new dimension. You need to add a new element in the Base Enum SysDimensions and add the new element in the respoective EDTs like Dimension,DimensionPriority,DimensionLedgerJournal etc., You can find which EDTs to be modified as and when you use the forms. Hope this helps!!! Regards, AnithaSantosh On Sat, Apr 10, 2010 at 10:42 AM, kishore kishore_jy...@yahoo.co.inwrote: hai all, I have a one issue I want to add a new dimension to ax later stage, I already having 3 dimensions issue is that I want to add new dimension as per requriment at later stage , I will buy license for it , Can i rename the dimension and use , It is technicaly possible then what the efforts for that, can u please help me, It very Urgent waiting for ur valuable suggestions regards kishore
Re: [Axapta-Knowledge-Village] Re: Customer aging by dimension
Hi Axl, The standard aging report works as follow : - Loop through custtable - Find open transaction for this custtable (calling to CustVendBalanceList* classes) - allocate to aging columns Then you might need to change as follow - Loop through all department - Loop through custtable - Find open transaction for this custtable, modify the CustVendBalanceList* classes to be filtered by department. - allocate to aging columns. Maybe this is not done in standard because there is a lot of variation, e.g. group the transaction by currency, print transaction by sales rep (order account) etc. Hope that helps, Agus On Thu, Apr 8, 2010 at 3:08 PM, axaeffect axaeff...@yahoo.com.sg wrote: Hi agus, Can u describe a bit about the modification ? Actualy this kind of report will be ask million times, I wonder why till now the standard Aging can not provide it. :) Thanks, Axl --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, Agus Riyadi agusa...@... wrote: Hi, We met this similar kind of requirement and the only solution that we found was to modify the Aging report. Best Regards, Agus On Wed, Apr 7, 2010 at 11:00 AM, axaeffect axaeff...@... wrote: Hi all, In report customer aging (A/R - reports - Status - Aging report), is there a way to group it per dimension. For example if I have activated 1st dimension (Department), in that report I want to group it per department, not just sort by customer account, because there is a case my customer transaction is in many department. Thanks in advance, axl
Re: [Axapta-Knowledge-Village] Customer aging by dimension
Hi, We met this similar kind of requirement and the only solution that we found was to modify the Aging report. Best Regards, Agus On Wed, Apr 7, 2010 at 11:00 AM, axaeffect axaeff...@yahoo.com.sg wrote: Hi all, In report customer aging (A/R - reports - Status - Aging report), is there a way to group it per dimension. For example if I have activated 1st dimension (Department), in that report I want to group it per department, not just sort by customer account, because there is a case my customer transaction is in many department. Thanks in advance, axl
Re: [Axapta-Knowledge-Village] AX backup
Hi, It is enough. Note that Ax backup using data export (.dat) is company specific data and cannot be used during disaster recovery when there is a problem with the database. Also it is better if you do daily database full backup and transaction log backup (can be hourly during not busy hours) using maintenance plan. Regards, Agus On Thu, Mar 4, 2010 at 4:02 PM, Sara Osman saragoo...@yahoo.com wrote: Hello All , My concern is that if am taking my daily backup for database (ax database) from sqlserver should also take backup from ax itself (.dat ) or it is enough ? thanks
[Axapta-Knowledge-Village] Sql server 16 columns index key limit
Dear all, Ax 2009 I have a requirement to add 6 more inventory storage dimension. Problem come when I tried to add fourth column to the TTSItemCheckDimIdx index of table InventSumDeltaDim. When it comes to fourth column, 16 columns have been part of the index (including dataareaid) and sql server reject adding new index column as it has 16 index key column limit. Can anyone help ? Or does it mean we have only maximum 3 custom inventory dimension in Ax 2009? Thanks and best regards, Agus Riyadi
Re: [Axapta-Knowledge-Village] Worklow
Hi, Open Administration Setup Server configuration. Check if on the right after AOS name, there is column 'Is batch server' activated. Regards, Agus On Fri, Aug 7, 2009 at 12:11 PM, Anitha S mail2eani...@gmail.com wrote: Hi, It is not necessary you should use the tutorial form. When you do WorkFlow setup configuration wizard , set up batch process for the same. Batch will take care of job processing. I tried without tutorial form and it worked for me. Regards, Anitha On Thu, Aug 6, 2009 at 6:55 PM, Craig Fidler cfid...@bs3.co.za wrote: Hi All, I have installed workflow. Have the jobs up and running however it does not process the que. When I use the Tutorial_Workflow it processes what’s in the que. Any thoughts as to what the problem maybe? Regards Craig
Re: [Axapta-Knowledge-Village] Help with Movement Journal...Mass Update Having Errors
Hi, Check if the total qty you are going to mass update for that particular item is more than available qty. Regards, Agus On Thu, Jul 30, 2009 at 4:28 AM, Girac girac...@yahoo.com wrote: When I do a mass update for my movement journal I receive the following error: Cannot receive quantity 1.00 because inventory transactions with status Ordered, Arrived, or Registered, are insufficient. When I do a manual journal it post fine. Am I missing a table update?
[Axapta-Knowledge-Village] user session status ending-blocked can't be terminated
Dear All, Ax2009 SP1. We have problem that many users are still online while they are actually has exit Ax. The session cannot be ended using end session in the online users form. This cause problems as online ending-blocked status still consume concurrent users allowed by license so no more user can login. Anyone could help? Thanks and best regards, Agus
[Axapta-Knowledge-Village] Re: user session status ending-blocked can't be terminated
Dear all, Managed to solve this problem. After reading this blog http://blogs.msdn.com/daxis/archive/2009/03/19/troubleshooting-orphaned-sessions-and-spids-in-dynamics-ax.aspxI checked my sql activity monitor. There was a spid that blocked many other spids. To get idea what this session is doing, I tried capture it using sql profiler but nothing get captured. Odd that this blocking spid didn't have any activity. Dbcc opentran(spid) also gave no result. So I killed this spids within the database activity monitor ( this is not recommended !) and then all ending-blocked sessions were gone. Thanks for your time. Agus On Tue, Jun 2, 2009 at 3:50 PM, Agus Riyadi agusa...@gmail.com wrote: Dear All, Ax2009 SP1. We have problem that many users are still online while they are actually has exit Ax. The session cannot be ended using end session in the online users form. This cause problems as online ending-blocked status still consume concurrent users allowed by license so no more user can login. Anyone could help? Thanks and best regards, Agus
Re: [Axapta-Knowledge-Village] Dynamic Group by Statement
Hi, Using query classes you can do that. e.g. q = new Query(); ds = q.addDataSource(tablenum(projInvoiceEmpl)); ds.addSelectionField(fieldnum(projInvoiceEmpl,qty),SelectionField::Sum); ds.addSortField(*fieldnum(projInvoiceEmpl,categoryid)*); ds.orderMode(OrderMode::GroupBy); ds.addSelectionField(*fieldnum(projInvoiceEmpl,categoryid*)); Change the bold ones with dynamic fieldid. Regards, Agus On Wed, May 13, 2009 at 12:13 AM, shaakera_b shaak...@gmail.com wrote: Hi All, I would like to group and sum by fields dynamically in an AX while statement. Basically I want to sum and group by any field on the table using a setup table. Example: while select sum(qty) from projinvoiceempl group by CategoryID { //Some code which does some stuff with the qty sum } i would like to : while select sum(fieldID of sum) from projinvoiceempl group by (fieldID of category code) { //Some code which does some stuff with the qty sum } Is this possible? Many thanks, Shaakera
Re: [Axapta-Knowledge-Village] Cant start AOS after creating new DB
Hi, Try create the new db for Ax by using Ax installer. It will make sure any required permisson settings and initial objects are created properly with the correct version. Regards, Agus On Tue, May 12, 2009 at 2:37 PM, kardo_ax kardo...@yahoo.com wrote: i have created a new DB in sql 2008, then changed then created a new configuration of the same instance but pointing to the new DB. When i tried to restart the AOS im getting an error. IF I i set the configuration to point to the old db it will restart normally. any help?
Re: [Axapta-Knowledge-Village] Ceiling function in X++
Hi, Use Global::roundup() or just roundup() Regards, Agus On Thu, May 7, 2009 at 5:43 PM, Tom Scott tom.sc...@britishceramictile.comwrote: Hi, I was wondering if there is a ceiling (i.e. round up) function in X++. I have tried playing with the round() function but I haven't managed to make it behave as I want it. I want to round up to the nearest integer, i.e.: a = 5.2; b = 5.5; c = 5.0; ceiling(a) = 6 ceiling(b) = 6 ceiling(c) = 5 It would be fairly simple to write my own, but I don't want to make extra work for myself if it's been done already... Tom
Re: [Axapta-Knowledge-Village] Re: No interactive logon rights
Hi Santosh, Thanks for your reply. Which specific setting is it? I don't find one similar to '%interactive logon%'. I tried by opening domain security policy windows setting local policies user right assignment deny logon locally. I add the proxy account here but I tested it can still log on to computer in the domain. Thanks and best regards, Agus On Mon, Apr 27, 2009 at 5:10 PM, r_ssh ramamurthy.sant...@gmail.com wrote: Hi Agus, Have you tried checking in Local Security Policy. Under Security Setting Local Policies Security option. Thanks Santosh.R --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, Agus Riyadi agusa...@... wrote: Hi All, Ax document recommends that domain account that is used as business connector proxy should be set with the following option : - password does not expire - no interactive logon rights However I can't find the second option 'no interactive logon rights', both in Windows 2000 and Windows 2003. Can someone tell me where to set this? Is this something to do in the group policy instead? Thanks and best regards, Agus
[Axapta-Knowledge-Village] No interactive logon rights
Hi All, Ax document recommends that domain account that is used as business connector proxy should be set with the following option : - password does not expire - no interactive logon rights However I can't find the second option 'no interactive logon rights', both in Windows 2000 and Windows 2003. Can someone tell me where to set this? Is this something to do in the group policy instead? Thanks and best regards, Agus
Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid
Hi Malcolm, Thank you, very interesting ('That Ax is smart enough to not add another dataareaid field') ! So I can try all index recommendation from tuning advisor. Thanks and best regards, Agus On Thu, Mar 5, 2009 at 4:38 PM, Malcolm Burtt malcolm.bu...@touchstone.co.uk wrote: Hi Agus Yes, you can override the placement of the dataAreaId field in indexes. To do this, simply manually add the dataAreaId as a field in an index (right click on the index and click New Field. Open the properties form for the new field then select DataAreaId as the field). Once you’ve done this you can move the field anywhere within the index just like a “normal” field and AX is smart enough to not add another dataAreaId field to the front of the index. The reason why you’ll find that the tuning advisor often recommends this kind of thing is that it can make the index more efficient. Typically indexes work better when the most unique (i.e. those with the most variation in value) are at the front of the index. So long as you’re careful to ensure that any index modified in this way will always have all of the fields in the index that are placed in front of the dataAreaid included in your selects you’ll be fine. Even if that’s not possible, you can always create another index to support those selects. I wouldn’t recommend always doing what the tuning advisor says but if you do a trial with the index changed and test for a genuine performance improvement (which means you need to know where in the Ax code the selects are coming from) then it can be a useful tool. Malcolm Burtt Touchstone Group People - Partnership - Solutions *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto: axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *Agus Riyadi *Sent:* 04 March 2009 07:27 *To:* axapta-knowledge-village *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] 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 vard...@yahoo.com 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 agusa...@gmail.com *To:* axapta-knowledge-village Axapta-Knowledge-Village@yahoogroups.com *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] 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 djf1...@gmail.com 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-Village@yahoogroups.com [mailto: axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *Agus Riyadi *Sent:* 05 March 2009 11:33 *To:* Axapta-Knowledge-Village@yahoogroups.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 vard...@yahoo.com 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 agusa...@gmail.com *To:* axapta-knowledge-village Axapta-Knowledge-Village@yahoogroups.com *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] Create index with first column not dataareaid
Thanks Varden / James, I will have a look more whats wrong in this instance, since usually recalc complete in 3 hours. Thanks and best regards, Agus On Thu, Mar 5, 2009 at 11:41 AM, Varden Morris vard...@yahoo.com wrote: 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 agusa...@gmail.com 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 djf1...@gmail. com 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 vard...@yahoo. com 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
Re: [Axapta-Knowledge-Village] Mathmatical Expression in ax
Hi, You can use runbuf function. Regards, Agus On Wed, Mar 4, 2009 at 12:50 PM, Sumit Loya loya.su...@gmail.com wrote: Hi, You can create a method in Global class where it evaluates your expression and pass all the variable values as parameters... This way you can call this method anywhere in the application to get the value you desire... I hope this is what you are trying to achieve.. Regards, Sumit On Tue, Mar 3, 2009 at 6:10 PM, naveed ali naveed_jadoo...@yahoo.comwrote: Hi, I have mathmatical expression like a+b(c/d)/(d*e). My problem is how to save it in database table and reterive to perform some mathmatical operation.All these varaibles have some fixed values which is stroed in another table. Any help regardig this. Regards,
[Axapta-Knowledge-Village] AX30SP6 Client Bug on ReportOutputUser.writeDate method
Hi All, I found a bug in AX 3.0 SP6 client where it produce wrong date value in ReportOutputUser.writeDate() method. For example for a date value 11/11/2008 it produces arbitrary value in excel like below : 39/CL/2064 40/CL/2000 38/2/1984 41/CL/2104 There is no particular pattern what value will be produced by a single date value, it can be any value. It is a kernel code so I can not amend it and unfortunately the class that uses this method is a customization so I guess can not escalate this to microsoft. I don't know if there is standard class uses this ReportOutputUser.writeDate method. Please let me know if any of you know how to solve it, as I don't find any more fix after SP6. Thanks and best regards, Agus
[Axapta-Knowledge-Village] Connection is busy with results for another hstmt
Dear All, My instance is AX30SP6 with SQL Server 2005. Please let me know if you have experienced and know what is the solution for the following error. [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt. The SQL statement was: INSERT INTO REQPO… [Microsoft][ODBC SQL Server Driver][SQL Server]SHOWPLAN permission denied in database 'AX30SP6Test'… [Microsoft][ODBC SQL Server Driver]Function sequence error. The SQL statement was: SELECT… This is happen intermittenly. AX30SP6 contains kernell rollup so it should work with SQL 2005. Thanks and best regards, Agus
Re: [Axapta-Knowledge-Village] Need Help
Hi, You can try using sql server profiler (if you use sql server) to capture what data are going to be inserted, and check what table is it and which unique index of the table is being affected. Regards, Agus On Fri, Sep 12, 2008 at 10:59 AM, naveed ali [EMAIL PROTECTED]wrote: Hi, I m importing sales data from text file in to axapta using dot net application.Data is coming in to sales table,salesline and inventtrans.After importing data in to axapta i m getting the following error The record already exist in all moduels by creating new transcation. Any body have any idear.Thanks in advance. Regards
Re: [Axapta-Knowledge-Village] Problem on storing a file on network
Hi, Try change your class to run on server or client which one works. Regards, Agus On Fri, Mar 14, 2008 at 1:34 PM, Pankaj Gupta [EMAIL PROTECTED] wrote: Hi. I have a requirement where I need to store a text file on client's computer which is on same network, I m using AsciiIo class for creating and storing the data, its runs fine on 3.0 but in Ax 4.0 as soon as code goes creating a new instance of class new AsciiIo it throws a stacktrace error. M able to save on local computer, help out! ttsbegin; FileIOPermission = new FileIOPermission(Eis-ax4\\testfolder, 'A'); FileIOPermission.assert(); if (WinAPI::fileExists(Eis-ax4\\testfolder)) { logFile = new AsciiIo(Eis-ax4\\testfolder, 'A'); } if (!logFile || logFile.status() != IO_Status::Ok) { throw error(strfmt(@SYS76826, 'xyz')); } else LogFile.write(a); ttscommit; -- Pankaj Kumar Gupta -- Software Developer | MBS Ax.
[Axapta-Knowledge-Village] Gantt : FormActiveXObject does not have method 'worldview'
Hi, When I open Master planning planned order inquiries explosion, then open the gantt tab I get this error message : FormActiveXObject does not have method 'worldview'. I use AX40SP2 and the latest vcgantt.ocx (3.200.3311.26). Any help? Thanks, Agus [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Square character on string fields
Hi, This is because I missed some scripts to update empty string data. During new record creation it calls initFromXX where the source table has some square characters. This question is closed. Thanks everyone! Regards, Agus On Dec 12, 2007 6:19 PM, Agus Riyadi [EMAIL PROTECTED] wrote: Hi, Thanks for your response but that doesn't work. I have compile my whole AOT 3 times (include during upgrade checklist) but I still get the square character. Regards, Agus On Dec 12, 2007 1:27 PM, nakul barai [EMAIL PROTECTED] wrote: I think you have to compile AOT again. Thanks, Agus Riyadi [EMAIL PROTECTED] agusacil%40gmail.com wrote: Hi, I experienced strange behavior after upgrade axapta from 3.0 SP1 to 4.0SP2. When creating new record in purchase order, many string fields got square character (hexa 02) value after I selected vendor account. This does not happen to other tables. Any suggestions ? Thanks and best regards, Agus [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] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Square character on string fields
Hi, Thanks for your response but that doesn't work. I have compile my whole AOT 3 times (include during upgrade checklist) but I still get the square character. Regards, Agus On Dec 12, 2007 1:27 PM, nakul barai [EMAIL PROTECTED] wrote: I think you have to compile AOT again. Thanks, Agus Riyadi [EMAIL PROTECTED] agusacil%40gmail.com wrote: Hi, I experienced strange behavior after upgrade axapta from 3.0 SP1 to 4.0SP2. When creating new record in purchase order, many string fields got square character (hexa 02) value after I selected vendor account. This does not happen to other tables. Any suggestions ? Thanks and best regards, Agus [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] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Square character on string fields
Hi, I experienced strange behavior after upgrade axapta from 3.0 SP1 to 4.0 SP2. When creating new record in purchase order, many string fields got square character (hexa 02) value after I selected vendor account. This does not happen to other tables. Any suggestions ? Thanks and best regards, Agus [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Grand Total
Hi, I guess you need to create a page footer instead of grand total footer. - Have Generated Design created. - Then copy all sum controls from grand total footer into your own page footer, remove the grand total footer. - Set the page footer auto declaration to yes - Override the fetch method, before row fetching put this code : element.disableSection(footerName); Then after fetching row add this code : element.enableSection(footerName). This make sure the page footer is printed only at the last page. Regards, Agus On 10/16/07, rmrallistan [EMAIL PROTECTED] wrote: Hi, I'm creating a report that need to fixed the grand total at last page bottom part of the report. I tried using the footer section but the grand total appear right next to the last record. Could you please help me how to fix this? Thanks in advance! Yna [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Credit Limit
Hi, We once had similar requirement as you. It need modification on the CustCreditLimit class, started on the check() method. Regards, Agus On 9/24/07, Sumit Loya [EMAIL PROTECTED] wrote: Hi Neeraj, If you are having parent-child relationship b/w different customers, then u may be having a customization where the parent customer id is stored so you can pass the customer id of parent customer to check the credit limit. the function called for checking the credit limit is *checkCreditLimit* method of CustTable table. Hope this info is useful to u Regards, Sumit On 9/24/07, NEERAJ JINDAL [EMAIL PROTECTED]neeraj_jindal26%40yahoo.com wrote: Hi All, My client have a requirement of Credit limit at parent customer level i.e. parent customer credit limit is applicable to all its child customer including sub child customer. Is there any way in Axapta, please tell me that. Also credit limit also includes credit days i.e. if for any transaction credit days is lapsed then system wont allow for further transaction similar to that of credit limit. Whichever is happened earlier i.e. either credit amount or credit days to get the warning message. Please tell me how we can go for that. Thanks in advance. regards Neeraj Kumar [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Electronic Banking in Ax
Hi, I don't have knowledge on electronic banking but a discussion with a colleage told me that one possibility is to use integration server such as BizTalk. Using that integration server Axapta can 'talk' to many different system. Please share if you get any progress. Regards, Agus On 9/19/07, kamaraju80 [EMAIL PROTECTED] wrote: Hi, can u provide the details if u have? I have been trying for any help for a long time Thanks Kamaraju --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, Mukesh Kumar [EMAIL PROTECTED] wrote: Hi All, How we can use Electronic Banking in Microsoft Dynamics Ax? Regards, Mukesh [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Electronic Banking in Ax
Hi, Sorry I thought it was connection to external system. Don't have idea on that. Regards, Agus On 9/20/07, Mukesh Kumar [EMAIL PROTECTED] wrote: Hi, When we put licence it shows us electronic banking module, even on the microsoft partner source site it shows electronic banking is possible with dynamics Ax. I studied a document in which it mention that Dynamics ax will import the transactions of electronic banking. In Customer Payment Journal--Lines--Functions, there is a button to import the transactions using import type Electronic Payment, But how it will work and in which format it receives the data it is not mentioned. Please guide me how it will work. Regards, Mukesh On 9/20/07, Agus Riyadi [EMAIL PROTECTED] agusacil%40gmail.com wrote: Hi, I don't have knowledge on electronic banking but a discussion with a colleage told me that one possibility is to use integration server such as BizTalk. Using that integration server Axapta can 'talk' to many different system. Please share if you get any progress. Regards, Agus On 9/19/07, kamaraju80 [EMAIL PROTECTED]kamaraju_vudata%40semanticspace.com kamaraju_vudata%40semanticspace.com wrote: Hi, can u provide the details if u have? I have been trying for any help for a long time Thanks Kamaraju --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com, Mukesh Kumar [EMAIL PROTECTED] wrote: Hi All, How we can use Electronic Banking in Microsoft Dynamics Ax? Regards, Mukesh [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] -- Mukesh Mutreja # 09818421567 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] EP Passing parameter to report displayed as web output content item
Hi Shahzad, Thanks the passing parameter works ! There are many messages in the event viewer when the site didn't work : DCOM authentication which then I modified manually through COM administration, IIS-WSS authentication error which then I got a script to update the authentication to NTLM. Regards, Agus On 9/11/07, Shahzad Butt [EMAIL PROTECTED] wrote: Check the user for your ApplicationPool in IIS which portal is using. It should have administrative rights to active directory. Also make sure if the password isn't expired or something... Check if the pool is started Cheers!! Shahzad Butt From: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Agus Riyadi Sent: 11 September 2007 11:04 To: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] EP Passing parameter to report displayed as web output content item Hi Shahzad, Thanks for your response. I will try that. Unfortunately with not clear reason I got this Windows Sharepoint Service error in my event viewer and my sites doesn't work. Requested registry access is not allowed Regards, Agus On 9/11/07, Shahzad Butt [EMAIL PROTECTED]sbutt%40epartnersolutions.com mailto:sbutt% sbutt%2540epartnersolutions.com wrote: When sending parameter use webLink.addOrUpdateExtraParam(#myParm, my parameter value) To extract _myParm = webSession().getParm(#myParm); Regards, Shahzad From: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Agus Riyadi Sent: 11 September 2007 05:16 To: axapta-knowledge-village Subject: [Axapta-Knowledge-Village] EP Passing parameter to report displayed as web output content item Dear All, I have a webform which has some value that I need to send to a standard report displayed as web report upon closedOk(). Here is my code : weblink = new weblink(); webUrlMenuFunction = new WebUrlMenuFunction(weburlitemstr(myReport)); weblink.parm(my parameter); webLink.menufunction(webUrlMenuFunction); webSession().redirect(webLink); Then in the target report's init() method I put a code : myparam = element.args().parm(). But this doesn't work. No value is retrieved. My goal is to send a range value to the report. I looked for documentation but didn't find any way to pass an object in Enterprises Portal so I guess the work around is using string parameter, but again this doesn't work. Note that my target report is standard Axapta report, but displayed as web report. Any comment would be appreciated. Or if you know other approach to specify query to a report displayed in EP that would be great. AX4.0 SP1 WSS 3.0 IIS 6. Regards, Agus [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] EP Passing parameter to report displayed as web output content item
Hi Shahzad, Thanks for your response. I will try that. Unfortunately with not clear reason I got this Windows Sharepoint Service error in my event viewer and my sites doesn't work. Requested registry access is not allowed Regards, Agus On 9/11/07, Shahzad Butt [EMAIL PROTECTED] wrote: When sending parameter use webLink.addOrUpdateExtraParam(#myParm, my parameter value) To extract _myParm = webSession().getParm(#myParm); Regards, Shahzad From: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Agus Riyadi Sent: 11 September 2007 05:16 To: axapta-knowledge-village Subject: [Axapta-Knowledge-Village] EP Passing parameter to report displayed as web output content item Dear All, I have a webform which has some value that I need to send to a standard report displayed as web report upon closedOk(). Here is my code : weblink = new weblink(); webUrlMenuFunction = new WebUrlMenuFunction(weburlitemstr(myReport)); weblink.parm(my parameter); webLink.menufunction(webUrlMenuFunction); webSession().redirect(webLink); Then in the target report's init() method I put a code : myparam = element.args().parm(). But this doesn't work. No value is retrieved. My goal is to send a range value to the report. I looked for documentation but didn't find any way to pass an object in Enterprises Portal so I guess the work around is using string parameter, but again this doesn't work. Note that my target report is standard Axapta report, but displayed as web report. Any comment would be appreciated. Or if you know other approach to specify query to a report displayed in EP that would be great. AX4.0 SP1 WSS 3.0 IIS 6. Regards, Agus [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Checking of Field Names and Field Types
Hi Ricardo, Use DictTable and DictField classes. Regards, Agus On 9/10/07, ricardodegouveia [EMAIL PROTECTED] wrote: Hi i'm trying to find out how in the emplTable or any table which fields are in the table, in other words i want to check if in code eg. field name = Race is a field in the EmplTable? as well how do you check the base type of the field like Race is it a string or enum and so on in code? Thanking you in Advance, Ricardo [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] EP Passing parameter to report displayed as web output content item
Dear All, I have a webform which has some value that I need to send to a standard report displayed as web report upon closedOk(). Here is my code : weblink = new weblink(); webUrlMenuFunction = new WebUrlMenuFunction(weburlitemstr(myReport)); weblink.parm(my parameter); webLink.menufunction(webUrlMenuFunction); webSession().redirect(webLink); Then in the target report's init() method I put a code : myparam = element.args().parm(). But this doesn't work. No value is retrieved. My goal is to send a range value to the report. I looked for documentation but didn't find any way to pass an object in Enterprises Portal so I guess the work around is using string parameter, but again this doesn't work. Note that my target report is standard Axapta report, but displayed as web report. Any comment would be appreciated. Or if you know other approach to specify query to a report displayed in EP that would be great. AX4.0 SP1 WSS 3.0 IIS 6. Regards, Agus [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: EP deployment wizard : could not load file or assembly
Hi All, I search through the C:\Windows\assembly\ directory using command prompt to find the file (Microsoft.Dynamics.ClrBridge.dll') and it was found in the C:\Windows\assembly\GAC_32\ folder. So then I copied the file manually to the expected directory ('C:\WINDOWS\assembly\GAC_MSIL\Microsoft.Dynamics.EP.Deployment\4.0.0.0__31bf3856ad364e35) and then EP configuration wizard works. This can only be done using command prompt, can not use Windows explorer. However I got another problem when deploying the EP, on the site creation I got this error message : The Web site http://myserver/mysite was not created correctly. Exception: No .NET Business Connector session could be found. I have created the business connector configuraton (Non interactive use only) as suggested but still no avail. Can anyone help what's wrong ? Regards, Agus On 8/16/07, Agus Riyadi [EMAIL PROTECTED] wrote: Dear All, I got this error when clicking on the finish button on the Completing the Enterprise Portal Deployment wizard : Message (14:36:18) Could not load file or assembly 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.Dynamics.EP.Deployment\4.0.0.0__31bf3856ad364e35\Microsoft.Dynamics.ClrBridge.dll' or one of its dependencies. The system cannot find the file specified. Previously the assembly (Microsoft.Dynamics.EP.Deployment) could not be loaded, then I registered the .dll file using Visual Studio Gacutil tool and succeeded. Anyone have clue please help. I am using AX4.0 SP1 in Windows 2003 Server. Regards, Agus [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: EP deployment wizard : could not load file or assembly
Further inverstigation on the event log I found : Rpc error : RPC exception 1727 occurred in session 0. I am using Win 2003 SP1, AX40SP1, Windows Share Point Services 2. Has anyone experienced this before ? Regards, Agus On 8/20/07, Agus Riyadi [EMAIL PROTECTED] wrote: Hi All, I search through the C:\Windows\assembly\ directory using command prompt to find the file (Microsoft.Dynamics.ClrBridge.dll') and it was found in the C:\Windows\assembly\GAC_32\ folder. So then I copied the file manually to the expected directory ('C:\WINDOWS\assembly\GAC_MSIL\Microsoft.Dynamics.EP.Deployment\4.0.0.0__31bf3856ad364e35) and then EP configuration wizard works. This can only be done using command prompt, can not use Windows explorer. However I got another problem when deploying the EP, on the site creation I got this error message : The Web site http://myserver/mysite was not created correctly. Exception: No .NET Business Connector session could be found. I have created the business connector configuraton (Non interactive use only) as suggested but still no avail. Can anyone help what's wrong ? Regards, Agus On 8/16/07, Agus Riyadi [EMAIL PROTECTED] wrote: Dear All, I got this error when clicking on the finish button on the Completing the Enterprise Portal Deployment wizard : Message (14:36:18) Could not load file or assembly 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.Dynamics.EP.Deployment\4.0.0.0__31bf3856ad364e35\Microsoft.Dynamics.ClrBridge.dll' or one of its dependencies. The system cannot find the file specified. Previously the assembly (Microsoft.Dynamics.EP.Deployment) could not be loaded, then I registered the .dll file using Visual Studio Gacutil tool and succeeded. Anyone have clue please help. I am using AX4.0 SP1 in Windows 2003 Server. Regards, Agus [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Create new Employee
Hi Ricky, You can put a breakpoint at EmplTable.insert() method to see which class used. Regards, Agus On 7/24/07, ricardodegouveia [EMAIL PROTECTED] wrote: i'm struggling the class that are used when you create a new employee? i know that purchFormLetter and salesFormLetter are used for sales and purchases but can't seem to find the class employees uses? Can anyone please tell which classes? Thanking you in advance ricky [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] explain Axapta AX 3.0 VS Axapta AX 4.0
Hi Amir, If you are affiliated to a partner, you may have What's new documents (both functional and technical). Those explain the difference between Ax 4.0 and 3.0. I don't know about SP6. Regards, Agus On 7/15/07, Amin Khan [EMAIL PROTECTED] wrote: hi friends can any body help me regarding my topic.whats the key differences between Axapta AX 3.0 VS Axapta AX 4.0.and what about Service pick 6. thanks Amin Khan [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Setting permission for temporary table with security key
Already found it, got from Axaptapedia. Change this on the SysDictTable class : boolean allowSecuritySetup() { if(//this.isTmp() || this.isMap() || this.isView() || !this.securityKeyId() || //If not, the table rights cannot be calculated if the user is a member of 1 group (this.configurationKeyId() !isConfigurationkeyEnabled( this.configurationKeyId( return false; return true; } Regards, Agus On 7/5/07, Agus Riyadi [EMAIL PROTECTED] wrote: Hi All, How do we set security permission for temporary table that has security key property? I can't find TmpInventTransWMS table below Invent tables in the security hierarchy as the properties suggested. Any help would be appreciated. Regards, Agus [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Setting permission for temporary table with security key
Hi All, How do we set security permission for temporary table that has security key property? I can't find TmpInventTransWMS table below Invent tables in the security hierarchy as the properties suggested. Any help would be appreciated. Regards, Agus [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Import csv with newline character in string field.
Hi All, I need to import csv file into a table using definition group of type custom. The table has string field that allow multiline (e.g. item description), so there could be newline character in the field value. The problem is when I try to put newline character in the csv file, it is recognized as record delimiter, not as part of the field value as expected. Axapta will treat the next string after newline as first field of new record. Any workaround please help. Thanks Regards, Agus [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: joining 3 tables
Hi Ton, Set the properties FetchMode to 1:1 to the second and third data source. Regards, Agus On 6/8/07, axaeffect [EMAIL PROTECTED] wrote: hi kamal, Thx, I already know the relation, the problem is when I use QueryBuildDataSource, after I create the first Query (InventDim), add new datasource (InventBatch), linked them, and add new datasource again(WMSLocation), when I link it to the first query, seems can not work. rgds, Ton. --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, kamal_ec [EMAIL PROTECTED] wrote: Hi Ton, The Relation has to be something like this Invent Dim | | |__ Invent Batch (Relation InventBatchId) | | |__ WMSLocation (Relation InvnetLocationId) Hope this helps :) Regards Kamalakannan --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, axaeffect axaeffect@ wrote: Hi all, how to join 3 tables in querybuilder? for example I want to join InventDim Table with inventBatch and WMSLocation In my logic should be like this 1. first Query is InventDim 2. join InventDim to InventBatch 3. join inventDim again to WMSLocation is that correct? thanks in advance, Ton [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Shared Tables in Virtual Company for new Company Account
Hi Pragashnee, Once I experienced the similar problem. We have client that need to add more share tables after go live. Axapta doesn't directly recognize the shared tables as we expected. I don't really sure which step that make it correct but I did these ways : - export out all existing data before virtual company account (have dataareaid different with virtual company account) - restart aos, - synchronize table - in my case I don't need to re-import data. I just repopulate the data and then it works just fine. New data has new virtual company code as its dataareaid column. I guess importing exported data is no problem either. Regards, Agus On 5/28/07, varsityblews [EMAIL PROTECTED] wrote: Good day We have a client on V3 SP3 that has been live for the past couple of years, and would now like to go live with a new company account for a new Country. Between the company accounts they would like to have intercompany setup. The result of this requirement is that more tables will now have to be added to the Shared Table collection. This seems very risky to me especially since these tables already have data and will have to be exported and reimported into the VC company. After trying this import several times in some cases it still doesnt see this table as a shared table even though all the setup is correct. Does anyone have any best practice advice regarding sharing tables after going live. The steps involved, things to watch out for or even if it is recommended at all. Any advice would be appreciated. Regards Pragashnee [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Failed loading assembly
Hi All, Has any of you experienced this error message : Error Message (14:12:55) Failed loading assembly Microsoft.Dynamics.EP.Deployment, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL Error Message (14:12:55) Failed loading assembly Microsoft.Dynamics.RfidProxy, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 It occurs intermittently while working with the editor. Please help if you know how to rectify it. Ax 4.0 SP1 Regards, Agus [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Blobdata type
Hi James, Any container typed is stored as image data type in SQL Server database so it is variable sized with maximum size of 2 GB. Don't how it is implemented in Oracle. Regards, Agus On 5/19/07, James Flavell [EMAIL PROTECTED] wrote: Hi everyone, I was wondering if I use the container type Blobdata on a table will this take a fixed amount of space in the database or how is the space decided? Thanks James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Business connector / COM connector and web application
Has nobody succeeded setting up web application connecting to Ax 4.0 ? It would be very helpful if you can share the tips. Regards, Agus On 5/1/07, Agus Riyadi [EMAIL PROTECTED] wrote: Hi Arijit, Thanks for your reply. I have managed it works with windows application, but my problem is that I can not make it works with ASP.NET http://asp.net/ web application. Regards, Agus On 5/1/07, Arijit Basu [EMAIL PROTECTED] wrote: Hi, I am sending u a screenshot of what I have done in a C# Windows Application which connects to AX 4.01 using the .NET Connector. Have you set the AX .NET Connector as a reference? Arijit Basu On 5/1/07, Agus Riyadi [EMAIL PROTECTED] agusacil%40gmail.com wrote: Hi Thanks for your response, I am using Ax 4.0 SP1. Regards, Agus On 5/1/07, Arijit Basu [EMAIL PROTECTED]arijit.basu%40gmail.com arijit.basu%40gmail.com wrote: Hi Agus, Can you tell me if you are using AX 3.0 or AX 4.x?? Arijit Basu On 5/1/07, Agus Riyadi [EMAIL PROTECTED] agusacil%40gmail.comagusacil%40gmail.comagusacil% 40gmail.com wrote: Hi All, I have search through this groups but could not find answer how to connect Axapta through web application. I have installed both Business Connector and COM Connector ( I want to test both of them). It works okay for windows application, but I couldn't make it work with asp.net application. I have done the following : 1. enable web.config to use impersonation 2. set the windows user used in impersonation as business connector proxy account Still, got the error like Failed to Initialized Business Connector Any help would be appreciated. Regards, Agus [Non-text portions of this message have been removed] -- Arijit Basu [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] -- Arijit Basu [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Business connector / COM connector and web application
Hi Thanks for your response, I am using Ax 4.0 SP1. Regards, Agus On 5/1/07, Arijit Basu [EMAIL PROTECTED] wrote: Hi Agus, Can you tell me if you are using AX 3.0 or AX 4.x?? Arijit Basu On 5/1/07, Agus Riyadi [EMAIL PROTECTED] agusacil%40gmail.com wrote: Hi All, I have search through this groups but could not find answer how to connect Axapta through web application. I have installed both Business Connector and COM Connector ( I want to test both of them). It works okay for windows application, but I couldn't make it work with asp.net application. I have done the following : 1. enable web.config to use impersonation 2. set the windows user used in impersonation as business connector proxy account Still, got the error like Failed to Initialized Business Connector Any help would be appreciated. Regards, Agus [Non-text portions of this message have been removed] -- Arijit Basu [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Prepayment settlement error when exch rate change
Hi All, I experienced unbalance error when tried to settle an invoice to prepayment (a foreign transaction), in which prepayment and invoice use different exch rate. Anyone have a fix on it or know how to amend on Ax 3.0 ? I use Ax 3.0 SP5. Thanks and regards, Agus [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Axapta deployment in two companies
Hi Enrique, It is not recommended to use two applications with one DB. You will get problem if one object (table / view) exist in one application but doesn't in the other. When you open Axapta from the application that doesn't have the object then it will delete the objects phsyically from the database (then you lost your data) since it doesn't recognize the object in its application files. You can have two instances of AOS (each with different application and different DB) running on the same server. To compare the result you have to feed the same data into both instances. However I have never test if it is okay when the differences between the two applications only for objects that is not physically mapped to DB like forms, reports, classes etc. Regards, Agus On 07 Mar 2007 17:01:06 -0800, jeamx99 [EMAIL PROTECTED] wrote: Hi, I would like to have your opinion regarding the following; I have a customer who has two companies, one of them needs a lot of customizations but the second one is planning to run in a standard mode (no customization). Can I use a different AOS for each company and see a different version of Axapta? so one company runs the application with all the customizations on AOS-1 and the second one runs plain Axapta on AOS-2 over the same DB. I will appreciate your advice! Best Regards Enrique [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Ax 4.0 run as doesn't work
Dear All, I wonder why some clients of our network can't run Ax 4.0 using run as command while some others can. Currently we are used to login with local client credential. When need to connect an Ax 4.0 instance in the network, we just right click Dynamic client select run as, specify network domain credential and it works. However, some of our colleagues failed with error message saying can not find the server. Has anyone experienced the same ? How is the workaround ? Thanks and regards, Agus [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] How to assign a variable in a class to args.Parm() ?
Hi Amer, That should work, and Axapta class can not directly assign to member variable, use parameter method instead. You also need to instantiate the Args object. Regards, Agus On 1/17/07, Amer Adnan [EMAIL PROTECTED] wrote: Dears, How can I pass a value from the args in the main(Args args), to a string filed in my class. What I want to do is: Args arg; arg.parm(some string); Myclass::Main(arg) static Main(Args arg) { MyClass obj = new MyClass(); obj.myVariable = arg.Parm(); //myVaraible is decared as a str member in MyClass } The last statement [ obj.myVariable = arg.Parm(); ] gives an error: Wrong argument types assignments How can I solve this problem? Thank you all amer - Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. [Non-text portions of this message have been removed] [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/
[Axapta-Knowledge-Village] Can not pick more than ordered
Hi All, Why sales order picking list can't exceed qty ordered ? while packing slip can ? I need to pick qty more than qty ordered (but at maximum qty ordered + over delivery pct) but can not. In packing slip it can be done. Why doesn't Axapta allow this? Thanks, Agus [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Ax 4.0 login screen as 3.0
Hi All, Is there any setting or workaround so that user can have a login screen in Axapta 4.0 like in 3.0 ? Thanks, Agus [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Web deployment installing service pack failed
Hi All, Found the cause myself. There is different file for client setup. MicrosoftBusinessSolutions-Axapta3.0SP5WebClient.exe is used instead of setup.exe for web deployment It works installing axapta client and service pack. However it is supposed to create new shorcuts in the desktop for axapta client and configuration but it didn't. I still have problem with this. And further unfortunately I read from partner source that web deployment is removed since KR 1. There are alternatives instead of web deployment i.e. silent installation, Group policy but the site doesn't give clear explanation (only a simple sample silent installation script). Please help if any of you have a better way to mass install client without web deployment. Thanks, Agus On 12/8/06, Agus Riyadi [EMAIL PROTECTED] wrote: Hi All, I setup a web deployment. I open web browser in a client and successfully install activeX and the client setup. However, it failed when try installing service pack. My Configuration is : Computer name : AOS Web deployment root directory C:\AxWebDeploy with virtual directory named AxWebDeploy ServerSetup = \\AOS\AxWebDeploy\ClientSetup ServerServicePack = \\AOS\AxWebDeploy\ClientServicePack\setup.exe It seems that files in the ClientSetup directory is copied to local client TMP directory when installing Axapta client, but when it comes to run Service Pack, only setup.exe is copied into local client directory (to the temporary internet files directory-NOT TMP directory). The problem seems that setup.exe can not find the file Microsoft Business Solutions-Axapta Client 3.0 SP5.msi in the temporary internet files folder (because it is not copied when clicking the active x). I have set the directory properties in the IIS to allow directory browsing but still doesn't work. Any help would be appreciated. Regards, Agus [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Web deployment installing service pack failed
Hi All, I setup a web deployment. I open web browser in a client and successfully install activeX and the client setup. However, it failed when try installing service pack. My Configuration is : Computer name : AOS Web deployment root directory C:\AxWebDeploy with virtual directory named AxWebDeploy ServerSetup = \\AOS\AxWebDeploy\ClientSetup ServerServicePack = \\AOS\AxWebDeploy\ClientServicePack\setup.exe It seems that files in the ClientSetup directory is copied to local client TMP directory when installing Axapta client, but when it comes to run Service Pack, only setup.exe is copied into local client directory (to the temporary internet files directory-NOT TMP directory). The problem seems that setup.exe can not find the file Microsoft Business Solutions-Axapta Client 3.0 SP5.msi in the temporary internet files folder (because it is not copied when clicking the active x). I have set the directory properties in the IIS to allow directory browsing but still doesn't work. Any help would be appreciated. Regards, Agus [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Data visibiltiy
Hi Jay, Did u set up record level security for the user ? Regards, Agus On 12/8/06, jay_naik_99 [EMAIL PROTECTED] wrote: Hi Can anyone help me answering this query. Regards, Jay --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, jay_naik_99 [EMAIL PROTECTED] wrote: Dear All, I am facing a unique problem. We have created one admin user and other users. I imprted a comapny accounts with Admin login and was able to view transactions from the admin login in Chart of accounts. When other users login they are able to see the chart of accounts but not the transactions. Under the same account number if I login using Admin I can see the transactions and if the user login he is not able to see the transactions? What could be the reason for this? Kindly help. Regards, Jay [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: RunbaseReport
Hi Patrick, I am sure Harry's suggestion will work. Please check the sequence of data stored in the container within pack and unpack method. Regards, Agus On 12/5/06, Harry Deshpande [EMAIL PROTECTED] wrote: Hi You need pack/unpack methods, you will get a different error otherwise. If you have already tried compiling and changing the version number then 1. check if the pack method stores in the format currentVersion, currentList 2. if the above is correct then there is something wrong with case #CurrentVersion: statement in the unpack method. Put a debug in the unpack method and find out which line is throwing the error. Regards Harry From: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com[mailto: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com] On Behalf Of chuapatrickd Sent: 05 December 2006 06:36 To: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: RunbaseReport --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com, Agus Riyadi [EMAIL PROTECTED] wrote: Hi Agus, Yes. I just did. compile and compile forward as you suggested. However, the error still occur. THanks, Patrick Hi, Have u try compile or compile forward (add ins compile forward) ? Regards, Agus On 12/5/06, chuapatrickd [EMAIL PROTECTED] wrote: Hi to all, I'm encountering an error when running my class which extend the runbaseReport base class. The error message Iv'e got is Error executing code: Wrong argument types in variable assignement the method shown is: \classes\RunbaseReport\MakeReportRun \classes\runbaseReport\initparmdefault \classes\xsyslastvalue\getlast I've already tried changing the version number in the class declaration and also deleted pack and unpack method, but same error occur. Is there anyone who knows how to remedy the situation ? Thanks, Patrick [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] RunbaseReport
Hi, Have u try compile or compile forward (add ins compile forward) ? Regards, Agus On 12/5/06, chuapatrickd [EMAIL PROTECTED] wrote: Hi to all, I'm encountering an error when running my class which extend the runbaseReport base class. The error message Iv'e got is Error executing code: Wrong argument types in variable assignement the method shown is: \classes\RunbaseReport\MakeReportRun \classes\runbaseReport\initparmdefault \classes\xsyslastvalue\getlast I've already tried changing the version number in the class declaration and also deleted pack and unpack method, but same error occur. Is there anyone who knows how to remedy the situation ? Thanks, Patrick [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Account Length
Hi Faiqa, You can enlarge the string width of Ledger Account through AccountNum Extended Data Type ( I don't know whether Gread Plains use the same concept of EDT or not - never use it). It is converted into varchar data type in the physical database which means you can set it to maxium of 8000 characters width as documented in SQL server ( CMMIW). I have no insight of your second query. Regards, Agus On 12/1/06, Faiqa Khushi [EMAIL PROTECTED] wrote: Hi , I am new to Axapta Dynamics, previously I worked over Great Plains Dynamics. Please help me about few queries: How much maximum Ledger Account length we can define in Axapta? Can we segregate our account in parts while generating reports from Axapta as we can do in GP using Segment features? Please reply me apart from using Dimensions. Can we rename the default Dimensions? Regards, Faq [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Plz help on axapta development
Hi, If I understand you correctly, you can are trying to create an inquiry form that will display sum qty of sale line group by item group. This inquiry form is then called from sales order. That can be achieved by creating view of three tables, salesline, inventtable and inventitemgroup. This view is then put as form datasource with grouping is set to per itemgroupid. Override executequery method of the datasource to make a group by and filter salesline based on the caller (salestable). Also specify sum of the qty field in the query. Regards, Agus On 4/26/06, icham icham [EMAIL PROTECTED] wrote: Hello all, I must create a form called since the customer order form which must contain the sum of the quantities (of sales lines ordered by item group) by item group for Ex : Item Group Parts = 10 (line1 qty=3 + line3 qty=7 line1 and line3 belong to the same item group) Item Group Lamps = 13 (line2 qty=11 + line4 qty=2 line2 and line4 belong to the same item group) Plz anyone could give me year program example for this. I don' T know how to do that Thank you ;) __ 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. Yahoo! Groups Links [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] attach file
Hi, In the document handling use new file and then choose the file from dialog. You can use any type of file. However unlike word document, pdf is not opened within the form but open acrobat reader outside axapta. Is that what you need ? Regards, Agus On 4/6/06, niphawan sungnoi [EMAIL PROTECTED] wrote: Hil all, You can attach files pdf ? If you can I want your example please thanks nip Yvonne Ranieri [EMAIL PROTECTED] wrote: Thanks, YRanieri [EMAIL PROTECTED] wrote: Hi, see tutorial_Form_File in Forms node under AOT. I think it will be useful for you. regs, Hema. S niphawan sungnoi [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent by: cc: [EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] attach file groups.com 04/05/2006 04:21 PM Please respond to Axapta-Knowledge-Village example I want to attatch detail of finished goods and it's pdf file thank you Agus Riyadi [EMAIL PROTECTED] wrote: Hi, Not clear with your requirement. There is doc handling in axapta. Regards, Agus On 3/23/06, niphawan sungnoi [EMAIL PROTECTED] wrote: dear all who can use attach file on axapta thank you nip Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: RE : RE : [Axapta-Knowledge-Village] Regarding multithreading concept in Axapta
Hi Subbu, I am also interested to take a look how it works. Would you please send me an email too :-) Thanks, Agus On 3/31/06, Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Steve Sir, I apolozise for this dely as I am travelling. I did this in previous project ( employer ) and I sent an email to send me the project xpo to my collegue and am waiting upon him. I will remaind him again. sorry for the delay. thanks regards, subbu Steeve Gilbert [EMAIL PROTECTED] wrote: Hi Subbu! Hope you're doing well. I just wanted to know if you could send me the stuff you did on threads. This is not a priority since there's not on going project on this so take the time you need. I'm looking forward to see what you've done on threads. Have a nice day! Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto: [EMAIL PROTECTED] De la part de Subrahmanyam, Mamidi Envoyé : 22 mars 2006 09:40 À : Axapta-Knowledge-Village@yahoogroups.com Objet : RE: RE : [Axapta-Knowledge-Village] Regarding multithreading concept in Axapta Hi Harry, Well, Its true thats it very hard to debug a dead lock in any multi thread environment and moreover, creation of the thread handles are not very favorable in windows.and I think there is a limit of 2400 ( ?? ) handles on Windows. at any time..User interface is possible ( only ) in MFC Steve, I contacted MS iniially for any good documentaion on this and they said no documentation available and refered a small tutorial :D I will send you a private email on the stuff I did. have a great day. thanks regards, subbbu Harry Deshpande [EMAIL PROTECTED] wrote: Hi Steve My advice is to stay away from threads in Axapta *s* the biggest problem is that you cannot debug threads so if some code logic is in-correct then you cannot use debugger to step thru the process. Plus I have a suspicion that thread process cannot have any user interface such as process bar etc. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto: [EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: 21 March 2006 21:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE : [Axapta-Knowledge-Village] Regarding multithreading concept in Axapta Hi Subbu, A couple of months ago we try to do some multithreading with the thread class in Axapta but it wasn't working very well so we abandoned it. But if there's other way to do that I am for it. So I wanted to see what WinAPI::createdThread() look like but it doesn't exist in our installation Ax 3.0 SP3. Is it in a later SP or do I need something else? Thanks, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto: [EMAIL PROTECTED] De la part de Subrahmanyam, Mamidi Envoyé : 21 mars 2006 14:24 À : Axapta-Knowledge-Village@yahoogroups.com Objet : Re: [Axapta-Knowledge-Village] Regarding multithreading concept in Axapta X++ is not favorable compared to C++ in terms of system programming. in C++, we have many options/ std Cthread class with all thread functions inlcuding mutex objects. 1. for normal purpose, we have a sleep(milli secs) function in X++ 2. If you want to spawn multiple threads, we have WinAPI class: In C++, we have CMutex, waitforSingleObject, waitForMultipleObjects ( = ~ Semaphore ) , but in X++, we have the following WinAPI::createdThread() WinAPI::waitforSingleObject(threadId, waittime) etc etc... This is as per my knowledge... Good Luck. thanks, Subbu truptiranjan nayak [EMAIL PROTECTED] wrote: Hi, can anybody tell me how to do coding using multithreading concept. Ex: Suppose i am updating the invenTtrans table in my class. After updating the invenTtrans table i want to stop the execution for 1000 milliseconds as in Java. (t.sleep(1000)). Thanks Trupti - Yahoo! Travel Find great deals to the top 10 hottest destinations! [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] Inventory On-Hand Report
Hi Rick, Yes, I faced the same problem and have not found any clue. Regards, Agus On 3/27/06, saykai83 [EMAIL PROTECTED] wrote: Hi all, Any of you facing the problem selecting query in on-hand inventory report ( Inventory management reports on-hand on-hans inventory ). This is due to the second time with same user-id, no selection can be make or field or criterial can be choosen. this is weird? any comment or suggestion? Rick. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] attach file
Hi, Not clear with your requirement. There is doc handling in axapta. Regards, Agus On 3/23/06, niphawan sungnoi [EMAIL PROTECTED] wrote: dear all who can use attach file on axapta thank you nip Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Where is System Monitoring Tool
There is also system monitoring tools under Tools Development tools System Monitoring. This tools display database activity. When running in three-tier it also display AOS activity, where we can examine traffic load and tune our code if necessary. Regards, Agus Riyadi -Original Message- From: vaibhav pednekar [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 7:38 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Where is System Monitoring Tool hi, Check in the Administration module the Inquiries and Periodic folders. Perfromance analysis, Database information etc... regards Vaibhav Pednekar Axapta Application Certified Master --- Padmaja Iyingar [EMAIL PROTECTED] wrote: Hi , 1. Where can I find System Monitoring Tool in Axapta?. 2. whats the use of this?. Can someone educate me?. Thanks, Padmaja - Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)
Hi Anton, You can use Axapta OLAP for that purpose. This requires MS Analysis Services SP3 installed. Regards, Agus -Original Message- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 9:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table) Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - --- ItemA 10 0 ItemB 10 10 can I do it in Axapta? thanks in advance, Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: SQL Statement (crosstable / pivot table)
Hi Anton, A workaround is creating another table with array column. Create code to populate data to the new table. Using form/report, change the label appearance of each array in the runtime, based on the data that you want to be displayed as column name. If someone have a better workaround, I would like to know too :-) Regards, Agus -Original Message- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 14:13 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: SQL Statement (crosstable / pivot table) Hi Agus, thanks for your reply, but I guess I can't try it 'cause my company didn't buy the 'OLAP' things hahaha --- In Axapta-Knowledge-Village@yahoogroups.com, Agus Riyadi [EMAIL PROTECTED] wrote: Hi Anton, You can use Axapta OLAP for that purpose. This requires MS Analysis Services SP3 installed. Regards, Agus -Original Message- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 9:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table) Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - --- ItemA 10 0 ItemB 10 10 can I do it in Axapta? thanks in advance, Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Two layer customizing
Joy, If you combine two different layers into one application, there will be the outmost layer that is run by axapta. If you have an object with two layers customization (i.e var and usr), and you login with usr layer, you will get the usr layer. If you login in var layer, you will get the var layer objects. You can combine both customization using export/import facility. You don't need to work in each project. You can create a project that contain 'all objects in a specified layer'. Your step should be: 1. For each layer, create a new project that contain all objects at that layer. In the project window, klik filter. In the project filter dialog clik select. Choose your layer in the utilLevel field. Klik Ok. This may take long depend on the number of objects at the layer. 2. Export your project. You have xpo file for each project. 3. Import the file. The layer with the functionality you user must be imported last. Remember to check delete table and class member in the import dialog. Hope that helps. regards, agus [EMAIL PROTECTED] --- In Axapta-Knowledge-Village@yahoogroups.com, Joy [EMAIL PROTECTED] wrote: - Original Message - From: Joy To: development-axapta@yahoogroups.com Sent: Wednesday, December 22, 2004 11:11 AM Subject: Two layer customizing Hi all, I want to ask a question about programming in two layer (Var and USR) Now i'm in a axapta project. My team make some program in USR layer and our consultant make it in VAR layer. My team made the program in different axapta application with our consultant. Is there the best way to combine our layer in other Axapta application, because i have try to combine it by taking the AXUSR file in our application and AXVAR file in our consultant application to another Application. The result is if our team have maded changes to the same object (such as method in tables, menues, etc) with our consultant, his changes seems dissappeared? Why it can happen, and what should i do to combine it beside by using expot import? cause if i use export import, i must do it at least 60 project. Thanks Joy Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Data import error
Probably it is a problem with your SysDataImport class. Have you update it ? I have it if you need. Agus --- In [EMAIL PROTECTED], Danny Gaethofs [EMAIL PROTECTED] wrote: Dear all, I have exported data import/export definitions from my development database. When importing my data import/export definition groups into a test database I get an error message. The message says not enough rights to insert the data or the imported file only contains shared tables. When importing the dat/def-file using the import wizard it works fine. The problem I have is that it seems impossible now to import other data using the definition groups. I get the message New table are available which have not been included in your group XXX. I seem not be able to solve this. Whatever I try, created new company, use the admin login, ... It certainly will be a small thing that I am overlooking. Anyone aware of this problem and knows how to solve it? regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Selecting a table
Hi Morris, You can put a combobox, set its lookup property to always, set its extended data type property to the same extended data type with the field you want to display. Then you should override its lookup method. There are various examples of 'creating your own lookup form' in the Developer guide. You can filter for any field of the table. Regards, Agus --- In [EMAIL PROTECTED], Morris Mendoza [EMAIL PROTECTED] wrote: How can i select a table and return a specific field and place it in a combobox? For example: I want to select the AccountNum field in the LEDGERTABLE and exclude records with HEADER,PAGE HEADER,EMPTYHEADER and TOTAL in their AccountType field. Then i want to put all these records in a single combobox. How can i accomplish this? Thanks, Morris Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Table that store user and password
Yes, the password is encrypted. It is Dictionary.buildPassword() method that encrypt it. I think we can not know how axapta doing the encryption. I don't have idea of decrypting it. Maybe someone expert in security area can help you. Regards, Agus --- In [EMAIL PROTECTED], Joel WU [EMAIL PROTECTED] wrote: Hi Agus: Thanks, I found that table, however, I saw the password is encrypted, so how can I decrypt it? Thanks Joel _ From: leo_agus_r [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 12:15 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Re: Table that store user and password Joel, It is UserInfo table. You can't find it under AOT, but it exists in the database. Agus --- In [EMAIL PROTECTED], Joel WU [EMAIL PROTECTED] wrote: Hello: Does anyone know which table will store the password of each user ? Regards, Joel Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=1293rktpm/M=295196.4901138.6071305.300117 6/D=gr oups/S=1705001380:HM/EXP=1100060167/A=2128215/R=0/SIG=10se96mf6/*http: /compa nion.yahoo.com click here http://us.adserver.yahoo.com/l? M=295196.4901138.6071305.3001176/D=groups/S= :HM/A=2128215/rand=206585508 _ 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] mailto:[EMAIL PROTECTED] subject=Unsubsc ribe * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Urgent : Not Showing Zeros in the Balance Sheet Report
General Ledger Setup Financial Statement Click columns, then in the Formatting Tab, set the show zero property. choose no regards, agus From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thu 8/26/2004 9:48 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Urgent : Not Showing Zeros in the Balance Sheet Report Hi, I am having a problem in printing balance sheet. The balance sheet has got 5 columns and 30 rows. Whenever the row is zero ( i.e no data ), Its prinitng zero there. I don't want to print zero rather would like to leave a blank. How can I achie this?. However, in the setup, I checked skip zero, Its skipping the row ( i.e not prininting at all ) if it is zero. Can anyone tell me how to show a blank in stead of zero in the balance sheet?. Many thanks, Ottawa Do you Yahoo!? Yahoo! Mail http://us.rd.yahoo.com/mail_us/taglines/50x/*http://promotions.yahoo.com/new_mail/static/efficiency.html - 50x more storage than other providers! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129a3dt0s/M=298184.5285298.6392945.3001176/D=groups/S=1705001380:HM/EXP=1093618149/A=2319498/R=0/SIG=11thfntfp/*http://www.netflix.com/Default?mqso=60185352partid=5285298 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat