[development-axapta] Proforma project invoice
Has anyone made the project invoice as proforma? Just wondering why there is no such function and is it due to being very difficult to do technically? Has anyone made such before and have any warnings? Thanks a lot James [Non-text portions of this message have been removed]
[development-axapta] Proforma project invoice - sorry pls ignore
Sorry pls ignore this.proforma does exist for project.been a long hard day ;) Sorry everyone about this Thanks James From: James Flavell [mailto:djf1...@gmail.com] Sent: 20 December 2010 18:19 To: 'development-axapta@yahoogroups.com' Subject: Proforma project invoice Has anyone made the project invoice as proforma? Just wondering why there is no such function and is it due to being very difficult to do technically? Has anyone made such before and have any warnings? Thanks a lot James [Non-text portions of this message have been removed]
[development-axapta] What is the latest AX 4.0 SP1 kernel available?
Can anyone tell me the latest kernel available for AX4.0 SP1? The hotfix list says xxx.939 but this turns out not to be a Kernel hotfix even though it says so on the list in PartnerSource. So now I don't trust the list and wondering which one really is the latest available kernel Also I assume I cannot use AX4.0 SP2 kernels with a AX4.0 SP1 application but again if anyone can confirm this is not a wise or supported configuration would be great Thanks as always J James [Non-text portions of this message have been removed]
[development-axapta] AX4.0 Internal error number 25 in script
Dear all does anyone have any ideas for this error happening in batch processing: There was some hotfix for non SP for this error but we are running Ax4.0 SP2 so should be included. We have basically the following batch jobs in 2 companies: Alerts - change abd due date based every 10 mins OLAP - Custom import/export of data - Looking at the entries in the batch list the alerts ran at 21:10:29 and so would only be running at 21:20 the next time. All the other tasks also were not scheduled to run at the time it happened which was 21:10:48 I saw there was another hotfix for SP2 regarding sending email from AR/AP module can get this error. The KB said it applied to the .NET connector but we are not using that (unless it is by default used when sending email?). But was wondering since alert is no doubt setup to send email notification whether there might be something related to the area of email sending? Has anyone else faced this error message as all batch jobs stop and the client crashes when we go to the batch client and click OK? As always a big thanks for taking the time to read this James [Non-text portions of this message have been removed]
[development-axapta] RE: temp table in AX2009
Sorry I also meant to ask if I have a temp table and use SQL commands like sum and count is there still any benefits or actually this is the same as using a while select? Thanks From: James Flavell [mailto:djf1...@gmail.com] Sent: 31 July 2010 13:06 To: 'development-axapta@yahoogroups.com' Subject: temp table in AX2009 Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% . I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James [Non-text portions of this message have been removed]
[development-axapta] temp table in AX2009
Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% . I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James [Non-text portions of this message have been removed]
[development-axapta] AX 3.0 and Oracle - nvarchar suddenly changed to varchar
Hi everyone It seems our customer who has AX3.0 and Oracle and have found their database fields for strings have changed from nvarchar to varchar suddenly. My guess was the 'Initialize DB to Unicode' in the AXC had been unticked and then someone did a sync but I am not sure if this can cause such a change in Oracle (in SQL server I tested and it makes no difference once the DB is created but I am guessing maybe Oracle is different) Have anyone had any experience where nvarchar fields have suddenly changed to varchar in AX with Oracle? It's a little strange as ItemId on Inventtable is now varchar but itemid on InventSum is still nvarchar!? Hope someone might have some ideas on this real soon as this is on live database L Thanks in advance once again James [Non-text portions of this message have been removed]
RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas?
Thanks Malcolm once again Just wondering is there any counter or tool to monitor memory usage in a specific process (i.e. AX32Serve.exe)? Monitoring the total memory or available is going to be a little tough I feel Also just to add is this 2GB limit still in AX2009? And does this mean having 4 GB RAM is all you need for an AOS server (given you can't use more than 2GB and another 2GB for OS should be sufficient)? Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 30 May 2010 01:56 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi James The AX AOS will crash as it approaches 2GB of memory use and its likely that performance would degrade as it nears this upper limit. It could be that you have uncovered a memory leak in AX which might account for this but it could also be that you just have too many users that run memory hungry processes at the same time and simply need another AOS to spread the load. You could use performance monitor to track memory use over time to see if you can get a better handle on whther it is a leak or you could simply grab a new kernel (there are some memory leak fixes in newer kernels as I've been dealing with a leak problem for one of my clients over the last couple of months and the signs are good that the latest kernel has resolved the problem for them. Regards Malcolm Burtt Product Development Manager Touchstone Ltd From: development-axapta@yahoogroups.com [development-axa...@yahoogroups.com] On Behalf Of James Flavell [djf1...@gmail.com] Sent: 25 May 2010 13:18 To: development-axapta@yahoogroups.com Subject: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi everyone We have an AX4.0 SP2 with kernel 4.0.2503.953 Today the user reported very slow performance and the AOS crashed later on When we looked in the event viewer there was an error: Object Server 01: RPC error: RPC exception 14 occurred in session 3 This was logged maybe 50 to 100 times in a single second every second!!! I searched but could find no mention of RCP 14 error anywhere (including partner source) Does anyone have any idea what can cause this error or similar kind of mass logging in the event viewer every second? Also I heard the Ax4.0 AOS is likely to crash when the Ax32Serv.exe process reaches around the 2GB limit. Has anyone heard about this? Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Links
RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas?
Cheers Absi for sharing that very useful info J Apart from Financial Statement was there any other reports or functions that should signs of causing this? Thanks James From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of abd absi Sent: 31 May 2010 22:25 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi All, I have run through the same issue in different sites runing Ax 4.0 SP2 and Ax 2009 SP1.I figured about the AOSes will start giving those errors and directly goes down.I made certain monitoring and it was basically because of certainn functions and reports that cause this issues. In my case the Financial statement Report was run with a focus of five dimensions in there ,the report was freezing the client session trying to fetch the report.I was monitoring the memory on the server that user was accessing and it goes down when the unilized memory reaches to 3GB,I am not sure why 3! This case is still logged with MS.and do not know if they found a solution or not. Regards Abdulrahman Absi --- On Mon, 5/31/10, James Flavell djf1...@gmail.com mailto:djf1994%40gmail.com wrote: From: James Flavell djf1...@gmail.com mailto:djf1994%40gmail.com Subject: RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Date: Monday, May 31, 2010, 11:33 AM Thanks Martin We upgraded the kernel to solve unstable problems of user sessions crashing or getting message about 'not enough resources so your session will be terminated' and I agreed it has helped a lot as the whole thing was stable for almost 2 months (rather than the usual few days) :) But then this one happened and I guess it was the 2GB limit. They are only 20+ users so we will just have to try to setup a start and stop routine (the main challenge to this is restarting the batch client which I asked about in previous postings in this group) Thanks again James -Original Message- From: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com [mailto:development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com ] On Behalf Of Malcolm Burtt Sent: 30 May 2010 01:56 To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi James The AX AOS will crash as it approaches 2GB of memory use and its likely that performance would degrade as it nears this upper limit. It could be that you have uncovered a memory leak in AX which might account for this but it could also be that you just have too many users that run memory hungry processes at the same time and simply need another AOS to spread the load. You could use performance monitor to track memory use over time to see if you can get a better handle on whther it is a leak or you could simply grab a new kernel (there are some memory leak fixes in newer kernels as I've been dealing with a leak problem for one of my clients over the last couple of months and the signs are good that the latest kernel has resolved the problem for them. Regards Malcolm Burtt Product Development Manager Touchstone Ltd From: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com [development-axa...@yahoogroups.com mailto:development-axapta%40yahoogroups.com ] On Behalf Of James Flavell [djf1...@gmail.com mailto:djf1994%40gmail.com ] Sent: 25 May 2010 13:18 To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi everyone We have an AX4.0 SP2 with kernel 4.0.2503.953 Today the user reported very slow performance and the AOS crashed later on When we looked in the event viewer there was an error: Object Server 01: RPC error: RPC exception 14 occurred in session 3 This was logged maybe 50 to 100 times in a single second every second!!! I searched but could find no mention of RCP 14 error anywhere (including partner source) Does anyone have any idea what can cause this error or similar kind of mass logging in the event viewer every second? Also I heard the Ax4.0 AOS is likely to crash when the Ax32Serv.exe process reaches around the 2GB limit. Has anyone heard about this? Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas?
Thanks Mike Can you just clarify for me about: We have a specific ax client configuration file on the batch server with the batch parameter in the 'command to run at application startup' You mean I can put a parameter in the AX config that will start the batch process running for certain batch groups? (i.e. no need to modify the SysStartup class?) Thank you very much James From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Mike Sent: 01 June 2010 21:13 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi James, There are a couple of different ways of handling the restart of the batch server. The best way is to get an extra batch server license and have a AOS service running on the batch server and have the batch client connect to it's on AOS service. This way users can't mess with the batch AOS and the batch AOS can't mess with the users. Before we had the separate batch AOS service, we ran one script on the batch server to reboot the batch server at the same time as the other script was stopping the AOS service on the AOS server. We have a specific ax client configuration file on the batch server with the batch parameter in the 'command to run at application startup' Then as a startup task we have a script that starts the ax client: Run C:\Program Files\Microsoft Dynamics AX\40_sp2\Client\AX40_Batch.axc From: James Flavell Sent: Monday, May 31, 2010 12:59 AM To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Thanks Mike J I don't believe we have any 3rd party apps that connect via business connector so it must be one of the normal clients L The only external party I can think of is the SQL OLAP being accessed via the AX client Pivot View analysis (or the pushing of data to the SQL OLAP during the cube processing) but I don't think this use business connector right? For stopping and starting since this is AX4.0 do you have any suggestions for getting the batch client running again? I believe I have to do something about the startup class or the like and then have a batch file that starts a client with some startup parameter or something right? Thanks again for your great help, much appreciated J James From: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com [mailto:development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com ] On Behalf Of Mike Sent: 28 May 2010 20:52 To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: Re: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? I would focus on whatever 3rd party apps you have on that AOS that connect via the business connector. That's going to be the source of an RPC error on the AOS. Yes, the AOS service crashes when it runs out of memory and it runs slow as it approaches the upper limits. You should restart the aos service periodically to prevent this from happening. pick a time of day when it affects the least amount of people. you could even create 2 .bat files with 'net stop AOS$03' and 'net start AOS$03' and schedule them to run 2 minutes apart at a time when no one is on the system. From: James Flavell Sent: Tuesday, May 25, 2010 8:18 AM To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi everyone We have an AX4.0 SP2 with kernel 4.0.2503.953 Today the user reported very slow performance and the AOS crashed later on When we looked in the event viewer there was an error: Object Server 01: RPC error: RPC exception 14 occurred in session 3 This was logged maybe 50 to 100 times in a single second every second!!! I searched but could find no mention of RCP 14 error anywhere (including partner source) Does anyone have any idea what can cause this error or similar kind of mass logging in the event viewer every second? Also I heard the Ax4.0 AOS is likely to crash when the Ax32Serv.exe process reaches around the 2GB limit. Has anyone heard about this? Thanks James [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: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas?
Sorry Mike a quick google gave me a detailed example to try out for this Thanks again James From: James Flavell [mailto:djf1...@gmail.com] Sent: 02 June 2010 17:31 To: 'development-axapta@yahoogroups.com' Subject: RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Thanks Mike Can you just clarify for me about: We have a specific ax client configuration file on the batch server with the batch parameter in the 'command to run at application startup' You mean I can put a parameter in the AX config that will start the batch process running for certain batch groups? (i.e. no need to modify the SysStartup class?) Thank you very much James From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Mike Sent: 01 June 2010 21:13 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi James, There are a couple of different ways of handling the restart of the batch server. The best way is to get an extra batch server license and have a AOS service running on the batch server and have the batch client connect to it's on AOS service. This way users can't mess with the batch AOS and the batch AOS can't mess with the users. Before we had the separate batch AOS service, we ran one script on the batch server to reboot the batch server at the same time as the other script was stopping the AOS service on the AOS server. We have a specific ax client configuration file on the batch server with the batch parameter in the 'command to run at application startup' Then as a startup task we have a script that starts the ax client: Run C:\Program Files\Microsoft Dynamics AX\40_sp2\Client\AX40_Batch.axc From: James Flavell Sent: Monday, May 31, 2010 12:59 AM To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Thanks Mike J I don't believe we have any 3rd party apps that connect via business connector so it must be one of the normal clients L The only external party I can think of is the SQL OLAP being accessed via the AX client Pivot View analysis (or the pushing of data to the SQL OLAP during the cube processing) but I don't think this use business connector right? For stopping and starting since this is AX4.0 do you have any suggestions for getting the batch client running again? I believe I have to do something about the startup class or the like and then have a batch file that starts a client with some startup parameter or something right? Thanks again for your great help, much appreciated J James From: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com [mailto:development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com ] On Behalf Of Mike Sent: 28 May 2010 20:52 To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: Re: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? I would focus on whatever 3rd party apps you have on that AOS that connect via the business connector. That's going to be the source of an RPC error on the AOS. Yes, the AOS service crashes when it runs out of memory and it runs slow as it approaches the upper limits. You should restart the aos service periodically to prevent this from happening. pick a time of day when it affects the least amount of people. you could even create 2 .bat files with 'net stop AOS$03' and 'net start AOS$03' and schedule them to run 2 minutes apart at a time when no one is on the system. From: James Flavell Sent: Tuesday, May 25, 2010 8:18 AM To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi everyone We have an AX4.0 SP2 with kernel 4.0.2503.953 Today the user reported very slow performance and the AOS crashed later on When we looked in the event viewer there was an error: Object Server 01: RPC error: RPC exception 14 occurred in session 3 This was logged maybe 50 to 100 times in a single second every second!!! I searched but could find no mention of RCP 14 error anywhere (including partner source) Does anyone have any idea what can cause this error or similar kind of mass logging in the event viewer every second? Also I heard the Ax4.0 AOS is likely to crash when the Ax32Serv.exe process reaches around the 2GB limit. Has anyone heard about this? Thanks James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text
RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas?
Thanks Mike J I don't believe we have any 3rd party apps that connect via business connector so it must be one of the normal clients L The only external party I can think of is the SQL OLAP being accessed via the AX client Pivot View analysis (or the pushing of data to the SQL OLAP during the cube processing) but I don't think this use business connector right? For stopping and starting since this is AX4.0 do you have any suggestions for getting the batch client running again? I believe I have to do something about the startup class or the like and then have a batch file that starts a client with some startup parameter or something right? Thanks again for your great help, much appreciated J James From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Mike Sent: 28 May 2010 20:52 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? I would focus on whatever 3rd party apps you have on that AOS that connect via the business connector. That's going to be the source of an RPC error on the AOS. Yes, the AOS service crashes when it runs out of memory and it runs slow as it approaches the upper limits. You should restart the aos service periodically to prevent this from happening. pick a time of day when it affects the least amount of people. you could even create 2 .bat files with 'net stop AOS$03' and 'net start AOS$03' and schedule them to run 2 minutes apart at a time when no one is on the system. From: James Flavell Sent: Tuesday, May 25, 2010 8:18 AM To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi everyone We have an AX4.0 SP2 with kernel 4.0.2503.953 Today the user reported very slow performance and the AOS crashed later on When we looked in the event viewer there was an error: Object Server 01: RPC error: RPC exception 14 occurred in session 3 This was logged maybe 50 to 100 times in a single second every second!!! I searched but could find no mention of RCP 14 error anywhere (including partner source) Does anyone have any idea what can cause this error or similar kind of mass logging in the event viewer every second? Also I heard the Ax4.0 AOS is likely to crash when the Ax32Serv.exe process reaches around the 2GB limit. Has anyone heard about this? Thanks James [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: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas?
Thanks Martin We upgraded the kernel to solve unstable problems of user sessions crashing or getting message about 'not enough resources so your session will be terminated' and I agreed it has helped a lot as the whole thing was stable for almost 2 months (rather than the usual few days) :) But then this one happened and I guess it was the 2GB limit. They are only 20+ users so we will just have to try to setup a start and stop routine (the main challenge to this is restarting the batch client which I asked about in previous postings in this group) Thanks again James -Original Message- From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 30 May 2010 01:56 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi James The AX AOS will crash as it approaches 2GB of memory use and its likely that performance would degrade as it nears this upper limit. It could be that you have uncovered a memory leak in AX which might account for this but it could also be that you just have too many users that run memory hungry processes at the same time and simply need another AOS to spread the load. You could use performance monitor to track memory use over time to see if you can get a better handle on whther it is a leak or you could simply grab a new kernel (there are some memory leak fixes in newer kernels as I've been dealing with a leak problem for one of my clients over the last couple of months and the signs are good that the latest kernel has resolved the problem for them. Regards Malcolm Burtt Product Development Manager Touchstone Ltd From: development-axapta@yahoogroups.com [development-axa...@yahoogroups.com] On Behalf Of James Flavell [djf1...@gmail.com] Sent: 25 May 2010 13:18 To: development-axapta@yahoogroups.com Subject: [development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas? Hi everyone We have an AX4.0 SP2 with kernel 4.0.2503.953 Today the user reported very slow performance and the AOS crashed later on When we looked in the event viewer there was an error: Object Server 01: RPC error: RPC exception 14 occurred in session 3 This was logged maybe 50 to 100 times in a single second every second!!! I searched but could find no mention of RCP 14 error anywhere (including partner source) Does anyone have any idea what can cause this error or similar kind of mass logging in the event viewer every second? Also I heard the Ax4.0 AOS is likely to crash when the Ax32Serv.exe process reaches around the 2GB limit. Has anyone heard about this? Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Links
[development-axapta] Live AOS failure RPC exception 14 reported in event log many many times per second - any ideas?
Hi everyone We have an AX4.0 SP2 with kernel 4.0.2503.953 Today the user reported very slow performance and the AOS crashed later on When we looked in the event viewer there was an error: Object Server 01: RPC error: RPC exception 14 occurred in session 3 This was logged maybe 50 to 100 times in a single second every second!!! I searched but could find no mention of RCP 14 error anywhere (including partner source) Does anyone have any idea what can cause this error or similar kind of mass logging in the event viewer every second? Also I heard the Ax4.0 AOS is likely to crash when the Ax32Serv.exe process reaches around the 2GB limit. Has anyone heard about this? Thanks James [Non-text portions of this message have been removed]
[development-axapta] AX4.0 how to know batch process is running
Hi everyone, I am not sure if this has been asked in the group before but if yes please help direct me to the posting I want to setup some way to alert me if the batch process (or batch user login) has failed or not been started in AX4.0. Basically I have several companies and about 5 batch groups in each so that is 10 batch processes that need to be running. I just want a simple way to get an email notification if the batch process is not running Usually the problem is the batch user session is terminated for various reason such as hardware problem So I was thinking is there some SQL script I can make to check the batch user is logged in or somehow from outside AX query what batch groups or processes are currently running in AX? Thanks in advance for your help James [Non-text portions of this message have been removed]
[development-axapta] FW: AX2009 windows left not responding
Hi everyone we have strange behaviour in AX2009 SP1 + GLS + RU3 Sometimes it seems users get AX windows that stop responding. In the list of the available windows inside AX these windows no longer appear in the list but in the OS taskbar they are there and can be selected but nothing can be done with them (including moving them around) I can open new windows in AX and they appear and act normal Does anyone know any ideas why this is? If seems like these windows have been lost by the AOS and so not considered as part of the users AX client session anymore It seems like it happens more with users who are working on inventory journals but cannot confirm anything about that Has anyone else had this or have any ideas what to check on? Thanks James [Non-text portions of this message have been removed]
[development-axapta] AOD modified date
Our auditor requires to know when are the AOD files updated by AX. Is it only when a change is made in the corresponding layer in an AOT object or are there other situations? If an object exists in both VAR and USR, if it is modified in USR can the VAR aod file in anyway be affected? If aoi is rebuilt can this affect? If cross reference is updated can this affect? The reason is the VAR aod file has strange dates that cannot be explained (since we did not do any changes in the VAR layer since a certain date) and so the auditor wants to know the situations of how AX can modify it Is there any way we can filter or see if there is any object in the VAR layer that has a created or modified date after a certain date? Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] LedgerTrans summarization record purge
Should be fine so long as you can live without the detail and just keep a good safe backup of all the original J From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of mep53565 Sent: 15 December 2009 07:32 To: development-axapta@yahoogroups.com Subject: [development-axapta] LedgerTrans summarization record purge I'm wondering if anyone has worked on reducing size of LedgerTrans file. Our current table is 30GB, we want to clean out data older than 4 years. I've got a preliminary class that summarizes transactions deletes the originals and it seems to work. I've recalculated period balances and so far they tie out to the penny. I'm wondering if I'm missing anything. AXv3sp3 [Non-text portions of this message have been removed]
RE: [development-axapta] Ax2009 and W2008
Thanks Jesper Just for everyone's info it seems we had to reinstall the client on the W2008 for some reason and no it seems okay. Clients on other machines didn't have the problem Thanks James From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of jesper.joergen...@bertelsmann.de Sent: 03 November 2009 20:34 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Ax2009 and W2008 Hallo James, check the entries in the event log proir to your termination log entry. Jesper From: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com [mailto:development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com ] On Behalf Of James Flavell Sent: Dienstag, 3. November 2009 11:53 To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: [development-axapta] Ax2009 and W2008 Hi everyone I know it is officially supported but has anyone had issue with W2008 (x64) and AX2009? Am getting event log: The Dynamics AX Object Server 5.0$01- service terminated unexpectedly. It has done this 1 time(s). And the log also says it says is running on a OS that is not supported and says W2003 SP1 is the supported os ..!!!??? I am running AX2009 SP1 with GLS and RU3 Thanks James [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]
[development-axapta] Ax3.0 SP6 physical value wrong
Hi everyone I have another urgent problem that I hope someone might be able to shine some light on We have AX3.0 SP6 with DIS/DIP for Norway The Inventory physical report that has a column showing Physical Posted is giving wrong values if we back date the report. Things we found: 1) If we run it on today's date the values are correct but if we run with a date in the past then the values are wrong. 2) If we have not run any closing (i.e. no settlements) then back dated report seems to be okay so it seems it is related to the settlements Has anyone had similar problem or know of any fix that might exist? Or does anyone have Ax3.0 SP6 and this column is working fine? Appreciate any help can get on this before the auditors turn up. Thanks James [Non-text portions of this message have been removed]
[development-axapta] RE: GLS or RU3 changes SYS or other system layers?
Just to update all The SYS and GLS layer are NOT changed by the RU3 according to MS support. From the support request (after much pain in dealing with MS support): While from the KB Article may sound like there has been changes in SYS/GLS, but what it actually means is that, it refers to the way the xxP will override the code from the xxS layer. Across various environments the SYS layer is consistent, it is only the SYP that will be updated. The same is true for the GLS layer which is the GLP. This goes on to say that The SYS and GLS layers themselves are not changed by the rollup in RU3. It is a fact that xxP layers will be used to apply the patches. To me the KB does not sound like it is saying there are changes in SYS or GLS but is actually saying it changes them! But then again my English might not be the best since I am Welsh ;) Thanks James From: James Flavell [mailto:djf1...@gmail.com] Sent: 28 October 2009 09:33 To: 'development-axapta@yahoogroups.com' Subject: RE: GLS or RU3 changes SYS or other system layers? Sorry slight correction/edit to my earlier post. I found the original web page that got me really concerned (sorry it was not the SP1 web page but search partner source or customer source for Hotfix rollup 3 (974407) is available for Microsoft Dynamics AX 2009) The below statement is what got me concerned: The rollup package contains both a cumulative kernel update and a cumulative application update. Although there is no dependency between these two updates, we recommend that you install both of the updates together. The rollup will be installed on the SYP layer and the GLP layer. Additionally, this rollup will update the SYS layer and the GLS layer that are installed on the system It clearly says here SYS and GLS will be updated!!! Any ideas why/what? So I think SP1 does not touch SYS or GLS (sorry for scaring anyone) but it would seem the RU3 does (I really don't understand why since XXP layers are supposed to be exactly for the reason of patching so why is there a need to change the original layer) Thanks James From: James Flavell [mailto:djf1...@gmail.com] Sent: 27 October 2009 16:39 To: 'development-axapta@yahoogroups.com' Subject: GLS or RU3 changes SYS or other system layers? Good afternoon Can anyone advise if the GLS or Hotfix RU3 install exe files update the SYS layer? I read on the web site for SP1 (and also I thought for GLS or RU3 but cannot seem to find now) that it updates the SYS but not sure if that is just some incorrect information on the web site..see: https://mbs.microsoft.com/customersource/downloads/servicepacks/dynamicsax20 09sp1 Other key highlights in this service pack release include: . The SP1 installer updates both the SYS and GLS layers of the product. This means, for example, that if you already have GLS-TR installed on your system, SP1 will update this layer during the installation process. I assumed the above meant SYP or GLP was updated but now I am a little unsure because I always thought SYS was off limits to everyone and only a new version made changes but a binary file compare of a SYS aod from the install DVD compared to after GLS and RU3 being applied shows a different file size and content. Can this change in SYS aod be due to a full compile of the AX application during the GLS or RU3 install or something like that? Would appreciate any help on being sure whether SYS aod file is the same even though the compare shows a difference Thanks James [Non-text portions of this message have been removed]
[development-axapta] Ax2009 and W2008
Hi everyone I know it is officially supported but has anyone had issue with W2008 (x64) and AX2009? Am getting event log: The Dynamics AX Object Server 5.0$01- service terminated unexpectedly. It has done this 1 time(s). And the log also says it says is running on a OS that is not supported and says W2003 SP1 is the supported os ..!!!??? I am running AX2009 SP1 with GLS and RU3 Thanks James [Non-text portions of this message have been removed]
[development-axapta] RE: GLS or RU3 changes SYS or other system layers?
Sorry slight correction/edit to my earlier post. I found the original web page that got me really concerned (sorry it was not the SP1 web page but search partner source or customer source for Hotfix rollup 3 (974407) is available for Microsoft Dynamics AX 2009) The below statement is what got me concerned: The rollup package contains both a cumulative kernel update and a cumulative application update. Although there is no dependency between these two updates, we recommend that you install both of the updates together. The rollup will be installed on the SYP layer and the GLP layer. Additionally, this rollup will update the SYS layer and the GLS layer that are installed on the system It clearly says here SYS and GLS will be updated!!! Any ideas why/what? So I think SP1 does not touch SYS or GLS (sorry for scaring anyone) but it would seem the RU3 does (I really don't understand why since XXP layers are supposed to be exactly for the reason of patching so why is there a need to change the original layer) Thanks James From: James Flavell [mailto:djf1...@gmail.com] Sent: 27 October 2009 16:39 To: 'development-axapta@yahoogroups.com' Subject: GLS or RU3 changes SYS or other system layers? Good afternoon Can anyone advise if the GLS or Hotfix RU3 install exe files update the SYS layer? I read on the web site for SP1 (and also I thought for GLS or RU3 but cannot seem to find now) that it updates the SYS but not sure if that is just some incorrect information on the web site..see: https://mbs.microsoft.com/customersource/downloads/servicepacks/dynamicsax20 09sp1 Other key highlights in this service pack release include: . The SP1 installer updates both the SYS and GLS layers of the product. This means, for example, that if you already have GLS-TR installed on your system, SP1 will update this layer during the installation process. I assumed the above meant SYP or GLP was updated but now I am a little unsure because I always thought SYS was off limits to everyone and only a new version made changes but a binary file compare of a SYS aod from the install DVD compared to after GLS and RU3 being applied shows a different file size and content. Can this change in SYS aod be due to a full compile of the AX application during the GLS or RU3 install or something like that? Would appreciate any help on being sure whether SYS aod file is the same even though the compare shows a difference Thanks James [Non-text portions of this message have been removed]
[development-axapta] GLS or RU3 changes SYS or other system layers?
Good afternoon Can anyone advise if the GLS or Hotfix RU3 install exe files update the SYS layer? I read on the web site for SP1 (and also I thought for GLS or RU3 but cannot seem to find now) that it updates the SYS but not sure if that is just some incorrect information on the web site..see: https://mbs.microsoft.com/customersource/downloads/servicepacks/dynamicsax20 09sp1 Other key highlights in this service pack release include: . The SP1 installer updates both the SYS and GLS layers of the product. This means, for example, that if you already have GLS-TR installed on your system, SP1 will update this layer during the installation process. I assumed the above meant SYP or GLP was updated but now I am a little unsure because I always thought SYS was off limits to everyone and only a new version made changes but a binary file compare of a SYS aod from the install DVD compared to after GLS and RU3 being applied shows a different file size and content. Can this change in SYS aod be due to a full compile of the AX application during the GLS or RU3 install or something like that? Would appreciate any help on being sure whether SYS aod file is the same even though the compare shows a difference Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] Split AR on a single Sales invoice posting
Thanks Michael I had not thought about such a way so thanks for some ideas but I think it wont get what i want in the end (but i will think it through) Basically what I want is 1 Invoice but the AR transaction (CustTrans) is split into an amount for salesman A and an amount for salesman B (salesman A and B will be specified on the sales order lines) Thanks James _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of mni_...@hotmail.com Sent: 12 August 2009 23:01 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Split AR on a single Sales invoice posting Hi James, i'm not sure if i understand right. If you mean to get a separate invoice for one salesorder for each salesrep ? Standard do this for adress in salesline. If you enable Account receivable parameters / Tab Summary Update Group Delivery information Invoice, for one Sales Order you got an invoice per salesline address. Perhaps you kann use the address for your issue, or use the same mechanism in code. Best regards Michael From: James Flavell Sent: Wednesday, August 12, 2009 2:58 AM To: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com Subject: [development-axapta] Split AR on a single Sales invoice posting Hi everyone, Just wondering has anyone done a mod to split the AR transaction for a sales order invoice posting? I have the case whereby a sales order has several lines and each line might have a different salesrep and I would like to get separate AR transactions (CustTrans) for each sales rep so easy to compile a AR aging or statement per salesrep. I could make a customer account for each salesrep but this would then mean the SO has to be spilt into one per salesrep so this is not an ideal solution Wondering if it is fairly straight forward or not to do this kind of split (considering Dimensions can split the revenue part of the posting was wondering if something similiar can be done on the AR part) Look forward to hearing from anyone who has managed or attempted it Thanks James [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]
[development-axapta] Split AR on a single Sales invoice posting
Hi everyone, Just wondering has anyone done a mod to split the AR transaction for a sales order invoice posting? I have the case whereby a sales order has several lines and each line might have a different salesrep and I would like to get separate AR transactions (CustTrans) for each sales rep so easy to compile a AR aging or statement per salesrep. I could make a customer account for each salesrep but this would then mean the SO has to be spilt into one per salesrep so this is not an ideal solution Wondering if it is fairly straight forward or not to do this kind of split (considering Dimensions can split the revenue part of the posting was wondering if something similiar can be done on the AR part) Look forward to hearing from anyone who has managed or attempted it Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] Re: Mobile Development for Barcode Scanner on Receiving Items
Hi Steve, I also have tried this but found the device screen too small so just wondering what device size screen/resolution you are using? Thanks James _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Steeve Gilbert Sent: 07 August 2009 04:05 To: development-axapta@yahoogroups.com Subject: [development-axapta] Re: Mobile Development for Barcode Scanner on Receiving Items If your scanner can have 100% WiFi connection coverage than I would highly recommend using Terminal Services. That's what we do here. We've created special Ax forms that fit the device. When the user open Terminal Services it automatically opens Ax than it opens his special Main menu. It's easy to do and everything is in Ax. You don't have to mess with the Business Connector. If you need help let me know. --- In development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com, Girac girac...@... wrote: Hi all, I need to develop a mobile application to run on a scanner, we will be using it to receive items. I ran across some tutorials on mobile development but this past wasn't covered. All I need to do is replicate some Ax forms to run on my Windows Mobile Device. Has anyone developed such an application and can they lend assistance? ciao, [Non-text portions of this message have been removed]
RE: [development-axapta] Error running export to file as batch but no problem when run normally by the user
Thank you all who have responded so fast Varden you were right in that once I tested changing the account on the AOS service to an account I know had rights to the folder then it worked perfectly. Thank you and the rest very much for all you speedy help. One question I have is if the AOS service is using NT AUTHORITY\NETWORK SERVICE is it wise to give this account access to folders or should I create some kind of new AOS service account (and if so what kind of permissions should I give it). I guess this is more a best practice type of query as I am not familiar with windows server permission and how best to configure an account for somethign like an AOS service. And sorry one final query that just popped in my head. If the users start to print reports to file and submit these as batch jobs then will the AOS service account need to have rights to write to whatever folders the user has typed in the report options? Thanks once again to you all :) James _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Varden Morris Sent: 10 June 2009 21:37 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Error running export to file as batch but no problem when run normally by the user Are you using a relative or absolute path? You should share the folder with write access for the user that executes the AOS service. Ensure that you are using an absolute path such as \\ComputerName\ShareFolderName. If you use a relative path such as C:\FolderName\AnotherFolder then it will work if the job is executed from the client computer and the folder is on that computer. However, if the batch job is set to run on the server and the same folder path does not exists on the AOS computer you will have a problem. Regards, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: James Flavell djf1...@gmail. mailto:djf1994%40gmail.com com To: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com Sent: Wednesday, June 10, 2009 12:03:00 AM Subject: [development-axapta] Error running export to file as batch but no problem when run normally by the user H i everyone I have a strange problem that I have a class that basically creates a text file of the item onhand information. The class works fine when run by the user but when I set it to run in batch it gives an error when the following code is called by the batch client: new FileIOPermission( FileName, 'w').assert( ); File = new AsciiIO(FileName, 'w'); The error says about ASCIIIO is not initialised. I get the error even if I start the batch client in the same logged in AX session that works if the user runs the export directly so I am a little lost Also I took the export and put it on a dev server and it worked okay using the batch client! So I am wondering when the batch client is running what user id is it running as? The user id that logged into AX and started the batch client or the user id that is in the AOS service start up or something else? Does anyone have any idea why the batch running would give this error since the export works fine when run directly by the user? This is AX4.0 SP1 or SP2 I cannot remember right now Thanks James [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]
[development-axapta] Error running export to file as batch but no problem when run normally by the user
H i everyone I have a strange problem that I have a class that basically creates a text file of the item onhand information. The class works fine when run by the user but when I set it to run in batch it gives an error when the following code is called by the batch client: new FileIOPermission(FileName, 'w').assert(); File= new AsciiIO(FileName, 'w'); The error says about ASCIIIO is not initialised. I get the error even if I start the batch client in the same logged in AX session that works if the user runs the export directly so I am a little lost Also I took the export and put it on a dev server and it worked okay using the batch client! So I am wondering when the batch client is running what user id is it running as? The user id that logged into AX and started the batch client or the user id that is in the AOS service start up or something else? Does anyone have any idea why the batch running would give this error since the export works fine when run directly by the user? This is AX4.0 SP1 or SP2 I cannot remember right now Thanks James [Non-text portions of this message have been removed]
[development-axapta] AX intercompany pain
Hi everyone Was wondering is anyone has come across the following pain in AX intercompany in AX2009 (or maybe earlier versions too) Orig SO (A) PO (B) created via direct delivery for (A) Intercompany SO (C) created for (B) When it is all created the address on all 3 is the sames as (A) BUT if I change the delivery term field (or other fields that are sync'd) on (C) then (A) and (B) have their delivery address 'reset' to the company info address!!! I can see code in AxSalesTable and AxPurchTable regarding setDeliveryAddress etc and it looking up companyinfo address but cannot quite fully understand how to fix such that the address should not change if I update something like Del Term (I have a feeling I need to trick AX into thinking the delviery address fields have changed and then these will be sync'd back rather than copnay info address being used but again this is only a educated guess and where exactly to put such code is another matter) Would apprecaite anyone who can give me some advice or ideas Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] Re: Top margin changes by itself
Thanks Malcom That is the 'work around' solution I have given to the customer. Of course they dont accept it for the longterm as it means even programmers have to remove all printers if they are going to touch and save a report object that needs specific placing of fields and this is their complaint (and mine...give me a warning or choice to change the margin not just do it without me even knowing) Of course when you involve customer, partner, freelance contractor, MS etc then you can see its not a very partical solution to have everyone removing all their printers ;) Thanks James James Flavell CITP Singapore Pte Ltd Mobile: +65 97582281 Email: d...@sg.columbusit.com _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 19 March 2009 17:37 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Re: Top margin changes by itself Hi James If the thing that's causing you the problem is that the import process changes the margin to match the physical limitations of the default printer of the user that did the XPO import, what would happen if you imported the object using an account that has no default printer (or perhaps no printer defined at all). It would probably mean having a domain account used only for doing XPO imports but if that solves your problem it would be a small price to pay. Malcolm From: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com [mailto:development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com] On Behalf Of James Flavell Sent: 19 March 2009 06:00 To: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com Subject: RE: [development-axapta] Re: Top margin changes by itself Thanks Karsten, I would say its somewhat of a bug because yes I agree I could program the report based on knowing the printer but these days this is often not the case. Customers see printers as plug and play etc and to ask them to say which printer in a multi site environment is for sure going to be thrown back from the customer My frustration is that export and import steps change the AOT property so now you have to be sure any person doing such is having the right printer (and the right default windows printer as far as I can tell). In most reports that are just listings its not a big issue but things like cheque printing where exact printing is required then its a real pain to have to make sure the programmer does not have any printer installed on their PC before they can edit and save the object! Going forward I guess the advice is for exact printing report the dev needs to have the driver installed and set as teh default printer when doing anything with such objects... Thanks James _ From: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.commailto:development-axapta%40yahoogroups.com [mailto:development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.commailto:development-axapta%40yahoogroups.com] On Behalf Of Karsten Krabbes Sent: 18 March 2009 16:46 To: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.commailto:development-axapta%40yahoogroups.com Subject: [development-axapta] Re: Top margin changes by itself Hi James, this is not a bug, its a feature :-) You face this problem everywhere in the windows world as the margins always depends on the actual printer driver and also on the hardware !. That means you should alway develop a report with the printer driver you want to use it with. If the positions on the paper are not that important and you use different printers in your company you could just set the property 'fit to page' to yes. Another approach to solve this is to read the actual top margin from the driver and calculate all the positions in the report in run time ... br Karsten --- In development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups. mailto:axapta%40yahoogroups.com commailto:axapta%40yahoogroups.com, James Flavell djf1...@... wrote: Hi everyone Just spent most of the day with a strange problem regarding the top margin property on a design section of a report. The situation is: Client PC has no windows printers installed Using this client set the top margin to 4.2mm in an AX4.0 SP2 report Install a pritner on this client PC Log back into AX and when look at the property it is now 6.27mm and cannot be changed to be less (this change happens without any edit of the report object!!!) I am guessing that somehow AX tries to be smart and says the minimum top margin is 6.27mm Is this some kind of hard coded size? Or does AX AOT reports somehow check the default windows printer?!!! Look forward to hearing from you Thanks James [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
RE: [development-axapta] Re: Top margin changes by itself
Thanks Karsten, I would say its somewhat of a bug because yes I agree I could program the report based on knowing the printer but these days this is often not the case. Customers see printers as plug and play etc and to ask them to say which printer in a multi site environment is for sure going to be thrown back from the customer My frustration is that export and import steps change the AOT property so now you have to be sure any person doing such is having the right printer (and the right default windows printer as far as I can tell). In most reports that are just listings its not a big issue but things like cheque printing where exact printing is required then its a real pain to have to make sure the programmer does not have any printer installed on their PC before they can edit and save the object! Going forward I guess the advice is for exact printing report the dev needs to have the driver installed and set as teh default printer when doing anything with such objects... Thanks James _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Karsten Krabbes Sent: 18 March 2009 16:46 To: development-axapta@yahoogroups.com Subject: [development-axapta] Re: Top margin changes by itself Hi James, this is not a bug, its a feature :-) You face this problem everywhere in the windows world as the margins always depends on the actual printer driver and also on the hardware !. That means you should alway develop a report with the printer driver you want to use it with. If the positions on the paper are not that important and you use different printers in your company you could just set the property 'fit to page' to yes. Another approach to solve this is to read the actual top margin from the driver and calculate all the positions in the report in run time ... br Karsten --- In development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com, James Flavell djf1...@... wrote: Hi everyone Just spent most of the day with a strange problem regarding the top margin property on a design section of a report. The situation is: Client PC has no windows printers installed Using this client set the top margin to 4.2mm in an AX4.0 SP2 report Install a pritner on this client PC Log back into AX and when look at the property it is now 6.27mm and cannot be changed to be less (this change happens without any edit of the report object!!!) I am guessing that somehow AX tries to be smart and says the minimum top margin is 6.27mm Is this some kind of hard coded size? Or does AX AOT reports somehow check the default windows printer?!!! Look forward to hearing from you Thanks James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[development-axapta] Top margin changes by itself
Hi everyone Just spent most of the day with a strange problem regarding the top margin property on a design section of a report. The situation is: Client PC has no windows printers installed Using this client set the top margin to 4.2mm in an AX4.0 SP2 report Install a pritner on this client PC Log back into AX and when look at the property it is now 6.27mm and cannot be changed to be less (this change happens without any edit of the report object!!!) I am guessing that somehow AX tries to be smart and says the minimum top margin is 6.27mm Is this some kind of hard coded size? Or does AX AOT reports somehow check the default windows printer?!!! Look forward to hearing from you Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] Re: Year end closing/opening
In SQL try to sum the amount MST field for all ledgertrans for the period op/01/07 to CL/12/07 If the amount is not 0. (you get the point :) ) then I guess there is some problem with the data The problem with export/import is I believe the export or import might round the SQL data into however many decimals AX uses and so the problem is not seen this new company _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of psmpvr Sent: 27 February 2009 12:23 To: development-axapta@yahoogroups.com Subject: [development-axapta] Re: Year end closing/opening I run the consistency check in axapta. path is \Basic\Periodic\Consistency check for the type of Check and fix error I don't hav idea on how to check on SQL the fin. year closing year after year i.e for 07-08 there is no difference...i run the related reports... In the \Classes\LedgerTransferOpening\insertOpeningTrans -- method ledgertrans.insert(this is for inserting the closing year balances to next year as opening balances) ..is there but...through debug it is showing that records are inserted..but...after debugging...it is not displaying the records in the table which are showing in debug and i import the same data in other environment...it is inserting values correctlybut in live environment..it is not any one hav idea. PLs reply ASAP --- In development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com, Topár Tamás toparta...@... wrote: Hi. Off topic, sorry, I'm just interested what kind of consistency check had you run? SQL? Does it exist in AX as well? Thx T ps.: just two idea: - did you run fin. year closing year after year? in 3.0 you have to. - have you checked if there is a real difference? --- On Thu, 2/26/09, psmpvr subbu.man...@... wrote: From: psmpvr subbu.man...@... Subject: [development-axapta] Re: Year end closing/opening To: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com Date: Thursday, February 26, 2009, 9:51 AM I run that consistency check for both check fix-error there is no errors.. I didn't import any any ledgertrans or ledgerbalance records the user made some necessary adjustment transactions in legertaccounts. Pls tell me ant remedy is ther? Thanks regards, Subbu --- In development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com, James Flavell djf1994@ wrote: Use the consistency check on the Ledger module Did you import any ledgertrans or ledgerbalance records? Maybe there was some amounts not rounding correctly? Also have you run the currency conversion script on your AX? Not sure if vaguely I remember similiar issue appeared due to that James _ From: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com [mailto:development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com] On Behalf Of psmpvr Sent: 24 February 2009 21:22 To: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com Subject: [development-axapta] Year end closing/opening I am trying to perform Fiscal Year End Opening transactions and got the following error: Total of the transactions in the year is not 0.00. Total is 9,924,189.00. This is a serious error. Run \Check\ on ledger transactions. For this what can i do... didi any one had know abt this error [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [development-axapta] Year end closing/opening
Use the consistency check on the Ledger module Did you import any ledgertrans or ledgerbalance records? Maybe there was some amounts not rounding correctly? Also have you run the currency conversion script on your AX? Not sure if vaguely I remember similiar issue appeared due to that James _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of psmpvr Sent: 24 February 2009 21:22 To: development-axapta@yahoogroups.com Subject: [development-axapta] Year end closing/opening I am trying to perform Fiscal Year End Opening transactions and got the following error: Total of the transactions in the year is not 0.00. Total is 9,924,189.00. This is a serious error. Run \Check\ on ledger transactions. For this what can i do... didi any one had know abt this error [Non-text portions of this message have been removed]
RE: [development-axapta] printing AX Financial Statement in Secondary Currency
Yes in the FS column setup one of the column types is 'Secondary amount' or something like that. That will give you the amounts from the secondary currency _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Patricia Pua Sent: 05 February 2009 10:32 To: development-axapta@yahoogroups.com Subject: [development-axapta] printing AX Financial Statement in Secondary Currency Hello All, May I know if there is any possibility to print AX Financial Statement base on the Secondary Currency? For example if we have a Europe Entity, and our Base Currency is EURO dollars and we also setup the Secondary Currency as USD. At this moment we can only print the AX Financial Statement base on EURO (ie base currency), any of you know if it is possible to print the same report base on Secondary Currency setup in Basic Company Other Tab? Thanks New Email addresses available on Yahoo! Get the Email name you#39;ve always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail. http://mail.promotions.yahoo.com/newdomains/sg/ promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [development-axapta] Matching of Reports from AX and Excel.
What version of AX are you running...I vaguely recall there was some bug in the trial balance report in AX4.0 (although I would have expected the AX result to show such a bug) so maybe check in the KB _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Abhay Sent: 02 February 2009 18:24 To: development-axapta@yahoogroups.com Subject: [development-axapta] Matching of Reports from AX and Excel. Dear All. I was trying to export from AX to Excel using html. I exported the trial balance from GL- reports- transations- Periodic- Trial Balance using html. When I opened the file with open with excel and am taking the totals of Debit and credit columns that are exported to excel there is a difference in the TB. But the same TB is matching in AX. Also the total of Net difference column in Exported Excel has to be zero as all debit and credit are considered but it does not show so. Please can anybody help me for the same it is and urgent requirement.Regards Abhay [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [development-axapta] Receiving items from purchase order in x++
Sorry not stopped to read your code but can't you use the status
'Registered' (PO line / Functions / Register) and then just do Delivery note
posting based on Registered?
_
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Shabbir Ahsan
Sent: 25 November 2008 23:58
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Receiving items from purchase order in x++
Hi,
I want to be able to receive items on a PO, but process one by one,
rather than one go as is the option within AX. I want to be able to
update the status of the line to received and then when all items are
received run a function to post the entire PO.
The current code I am using to process each line is:
PurchTable purchTable;
PurchLine purchLine;
TransDate transDate;
;
transDate = SystemDateGet();
try
{
ttsbegin;
purchTable = PurchTable::find(myPOId);
select forupdate purchLine where purchLine.PurchId == myPOId
purchLine.ItemId == myItem purchLine.LineNum == mynum;
purchLine.PurchReceivedNow = RecQty;
purchLine.RemainPurchPhysical = (purchLine.RemainPurchPhysical -
RecQty);
purchLine.setInventReceivedNow();
if (purchLine.RemainPurchPhysical == 0)
{
purchLine.setPurchStatus();
}
purchLine.update(true);
ttscommit;
}
catch (Exception::Error)
{
return got an error;
}
return processed;
}
With the above code, it sets the status as cancelled. Do I have to
calculate and set the REmainPurchFinancial value as well in order for
it to give the correct status. Is there not a function that can
receive an item and calculate this automatically?
After all the status of items is set to received (ie all items have
matching quantity to that ordered) I will post the PO using the
following code - I don't think there will be a problem here:
purchformletter =
purchformletter::construct(DocumentStatus::PackingSlip,true);
purchtable.clear();
purchtable = purchtable::find(myPOId);
purchformletter.update(purchtable,myDelNo,systemDateGet(),purchUpdate:
:All,AccountOrder::None,
NoYes::No,
NoYes::Yes);
Some help on this would be much appreciated.
[Non-text portions of this message have been removed]
[development-axapta] XML file parsing
Hi everyone, I am needing to kick start some investigation into reading in an XML file to AX can anyone direct me to code or any web site with useful information. I understand XML and the schema etc but wondering is there any parsing engine and examples to get me started in AX? Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] Serious Recid problems
Thanks David I am not 100% sure as the programmer did the upgrade but for now I would have to assume yes it was done (I will check) If they did not run this job do you know the effect? Does this process just change the field type into Int64? or does some renumbering of recid? The SQL type is Int64 in the database Thanks James _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of david santoso Sent: 24 August 2008 17:24 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Serious Recid problems Hi James, Did you notice that when you upgrade from ax 3.0 SP4 into ax 4.0, you have to run the upgrade column list 9 the purpose to change the recid into int64. My company has upgrade from 2.5 - 3.0 SP 6 - 4.0 SP2 for 1 month, and has run the posting confirm smoothly. Cheers, David S On Fri, Aug 22, 2008 at 5:18 PM, James Flavell [EMAIL PROTECTED] mailto:djf1994%40gmail.com com wrote: Hi everyone, somethign interesting to share and praying someone might have some ideas of how to fix or investigate further: In the SalesTable form in the active method for Salestable datasource there is code that checks whether the Functions button on the header should be enabled. We have the situation that this code returns False even though there is a RecId for some salestables. We found the KB 930416 which mentions about similar problem but we have the required hotfix/build and are still getting a problem. What we noticed was if we convert salestable.recid to a boolean first and then test this it is okay but not if we just do enabled(salestable.recid) This does not work: buttonHeaderFunction.enabled (salesTable.RecId); -change boolean This works (htktestbol is of type boolean): htktestbol = (salestable.recid); buttonHeaderFunction.enabled (htktestbol); The salestable record having the problem is having a recid value that is a BigInt (i.e. the recid is too large to fit in an Int) We have one more problem that has also appeared and that is for certain inserts such as posting of order confirmation we get an SQL error (see below) we are wondering is this also due to the recid not testing as true!? SQL error: Cannot create a record in Confirmation journal (CustConfirmJour). Order Confirmation: , 20016. The SQL database has issued an error. operation cancelled An error occurred durign update This error can happen on various tables not just Confirmation journal. We tested and found the following results. If we do an AX def export of the company and then imported into a new company: 1) if we import in to the same SQL database but just a new company the problem still happens in the new company 2) if we import into a clean SQL database there is no problem To us this suggest some issue with RecId (and maybe SystemSequence table or something that is shared across all companies?) Note this is an Ax3.0 SP4 upgraded to Ax4.0 Thanks James [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]
[development-axapta] RE: Invalid date foramt SQL error
Okay i found the solution by rearranging the code as follows:
while select priceDiscGroup
where
priceDiscGroup.Module == ModuleInventCustVend::Cust
priceDiscGroup.Type == PriceGroupType::PriceGroup
(crtDateFrom = priceDiscGroup.FromDate ||
priceDiscGroup.FromDate == datenull())
(crtDateTo = priceDiscGroup.ToDate ||
priceDiscGroup.ToDate == datenull())
join promoPriceGroup where
priceDiscGroup.groupId == promoPriceGroup.CustPriceGroup
promoPriceGroup.CustAccount==invoiceAccount
join priceDiscTable where
promoPriceGroup.CustPriceGroup==priceDiscTable.AccountRelation
priceDiscTable.Module==ModuleInventCustVend::Cust
priceDiscTable.AccountCode==TableGroupAll::GroupId
priceDiscTable.ItemCode==TableGroupAll::Table
priceDiscTable.ItemRelation==this.ItemId
(crtDateFrom = priceDiscTable.FromDate ||
priceDiscTable.FromDate==DateNull())
(crtDateTo = priceDiscTable.ToDate ||
priceDiscTable.ToDate==DateNull())
priceDiscTable.Currency==this.CurrencyCode
Thanks for listening
James
_
From: James Flavell [mailto:[EMAIL PROTECTED]
Sent: 12 August 2008 14:51
To: 'development-axapta@yahoogroups.com'
Subject: Invalid date foramt SQL error
Hi everyone,
I think I remember someone posted before some problem in std AX (Ax3.0)
about when you have a join statement. I have the following code which gives
an SQL error:
static void Job19(Args _args)
{
PriceDiscGroup priceDiscGroup;
PromoPriceGroup promoPriceGroup;
FromDate crtDateFrom = systemdateget();
ToDate crtDateTo = crtDateFrom;
;
while select priceDiscGroup
join promoPriceGroup
where (crtDateFrom = priceDiscGroup.FromDate ||
priceDiscGroup.FromDate == datenull())
(crtDateTo = priceDiscGroup.ToDate ||
priceDiscGroup.ToDate == datenull())
priceDiscGroup.Module == ModuleInventCustVend::Cust
priceDiscGroup.Type == PriceGroupType::PriceGroup
priceDiscGroup.groupId == promoPriceGroup.CustPriceGroup
{
print pricediscgroup.GroupId;
pause;
}
}
SQL error given:
Error Message (13:49:46) Cannot select a record in Price groups
(PriceDiscGroup). Price groups: , .
The SQL database has issued an error.
Info Message (13:49:46) SQL error description: [Microsoft][ODBC SQL Server
Driver]Invalid date format
Info Message (13:49:46) SQL statement: SELECT
A.MODULE,A.TYPE,A.GROUPID,A.NAME,A.INCLTAX,A.TODATE,A.FROMDATE,A.PROMOTION,A
.MODIFIEDDATE,A.MODIFIEDTIME,A.MODIFIEDBY,A.CREATEDDATE,A.CREATEDTIME,A.CREA
TEDBY,A.RECID,B.CUSTACCOUNT,B.TODATE,B.FROMDATE,B.CUSTPRICEGROUP,B.MODIFIEDD
ATE,B.MODIFIEDTIME,B.MODIFIEDBY,B.CREATEDDATE,B.CREATEDTIME,B.CREATEDBY,B.RE
CID FROM PRICEDISCGROUP A(NOLOCK) ,CITPROMOPRICEGROUP B(NOLOCK) WHERE
(A.DATAAREAID=?) AND ((B.DATAAREAID=?) AND ((?=A.FROMDATE) OR
(A.FROMDATE=?)) AND ((?=A.TODATE) OR (A.TODATE=?))) AND (A.MODULE=?)) AND
(A.TYPE=?)) AND (A.GROUPID=B.CUSTPRICEGROUP))) OPTION(FAST 83)
If just do the code to search on the one table priceDiscGroup then it works
fine!
I hope someone can help me understand (is it something about I cannot have
multiple conditions or use variables on a field from a joined table??? or
maybe I am doing somethign completely wrong in my join???)
Thanks
James
[Non-text portions of this message have been removed]
[development-axapta] Passing batch number during master planning
Hi everyone, I would like to do modification so that the batch number from a sales order flows all the way through master planning so that my firmed purchase order will have the batch number. I know there is marking but this is not visible enough to the user so I would like to look at using batch number. Can any one direct me to where in the code I can look to be passing the batch number on to the next ReqTrans being created in the planning etc? Of course if anyone has any other ides how to address the problem please feel free to share Thanks James [Non-text portions of this message have been removed]
[development-axapta] Watermark in AX reports
Hi everyone, Is it possible (and if so how easy) to print watermarks on AX reports or should I tell the user that is just something they should setup on their printer outside of AX? Thanks James [Non-text portions of this message have been removed]
[development-axapta] PDF with embedded font does not work
Hi I am trying to print using AX's PDF with embedded font option but it seems once the file is generated and I open the file on a different PC (where the special fonts are not installed) then the font is not shown correctly I thought embedded font means whatever fonts I use in the document will also be kept in the document I am correct in my understanding of what embedded font means or did I misunderstand something? This is AX4.0 SP2 Thanks James [Non-text portions of this message have been removed]
[development-axapta] Problem with Int64 and SET
Can anyone help me to fix a problem in AX4.0 realted to Int64 and SETs I have some code that does the following: SET xyz; SalesLine salines; ; if (!xyz.add(saleslinerecid)) It gives an error that it was expecting an int and not an Int64 I understand the RecId is now Int64 but do not know how to get a SET object to accept it... Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] Re: Consumption account error in credit note on Purchase Order
This is because your return cost is different to the calculated cost value on the PO credit note...so the system needs to post the difference to somewhere. WHy the difference you may ask? Usually due to if your PO is in foriegn currency then the rate ahs changed since the original invocie OR the cost the system comes up with for the return is different to the original (picked up different lotid than the original) Just set dimensions on your PO so it can post and the result should show you what has happened James _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of José Quintero Sent: Thursday, May 01, 2008 12:12 AM To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Re: Consumption account error in credit note on Purchase Order Hi!: I have the account. Occurs that this account needs Customer Dim. We only want to make credit note in Purchase order and reversing original voucher (original voucher only has two accounts). The orginal Order does not has consumption account Any ideas?. prasanna_koulgi prasanna_koulgi@ mailto:prasanna_koulgi%40yahoo.co.in yahoo.co.in wrote: Just give consumption account in the Item Group -- Posting -- PO -- consumption account PRASANA --- In development- mailto:development-axapta%40yahoogroups.com [EMAIL PROTECTED], jquinteroz [EMAIL PROTECTED] wrote: Hi!: When we want to post a credit note in purchase order, we receive a message that Customer Dim must be specified for account consumption account. How I can solve that?. - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[development-axapta] Serial numbering only for sales
Hi everyone, Can anyone suggest an add on solution or modifcation for serial number tracking only at customer side? Basically I want to track the serial numbers issued to a customer and returned from a customer (warranty tracking). The basics are to just record the serial numbers (auto generated number is acceptable) when selling the items and then when they are returned to be able to select serial number already issued to the customer I guess such requirement is fairly common so wondering whether anyone has done already or knows of existing solution? Thanks James [Non-text portions of this message have been removed]
[development-axapta] Security rights for 'local' buttons
Hi everyone, Has anyone had problems with exporting and importing security permissions (v3.0 or V4.0) It seems when a form has waht I call a 'local' button which is a button that executes code in the 'clicked' trigger rather than pointing to a MenuItem object, then when I export the permissions into a ASG file the permissions I set on such 'local' buttons are not included in the ASG file because when I import the ASG into a new system and empty user group the permissions for this button are not set Can anyone confirm this is a known problem and is there any solution? Thanks James [Non-text portions of this message have been removed]
[development-axapta] AX 2.1 SP3 install anyone?
Anyone have the SP3 install for Ax 2.1 or where I can get it urgently? Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] Who locks the table?
The online users screen shows I think _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of jquinteroz Sent: Wednesday, January 23, 2008 9:56 AM To: development-axapta@yahoogroups.com Subject: [development-axapta] Who locks the table? Hi: We recently had had some issues with record blocking (lock). We can see the SPID of locked tables...but how we can know which user is doing that (locking the table). Regards. [Non-text portions of this message have been removed]
RE: [development-axapta] Re: Cluster indexes yes or no?
Thanks I have read up this web site as well as others and understand cluster indexes but I guess my concern is has std AX table objects been setup with good cluster indexes? I guess I can look at the main volume tables such as inventtrans etc but I was just wondering if anyone had any feedback on their experience in this area of AX (i.e. should I be trusting MS on what they have done...usually the answer to this is no) Thanks James James Flavell CITP Singapore Pte Ltd Mobile: +65 97582281 Email: [EMAIL PROTECTED] _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Max Belugin Sent: Wednesday, January 16, 2008 9:03 PM To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Re: Clsiter indexes yes or no? Have you reade this http://msdn2. http://msdn2.microsoft.com/en-us/library/aa623224.aspx microsoft.com/en-us/library/aa623224.aspx On 1/14/08, gollywogman brandon.boman@ mailto:brandon.boman%40isoft-tech.co.za isoft-tech.co.za wrote: Hi there As far as I know, (I could be mistaken) the best thing to do is to have a cluster index only if a table has one index, otherwise a table shouldn't have a cluster index. --- In development- mailto:development-axapta%40yahoogroups.com [EMAIL PROTECTED], James Flavell [EMAIL PROTECTED] wrote: Should be disable cluster indexes or not in Ax4.0? I know the pros and cons but my impression is for AX at least we should turn them of until someone in MS takes a good look and think slong and hard about which index is the best as a clsuter index. Anyone agree/disagree? Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Links -- Max Belugin, http://belugin. http://belugin.info info , ICQ:9406811, MSN: [EMAIL PROTECTED] mailto:belugin%40mail.ru ru [Non-text portions of this message have been removed]
[development-axapta] Items that cannot be closed
Hi does anyone have any ideas why the following item cannot be closed in AX 4.0 SP1. Pasted below is the ValueOpen=Yes transactions (can cut and paste the text into excel I believe to get nicely formated). No dimensions are ticked for financial inventory and warehouse is ticked as physical To me there is enough Qty that can be settled I am thinking maybe AX does some kind of rounding in the closing such that there is 0.01 short of qty and so it decides cannot close. I am little concerned that the SQL data is not rounded on the QtySettled field (I assume thsi is the filed AX uses during closing to work out the open qty of a transaction) Or maybe it is something to do with a Transfer being the last transaction? Thanks James Warehouse Physical date Financial date Reference Receipt Issue QuantityAX Settled quantity AX OpenQty SQL QtySettled SQLOpenQty 43701 10/9/2007 10/9/2007 TransferPurchased 1 0.930.070.93330 0.06670 415610/10/2007 10/10/2007 TransferPurchased 1 0.750.250.75000 0.25000 45201 11/7/2007 11/7/2007 Sales order Purchased 1 0.830.170.83340 0.16660 45201 11/7/2007 11/7/2007 Sales order Purchased 1 0.5 0.500.5 0.5 45201 11/7/2007 11/7/2007 TransferSold-2 45211 11/7/2007 11/7/2007 TransferPurchased 2 0.981.020.98330 1.01670 4 3.992.01 4.0 2.0
RE: [development-axapta] Bad response time on the CUSTINVOICEJOUR form
Hi Paul any news on any progress for this? We just found the problem came back for us so i dont think its a compile problem. I think for us because we created a new index SQL had cached data so when we deleted the index it was still okay due to the cached data being there but now after a while the cached data is not there so its back to being a problem. So for now we have created a new index (just on invoicedate of custinvoicejour) and things are working okay One thing I was wondering and might be worth testing is does the probem exist on the customer / inquiries? Just wondering about the sort order in the SQL statement is InvoiceAccount. In theory SQL should handle this no problem I think but maybe somethign to check Also what about the Find First Fast option? This maybe causes/forces the SQL to start on CustInvoiceJour...maybe try turnign it off and see if any immedaite change Thanks James _ From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 4:06 PM To: 'development-axapta@yahoogroups.com' Subject: RE: [development-axapta] Bad response time on the CUSTINVOICEJOUR form Snap!!! Same probem here We have the same kind of number of records in the tables (FYI we have about 5 diff AX companies...do you have multi companies, not sure this has anything to do with the problem?) Also we found users who killed there AX session (thinking it was not responding) it actaully left the process in the SQL and it would not stop and took 100%!!! Look in your event viewer for things like AOS saying SPID xxx should be killed (i.e. AOS cannot kill it and you have to go into SQL yourself to do) We seemed to have fixed (just like 5 mins ago) for now but not sure, these are the steps we did for your info: 1) We added an index with invoicedate to custinvoicejour 2) Opened the form again and this time data appeared fine 3) We deleted the index and still the form is fine (this might be SQL caching of some kind I am not sure) Maybe you can first just test a compile of the form and then a full compile Still problem: Check in SQL do indexes exist on this table? (wondering if somehow the AOT indexes did not get to SQL) Do a sync from AOT for this table If these do not work then try creating an index on this table Anyone else having this problem? We thought it might be a AX system file corruption as we had some server problems a while back but it seems maybe it is more of a Standard AX problem since someone else has the problem Also I suggest you try putting the SQL statement in the SQL profiler to see what query path the SQL plans to use (maybe before you try any of the fixes) Looking forward to hearing from you Thanks James _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pkpeterson652 Sent: Wednesday, January 09, 2008 8:32 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Bad response time on the CUSTINVOICEJOUR form I have a response time problem with the CUSTINVOICEJOUR form. Accounts receivable \ Sales Orders \ Inquiries \ Invoices This form only has some minor modifications to it and when the mods are removed the same results are given. We are running Dynamics AX 4.0 at SP1, SQL Server 2005, and one AOS. The first time this option is selected it takes anywhere from 1 1/2 to 2 1/2 minutes to come up. Once the form has been opened up this form will come up in 1 to 2 seconds. I understand this because the necessary infomation is probably in the cache for the subsequent queries. I have run SQL trace and have isolated the offending query. I have taken the SQL statement shown in the SQL Trace log into the Database Engine tuning advisor, built and updated the recommended Statistics and built the recommend indexes. There are 166,506 records in the CUSINVOICEJOUR table across all companies and 108,388 records in the CUSTINOICESALESLINK table accross all companies. Any suggestions of what I should look at next? SQL Statement is as follows: SELECT A.CUSTGROUP,A.REFNUM,A.SALESID,A.ORDERACCOUNT,A.INVOICEACCOUNT, A.INVOICEDATE,A.DUEDATE,A.CASHDISC,A.CASHDISCDATE,A.QTY,A.VOLUME, A.WEIGHT,A.SUMLINEDISC,A.SALESBALANCE,A.ENDDISC,A.INVOICEAMOUNT, A.CURRENCYCODE,A.EXCHRATE,A.SALESADMINISTRATOR,A.INVOICEID,A.LEDGERVOU CHER,A.UPDATED,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_, A.ONACCOUNTAMOUNT,A.TAXPRINTONINVOICE,A.LISTCODE,A.DEL_PRINTED, A.DOCUMENTNUM,A.DOCUMENTDATE,A.INTRASTATDISPATCH,A.DELIVERYNAME, A.DELIVERYADDRESS,A.PURCHASEORDER,A.DLVTERM,A.DLVMODE,A.PAYMENT, A.CASHDISCCODE,A.INVOICEROUNDOFF,A.SUMMARKUP,A.COVSTATUS, A.RETURNITEMNUM,A.POSTINGPROFILE,A.BACKORDER,A.PREPAYMENT, A.DLVZIPCODE,A.DLVCOUNTY,A.DLVCOUNTRYREGIONID,A.DLVSTATE,A.TAXGROUP, A.TAXITEMGROUP,A.DEL_TAXSPECIFYTOTAL,A.TAXSPECIFYBYLINE, A.EINVOICELINESPECIFIC,A.DEL_CORRECTEDINVOICEID,A.ONETIMECUSTOMER, A.PAYMENTSCHED,A.SUMTAX,A.SALESTYPE,A.EINVOICEACCOUNTCODE,A.PARMID,A.E USALESLIST,A.EXCHRATESECONDARY,A.TRIANGULATION
RE: [development-axapta] Bad response time on the CUSTINVOICEJOUR form
Snap!!! Same probem here We have the same kind of number of records in the tables (FYI we have about 5 diff AX companies...do you have multi companies, not sure this has anything to do with the problem?) Also we found users who killed there AX session (thinking it was not responding) it actaully left the process in the SQL and it would not stop and took 100%!!! Look in your event viewer for things like AOS saying SPID xxx should be killed (i.e. AOS cannot kill it and you have to go into SQL yourself to do) We seemed to have fixed (just like 5 mins ago) for now but not sure, these are the steps we did for your info: 1) We added an index with invoicedate to custinvoicejour 2) Opened the form again and this time data appeared fine 3) We deleted the index and still the form is fine (this might be SQL caching of some kind I am not sure) Maybe you can first just test a compile of the form and then a full compile Still problem: Check in SQL do indexes exist on this table? (wondering if somehow the AOT indexes did not get to SQL) Do a sync from AOT for this table If these do not work then try creating an index on this table Anyone else having this problem? We thought it might be a AX system file corruption as we had some server problems a while back but it seems maybe it is more of a Standard AX problem since someone else has the problem Also I suggest you try putting the SQL statement in the SQL profiler to see what query path the SQL plans to use (maybe before you try any of the fixes) Looking forward to hearing from you Thanks James _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pkpeterson652 Sent: Wednesday, January 09, 2008 8:32 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Bad response time on the CUSTINVOICEJOUR form I have a response time problem with the CUSTINVOICEJOUR form. Accounts receivable \ Sales Orders \ Inquiries \ Invoices This form only has some minor modifications to it and when the mods are removed the same results are given. We are running Dynamics AX 4.0 at SP1, SQL Server 2005, and one AOS. The first time this option is selected it takes anywhere from 1 1/2 to 2 1/2 minutes to come up. Once the form has been opened up this form will come up in 1 to 2 seconds. I understand this because the necessary infomation is probably in the cache for the subsequent queries. I have run SQL trace and have isolated the offending query. I have taken the SQL statement shown in the SQL Trace log into the Database Engine tuning advisor, built and updated the recommended Statistics and built the recommend indexes. There are 166,506 records in the CUSINVOICEJOUR table across all companies and 108,388 records in the CUSTINOICESALESLINK table accross all companies. Any suggestions of what I should look at next? SQL Statement is as follows: SELECT A.CUSTGROUP,A.REFNUM,A.SALESID,A.ORDERACCOUNT,A.INVOICEACCOUNT, A.INVOICEDATE,A.DUEDATE,A.CASHDISC,A.CASHDISCDATE,A.QTY,A.VOLUME, A.WEIGHT,A.SUMLINEDISC,A.SALESBALANCE,A.ENDDISC,A.INVOICEAMOUNT, A.CURRENCYCODE,A.EXCHRATE,A.SALESADMINISTRATOR,A.INVOICEID,A.LEDGERVOU CHER,A.UPDATED,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_, A.ONACCOUNTAMOUNT,A.TAXPRINTONINVOICE,A.LISTCODE,A.DEL_PRINTED, A.DOCUMENTNUM,A.DOCUMENTDATE,A.INTRASTATDISPATCH,A.DELIVERYNAME, A.DELIVERYADDRESS,A.PURCHASEORDER,A.DLVTERM,A.DLVMODE,A.PAYMENT, A.CASHDISCCODE,A.INVOICEROUNDOFF,A.SUMMARKUP,A.COVSTATUS, A.RETURNITEMNUM,A.POSTINGPROFILE,A.BACKORDER,A.PREPAYMENT, A.DLVZIPCODE,A.DLVCOUNTY,A.DLVCOUNTRYREGIONID,A.DLVSTATE,A.TAXGROUP, A.TAXITEMGROUP,A.DEL_TAXSPECIFYTOTAL,A.TAXSPECIFYBYLINE, A.EINVOICELINESPECIFIC,A.DEL_CORRECTEDINVOICEID,A.ONETIMECUSTOMER, A.PAYMENTSCHED,A.SUMTAX,A.SALESTYPE,A.EINVOICEACCOUNTCODE,A.PARMID,A.E USALESLIST,A.EXCHRATESECONDARY,A.TRIANGULATION,A.CUSTOMERREF, A.VATNUM,A.NUMBERSEQUENCEGROUP,A.LANGUAGEID,A.INCLTAX,A.LOG, A.PAYMDAYID,A.INVOICINGNAME,A.INVOICINGADDRESS,A.INVZIPCODE, A.INVCOUNTY,A.INVCOUNTRYREGIONID,A.INVSTATE,A.GIROTYPE, A.CONTACTPERSONID,A.SALESORIGINID,A.BILLOFLADINGID,A.INVENTLOCATIONID, A.FIXEDDUEDATE,A.DELIVERYCITY,A.DELIVERYSTREET,A.INVOICECITY, A.INVOICESTREET,A.PRINTORIGINALS,A.PRINTCOPIES,A.INVOICEAMOUNTMST, A.INVOICEROUNDOFFMST,A.SUMMARKUPMST,A.SUMLINEDISCMST,A.ENDDISCMST, A.SALESBALANCEMST,A.SUMTAXMST,A.DEL_REFDLVZIPCODE,A.DEL_REFINVZIPCODE, A.INTERCOMPANYCOMPANYID,A.INTERCOMPANYPURCHID,A.PROFORMA, A.MILCHECKNUM,A.MILPAYMENTMETHOD,A.MILPAYMENTAMOUNT,A.CREATEDDATE, A.CREATEDTIME,A.CREATEDBY,A.RECVERSION,A.RECID, B.INVOICEID,B.INVOICEDATE,B.SALESID,B.ORIGSALESID,B.INVOICEACCOUNT, B.ORDERACCOUNT,B.DELIVERYNAME,B.DELIVERYADDRESS,B.PARMID, B.INVOICINGADDRESS,B.INVOICINGNAME,B.PURCHASEORDER,B.CUSTOMERREF, B.RECVERSION,B.RECID,A.DEL_CORRECTIVEREASON FROM CUSTINVOICEJOUR A,CUSTINVOICESALESLINK B WHERE ((A.DATAAREAID='100') AND (A.REFNUM=0)) AND ((B.DATAAREAID='100') AND A.SALESID=B.SALESID) AND (A.INVOICEID=B.INVOICEID)) AND
FW: [development-axapta] Bad response time on the CUSTINVOICEJOUR form
Sorry if this already got through to the group...I realised i think i sent it with the wrong email the first time so it wont get through _ From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 12:06 PM To: 'development-axapta@yahoogroups.com' Subject: RE: [development-axapta] Bad response time on the CUSTINVOICEJOUR form Snap!!! Same probem here We have the same kind of number of records in the tables (FYI we have about 5 diff AX companies...do you have multi companies, not sure this has anything to do with the problem?) Also we found users who killed there AX session (thinking it was not responding) it actaully left the process in the SQL and it would not stop and took 100%!!! Look in your event viewer for things like AOS saying SPID xxx should be killed (i.e. AOS cannot kill it and you have to go into SQL yourself to do) We seemed to have fixed (just like 5 mins ago) for now but not sure, these are the steps we did for your info: 1) We added an index with invoicedate to custinvoicejour 2) Opened the form again and this time data appeared fine 3) We deleted the index and still the form is fine (this might be SQL caching of some kind I am not sure) Maybe you can first just test a compile of the form and then a full compile Still problem: Check in SQL do indexes exist on this table? (wondering if somehow the AOT indexes did not get to SQL) Do a sync from AOT for this table If these do not work then try creating an index on this table Anyone else having this problem? We thought it might be a AX system file corruption as we had some server problems a while back but it seems maybe it is more of a Standard AX problem since someone else has the problem Also I suggest you try putting the SQL statement in the SQL profiler to see what query path the SQL plans to use (maybe before you try any of the fixes) Looking forward to hearing from you Thanks James _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pkpeterson652 Sent: Wednesday, January 09, 2008 8:32 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Bad response time on the CUSTINVOICEJOUR form I have a response time problem with the CUSTINVOICEJOUR form. Accounts receivable \ Sales Orders \ Inquiries \ Invoices This form only has some minor modifications to it and when the mods are removed the same results are given. We are running Dynamics AX 4.0 at SP1, SQL Server 2005, and one AOS. The first time this option is selected it takes anywhere from 1 1/2 to 2 1/2 minutes to come up. Once the form has been opened up this form will come up in 1 to 2 seconds. I understand this because the necessary infomation is probably in the cache for the subsequent queries. I have run SQL trace and have isolated the offending query. I have taken the SQL statement shown in the SQL Trace log into the Database Engine tuning advisor, built and updated the recommended Statistics and built the recommend indexes. There are 166,506 records in the CUSINVOICEJOUR table across all companies and 108,388 records in the CUSTINOICESALESLINK table accross all companies. Any suggestions of what I should look at next? SQL Statement is as follows: SELECT A.CUSTGROUP,A.REFNUM,A.SALESID,A.ORDERACCOUNT,A.INVOICEACCOUNT, A.INVOICEDATE,A.DUEDATE,A.CASHDISC,A.CASHDISCDATE,A.QTY,A.VOLUME, A.WEIGHT,A.SUMLINEDISC,A.SALESBALANCE,A.ENDDISC,A.INVOICEAMOUNT, A.CURRENCYCODE,A.EXCHRATE,A.SALESADMINISTRATOR,A.INVOICEID,A.LEDGERVOU CHER,A.UPDATED,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_, A.ONACCOUNTAMOUNT,A.TAXPRINTONINVOICE,A.LISTCODE,A.DEL_PRINTED, A.DOCUMENTNUM,A.DOCUMENTDATE,A.INTRASTATDISPATCH,A.DELIVERYNAME, A.DELIVERYADDRESS,A.PURCHASEORDER,A.DLVTERM,A.DLVMODE,A.PAYMENT, A.CASHDISCCODE,A.INVOICEROUNDOFF,A.SUMMARKUP,A.COVSTATUS, A.RETURNITEMNUM,A.POSTINGPROFILE,A.BACKORDER,A.PREPAYMENT, A.DLVZIPCODE,A.DLVCOUNTY,A.DLVCOUNTRYREGIONID,A.DLVSTATE,A.TAXGROUP, A.TAXITEMGROUP,A.DEL_TAXSPECIFYTOTAL,A.TAXSPECIFYBYLINE, A.EINVOICELINESPECIFIC,A.DEL_CORRECTEDINVOICEID,A.ONETIMECUSTOMER, A.PAYMENTSCHED,A.SUMTAX,A.SALESTYPE,A.EINVOICEACCOUNTCODE,A.PARMID,A.E USALESLIST,A.EXCHRATESECONDARY,A.TRIANGULATION,A.CUSTOMERREF, A.VATNUM,A.NUMBERSEQUENCEGROUP,A.LANGUAGEID,A.INCLTAX,A.LOG, A.PAYMDAYID,A.INVOICINGNAME,A.INVOICINGADDRESS,A.INVZIPCODE, A.INVCOUNTY,A.INVCOUNTRYREGIONID,A.INVSTATE,A.GIROTYPE, A.CONTACTPERSONID,A.SALESORIGINID,A.BILLOFLADINGID,A.INVENTLOCATIONID, A.FIXEDDUEDATE,A.DELIVERYCITY,A.DELIVERYSTREET,A.INVOICECITY, A.INVOICESTREET,A.PRINTORIGINALS,A.PRINTCOPIES,A.INVOICEAMOUNTMST, A.INVOICEROUNDOFFMST,A.SUMMARKUPMST,A.SUMLINEDISCMST,A.ENDDISCMST, A.SALESBALANCEMST,A.SUMTAXMST,A.DEL_REFDLVZIPCODE,A.DEL_REFINVZIPCODE, A.INTERCOMPANYCOMPANYID,A.INTERCOMPANYPURCHID,A.PROFORMA, A.MILCHECKNUM,A.MILPAYMENTMETHOD,A.MILPAYMENTAMOUNT,A.CREATEDDATE, A.CREATEDTIME,A.CREATEDBY,A.RECVERSION,A.RECID, B.INVOICEID,B.INVOICEDATE,B.SALESID,B.ORIGSALESID,B.INVOICEACCOUNT
[development-axapta] Clsiter indexes yes or no?
Should be disable cluster indexes or not in Ax4.0? I know the pros and cons but my impression is for AX at least we should turn them of until someone in MS takes a good look and think slong and hard about which index is the best as a clsuter index. Anyone agree/disagree? Thanks James [Non-text portions of this message have been removed]
[development-axapta] Only 1 page header in a text file please
Hi everyone, I am sure this has been a common headache for many of you... How to fix Ax4.0 SP1 to be like Ax3.0 whereby printing direct to text file causes only 1 page header to be put inside the file? Thanks James [Non-text portions of this message have been removed]
[development-axapta] 4 decimals for amounts
Has anyone changed or tried to change AX to allow 4 decimals in amount fields (base or currency amoutns)? I would appreciate if you could share your expereince with such a modifcation Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] Dimensions hierarchy - filtering
I think the ledger parameter needs to be 'posting and entry' _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of gabryelczyk Sent: 11 December 2007 19:52 To: development-axapta@yahoogroups.com Subject: [development-axapta] Dimensions hierarchy - filtering Hi all, I have set dimensions hierarchy Deoartment-Centre. It means that for specified Department only specified Centres are acceptable. In ledger parameters field Acivate stes I have set for 'At update and posting'. In hierarchy rules I have connected this hierarchy to specified ledger accounts. When I use this account in ledger journa, when I choose Department i Centre field I see all Centres. I thought I should see only Centres connected to specified Department. When I check journal, the system checks connection Departnet-Centre correctly. What to do see on the Centre list only centres connected with choosen department ? Thanks in advance Pawel Gabryelczyk [Non-text portions of this message have been removed]
[development-axapta] Contact person Go To Main table
Hi everyone I have added an extra contact person field on the sales table and have overridden the lookup() to provide a list of contacts from the INVOICE ACCOUNT. The problem is the Go to main table does not work on this new field. I have overriden the jumpref() to set the args.enum to YES in the jumpref() to indicate it is a Go to main table but the contact person records shown are those of the salestable.orderaccount After some checking I found that there is a table relation on cotnactperson that sales contactperson.custaccount == salestable.orderaccount From what my testing has found this relation puts a 'silent' filter or join into the contact person query when the form is called as a Go to main Is there: 1) a way to change this (I played with the executequery() in contact person but could not get anything to work) 2) how/where do I store in args the calling field (because i ahve 2 fields) so I can work out where the contactperson was called from Right now I removed the jumpref() on the field and this half works...it gets the right record but the problem is it shows ALL contactperson records where as I only want to show the contactperson records having custaccount == slaestable.invoiceaccount Lok forward to hearing possible solutions Thanks James [Non-text portions of this message have been removed]
RE: [development-axapta] Re: select first only
Thanks everyone...
I tried a join but in my testing it made my method of creating journals of
300 lines 5 seconds slower per journal so i guess in this case a join might
not be the best
But thanks for all your advice it is great to be able to get quality help
and feedback :)
Thanks everyone once again :)
James
_
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of stuzimmy
Sent: 02 November 2007 12:05
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Re: select first only
James,
A better query might be to join the two tables. Why select WMSPallet
and then query InventPalletBT. You could be looping throught thousands
of records only to find a match in the other table on a small subset.
Let your DBMS handle that for you.
The only way to guarantee the records are fetched in any particular
order is to order them that way in your where clause. Otherwise you're
at the mercy of the indexes on the table and results can vary.
Hope this helps.
while select WMSPallet
order by WMSPalletId
join InventPalletBT
where inventPalletBT.PalletID ==
WMSPallet.wMSPalletID
{
}
--- In development- mailto:development-axapta%40yahoogroups.com
[EMAIL PROTECTED], James Flavell [EMAIL PROTECTED]
wrote:
Hi again everyone,
Another query I have is with the firstonly command. I understand
basically
how it works but want to know how it really works in practice
Given this code:
while select WMSPallet
order by WMSPalletId
{
select firstonly InventPalletBP
where InventPalletBP.PalletId ==
WMSPallet.wMSPalletId;
}
Is it better to use firstonly in such a situation?
I mean I am going to be looping through pallets so if I dont use
firstonly a
number of inventpalletbp table records will be fetched together which
in
theory would be a good thing to save on database calls. But then i am
wondering will the records that are fetched be in any particualr order
(e.g.
by palletid) or just from the same page in the SQL server? I guess it
should be read ahead according to the where clause or do I need to
explicitly put an order by or index command against the InventPalletBP
select statement to be sure of this?
Looking forward to your input
Thanks
James
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[development-axapta] select first only
Hi again everyone,
Another query I have is with the firstonly command. I understand basically
how it works but want to know how it really works in practice
Given this code:
while select WMSPallet
order by WMSPalletId
{
select firstonly InventPalletBP
where InventPalletBP.PalletId ==
WMSPallet.wMSPalletId;
}
Is it better to use firstonly in such a situation?
I mean I am going to be looping through pallets so if I dont use firstonly a
number of inventpalletbp table records will be fetched together which in
theory would be a good thing to save on database calls. But then i am
wondering will the records that are fetched be in any particualr order (e.g.
by palletid) or just from the same page in the SQL server? I guess it
should be read ahead according to the where clause or do I need to
explicitly put an order by or index command against the InventPalletBP
select statement to be sure of this?
Looking forward to your input
Thanks
James
[Non-text portions of this message have been removed]
[development-axapta] Oracle to SQL
Hi everyone Has anyone done data migration of Oracle AX DB to SQL? Can it be done easily via SQL DTS or is there many differences in table/fields? Things I am concerend are: Extra fields in table structures Field type differences and hence truncation etc Thanks James
RE: [development-axapta] Intercompany dimensions
Where did you get the text from? PartnerSource KB? Can you not just request the hotfix from MBS if you are a partner? Thanks James James Flavell CITP Singapore Pte Ltd Mobile: +65 97582281 Email: [EMAIL PROTECTED] -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Darius Baciulis Sent: 19 February 2007 18:59 To: development-axapta@yahoogroups.com Subject: [development-axapta] Intercompany dimensions Hi guys , does anyone of you faced this problem and most important have a hotfix for it ;) ** SYMPTOMS Consider the following Microsoft Business Solutions - Axapta 3.0 scenario:1. You configure intercompany postings between two companies, Company A and Company B. 2. You create a dimension in Company B that does not exist in Company A. 3. You create an intercompany journal in Company A. You select the new dimension that you created as the intercompany dimension. In this scenario, when you post an intercompany transaction from Company A, you receive a validation error. CAUSE This problem occurs if you post an intercompany transaction with a dimension that is different from the company where the transaction originates. Axapta always looks up the dimensions that belong to the company where the journal is created. This problem occurs because the posting routines and the validation routines in Axapta 3.0 validate the dimension by checking the source company instead of by checking the destination company. Therefore, if the dimension does not exist in the source company, you receive a validation error when you try to post the transaction. RESOLUTION A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. ** Darius Yahoo! Groups Links
RE: [development-axapta] Duplicate LineNume in SalesLine
It is possible to get duplicate linenum in a SO or PO. search Axapta village or this group for postings I did a few months ago. Suggestion is to make the LineNumIdx on these tables unqiue so can catch the 'error' (if needs to be unique for you) All the best James _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of amit bansal Sent: 12 January 2007 17:13 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Duplicate LineNume in SalesLine Hi Vicente, The line num is counterfield of the datasource. So thr is no possibility of generation of same linenum against a single salesid or purchid. bizen99 [EMAIL PROTECTED] mailto:bizen99%40gmail.com com wrote: Hi, When I add a line in salesline, sometimes two linenums have the same number. Where lineNum is updated? Thanks Vicente Send instant messages to your online friends http://uk.messenger http://uk.messenger.yahoo.com .yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [development-axapta] Include more than one company in a OLAP cube
I don't think this is possible without modifying the script in the OLAP but if you take a look at the script you might be able to do a quick and dirty mod to change company and run the whole script then after that the populate to cube just needs to pull in the data from both companies . You can do in business views with 'company collections' because these are created in SQL but if you use the OLAP in Axapta it is defaulted to the current company like all the filtering... _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of hilda cabrejos Sent: 31 May 2006 07:05 To: development Subject: [development-axapta] Include more than one company in a OLAP cube Hello everybody Does anybody know how I can include the information of two companies in my OLAP cube? Is this possible ? I made a cube in one company but my user wants the information of another company to be included in the cube Thank you in advance Hilda - Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1cent;/min. [Non-text portions of this message have been removed] SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Progr amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvc LTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+part w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yf eG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy 8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. _ [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] Long time opening form - user settings problem
Is it slow everytime they open the form or just the first time after login? If so then maybe there is some table being loaded into the local cache for that users setup Do the users have exactly the same access rights? -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Agus Riyadi Sent: 02 May 2006 13:13 To: development-axapta@yahoogroups.com Subject: [development-axapta] Long time opening form - user settings problem Dear All, I have a user that takes a very long time ( 1 mins) to open production order form, while another user with the same user group has no problem. I think something wrong with user settings because when I put a breakpoint (which then system ignore user settings), then this user can normally open the form. But I don't know how to find what user customization that cause this trouble. I opened usage data but it only show collected values as container of number that explains nothing. Could some one give a clue on this ? Thanks in advance. Regards, Agus [Non-text portions of this message have been removed] SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Progr amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvc LTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+part w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yf eG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy 8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] Business Views
Thanks Mike,
I guess there is not much hope for end users to get this except vai external
querying such as SQL or OLAP...
Thanks
James
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Savage
Sent: 26 April 2006 20:10
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Business Views
James
The way I have done that in the past is to write an actual SQL
statement, execute it and retrieve the record set and report on that.
Something like:
static void Job3(Args _args)
{
Connection con;
Statement statement;
ResultSet resultSet;
Str sqlSelect;
;
con = new Connection();
statement = con.createStatement();
sqlSelect = select DATEPART(yy,custinvoicetrans.invoicedate) as
Year,;
sqlSelect += itemId as Item, SUM(qty) as Qty ;
sqlSelect += from custinvoicetrans ;
sqlSelect += where dataareaid = 'DMO' ;
sqlSelect += GROUP BY DATEPART(yy,custinvoicetrans.invoicedate),
ItemId;
resultSet = statement.executeQuery(sqlSelect);
while (resultSet.next())
{
info(strfmt(%1 %2
%3,resultSet.getInt(1),resultSet.getString(2),resultSet.getReal(3)));
}
}
In the above example, it does limit the company, but, if you remove that
line, it will report across all companies.
You will then need to load the data to a temp table to allow you to use
Axapta's reporting, but that will do it.
The code should be executed within the report (obviously!)
Cheers
Mike Savage
Sense Enterprise Solutions Ltd
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of James Flavell
Sent: 26 April 2006 07:27
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Business Views
Hi Mike,
Yeah I am not too sure...I am guessing it was an early attempt at using
Axapta as some kind of BI tool as you have things like grouping but it
is
very limited and I get the feeling they did it and then left it because
it
was not worth anymore effort due to better tools being out there in the
BI
market
Anyway I am interested to know a little more on a somewhat related
issue:
Is it possible to have a report that prints data from all companies?
By default the kernel (I think) fitlers it to the current company so
even if
I cahnge the property 'Company' in the datasource it will only ever take
it
from the active company!!!
If there any way to avoid this behavior inside datasources/queries? So
far
the only possible way I have come across is by using business views but
these are not able to be used inside Axapta (because they basically
create
SQL objects)
Thanks
James
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Savage
Sent: 22 April 2006 00:43
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Business Views
Does anyone know what the purpose and use of the 'Business views'
functionality is in the Admin module?
According to the help text '_dictTable.name() != 'In the Business Views
form you create new business views allowing data from the database to be
wrapped and translated into human readable format.'
I can create a view in the form in Axapta and see it in the Views
section of Enterprise Manager, but now what? I could use another tool
to look at it I suppose, but how can I access it from Axapta?
Cheers
Mike Savage
Sense Enterprise Solutions Ltd
Corner House
Robey Close
Linby
Nottinghamshire
NG15 8AA
t: +44 (0) 115 964 6646
f: +44 (0) 115 964 6647
e: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
w: www.senseenterprisesolutions.co.uk
Confidentiality:
This e-mail and its attachments are intended for the above named only
and may be confidential. If they have come to you in error you must take
no action based on them, nor must you copy or show them to anyone;
please reply to this e-mail and highlight the error.
Security Warning:
Please note that this e-mail has been created in the knowledge that
Internet e-mail is not a 100% secure communications medium. We advise
that you understand and observe this lack of security when e-mailing us.
Viruses:
Although we have taken steps to ensure that this e-mail and attachments
are free from any virus, we advise that in keeping with good computing
practice the recipient should ensure they are actually virus free.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Computer
http://groups.yahoo.com/gads?t=ms
http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=P
k=Computer+partw1=Computer+partw2=P
rogr
amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=y
Lpvc
LTIDJ5FTkRJGsO11w part Programming
http://groups.yahoo.com/gads?t=ms
http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+p
k=Programming+languagesw1=Computer+p
art
w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=9
0.s
ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft
http://groups.yahoo.com/gads?t
RE: [development-axapta] Optimistic Concurrency Checking/RecVersion
Thanks for sharing that Lennart, I am sure it has saved me a lot of searching in the future -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Lennart Conrad Sent: 24 April 2006 22:45 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Optimistic Concurrency Checking/RecVersion The field is related to the OCC. Everytime the record is updated the recversion is changed. So the kernel checks if the recversion you try to commit is different than the one in the database - if it is, somebody else updated the record before you and your update fails. Regards Lennart -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of cdlmalherbe01 Sent: 18. april 2006 08:48 To: development-axapta@yahoogroups.com Subject: [development-axapta] Optimistic Concurrency Checking/RecVersion Hi all, I'm trying to come to grips with differences between Ax3/4 and SQL2000/2005. A feature that was introduced with Ax3 KR1/Sp5 is optomistic concurrency checking. I'd like to know if the addition of a column called RECVERSION to each table has anything to do with OCC? Regards, Christoph Yahoo! Groups Links _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] Business Views
Hi Mike, Yeah I am not too sure...I am guessing it was an early attempt at using Axapta as some kind of BI tool as you have things like grouping but it is very limited and I get the feeling they did it and then left it because it was not worth anymore effort due to better tools being out there in the BI market Anyway I am interested to know a little more on a somewhat related issue: Is it possible to have a report that prints data from all companies? By default the kernel (I think) fitlers it to the current company so even if I cahnge the property 'Company' in the datasource it will only ever take it from the active company!!! If there any way to avoid this behavior inside datasources/queries? So far the only possible way I have come across is by using business views but these are not able to be used inside Axapta (because they basically create SQL objects) Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Savage Sent: 22 April 2006 00:43 To: development-axapta@yahoogroups.com Subject: [development-axapta] Business Views Does anyone know what the purpose and use of the 'Business views' functionality is in the Admin module? According to the help text '_dictTable.name() != 'In the Business Views form you create new business views allowing data from the database to be wrapped and translated into human readable format.' I can create a view in the form in Axapta and see it in the Views section of Enterprise Manager, but now what? I could use another tool to look at it I suppose, but how can I access it from Axapta? Cheers Mike Savage Sense Enterprise Solutions Ltd Corner House Robey Close Linby Nottinghamshire NG15 8AA t: +44 (0) 115 964 6646 f: +44 (0) 115 964 6647 e: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] w: www.senseenterprisesolutions.co.uk Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Security Warning: Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. [Non-text portions of this message have been removed] SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Progr amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvc LTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+part w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yf eG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy 8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] How to get distinct records in report?
I believe whatever fields are set in your sort are considered the groupby fields -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of vk Sent: 30 March 2006 15:02 To: development-axapta@yahoogroups.com Subject: [development-axapta] How to get distinct records in report? hi, Thanks for ur favourable response. i have tried, but i get redendent data.for example , the report display like this. EquipmentClass Description BDR180HA BullTozer 180Hp BDR180HA BullTozer 180Hp BDR180HA BullTozer 180Hp BHL007TA Back hoe loader 7 hp BHL007TA Back hoe loader 7 hp but i want BDR180HA BullTozer 180Hp BHL007TA Back hoe loader 7 hp I have set group by in report Datasource's orderby mode. which field default taken for group by. i want to group by as equipment class.how to do? regards, vijay Steeve Gilbert [EMAIL PROTECTED] wrote: Hi Vijay, To do a group by, take a look at the property OrderMode of your report's dataSource. Regards, Steeve... -Message d'origine- De : development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de vk Envoyé : 28 mars 2006 23:39 À : development-axapta@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.com Objet : [development-axapta] How to get distinct records in report? hi, I have an EquipmentTable.In my EquipmentTable having Equipmentcode,EquipmentClass,Declaration(3 fields).The Equipment code is a primary key.Same EquipmentClass having Different equipment code. my query is, how to get the unique equipmentclass in my report? equipmentTable having the entry like this Equipmentcode EquipmentClass Description BDR001 BDR180HA Bull tozer180HP BDR002 BDR180HA Bull tozer180HP BDR003 BDR180HA Bull tozer180HP BHL001 BHL007TA Backhoe loader 7 ton BHL002 BHL007TA Backhoe loader 7 ton In my report i have display only, EquipmentClas Description TotalNoOf_Equipment BDR180HA Bull tozer180HP 3 BHL007TA Backhoe loader 7 ton 2 How to get the unique Equipment class in my report.I have tried using Groupby query in jobs.i got the answer.but how to use this query in report? i used the query is, select EquipmentTable group by equipmentclass; help me yours, vijay Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Links - YAHOO! GROUPS LINKS Visit your group development-axapta 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] _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] Axapta Upgrade
Thanks Jim I understand your approach now...I thought originally you just took a 2.5 and put SP5 on it!!! Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chwaszczewski, Jim Sent: 24 March 2006 00:25 To: development-axapta@yahoogroups.com Subject: [development-axapta] Axapta Upgrade Hi James. Interesting is definitely the word for Axapta upgrades. The service pack brings in new SYP, GLP, DIP layers. I do the code upgrade to the current release and service pack. I then open the old 2.5 database with the new application which starts the whole data upgrade. There are separate ReleaseUpdateDB... classes for moving the data from 2.5 to 3.0 and then from 3.0 to the current SP. So far, I haven't had any major problems. According to Microsoft, Axapta service packs are cumulative so if a service pack becomes a required stopping point on the way to another release, then it shouldn't be a service pack, it should be a new release like 3.5. I definitely put up a fuss when Microsoft creates more problems for upgrades. Upgrades take enough time as is and it hard to bill clients for extra work caused by Axapta's developers (we end up eating the time). With all that said, I have a great time working with Axapta. I'm looking forward to seeing 4.0. Jim Chwaszczewski [EMAIL PROTECTED] Message: 1 Date: Wed, 22 Mar 2006 08:57:36 +0900 From: James Flavell [EMAIL PROTECTED] Subject: RE: Digest Number 1713 Supposedly the install doc says need to upgrade 2.5 to 3.0 BUT then do not start Axapta...rather just apply SP5. So basically each version is a milestone I would say Interesting as it sounds like you say you have not taken this approach but gone directly to the service pack...I am just wondering does that not mean your SYS layer is actually a 2.5 version? In theory the SP should only bring in a SYP layer Interesting Thanks James _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] Digest Number 1713
Supposedly the install doc says need to upgrade 2.5 to 3.0 BUT then do not start Axapta...rather just apply SP5. So basically each version is a milestone I would say Interesting as it sounds like you say you have not taken this approach but gone directly to the service pack...I am just wondering does that not mean your SYS layer is actually a 2.5 version? In theory the SP should only bring in a SYP layer Interesting Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chwaszczewski, Jim Sent: 22 March 2006 02:35 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Digest Number 1713 I've not seen anything from Microsoft saying that you must migrate to 3.0 before migrating to SP4. You'll have to check with them since I could be wrong. However, I've done 3 upgrades from 2.5 to SP3 in the past 6 months and I'm working on a 4th to SP4. There are some hotfixes that were issued for SP3 that had jobs to run in addition to the upgrade. The developers made a royal mess of inventory. In general, Microsoft says you cannot skip major releases, so you can't go from 2.1 to 3.0 (skipping 2.5), or 2.5 to 4.0 (skipping 3.0), but unless there is something mentioned in the service pack documentation you should be able to migrate to the newest service pack of the next higher release. As a customer or VAR, I would be sorely angry if Microsoft came out with a service pack that made such major changes that I had to do a double upgrade within a major release. Due to the difference of the responses, I recommend you check with Microsoft. Jim Chwaszczewski - Message: 6 Date: Mon, 20 Mar 2006 09:14:58 +0100 From: Askeryd Thomas [EMAIL PROTECTED] Subject: SV: Digest Number 1706 You can not go to SP4 directly. MS should have a spec. somewhere which packs are milestones or what to call them. Thomas. Från: development-axapta@yahoogroups.com genom James Flavell Skickat: fr 2006-03-17 01:53 Till: development-axapta@yahoogroups.com Ämne: RE: [development-axapta] Digest Number 1706 Hi Jim, Can you confirm you can go from 2.5 to 3.0SP4 directly (i.e. just run the Sp4 installation etc). I was always under the impression we had to upgrade to 3.0SP0 first. Just want to check as I am doing such an upgrade in the near future Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chwaszczewski, Jim Sent: 16 March 2006 02:11 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Digest Number 1706 You can upgrade directly to 3.0 SP4 from 2.5. Number sequence references in 3.0 must be unique. A number sequence can only be used once. You need to clean up number sequence references in 2.5 before the upgrade. It's one of those architectural changes they don't tell you about. Jim Chwaszczewski [EMAIL PROTECTED] The content of this e-mail and any attached files is confidential, and may be subject to certain privilege. This e-mail is intended for the designated recipient(s) only. If you have received this e-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this e-mail (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Progr amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvc LTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+part w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yf eG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy 8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this g
RE: [development-axapta] Digest Number 1706
Hi Jim, Can you confirm you can go from 2.5 to 3.0SP4 directly (i.e. just run the Sp4 installation etc). I was always under the impression we had to upgrade to 3.0SP0 first. Just want to check as I am doing such an upgrade in the near future Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chwaszczewski, Jim Sent: 16 March 2006 02:11 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Digest Number 1706 You can upgrade directly to 3.0 SP4 from 2.5. Number sequence references in 3.0 must be unique. A number sequence can only be used once. You need to clean up number sequence references in 2.5 before the upgrade. It's one of those architectural changes they don't tell you about. Jim Chwaszczewski [EMAIL PROTECTED] Message: 1 Date: Fri, 10 Mar 2006 14:48:34 +0100 From: Dahlsgaard Jan [EMAIL PROTECTED] Subject: SV: Error whil upgrad Ax 2.5 DB to Ax 3.0 SP4 I don't think you can go directly from 2.5 to 3.0SP4. You have to upgrade your db to 3.0 og 3.0SP1 first. Fra: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af pbercher Sendt: 10. marts 2006 13:29 Til: development-axapta@yahoogroups.com Emne: [development-axapta] Error whil upgrad Ax 2.5 DB to Ax 3.0 SP4 Hi, during the upgrade process i get the folowoning message: *** Info Message (13:26:31) Run job 'updateCustSalesLinkTable' ordered by 'Admin' in database 'pa1'. Error Message (13:26:31)\Table CustPickingListSalesLink Reference for call of number sequences is not specified. *** any good hints where to look? Thx Pirmin The content of this e-mail and any attached files is confidential, and may be subject to certain privilege. This e-mail is intended for the designated recipient(s) only. If you have received this e-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this e-mail (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] URGENT Decimal Length
Which part needs to be 3 decimals? And why? Qty? Price? Sales or Purchase? Base Amounts? -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mohib B. Reda Sent: 24 December 2005 16:31 To: Axapta_Documentation@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.com Subject: [development-axapta] URGENT Decimal Length Hi all Can you please advice me how to use different decimal length for two companies one of them using 2 digit and the other use 3 digit Thanks for your Support Regards Mohibz [Non-text portions of this message have been removed] _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] Print group totals in auto reports
Instead of autoreport use the report wizard (can do auto report and then 'modify') In one of the steps (about the 3rd of 4th NExt button) there is which fields you want to subtotal on :) James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Stefan Osterburg Sent: 19 October 2005 01:15 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Print group totals in auto reports Sonny, thanks for your answer - but I do not want to save the autoreport in AOT as I want the user to choose by what feidls he needs the report grouped and sub-totaled: The user clicks on the print icon, when he is in a form where in my case ProjJournalTrans is the datasource, Axapta opens the dialog for Auto-Reports, the user clicks Select and on the tab Sorting can choose the fields to sort the report by and decide to print subheadings and subtotatals, whenever the value in a certain sort field changes. Unfortenately, Axapta does not print subtotals for all number fields, but only certain fields. As I explained in my initial mail the following example shows what I mean: when I use auto-report on LedgerTrans table I get a sum on the AmountMST field but not on the AmountMSTSecond field. Likewise I cannot get Axapta to automatically print subtotals on ProjJournalTrans\Qty field. What I woulkd like to know is how I can tell Axapta to consider certain number fields for automatic subtotal-creation. Stefan Sonny Wibawa Adi schrieb: Hi, Stefan, You have to change the report design through AOT. Set the property SumAll or SumNeg or SumPos of real-type controls to Yes. Those controls will then be summed up by Axapta automatically. --- Stefan Osterburg [EMAIL PROTECTED] wrote: Hi, I am trying to use Axapta's auto report to print group total sums. However I do not get this to work for all fields I would like to sum up. For example when I use auto-report on LedgerTrans table I get a sum on the AmountMST field but not on the AmountMSTSecond field. However what I am actually trying is to get an auto-report on ProjJournalTrans print sub-totals for the Qty field. Any idea, how Axapta chooses the fields to print sums for and what I can do to change this? Stefan Yahoo! Groups Sponsor ~-- Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM ~- Yahoo! Groups Links http://groups.yahoo.com/group/development-axapta/ [EMAIL PROTECTED] Best regards, Sonny Wibawa Adi MBS Certified Professional - Axapta 3.0 Technical MCSD.NET MCAD.NET __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ Yahoo! Groups Links _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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.
[development-axapta] table cache 'Entire table'
Hi Can anyone tell me the table protperty for 'CacheLookup' if set to EntireTable will this load all Axapta companies records or only the company I am in when I access that table? Also if I set it up in user options the 'PreLoad' for a table deos it also load all Axapta companies or just the one I am in? Thanks James [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] From Axapta 2.5 to 4.0
mmm I am confused what is SP2.5???!! Anyway if you are going from version 2.5 to version 3.0 from what I can recall you need to install the last 2.5 SP and then upgrade to v3.0 SP0 after which you can then install the latest v.30 SP (i.e SP4) because service pack are accumualtive (i.e. SP4 contains all the things in SP1,2 and 3). If you upgrade say a 2.5 SP1 straight to v3.0 SP0 then I think you will have problems if my memory serves me correct. All the best James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of hilda cabrejos Sent: 23 August 2005 21:47 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] From Axapta 2.5 to 4.0 Hello Sorry if there was a misunderstanding de upgrade was from version 3 SP2.5 to version 3 SP4, as you say version 4 is not out yet. I do not recommend going from V3 SP2.5 to V3 SP3 and then V3 SP4...we did it and lost about 1 month on the try, it all failed. Hilda mudit mittal [EMAIL PROTECTED] wrote: Hi First i dont think so 4.0 is out in market , and other thing is if you have to do a upgrade from 2.5 to 4.0 , best way is to do in steps , do it from 2.5 to 3.0 and then from 3.0 to 4.0. Regards Mudit yuvika sharma [EMAIL PROTECTED] wrote: Hi, I need to know about the requirements to upgrade from version 2.5 to version 4.0.For that do we need to install SP4 client on every client ? Regards Tom Kim [EMAIL PROTECTED] wrote: Do you mean you just upgraded from 2.5 to 2.5 with SP4, or to version 4.0? Thanks --Tom Tom Kim Microsoft Business Solutions Certified Professional Advanced Systems Integration, Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 949-597-2170 949-597-0720 (Fax) [EMAIL PROTECTED] www.advancedsystemsintegration.com -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of hilda cabrejos Sent: Friday, August 19, 2005 6:11 AM To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] From Axapta 2.5 to 4.0 Hello We just upgraded from 2.5 to 4.0, what I recommend is to make a good backup checking that the owner is bmssa, backup of axaptaapplication 2.5 directory, and backup of axaptaclient 2.5 directory if you have to go back (we had to), do the upgrade in another server different from the one you have axapta 2.5 first, if everything works ok do it on the real one, the process depending on the size of your DB (150M took about 6 hours), if you work with SALESLINETABLE check for lines that have no unit, after the upgrade these will appear with a unit called AX. Do this process on a weekend. You must install SP4 client on every client so rename the actual AOT so there is no chance on somebody entering with another version of SP. Can´t think of anything else. yuvika sharma [EMAIL PROTECTED] wrote: Hi all, can any one list the requirements and precautions needed to upgrade the code from version 2.5 to 4.0 ??? Thanks __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] - YAHOO! GROUPS LINKS Visit your group development-axapta on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Links - YAHOO! GROUPS LINKS Visit your group development-axapta 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. - - Start your day with Yahoo! - make it your home page [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange - YAHOO! GROUPS LINKS Visit your group development-axapta 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. - - Start your day with Yahoo! - make it your home page [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange - YAHOO! GROUPS LINKS Visit your group development-axapta on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is
RE: [development-axapta] External Axapta Training Resources
Hi Kang, We are present with offices in Indonesia and Singapore that service the whole Asia region, with satisified customers in Malaysia, Hong Kong etc. We can provide both functional and development training as well as other Axapta related services and have basically been a DEDICATED Axapta only partner since it all started back in 1998/1999 (and before that the predecessor to Axapta which was Concorde XAL) so resources wise we wont send you someone who has just done the training themselves and is just repeating what is written in the book but we will share our experiences of things that work well and thigns that don't work so well (in fact our training sessions tend to be more for customers who have key users who want explore 'deeper' matters than what is covered in the 'theory' sessions ). Other alternatives are of course official MBS training sessions (cheap but depends on when MBS arrange and have to share the trainers time with other partners...also I am not sure if you need to be a registered MBS partner to attend) Also FYI I believe there is a company in Malaysia (cannot recall the name but starts with A or E but its not ESG) that MBS have previously sourced to run official MBS Axapta training sessions but the feedback I have received is that it is pretty much going through the MBS training documents and so alot of theory rather than pratical/experience but maybe they can tailor make a session similar to what we would usually do. If it is just to get you started then official MBS training I would recommend given its cost but looking at your web site I am not sure exactly whether you are an end customer or potential partner etc, maybe you can give an indication of exactly what yor plans are with Axapta (end customer, integrating 3rd aprty manufacturing tools ...) If you wish to considered our services please contact me on the email [EMAIL PROTECTED] Thanks James James Flavell International Business Consultant Email: [EMAIL PROTECTED] / [EMAIL PROTECTED] Tel : +65 97582281(SG) PT Columbus IT Indonesia Graha Surya Internusa, Lantai 8 Suite 806, Jl. H.R. Rasuna Said Kav. X-O, Jakarta 12950 Indonesia Tel: +62 21 527 6630/6640 Fax: +62 21 527 6650 -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Kang Shang Yie Sent: 27 July 2005 12:56 To: development-axapta@yahoogroups.com Subject: [development-axapta] External Axapta Training Resources Hi all, Anyone knows, if there is some training centre or Axapta expert in Malaysia, provides proper Axapta Training in Functional and Development module ? Looking forward for any reply, thanks. Kind Regards, Kang SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Progr amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvc LTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+part w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yf eG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy 8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] SQL sync error
Thanks Dilip, What you say is mostly correct see what I found out (important point is who the owner of the view is): It seems this error is because the view called 'VIEWS' in the master DB of my SQL has the owner as 'dbo' and not 'Information_SCHEMA'. I think maybe at some point I accidental ran the change owner script on the master db rather than the Ax DB Now I just need to find a way to set back the right views etc to the right user...or otherwise reinstall SQL (since I don't have a backup of master before the change owner happened) Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dilip N Sent: 19 July 2005 20:54 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] SQL sync error Information_schema.views is a system view which resides in master database. First step, you just check whether this view is present in the location by expanding master database-VIews, Nextly, you check if proper permissions like dbo is the owner of the view..I believe it might be corrupted. or if you have another sql server hosted, just try using that copy of master database..maybe backup this master db and restore the other master db.. Good luck :-) James Flavell [EMAIL PROTECTED] wrote: Can anyone tell me anything about INFORMATION_SCHEMA.VIEWS in SQL ...I get teh following error messages when I try to sync Axapta. I guess I am missing this view or table and so the system gets stuck but where shoul dthis view be? In the Ax DB or the master DB or where? I hope someone can help as I am not able to do any sync to my databases because of this... Thanks James Error given during sync: Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCES') DROP VIEW LEDGERBALANCES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCESDIM') DROP VIEW LEDGERBALANCESDIM Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNUSERSPERLINES') DROP VIEW BMRUNUSERSPERLINES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMUSERSCRIPTTIMINGAGG') DROP VIEW BMUSERSCRIPTTIMINGAGG Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNSTEPSPREADING') DROP VIEW BMRUNSTEPSPREADING Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMSCRIPTSTEP') DROP VIEW BMSCRIPTSTEP Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERVENDPAYMPROPOSAL') DROP VIEW LEDGERVENDPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERCUSTPAYMPROPOSAL') DROP VIEW LEDGERCUSTPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'CUSTVIEW') DROP VIEW CUSTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
[development-axapta] SQL sync error
Can anyone tell me anything about INFORMATION_SCHEMA.VIEWS in SQL ...I get teh following error messages when I try to sync Axapta. I guess I am missing this view or table and so the system gets stuck but where shoul dthis view be? In the Ax DB or the master DB or where? I hope someone can help as I am not able to do any sync to my databases because of this... Thanks James Error given during sync: Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCES') DROP VIEW LEDGERBALANCES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCESDIM') DROP VIEW LEDGERBALANCESDIM Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNUSERSPERLINES') DROP VIEW BMRUNUSERSPERLINES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMUSERSCRIPTTIMINGAGG') DROP VIEW BMUSERSCRIPTTIMINGAGG Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNSTEPSPREADING') DROP VIEW BMRUNSTEPSPREADING Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMSCRIPTSTEP') DROP VIEW BMSCRIPTSTEP Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERVENDPAYMPROPOSAL') DROP VIEW LEDGERVENDPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERCUSTPAYMPROPOSAL') DROP VIEW LEDGERCUSTPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'CUSTVIEW') DROP VIEW CUSTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERACCOUNTVIEW') DROP VIEW LEDGERACCOUNTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERTRANSVIEW') DROP VIEW LEDGERTRANSVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'PROJDATAVIEW') DROP VIEW PROJDATAVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'PROJEMPLSUM') DROP VIEW PROJEMPLSUM Cannot execute the required database operation.,The SQL database has issued an error. SQL error description:
RE: [development-axapta] Range criteria on InventTrans
you should realise any trans can only ahve status in either issue or receipt but you are basically telling the report to find trans that has value in both (i.e. criteri are AND together) basically you will need to run the report 2 times I think -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hemant Sent: 07 July 2005 13:33 To: development-axapta@yahoogroups.com Subject: [development-axapta] Range criteria on InventTrans Hi There, I created a Auto Report and I want to select only transaction where the StatusIssue has Issue type of Sold or Deducted and I also want to select transaction where StatusReceipt has Receipt type of Purchased or Received, but when I use these in the Query screen , the report doesn't print, I know because of the criteria, since I tried giving only one criteria each in Status Issue and receipt I am able to see the information on the report. I would appreciate your suggestions. In the Query Status Issue = Sold, Deducted Status Receipt = Purchased, Received Since the condition is getting compunded I think the report is coming out empty. SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Progr amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvc LTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+part w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yf eG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy 8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * 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/ . _ [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" 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: [development-axapta] Print all Axapta companies data in a report
Thanks a lot I will look into that but liek yourself I dont have much time for doing it right now Thanks once again James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jesper Kehlet Sent: 09 June 2005 11:01 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Print all Axapta companies data in a report There is actually a class + a form, both called SysQueryForm, that control the queries for reports. If you change the findFields() method on the class, you can enable the Company (DataAreaId) field for selection, but there may be other things needed to have it actually pull data. I need to dig more into this later myself, but I don't have time right now. Hopefully this will get you started. From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Monday, May 30, 2005 7:52 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Print all Axapta companies data in a report Hi I am thinking of writing a report that prints information from several Axapta companies but do not want to have to use the changeCompany function because I want a select (or query) to be able to run through all the records to consolidate records with same values and so I would like to use groupby rather than manually have to do this with change company and temp tables etc. Is this possible or will all Axapta select statements and queries always be defaulted to filter by the current company I am in? Is there anyway to turn this default behaviour off for a given select or query? I guess I can write direct SQL in Axapta but I have never done this and so am not sure the syntax to handle the returned records/results so would prefer to do it using std Axapta if possible. If it is only possible with direct SQL I would apprecaite some help as how to handle the results coming back. Can I make use of views for this? Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Inventory amount adjustment some warehouse not shown ???
I think on hand adjustment is only based on the on hand at last inventory closing so probably do an invnetory closing up to the current date and you should see the same warehouses...I think, let us know if this is the case cheers -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of SAS Sent: 08 June 2005 18:54 To: development-axapta@yahoogroups.com Subject: [development-axapta] Inventory amount adjustment some warehouse not shown ??? Dear all, we want to do on hand amount adjustment on an item number , if we check on ON Hand inventory , there are several warehouse over there , but when we wanna do on hand amount inventory adjustment we saw the warehouse number is less then on on hand inventory . ( suppose if check on hand inventory , there are warehouse a1,a2,a3 but when we will do on hand amount adjustment only warehouse a1 and a2 over there ). do you have any idea how we can show all warehouse ? thx sas _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Print all Axapta companies data in a report
Hi I am thinking of writing a report that prints information from several Axapta companies but do not want to have to use the changeCompany function because I want a select (or query) to be able to run through all the records to consolidate records with same values and so I would like to use groupby rather than manually have to do this with change company and temp tables etc. Is this possible or will all Axapta select statements and queries always be defaulted to filter by the current company I am in? Is there anyway to turn this default behaviour off for a given select or query? I guess I can write direct SQL in Axapta but I have never done this and so am not sure the syntax to handle the returned records/results so would prefer to do it using std Axapta if possible. If it is only possible with direct SQL I would apprecaite some help as how to handle the results coming back. Can I make use of views for this? Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Change InvoiceId on an invoice generated
Try the rename...it does not rename the field but the contents (i.e. exactly what you want)! -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Elías Manchón López Sent: 26 May 2005 19:36 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Change InvoiceId on an invoice generated Sorry but I don't change the name of field, I want change the content of the data on this field and that this information propagate about the interested tables. Thanks -Mensaje original- De: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] nombre de James Flavell Enviado el: jueves, 26 de mayo de 2005 11:02 Para: development-axapta@yahoogroups.com Asunto: RE: [development-axapta] Change InvoiceId on an invoice generated Right click on the invoice id field and do 'Rename' and enter the value you want ... just take care to check all places have changed (not sure if inventtrans field will change as this rename is based on EDT relationships I think and since the inventtrans field is used for both sales and purchase invoice etc I am not sure it will be using the same EDT so not sure will get changed...) -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Elías Manchón López Sent: 26 May 2005 18:32 To: development-axapta@yahoogroups.com Subject: [development-axapta] Change InvoiceId on an invoice generated Hi friends: How could I change the invoicedid on an invoice generated? is there some job for this purpose? The number of sequence was wrong. Thanks in advance. Elías _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] -- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Deny user log on concurrently
Sorry Kenneth I would like to add maybe another question in the same area: If I have two companies within one system is there any place I can control to make sure the total user licenses are allocated correctly to each company? E.g. Comapny A - paid for 10 users Company B - paid for 25 users So users who login and are associated with company A should be limited to 10 and likewise users logins for users assocaited with comapnyB shoul dbe limited to 25. I guess i will have to do modification so the system knows which company a user id is associated with but where is the best place to put the code for the checking how many users for each company is already logged in (I guess it is going to be basically the sameplace as where Kenneth would need his check also) Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of kamchung322 Sent: 13 May 2005 15:25 To: development-axapta@yahoogroups.com Subject: [development-axapta] Deny user log on concurrently Hi, Is it possible to deny user log on concurrently ? Regards Kenneth. _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] APAR aging by currency
ah thanks Harry I was trying to remember where I had seen the aging by currency :) -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande Sent: 20 April 2005 11:44 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] APAR aging by currency hi V3Sp2 Standard system I posted two transactions in different currencies and printed customer - external account statement, the aging was printed for multiple currencies. regards harry James Flavell [EMAIL PROTECTED] wrote: Thanks Harry, I have taken a quick look at the class and method etc and find there is a method in class custbalancelist that calls the method you mention. Need to spend some more time digging a bit deeper Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande Sent: 19 April 2005 18:03 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] APAR aging by currency hi Check class - CustVendBalanceList method placeTransInColumnsCur. This method does exactly what you want to achive. You will have to back-track this method (or method PlaceTransInColumns) to the ageing report. (i.e. method tmpAccountSum). regards harry James Flavell [EMAIL PROTECTED] wrote: hi Harry, Sorry I am only having up to Sp2 right now and from what I can see the balance aging reports (Ar/Reports/status/Aging report) show only the base curency amount. Maybe you have SP3 and my requirement is covered in that is it? Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande Sent: 15 April 2005 11:10 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] APAR aging by currency hi I was looking @this functionality it looks like this is standard in Axapta. Exactly which AR aeging report are you taking about? regards harry James Flavell [EMAIL PROTECTED] wrote: Hi all, Has anyone created the AR and AP aging reports in original transaction currencies? I have a requirement for this but am not sure how long it might take to do or whether there is any risks (i.e. why is such reports not already in std Axapta?) Thanks James [Non-text portions of this message have been removed] - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Make Yahoo! your home page [Non-text portions of this message have been removed] _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. [Non-text portions of this message have been removed] _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! [Non-text portions of this message have been removed] _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group
RE: [development-axapta] APAR aging by currency
Thanks Harry, I have taken a quick look at the class and method etc and find there is a method in class custbalancelist that calls the method you mention. Need to spend some more time digging a bit deeper Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande Sent: 19 April 2005 18:03 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] APAR aging by currency hi Check class - CustVendBalanceList method placeTransInColumnsCur. This method does exactly what you want to achive. You will have to back-track this method (or method PlaceTransInColumns) to the ageing report. (i.e. method tmpAccountSum). regards harry James Flavell [EMAIL PROTECTED] wrote: hi Harry, Sorry I am only having up to Sp2 right now and from what I can see the balance aging reports (Ar/Reports/status/Aging report) show only the base curency amount. Maybe you have SP3 and my requirement is covered in that is it? Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande Sent: 15 April 2005 11:10 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] APAR aging by currency hi I was looking @this functionality it looks like this is standard in Axapta. Exactly which AR aeging report are you taking about? regards harry James Flavell [EMAIL PROTECTED] wrote: Hi all, Has anyone created the AR and AP aging reports in original transaction currencies? I have a requirement for this but am not sure how long it might take to do or whether there is any risks (i.e. why is such reports not already in std Axapta?) Thanks James [Non-text portions of this message have been removed] - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Make Yahoo! your home page [Non-text portions of this message have been removed] _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. [Non-text portions of this message have been removed] _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] APAR aging by currency
hi Harry, Sorry I am only having up to Sp2 right now and from what I can see the balance aging reports (Ar/Reports/status/Aging report) show only the base curency amount. Maybe you have SP3 and my requirement is covered in that is it? Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande Sent: 15 April 2005 11:10 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] APAR aging by currency hi I was looking @this functionality it looks like this is standard in Axapta. Exactly which AR aeging report are you taking about? regards harry James Flavell [EMAIL PROTECTED] wrote: Hi all, Has anyone created the AR and AP aging reports in original transaction currencies? I have a requirement for this but am not sure how long it might take to do or whether there is any risks (i.e. why is such reports not already in std Axapta?) Thanks James [Non-text portions of this message have been removed] - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Make Yahoo! your home page [Non-text portions of this message have been removed] _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] OLAP cubes for cost of sales
Hi everyone, Has anyone done any OLAP cubes for cost of sales analysis/reports? I am considering doing this for a customer and am just wondering if there is any potential dangers/risks? >From what I can see there is an 'OLAPCostValue' on the custinvoicelines table. Can I use this field and if so is there any extra step I need to do (i.e. is this field populated by normal inovice update and inventory closing). I plan to make the cubes directly in SQL (as the customer does not have the Business Analysis module) and so I believe there is some challenges to getting the cost per invoice line (since this is a method rather than actual field). Should I think about first creating a view in Axapta and then using that to make my cube (e.g. I have not really used views but I guess I can use Axapta methods to get a cost in the view but in a direct SQL to the view will such a cost field exist and be already populated?) I look forward to hearing your experience and advice Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] APAR aging by currency
Hi all, Has anyone created the AR and AP aging reports in original transaction currencies? I have a requirement for this but am not sure how long it might take to do or whether there is any risks (i.e. why is such reports not already in std Axapta?) Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] OLAP cubes for cost of sales
Thanks Michael, I looked at the configuration key and realised that the field my customer wont get any way because it requires 'Business analysis' license but I am still interested to know the class you mention is being triggered during cube generating is it? Thanks James -Original Message- From: Michael Niemeyer [mailto:[EMAIL PROTECTED] Sent: 14 April 2005 18:26 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] OLAP cubes for cost of sales Hi, in OLAPCostValue Axapta calc the actual CostValue every time you update 'custinvoiceTrans' in the cube (s. \Classes\OLAPCreateAmount\fieldMethodName). Michael From: James Flavell [EMAIL PROTECTED] Reply-To: development-axapta@yahoogroups.com To: development-axapta@yahoogroups.com Subject: [development-axapta] OLAP cubes for cost of sales Date: Thu, 14 Apr 2005 08:46:26 +0900 Hi everyone, Has anyone done any OLAP cubes for cost of sales analysis/reports? I am considering doing this for a customer and am just wondering if there is any potential dangers/risks? From what I can see there is an 'OLAPCostValue' on the custinvoicelines table. Can I use this field and if so is there any extra step I need to do (i.e. is this field populated by normal inovice update and inventory closing). I plan to make the cubes directly in SQL (as the customer does not have the Business Analysis module) and so I believe there is some challenges to getting the cost per invoice line (since this is a method rather than actual field). Should I think about first creating a view in Axapta and then using that to make my cube (e.g. I have not really used views but I guess I can use Axapta methods to get a cost in the view but in a direct SQL to the view will such a cost field exist and be already populated?) I look forward to hearing your experience and advice Thanks James [Non-text portions of this message have been removed] _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Printing Sales invoice
Hi all, Posted next is the Dx Harry and I had sometime ago on teh other group about this form sort (take care it only works for 'After' setting...read on). Hope it helps and of course if not then post back :) Dx from sometiem ago: Hey thanks alot Harry, That is why I could not get it to work! At least now I can get the sort to work rather than wonder whether it was some nice idea by some programmer that never quite got off the ground ;) 'After' I believe is strictly just the printout so your thoughts about a problem after a few have been processed, I don't think anything is done. >From my understanding 'After' is more for batch update over night but you dont wnat to send it to the printer as if the print jams or low toner etc there is noone there to check and so you could come back in the morning and find that you just wasted sheets and sheets of paper etc... Thanks alot for your time and input, really appreciate it (I dont think I would have got around to testing the 'after' ...more likely to have given up!!!) Thanks James -Original Message- From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 7:50 AM To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Form sort used for what? Hi James First of all... if you want to apply a different sort order then you have to finger around with newJournalList method of class salesFormLetter_PickingList. Now to your question as to why this is not working for you... To be very honest, I did not try this out. However, I have a feeling as to why this is not working out for you. Axapta as two methods of printing the picking lists. First method is print pickinglist one by one as soon as they are processed. Represented by Printout=current on salesEditLinesForm. Second method is print pickinglists after they are processed. Represented by Printout = after on salesEditLinesForm. Obviously the sort will not work if Printout = current, since picking lists are being printed as soon as they are processed. I do not think you cannot change the value of printout manually. This can be changed in the update method of class salesformletter this.initParameters(salesParmUpdate, PrintOut::Current); // Printout I have not made a study of why this has been set as current in standard Axapta and the implications of setting printout to after. (for eg. If the picking list operations fails after processing 5 picking lists then whether the previous picking lists are reversed and if they are not reversed and there is a system failure then picking lists will not be printed etc etc.) However,in order for the formSort to work this value will have to be set to after. Another option which you may want to look at will be to change the order in which picking list are processed. Hope this helps Regards harry _ From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Saturday, 7 August 2004 11:28 a.m. To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Form sort used for what? Thanks very much Harry, Your example situation is a very good one and one that had not really crossed my mind :) my situation is very similar in that I want to make sure the warehouse pick priority customer stock first and therefore want the picking instructions to appear in customer prioirty order. I would refer the pick instruction number to be assigned in this order as it is more full proof but if it cannot then the print out in that order is the next best thing. Can you tell me exactly what you set to get it to work and what you did to test it worked? Like I said I have v3.0 SP2 and have set a sort but dont seem to get the printouts in that order (did you print to screen or printer...although I believe I should still be able to see the effect on the screen...) Thank you James -Original Message- From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Friday, August 06, 2004 6:03 AM To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Form sort used for what? Hi The questions still unanswered are: 1) Is the sort applied before or after the invoice number is assigned? i.e. can this sort influence the number assigned to a journal or does it only come into effect after each journal has been created (strictly the prinout) ** The sort cannot influence the number assigned to the journal and the sort is applied after the invoice number is assigned. can actually get it to work and maybe who actually uses this in a real life situation and if so can you add your input please :) ** Ummm, I do not know anyone who has used it but I can guess of a scenario... accounts department prints all the invoices during the night and the clerk files the invoices in the morning. Now if the invoices are being filed in alphabetical order (customer code or name) then you would sort them on that field. If the invoices are being filed in the number sequence then
[development-axapta] Adding new field to inventrans and getting it populated
Hi I would like to know what I need to do to add a new field to the inventrans and to get this field populated. I have a customer PO number that ends up being many Axapta sales orders and this PO number is very importnat for the my client to review inventory movements. I could use the batch number inventory dimension to record this PO number but dont think this is the best approach so I want to mkae a new field on the inventtrans and get this field copied from the sales order down to the inventtrans. Is this the best/correct way? If so can I just add the field (same name as sales order) and put it in one of the field groups and the system will take care of the rest (me dreaming?) or do I have to change a lot of code to get inventrans correctly populated? Is my appraoch advised/difficult? Thanks James [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Printing Sales invoice
I think its in the Form' sort (AR/Setup) -Original Message- From: anettemalmberg [mailto:[EMAIL PROTECTED] Sent: 07 March 2005 23:00 To: development-axapta@yahoogroups.com Subject: [development-axapta] Printing Sales invoice Hi Multiprinting of Sales invoice is sorting by SalesId. How can I modify this sorting so all Invoices will come out sortied by another field in SalesTable instead? Thanks Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129h7hrs1/M=298184.6018725.7038619.3001176/D=gr oups/S=1705006764:HM/EXP=1110383476/A=2593423/R=0/SIG=11el9gslf/*http://www. netflix.com/Default?mqso=60190075 click here http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S= :HM/A=2593423/rand=711762574 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * 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/ . [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Re: Product builder, how to execute user entered X++
Thanks Onno that really helps me :))
Is this the way the product builder does it?
Thanks
James
-Original Message-
From: onnobid [mailto:[EMAIL PROTECTED]
Sent: 03 March 2005 17:30
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Re: Product builder, how to execute user
entered X++
Hi,
try this:
static void Job51(Args _args)
{
XppCompiler XppComp = new XppCompiler();
str XppSrc = void Box(str Text) {;box::info(Text);};
XppComp.compile(XppSrc);
XppComp.execute(Hi);
}
or this:
static void Job52(Args _args)
{
str XppSrc = void Box(str Text) {;box::info(Text);};
runbuf(XppSrc, Hi);
}
Note: Source must not exceed 64K!
Regards,
Onno
Yahoo! Groups Sponsor
ADVERTISEMENT
http://us.ard.yahoo.com/SIG=129epdps6/M=298184.6018725.7038619.3001176/D=gr
oups/S=1705006764:HM/EXP=1109925399/A=2593423/R=0/SIG=11el9gslf/*http://www.
netflix.com/Default?mqso=60190075 click here
http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=
:HM/A=2593423/rand=994282163
_
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* 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/ .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Product builder, how to execute user entered X++
Thanks
You say everything gets embedded in the model when you compile, this is the
part I am most interested in looking at. Basically I want to see how/where
the code to turn the user entered X++ (just a memo field at this point from
what I can see in the Product Builder) into actual AOT X++ (actual compiled
code), do you have any idea where I can see this happening?
Thanks again
James
-Original Message-
From: Hemant Kumthekar [mailto:[EMAIL PROTECTED]
Sent: 28 February 2005 03:23
To: development-axapta@yahoogroups.com
Subject: Re: [development-axapta] Product builder, how to execute user
entered X++
Hi James,
There are lot of things you can do in the Product Builder X++ code , like
you can check for the responses entered by user and calculate / manipulate
data based on the input, if you see the nodes you can attache the If / else,
Loop (for While) or X++ code. You can have array elements too. Have a look
at the sample Advance Lamp Model in Demo Data, I hope you find your answers
there.
Everything thing gets embedded in the Model when you compile, and the forms
are loaded, you can control the display of elements on the form by Visible /
invisible properties, the model once compiled runs very well in Rich/ thin
client as well as Web.
But check on one thing that the sales ordered configured on the web using
Product builder doesn't get recorded as what was configured, so when you go
back to the rich client and open up the Sales order and check it you will
not find the configuration. I think this is a known bug not yet addressed.
Regards,
HK
James Flavell [EMAIL PROTECTED] wrote:
Hi I am not a true X++ programmer and need some guideance to see how user
entered X++ logic can be executed (like what can be done in the product
builder).
Is it need into some kind of AOT object or compiled and run on the fly? Is
there performance issue to worry abut?
Thanks
James
-Original Message-
From: Bayliss, Barry [mailto:[EMAIL PROTECTED]
Sent: 25 February 2005 17:00
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Dynamic form changes possible?
Hello James,
>From your original description of what you are trying to do, the
sysSetupFormRun class is unable to do what you want.
As you want the effect to be record based, you need to use the active()
method on the datasource. Alternatively, you can use a lower level
call.
By modifying Docu\reSearch, you can partially achieve what you are
trying to do. I have attached a word document given screen shots
showing the effect in action (using the below code modification to the
Docu class).
This is just a starting point for you. Let me know if you get stuck.
Barry.
void reSearch(FormRun formRun)
{
Common common;
FormDataSource formDataSource;
boolean notePressed;
FormDesign formDesign;
int t;
void disableNoteButton()
{
infolog.formNoteButton(false, false);
}
;
Standard code deleted
// If datasource has no name = not valid
formDataSource = common.dataSource();
if (common.RecId == 12358860) {
if (FormRun.design().controlName(btHide)) {
FormRun.design().controlName(btHide).visible(false);
}
} else {
if (FormRun.design().controlName(btHide)) {
FormRun.design().controlName(btHide).visible(True);
}
}
standard code deleted
}
-Original Message-
From: James Flavell [mailto:[EMAIL PROTECTED]
Sent: Saturday, 19 February 2005 12:51 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Dynamic form changes possible?
Thanks Carsten,
I have been debuggin alot in all these classes but I meant I could not
find
the line(s) of code that change the form layout (like what I managed to
find
for the security) even in the SysSaveSetup class.
I will go back and look some more.
Thanks for the job example I think that will make debugging a little
easier
Thanks a lot
James
-Original Message-
From: Carsten F. Frandsen [mailto:[EMAIL PROTECTED]
Sent: 16 February 2005 18:45
To: development-axapta@yahoogroups.com
Subject: SV: [development-axapta] Dynamic form changes possible?
There is another class SysSaveSetup which are used by the
SysSetupFormRun
class - SysSaveSetup class are used for saving and retrieving a user
defined
design...
Also SysSetupFormRun class are used by any form in Axapta - AFAIR it is
the
SysSetupFormRun class which actually executes the form !
Try entering the follwing job with a break-point - the use the debugger
to
investigate how the form is activated.
static void job1(Args _args)
{
Args args = new Args(formStr(InventItemGroup));
FormRun formRun;
;
formRun = ClassFactory::formRunClassOnClient(args); //
break-point
on this line.
formRun.init();
formRun.run();
formRun.wait();
}
HTH
Best regards
Carsten F. Frandsen
Fra: James Flavell [mailto:[EMAIL PROTECTED]
Sendt: ti 15-02-2005 14:42
Til: development-axapta@yahoogroups.com
Emne: RE: [development-axapta] Dynamic form chan
RE: [development-axapta] Dynamic form changes possible?
HI Barry,
Thanks for your help, I was under the impression the syssetup class was not
called a record level so was looking at other places like Docu and Common
(and am still poking around), thanks for the confirmation.
I think maybe the group posting does not allow attached docs so could you
send me the doc directly?
Thanks
James
-Original Message-
From: Bayliss, Barry [mailto:[EMAIL PROTECTED]
Sent: 25 February 2005 17:00
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Dynamic form changes possible?
Hello James,
>From your original description of what you are trying to do, the
sysSetupFormRun class is unable to do what you want.
As you want the effect to be record based, you need to use the active()
method on the datasource. Alternatively, you can use a lower level
call.
By modifying Docu\reSearch, you can partially achieve what you are
trying to do. I have attached a word document given screen shots
showing the effect in action (using the below code modification to the
Docu class).
This is just a starting point for you. Let me know if you get stuck.
Barry.
void reSearch(FormRun formRun)
{
Common common;
FormDataSource formDataSource;
boolean notePressed;
FormDesign formDesign;
int t;
void disableNoteButton()
{
infolog.formNoteButton(false, false);
}
;
Standard code deleted
// If datasource has no name = not valid
formDataSource = common.dataSource();
if (common.RecId == 12358860) {
if (FormRun.design().controlName(btHide)) {
FormRun.design().controlName(btHide).visible(false);
}
} else {
if (FormRun.design().controlName(btHide)) {
FormRun.design().controlName(btHide).visible(True);
}
}
standard code deleted
}
-Original Message-
From: James Flavell [mailto:[EMAIL PROTECTED]
Sent: Saturday, 19 February 2005 12:51 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Dynamic form changes possible?
Thanks Carsten,
I have been debuggin alot in all these classes but I meant I could not
find
the line(s) of code that change the form layout (like what I managed to
find
for the security) even in the SysSaveSetup class.
I will go back and look some more.
Thanks for the job example I think that will make debugging a little
easier
Thanks a lot
James
-Original Message-
From: Carsten F. Frandsen [mailto:[EMAIL PROTECTED]
Sent: 16 February 2005 18:45
To: development-axapta@yahoogroups.com
Subject: SV: [development-axapta] Dynamic form changes possible?
There is another class SysSaveSetup which are used by the
SysSetupFormRun
class - SysSaveSetup class are used for saving and retrieving a user
defined
design...
Also SysSetupFormRun class are used by any form in Axapta - AFAIR it is
the
SysSetupFormRun class which actually executes the form !
Try entering the follwing job with a break-point - the use the debugger
to
investigate how the form is activated.
static void job1(Args _args)
{
Args args = new Args(formStr(InventItemGroup));
FormRun formRun;
;
formRun = ClassFactory::formRunClassOnClient(args); //
break-point
on this line.
formRun.init();
formRun.run();
formRun.wait();
}
HTH
Best regards
Carsten F. Frandsen
Fra: James Flavell [mailto:[EMAIL PROTECTED]
Sendt: ti 15-02-2005 14:42
Til: development-axapta@yahoogroups.com
Emne: RE: [development-axapta] Dynamic form changes possible?
Thanks Carsten,
I have been trying to make some sense of the SysSetupFrom classes but
still
dont seem to be able to find where the code for hidding a control the
user
has hidden previously is (i.e. where is it that the users setup gets
applied
to the form), any chance you could give me somewhere where I can see it
in
action?
I spotted in SysSecurityFormSetup.loadSecurity some examples of the
security
settings being applied, such as:
formControl =
SysSecurityFormSetup::getFormControl(_formRun,
mapIterator.key());
formControl.userSecurityLevel(accessType + 1);
which gives me an idea of how I can control the form using access right
levels but I think I want to know how to control the form via direct
enable/disable (partly I am not sure if I use access rights whether I
need
to do some processor intensive 'redraw' of the form??? the access
to
the controls will change with each record the user selects or modifies
so I
need I think I need to be careful not to make a hog of a solution ...)
Thanks
James
-Original Message-
From: Carsten F. Frandsen [mailto:[EMAIL PROTECTED]
Sent: 15 February 2005 18:09
To: development-axapta@yahoogroups.com
Subject: SV: [development-axapta] Dynamic form changes possible?
Take a look at the class SysSetupFormRun
This class is used to e.g. retrieve a user defined design for a form...
Regards
Carsten F. Frandsen
Fra: James Flavell [mailto:[EMAIL PROTECTED]
Sendt: ti 15-02-2005 01:15
Til: development-axapta@yahoogroups.com
Emne: RE: [development-axa
[development-axapta] Product builder, how to execute user entered X++
Hi I am not a true X++ programmer and need some guideance to see how user
entered X++ logic can be executed (like what can be done in the product
builder).
Is it need into some kind of AOT object or compiled and run on the fly? Is
there performance issue to worry abut?
Thanks
James
-Original Message-
From: Bayliss, Barry [mailto:[EMAIL PROTECTED]
Sent: 25 February 2005 17:00
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Dynamic form changes possible?
Hello James,
>From your original description of what you are trying to do, the
sysSetupFormRun class is unable to do what you want.
As you want the effect to be record based, you need to use the active()
method on the datasource. Alternatively, you can use a lower level
call.
By modifying Docu\reSearch, you can partially achieve what you are
trying to do. I have attached a word document given screen shots
showing the effect in action (using the below code modification to the
Docu class).
This is just a starting point for you. Let me know if you get stuck.
Barry.
void reSearch(FormRun formRun)
{
Common common;
FormDataSource formDataSource;
boolean notePressed;
FormDesign formDesign;
int t;
void disableNoteButton()
{
infolog.formNoteButton(false, false);
}
;
Standard code deleted
// If datasource has no name = not valid
formDataSource = common.dataSource();
if (common.RecId == 12358860) {
if (FormRun.design().controlName(btHide)) {
FormRun.design().controlName(btHide).visible(false);
}
} else {
if (FormRun.design().controlName(btHide)) {
FormRun.design().controlName(btHide).visible(True);
}
}
standard code deleted
}
-Original Message-
From: James Flavell [mailto:[EMAIL PROTECTED]
Sent: Saturday, 19 February 2005 12:51 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Dynamic form changes possible?
Thanks Carsten,
I have been debuggin alot in all these classes but I meant I could not
find
the line(s) of code that change the form layout (like what I managed to
find
for the security) even in the SysSaveSetup class.
I will go back and look some more.
Thanks for the job example I think that will make debugging a little
easier
Thanks a lot
James
-Original Message-
From: Carsten F. Frandsen [mailto:[EMAIL PROTECTED]
Sent: 16 February 2005 18:45
To: development-axapta@yahoogroups.com
Subject: SV: [development-axapta] Dynamic form changes possible?
There is another class SysSaveSetup which are used by the
SysSetupFormRun
class - SysSaveSetup class are used for saving and retrieving a user
defined
design...
Also SysSetupFormRun class are used by any form in Axapta - AFAIR it is
the
SysSetupFormRun class which actually executes the form !
Try entering the follwing job with a break-point - the use the debugger
to
investigate how the form is activated.
static void job1(Args _args)
{
Args args = new Args(formStr(InventItemGroup));
FormRun formRun;
;
formRun = ClassFactory::formRunClassOnClient(args); //
break-point
on this line.
formRun.init();
formRun.run();
formRun.wait();
}
HTH
Best regards
Carsten F. Frandsen
Fra: James Flavell [mailto:[EMAIL PROTECTED]
Sendt: ti 15-02-2005 14:42
Til: development-axapta@yahoogroups.com
Emne: RE: [development-axapta] Dynamic form changes possible?
Thanks Carsten,
I have been trying to make some sense of the SysSetupFrom classes but
still
dont seem to be able to find where the code for hidding a control the
user
has hidden previously is (i.e. where is it that the users setup gets
applied
to the form), any chance you could give me somewhere where I can see it
in
action?
I spotted in SysSecurityFormSetup.loadSecurity some examples of the
security
settings being applied, such as:
formControl =
SysSecurityFormSetup::getFormControl(_formRun,
mapIterator.key());
formControl.userSecurityLevel(accessType + 1);
which gives me an idea of how I can control the form using access right
levels but I think I want to know how to control the form via direct
enable/disable (partly I am not sure if I use access rights whether I
need
to do some processor intensive 'redraw' of the form??? the access
to
the controls will change with each record the user selects or modifies
so I
need I think I need to be careful not to make a hog of a solution ...)
Thanks
James
-Original Message-
From: Carsten F. Frandsen [mailto:[EMAIL PROTECTED]
Sent: 15 February 2005 18:09
To: development-axapta@yahoogroups.com
Subject: SV: [development-axapta] Dynamic form changes possible?
Take a look at the class SysSetupFormRun
This class is used to e.g. retrieve a user defined design for a form...
Regards
Carsten F. Frandsen
Fra: James Flavell [mailto:[EMAIL PROTECTED]
Sendt: ti 15-02-2005 01:15
Til: development-axapta@yahoogroups.com
Emne: RE: [development-axapta] Dynamic form changes possible?
Thanks Mal
