[Axapta-Knowledge-Village] Invoice account vs order account in AR.
Hi, We need to implement the concept of an umbrella account in Axapta. This means that we have a big customer that has many accounts with us. Every account gets its own set of invoices and statement at the end of the month. What we however want to do is also provide the customer with a statement and related invoices for the consolidated head office account (the umbrella account). Also, when we look at our top 100 customers we would like Axapta to look at the value of the umbrella account instead of at the individual accounts. My question is this: Is the invoice account/order account fields the correct place to implement this? It seems to me as if all transactions and all invoices lie against the invoice account even if you post to the order account. Can someone please shed some light on this for me? Thanks, Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] One-time suppliers
Hi all, What is the real significance of making a supplier a one-time supplier? Are there any functionality that works differently? It seems as if AX allows you to post multiple invoices in different periods to a one-time vendor which kind of defeats the meaning of the word one-time supplier. Also, are there any pitfalls when converting a one-time supplier to a regular recurring supplier? Thanks, Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Sales groups/teams
Hi all, I am looking at implementing sales commission in the AR module in Axapta. Requirement is that Sales Reps (Employees in the HR module) should be grouped into sales teams. This is no problem in Axapta and get stored in table.CommissionSalesRep and table.CommissionSalesGroup. Further requirement is that sales reps / sales teams should have targets assigned to them and there will be appraisals/councelling based on the sales targets and whether you reach them or not. This can be done in the CRM module and gets managed in table.smmSalesTargets and table.smmSalesUnit and table.smmSalesUnitMembers (the sales unit members again coming from the HR module). As far as I can ascertain, however, this CRM tables do not get used anywhere else in Axapta than just in a very isolated fashion in CRM. Are there any links between A) The CRM sales units accompanying sales rep targets AND B) The Accounts Receivable module the commission sales rep groups on which sales commission is based. Or are sales units in CRM entirely different form sales rep groups in Sales Ledger? Did anyone ever attempted to join the two and intergrate sales targets into commission? Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Sales groups/teams
Hi all, I am looking at implementing sales commission in the AR module in Axapta. Requirement is that Sales Reps (Employees in the HR module) should be grouped into sales teams. This is no problem in Axapta and get stored in table.CommissionSalesRep and table.CommissionSalesGroup. Further requirement is that sales reps / sales teams should have targets assigned to them and there will be appraisals/councelling based on the sales targets and whether you reach them or not. This can be done in the CRM module and gets managed in table.smmSalesTargets and table.smmSalesUnit and table.smmSalesUnitMembers (the sales unit members again coming from the HR module). As far as I can ascertain, however, this CRM tables do not get used anywhere else in Axapta than just in a very isolated fashion in CRM. Are there any links between A) The CRM sales units accompanying sales rep targets AND B) The Accounts Receivable module the commission sales rep groups on which sales commission is based. Or are sales units in CRM entirely different form sales rep groups in Sales Ledger? Did anyone ever attempted to join the two and intergrate sales targets into commission? Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Axapta business connector
Hi all, Can the business connector be run in 2-tier mode? Regards, Hennie Hennie Potgieter-Senior Business Analyst UTi |cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061South Africa [EMAIL PROTECTED]| O (+27)12 673 2340| F (+27)12 673 2344 Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Axapta business connector
Hi all, Can the business connector be run in 2-tier mode? Regards, Hennie Hennie Potgieter-Senior Business Analyst UTi |cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061South Africa [EMAIL PROTECTED]| O (+27)12 673 2340| F (+27)12 673 2344 Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Peformance Issues
Hi, Have a look at http://www.sql-server-performance.com/gv_clustered_indexes.asp As you can see, clustered indexes are an absolute necessity (unless maybe for tables with LOTS of update statements and few inserts/deletes). I also assume you are not doing credit limit checking as part of the posting of a sales order because this is known to be slow. Hennie Hennie Potgieter-Senior Business Analyst UTi |cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061South Africa [EMAIL PROTECTED]| O (+27)12 673 2340| F (+27)12 673 2344 From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: 14 December 2005 12:35 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Peformance Issues Thanks! My next step is to use the code profiler. The thing that is strange, is that just last week it was performing fine, and there have been Zero code changes to the code in the area that is starting to perform slower - which is pretty much all SalesFormLetter classes / processes (The entire Sales Life Cycle slowed down the past two days). Anyway I will continue to see what I can find out and keep everyone posted. I know that we will be able to figure this out, I was just trying to get some fresh minds giving me some fresh ideas. Thanks! -Brandon From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: Wednesday, December 14, 2005 1:47 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Peformance Issues Hi Brandon, We also had major performance problems on our Axapta v3sp2 installation. Our biggest problem area was Sales Ledger / Account Receivable. We definitely found that adding clustered indexes to a number of the most heavily used tables improved performance by quite a lot. Troubleshooting Axapta performance unfortunately is quite a tedious process and you will have to identify the key processes that are slow and need to be improved. While troubleshooting a process a few weeks ago, I found the Code Profiler to be quite valuable since you can see exactly where the problem lies and then either make a code or an index change. I found the SQL Index tuning wizard to be not that valuable since it does not pinpoint the exact problem in the way that the code profiler does. Good luck, Hennie Hennie Potgieter-Senior Business Analyst UTi |cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061South Africa [EMAIL PROTECTED]| O (+27)12 673 2340| F (+27)12 673 2344 From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: 14 December 2005 02:14 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Peformance Issues I have been researching, and done as much as I can with indexes / indices. I have added some to a couple of Axapta Tables, that according to SQL Index Tuning Wizard should improve overall performance by 18%. This will be some what of a boost, but not quite the at least 25% I was hoping for. Also I have un-checked the initialize for unicode' in the Configuration. I did, come across this is a forum post: -AOS=hostIPaddress:port The user said that they added as part of the command line parameters? I am wondering what does this do? Anyway I am hoping that someone can give me some more feedback as to what I can do to help improve things. I have re-indexed everything, synchronized everything, etc. etc. -Brandon From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: Tuesday, December 13, 2005 3:54 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Peformance Issues Hello All, I was wondering if anyone has ever came across using the Clustered Index and Primary Index property fields of an Axapta table? Do setting these help performance at all? We this week just started having issues with performance and Axapta. I have been running performance analyzer on SQL server and it seems as though the page life expectancy has dropped from an avg. values in secs. of 5200 down to 1650. This is the only real indication of the problem we are seeing. All the rest of the SQL related performance items are doing just about the same. The page life expectancy counter tells you, on average, how long data pages are staying in the buffer. The higher the number the better. Dropping number here means more memory is having to be used, and accessed more frequently. Anyway I am puzzled, and I am trying to find out the best way to address this, as the memory in our SQL server is more than enough. I was wondering
RE: [Axapta-Knowledge-Village] Peformance Issues
Hi Brandon, We also had major performance problems on our Axapta v3sp2 installation. Our biggest problem area was Sales Ledger / Account Receivable. We definitely found that adding clustered indexes to a number of the most heavily used tables improved performance by quite a lot. Troubleshooting Axapta performance unfortunately is quite a tedious process and you will have to identify the key processes that are slow and need to be improved. While troubleshooting a process a few weeks ago, I found the Code Profiler to be quite valuable since you can see exactly where the problem lies and then either make a code or an index change. I found the SQL Index tuning wizard to be not that valuable since it does not pinpoint the exact problem in the way that the code profiler does. Good luck, Hennie Hennie Potgieter-Senior Business Analyst UTi |cnr Olievenhoutbush Brakfontein Rd | Centurion | Gauteng | 0061South Africa [EMAIL PROTECTED]| O (+27)12 673 2340| F (+27)12 673 2344 From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: 14 December 2005 02:14 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Peformance Issues I have been researching, and done as much as I can with indexes / indices. I have added some to a couple of Axapta Tables, that according to SQL Index Tuning Wizard should improve overall performance by 18%. This will be some what of a boost, but not quite the at least 25% I was hoping for. Also I have un-checked the initialize for unicode' in the Configuration. I did, come across this is a forum post: -AOS=hostIPaddress:port The user said that they added as part of the command line parameters? I am wondering what does this do? Anyway I am hoping that someone can give me some more feedback as to what I can do to help improve things. I have re-indexed everything, synchronized everything, etc. etc. -Brandon From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: Tuesday, December 13, 2005 3:54 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Peformance Issues Hello All, I was wondering if anyone has ever came across using the Clustered Index and Primary Index property fields of an Axapta table? Do setting these help performance at all? We this week just started having issues with performance and Axapta. I have been running performance analyzer on SQL server and it seems as though the page life expectancy has dropped from an avg. values in secs. of 5200 down to 1650. This is the only real indication of the problem we are seeing. All the rest of the SQL related performance items are doing just about the same. The page life expectancy counter tells you, on average, how long data pages are staying in the buffer. The higher the number the better. Dropping number here means more memory is having to be used, and accessed more frequently. Anyway I am puzzled, and I am trying to find out the best way to address this, as the memory in our SQL server is more than enough. I was wondering if anyone has any suggestions, as my eye's are getting tired from looking at the same data and not coming up with anything new thanks in advance -Brandon Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Consignment (3rd party) stock
Hi all, Can Axaptas inventory model and financials handle consignment / 3rd party stock items? I cannot find anything that looks like consignment stock in the inventory module. Can anyone please give me any pointers on this? Regards, Hennie Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Axapta Demo Installation Error : 1602
Title: Message Check your AOS log file for clues. More often than not it is DB connectivity (DSN names, server name etc.). Also check for stuff like port clashes and application directory. Hennie _ Hennie Potgieter - Senior Axapta Business Analyst UTi Sun Couriers Division | Cnr Olievenhout Rd Brakfontein Rd, Centurion, 0061 [EMAIL PROTECTED] | O 012-6732340 | F 012-6732344 -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Pushpa BherwaniSent: Tuesday, 11 October 2005 15:17 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Axapta Demo Installation Error : 1602 hi Thanks a lot for the help I have installed AOS Its running in Services but through Control Panel it shows status as Stopped and when I start it , it again goes Stopped within seconds What could be the reason ? Thanks Pushpa Lalith Jayantha [EMAIL PROTECTED] wrote: HiYou need to install Aos. its in axapta installationCD.Lalith --- Pushpa Bherwani [EMAIL PROTECTED]wrote: Hi Thanks for the reply That gave me a clue what is to be done but i m still not getting the actual way firstly i have a confusion regarding AOS Does it need some separate installation or what ?? I have installed MSDE and Microsoft Axapta 3.0 SP3 demo so do i need something else to get AOS coz i can't see AOS service manager running in my machine's services ...Plz answer this. Girish Bhatkal [EMAIL PROTECTED] wrote: in the axapta configuration you set the application path (system directory). here you give the path of the application (in your case it would be the path where the application is set on server B).make sure that you give the proper access rights for the application folder on server B and see that the folder can be accessed from machine A. i hope you are looking for this answer? --- Pushpa Bherwani [EMAIL PROTECTED] wrote: Hi I have now created a new database in my server and noe I can run Axapta Demo through that dsn. Anyhow its working Thanks to all for the help But can someone tell me that if I have Axapta running on some machine say Server A and my application is in some client machine say Machine B then how can I logon to Axapta which is o Machine A through my application which is on Machine BThanks I hope someone will come with a solution Pushpa Hi, Can you check whether the AOS is running. Control Panel Navision Axapta Object Server. Check what is the AOS name, and also check your 3-tier configuration the Client tab. HKLalith Jayantha [EMAIL PROTECTED] wrote:Hi can you run the axapta without server in 2tire Lalith --- Pushpa [EMAIL PROTECTED] wrote: Hi I am getting the following error ahile installing Axapta Demo Server not found : 1602 I have server and application on same machine. The strange thing is that I first installed demo which ran smoothly for 2-3 days and then suddenly in stopped working giving "server notfound" errro , I am using the local as server I reinstalled it but now its not working on my system. Please help me to sort out this. Thanks Pushpa __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com - Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! India Matrimony: Find your partner now. ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finan
[Axapta-Knowledge-Village] Fixed asset acquisition adjustment
Title: Message Hi all, Can someone please help me understand this I have a fixed asset in my Asset Book (GL Fixed Assets). When I look at the asset's value model under the General tab, there is an acquisition price and date. I need to make an adjustment to an asset's acquisition priceand want to know if this is the correct place to make such an adjustment? Would this form take my changes all the way through to the General Ledger fixed asset accounts or does this only affect the asset register? I found that I can also create a new fixed asset journal (under GL Journals Fixed Asset) that can be of type "Acquisition adjustment". This will surely post to the relevant GL accounts as set up under fixed asset posting profiles. Will this be carried through to the asset book? My 2 questions are basically: 1. What is the difference between the above mentioned ways of adjusting acquisition price and what is the correct way of doing it? 2. How will an adjustment inacquisition price affect the depreciation of the asset if it is in the middle of its life cycle and you adjust the acquisition price? Will it update the depreciation amount of past depreciation cycles? Regards, Hennie _____ Hennie Potgieter - Senior Axapta Business Analyst UTi Sun Couriers Division | Cnr Olievenhout Rd Brakfontein Rd, Centurion, 0061 [EMAIL PROTECTED] | O 012-6732340 | F 012-6732344 Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] QueryBuildRange value
Title: Message Hi all, I encountered the following code in my application: qr.query().dataSourceNo(2).rangeField(fieldNum(CustInvoiceJour, TaxInvoiceNo)).value('!?*'); Can anyone please explain to me what the value('!?*') means? I suspect is specifies a null? Is this the only/simplest way of specifying null in a query range value or is there something simpler? Hennie _ Hennie Potgieter - Senior Axapta Business Analyst UTi Sun Couriers Division | Cnr Olievenhout Rd Brakfontein Rd, Centurion, 0061 [EMAIL PROTECTED] | O 012-6732340 | F 012-6732344 Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] SQL Ram Usage
Hi Cenk, Make sure that the PAE (Physical Address Extensions) and 3GB properties are set in your boot.ini file on the server and then reboot. Hennie -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Cenk Ince Sent: Thursday, 01 September 2005 13:06 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SQL Ram Usage Hi all; I have a problem with SQL 2000. When i run Axapta i can't use more ram than 1,826,000 MB. I thougth that it was because it is Standard Edition. Then i created a test env. and Setup an Enterprise SQL 2000. But i can't still use more than 1,826,000 MB ram. Is there a solution for this. Thanks. Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Help Sudanese refugees rebuild their lives through GlobalGiving. http://us.click.yahoo.com/hjNroD/EbOLAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Any Idea abou this?
Title: Message Hi, I changed the alignment of this EDT once (by accident). It caused quite a bit of chaos since Axapta could not find any of its GL accounts and as a result posted all transactions to the "System Error Account" account. Hennie -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ANIL OZAYSent: Wednesday, 31 August 2005 08:59 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Any Idea abou this? Hi Subbu, Yes, you can check EDT, or anybody has changed it from Adjust Global Types on Administration/Setup/System/Adjust Global Types. Regards, Anil Ozay From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan DeshpandeSent: Wednesday, August 31, 2005 9:26 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Any Idea abou this? hi subbu check the property on the extended data type regards harry "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi, I am wondering if you guys know of this. Why is the field 'AccountNum' is right aligned and why not 'Left aligned'?. Does what factor judge alignment property?. Because this has significant effect in 'select' statements if I use AccountNum as Index. Any help is highly appreciated, Thanks Regards, subbu Start your day with Yahoo! - make it your home page Start your day with Yahoo! - make it your home page Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz.This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Sending email automatically in Axapta
Title: Message Hi, We also mail PDF documents from Axapta and it works like a dream. Try using the SysMailer Class instead of SysInetMail. SysMailer mailer; ; mailer = new SysMailer(); try { mailer.fromAddress(emplTable.Email);mailer.fromName(emplTable.Name);mailer.subject("Hallo World"); custEmailAddress = custTable::find(.); mailer.tos().add(custEmailAddress); mailer.body("Attached please find documents for period " + date2str(beginDate,123,2,1,3,1,4) + " to " + date2str(endingDate,123,2,1,3,1,4)); mailer.SMTPRelayServers().add(SysEmailParameters::find().SMTPRelayServerName, SysEmailParameters::find().SMTPPortNumber, SysEmailParameters::find().SMTPServerIPAddress, SysEmailParameters::find().SMTPUserName, SysEmailParameters::find().SMTPPassword); mailer.attachments().add(File); mailer.sendMail();} catch (Exception::Error) { .. } Hope this helps Hennie -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Huseyin AkdagSent: Friday, 19 August 2005 11:23 AMTo: development-axapta@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Sending email automatically in Axapta Hi all, I am trying to create a batch job which should send some Reports as PDF file per Mail daily. The problem is, The job can generate this file , and attach to Email this file but cant send the mail automatically. After calling the SendAttachment method , Outlook window is opened. And I must click to send Button in this Window . But I want to send this mail without a Confirmation or manual handling. I am using SysInetMail class. Is there any other way to send it automatically? Regards.. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] XPO import some properties missed out
Title: Message Hi all, We also struggle with this inconsistencies in the XPO import. I specifically found that hidden ranges on reports do not import correctly. Sometimes a second import fixes it, but I have a few reports where I had to add the hidden range in the live env. Hennie -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James FlavellSent: Thursday, 11 August 2005 04:09 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] XPO import some properties missed out Thanks Steve, I guess it is something will have to live with and just try to look out for anything that helps ease the pain...has anyone modified the import to do the import more than once??? Thanks James -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve WrightSent: 11 August 2005 11:32To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] XPO import some properties missed out Hi James I am not sure about a pattern. Just the other day another partner sent me a .xpo. I imported into a clean copy of Axapta SP4 - this had no other customisation. Some columns on the table were excluded and therefore there were compile errors (of course). I could see the missing columns using Windows notepad but they did not import until I repeated the .xpo import. This was running axapta sp4 locally on my laptop - 2 tier. Steve. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Re: Posting Memory Leak
Hi Vaibhav, The leak only becomes problematic after posting around 3500 sales orders. Hennie -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of vaibhav pednekar Sent: Thursday, 28 July 2005 17:10 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Re: Posting Memory Leak hi all, I will put my case here -- i also have an interface for importing the sales transactions into temporary table for posting the sales orders in axapta. i use a Axapta definition group of Custom type to import the sales transactions into the temp table. in my case, there are 250 Shops, and the average transactions are around 1 recs per month per shop, and the process what i designed is importing per shop and Posting per shop. When posted it will create one sales order per day and post invoice. till now i havent faced any problems, but if any of you have already experienced such case and have faced any situations which need attention, then please do let me know. Thank you regards vaibhav Microsoft Business Solutions - Axapta Application Certified Master --- austinsoftware [EMAIL PROTECTED] wrote: We have the same issue; the fix may have helped a little, but ultimately the memory leak still exists. To work around the issue we have to limit the amount of data we load at one time, then close and reopen Axapta to free the leaked memory. We rearchitected our import class so that it could handle multiple instances running at the same time, and limit each instance to no more than 10MB of EDI data (which is read into a staging table then posted). The amount of data, SOs, Lines you can do at one time will be dependent on your exact machine and SO configuration, so you'll have to determine what the safe number is for your appilcation. For large loads we'll run 3 instance on each of 2 machines with FAT connections to get the data loaded. In our busiest invoicing period, we have to do it twice. The rest of the year 1 iteration of 1 to 6 instances will do it. --- In Axapta-Knowledge-Village@yahoogroups.com, Hennie Potgieter [EMAIL PROTECTED] wrote: Hi Kim, We do have the SmartHeapMemorySizeUp() in our Info.Startup method exactly as you describe and the problem still occurs after 3500 odd sales orders posted from 1 client. Hennie -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Kim Truelsen Sent: Tuesday, 26 July 2005 13:06 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Posting Memory Leak In Sp3 we made a change in Classes / Info / Startup. Please implement that change and hopefully your problem is gone. void startup(str startupCommand) { this.docuInit(); if (xGlobal::clientKind() != ClientType::Server) SmartHeapMemorySizeUp(); Med venlig hilsen / Best regards Kim Truelsen Escalation Engineer Microsoft Business Solutions Axapta EMEA Global Technical Support Center Direct / mobile: +45 4489 0786 / +45 29499958 E-mail: mailto:[EMAIL PROTECTED]@microsoft.com [EMAIL PROTECTED] Online support at: BLOCKED::http://www.microsoft.com/support www.microsoft.com/support MBS Partnersource at: BLOCKED::http://www.microsoft.com/BusinessSolutions/PartnerSource/de fau lt.mspx www.microsoft.com/BusinessSolutions/PartnerSource/default.mspx Security Updates at: BLOCKED::http://www.microsoft.com/protect www.microsoft.com/protect BLOCKED::http://www.microsoft.dk/ Microsoft Denmark Tuborg Boulevard 12 DK-2900 Hellerup Phone:+45 4489 0100 / Fax: +45 4468 5510 _ If you have any feedback about my work, please let either myself or my manager Kenneth Stubban know at BLOCKED::mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] or telephone +45 4489 0784 Note: This email may contain confidential information. If you are not named on the addressee list, please take no action in relation to this email, do not open any attachment and please contact the sender (details above) immediately. _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: 26. juli 2005 13:00 To: Axapta-Knowledge-Village@yahoogroups.com Cc: Edine Le Roux Subject: [Axapta-Knowledge-Village] Posting Memory Leak Hi, We are still experiencing problems with the standard sales order posting process in Axapta v3 SP2. It seems as if the standard posting routine in Axapta has a memory leak that causes Ax32.exe to crash with an out of memory error. Has anyone of you experienced this before and do you have any recommendations for us in this regard? The details are as follows: We get the SmartHeap Out
RE: [Axapta-Knowledge-Village] Re: Posting Memory Leak
Hi Austin, I am working with Edine (axapta123456) on this. We have already carried out the MemSizeUp due to previous memory issues (as she mentions at the end of the post). This is not the issue. The problem is that we have identified that there are definitely memory leaks in the posting process leading to a leak of (on average) 150k with each call to SalesFormLetter.post(), which we did not notice previously due to the fact that our posting pattern was different. Basically things have changed as follows due to changed business requirements: Before: -Import batches of 500 Sales Orders into parm tables -Post all 500 simultaneously Now -Import a single invoice 'realtime' -Post the invoice As a result, when posting all 2 invoices using the old method, we would only leak 2/500*150k = 6000k = about 6Mb, which is by no means trivial, but small enough to not cause leak problems too often (though in retrospect some of our memory issues now make sense. Now when importing 2 invoices we are leaking 2*150k = 300k = about 3Gb! We are currently running into issues after 3500 invoices, which leaks about 500M, which matches the behaviour on Edine's machine. We are aware that the SmartHeap garbage collector may eventually reclaim some of this memory, but by that time we have already experienced out of memory issues, ie Axapta has already crashed. Our requirements are that we need to import single invoices and post them immediately and return the generated voucher numbers. This, combined with the fact that we cannot have entire batch postings failing due to one invalid invoices means that we cannot stick to a batched approach of any kind. We MUST have a 1-1 relation between invoices and posts. What we want to know is if anyone has written any code to fix this leak, or if anyone knows how to fix this. Regards, Hennie -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of austinsoftware Sent: Tuesday, 26 July 2005 20:18 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Posting Memory Leak We have the same issue; the fix may have helped a little, but ultimately the memory leak still exists. To work around the issue we have to limit the amount of data we load at one time, then close and reopen Axapta to free the leaked memory. We rearchitected our import class so that it could handle multiple instances running at the same time, and limit each instance to no more than 10MB of EDI data (which is read into a staging table then posted). The amount of data, SOs, Lines you can do at one time will be dependent on your exact machine and SO configuration, so you'll have to determine what the safe number is for your appilcation. For large loads we'll run 3 instance on each of 2 machines with FAT connections to get the data loaded. In our busiest invoicing period, we have to do it twice. The rest of the year 1 iteration of 1 to 6 instances will do it. --- In Axapta-Knowledge-Village@yahoogroups.com, Hennie Potgieter [EMAIL PROTECTED] wrote: Hi Kim, We do have the SmartHeapMemorySizeUp() in our Info.Startup method exactly as you describe and the problem still occurs after 3500 odd sales orders posted from 1 client. Hennie -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Kim Truelsen Sent: Tuesday, 26 July 2005 13:06 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Posting Memory Leak _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: 26. juli 2005 13:00 To: Axapta-Knowledge-Village@yahoogroups.com Cc: Edine Le Roux Subject: [Axapta-Knowledge-Village] Posting Memory Leak Hi, We are still experiencing problems with the standard sales order posting process in Axapta v3 SP2. It seems as if the standard posting routine in Axapta has a memory leak that causes Ax32.exe to crash with an out of memory error. Has anyone of you experienced this before and do you have any recommendations for us in this regard? The details are as follows: We get the SmartHeap Out of Memory error when trying to import and post individual sales orders from an external system. The invoices get imported into Axapta and then posted. This posting happens on a per sales order basis. (Import 1 sales order from the external system into the temporary posting tables and then post the sales order) We suspect that this is due to a memory leak in the Axapta standard posting process. (Class.SalesFormLetter). For each sales order that is posted, a certain amount of memory is allocated (as can be seen in the Windows task manager) and added to the total memory usage of the Ax32 process. Only a small amount of the added memory is released after the posting process. This cause the total
[Axapta-Knowledge-Village] CRM Sales units
Title: Message Hi, Can anyone please give me some info on the use of sales units in CRM. I believe that it can be quite valuable in management reporting by sales unit / team and have set the sales units up accordingly. It seems however as if very few reports actually has smmSalesUnit as a datasource (Sales Targets seems to be the only one) and are able to report off it. Do you have to customize your reports to be able to report / filter per sales unit? regards, Hennie -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Posting Memory Leak
Title: Message Hi, We are still experiencing problems with the standard sales order posting process in Axapta v3 SP2. It seems as if the standard posting routine in Axapta has a memory leak that causes Ax32.exe to crash with an out of memory error. Has anyone of you experienced thisbefore and do you have any recommendations for us in this regard? The details are as follows: We get the SmartHeap Out of Memory error when trying to import and post individual sales orders from an external system.The invoices get imported into Axapta and then posted. This posting happens on a per sales order basis. (Import 1 sales order from the external system into the temporary posting tables and then post the sales order) Wesuspect that this is due to a memory leak in the Axaptastandard posting process.(Class.SalesFormLetter). For each sales order that is posted, a certain amount of memory is allocated(as can be seen in the Windows task manager) and added to the total memory usage of the Ax32 process. Only a small amount of the added memory is releasedafter the posting process. This cause the total memory usage of the Ax32 process to keep growing. (Typical memory leak behaviour). This causesthe SmartHeap Out of Memory error after a variable amount(about 3500) ofsales orders were posted. We have tracked this down to the SalesFormLetter.post() instruction in Axapta. The posting is run from a client PC and the error occurs in both 2 and 3-tier mode. The standard Axapta posting procedure, in SalesFormLetter.run(), is called for eachsales order imported. (The code causes the memory leak). The SmartHeapMemorySizeUp() value has been set. Do anyone have any suggestions in this regard? Regards, -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Posting Memory Leak
Title: Message Hi Kim, We do have the SmartHeapMemorySizeUp()in our Info.Startup method exactly as you describe and the problem still occurs after 3500 odd sales ordersposted from 1 client. Hennie -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Kim TruelsenSent: Tuesday, 26 July 2005 13:06 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Posting Memory Leak In Sp3 we made a change in Classes / Info / Startup. Please implement that change and hopefully your problem is gone. void startup(str startupCommand) { this.docuInit(); if (xGlobal::clientKind() != ClientType::Server) SmartHeapMemorySizeUp(); Med venlig hilsen / Best regardsKim TruelsenEscalation EngineerMicrosoft Business Solutions AxaptaEMEA Global Technical Support CenterDirect / mobile: +45 44890786 / +45 29499958E-mail: [EMAIL PROTECTED] Online support at: www.microsoft.com/support MBS Partnersource at: www.microsoft.com/BusinessSolutions/PartnerSource/default.mspx Security Updates at: www.microsoft.com/protect Microsoft Denmark Tuborg Boulevard 12DK-2900 HellerupPhone:+45 4489 0100 / Fax: +45 4468 5510 If you have any feedback about my work, please let either myself or my manager Kenneth Stubban know at [EMAIL PROTECTED] or telephone +45 4489 0784Note: This email may contain confidential information. If you are not named on the addressee list, please take no action in relation to this email, do not open any attachment and please contact the sender (details above) immediately. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie PotgieterSent: 26. juli 2005 13:00To: Axapta-Knowledge-Village@yahoogroups.comCc: Edine Le RouxSubject: [Axapta-Knowledge-Village] Posting Memory Leak Hi, We are still experiencing problems with the standard sales order posting process in Axapta v3 SP2. It seems as if the standard posting routine in Axapta has a memory leak that causes Ax32.exe to crash with an out of memory error. Has anyone of you experienced thisbefore and do you have any recommendations for us in this regard? The details are as follows: We get the SmartHeap Out of Memory error when trying to import and post individual sales orders from an external system.The invoices get imported into Axapta and then posted. This posting happens on a per sales order basis. (Import 1 sales order from the external system into the temporary posting tables and then post the sales order) Wesuspect that this is due to a memory leak in the Axaptastandard posting process.(Class.SalesFormLetter). For each sales order that is posted, a certain amount of memory is allocated(as can be seen in the Windows task manager) and added to the total memory usage of the Ax32 process. Only a small amount of the added memory is releasedafter the posting process. This cause the total memory usage of the Ax32 process to keep growing. (Typical memory leak behaviour). This causesthe SmartHeap Out of Memory error after a variable amount(about 3500) ofsales orders were posted. We have tracked this down to the SalesFormLetter.post() instruction in Axapta. The posting is run from a client PC and the error occurs in both 2 and 3-tier mode. The standard Axapta posting procedure, in SalesFormLetter.run(), is called for eachsales order imported. (The code causes the memory leak). The SmartHeapMemorySizeUp() value has been set. Do anyone have any suggestions in this regard? Regards, -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] CRM Sales units
Title: Message Hi, Can anyone please give me some info on the use of sales units in CRM. I believe that it can be quite valuable in management reporting by sales unit / team and have set the sales units up accordingly. It seems however as if very few reports actually has smmSalesUnit as a datasource (Sales Targets seems to be the only one) and are able to report off it. Do you have to customize your reports to be able to report / filter per sales unit? regards, Hennie -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] SOX compliance of Axapta
Title: Message Hi Subbu, SARBOX or SOX is the abbreviated form for the Sarbanes-Oxley Act. This is a set of COBIT (Control Objectives for Information Technology) guidelines that all companies that are noted on a USA stock exchange should pass in order to get a favourable (unqualified) audit report at the end of the financial year. Search google for sarbanes-oxley. There are 6 million odd pages to get you started. Regards, Hennie -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, MamidiSent: Thursday, 14 July 2005 15:50 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] SOX compliance of Axapta Hi Hennie, I really don;t know what SARBOX audit. I guess its something I should be aware of. 1. what is SARBOX audit? 2. Why is it needed for a Axapta partner? I hear that we have an upcoming auditBut not sure if its SARBOX. Can you please inform me if I need to learn something ?. Appreciate your help. Thanks Regards, subbu Hennie Potgieter [EMAIL PROTECTED] wrote: Hi,We just went through a massive worldwide SARBOX audit and in myself andour auditors' opinion, Axapta is not SOX compliant. We did pass theaudit however because of the implementation of a number of mitigatingcontrols. Some of the issues were:1. Source version control and project locking in Axapta isinsufficient.2. Development tools need to be enabled in live environment to be ableto import XPO's from test environment. This was a major problem.3. The fact that projects (XPO's) need to be recompiled in the liveenvironment after importing (you may not recompile code in live)4. Axapta does'nt automatically force a password change after firstlogon when the Administrator resets your password.5. Passwords can be cleared through the database.6. Data model changes are made by developers through the AOS and notthe DBA.These were only some of the issues/shortcomings that came up. Cannotthink of everything right now. Ironic thing is that in 1995 the USA proclaimed the "Paper ReductionAct" and now with SARBOX additional, filed paperwork with signoffs forjust about everything is encouraged.Hennie-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com[mailto:[EMAIL PROTECTED] On Behalf Oframyakrishnan_1023Sent: Thursday, 14 July 2005 14:39 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] SOX compliance of AxaptaHi All,can somebody throw light on whether Axapta is SOX compliant. If so where can I find some details on the same.thanksramya Sharing the knowledge on Axapta. Yahoo! Groups LinksSharing the knowledge on Axapta. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] SOX compliance of Axapta
Hi James, Thanks for your comments. I agree that copying the entire AOD file for the layer in which you develop should enable you to disable development tools in live and would also provide better version control in that you can copy the AOD file into a 3rd party source version control system and thus easily keep n, n-1 and n-2 versions of your live environment as per SOX requirement. You also wrote I could just use another normal users network login. This is of course not allowed by SOX. Correct SOX way of doing things is to request a new login from the User Administrator (for lack of a better term) that is only active for a limited time to do what you agreed to do. Hennie -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Friday, 15 July 2005 03:38 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] SOX compliance of Axapta To add to this: To pass the audit supposedly the way you should do live changes is not XPO/projects but via complete AOD files this way you can turn of dev tools in the live. So changes should be put into test system where user test and when okayed full test AOD moved to live (and remember to move any new permissions as well!!!) This will pass SOX audit ok I believe (experience is from XAL but same concepts apply). A few other thoughts/experience that might help .. basically I the developer have no rights to get to the live system (done at OS file level) therefore any raise requires me to request the customer to provide access to the live for a given period of time that I can move AOD files etc overall this basically means it is very difficult for any change to be made to the appl, of course it is not impossible (I could just use another normal users network login) but the final step is for binary file comparison by the customer to allow detection of any change in AOD files. The main problem I had with XAL and I am not sure whether it also exist in Axapta is: In XAL the main problem was any user setups on screens (hide fields etc) and filters was saved in the AOD (*_UTIL) and so these files had to be kept as read and write. If the AOD can be made read only (e.g. hopefully in Axapta the user settings can be contained in a separate file, if they are in the AOD I suggest you make a service request to MBS to change it for SOX compliance etc) then you should be able to lock down the dev side of Axapta no problem. Maybe someone can tell us where are user chagnes kept? And yes SOX is a real killer for EVERYONE involved, the only ppl who benefit are the audit firms who charge huge amounts to the customer to make them run their business twice as slow! I understand the reason behind it all but really in practice you will see it really is a bit of a joke...a sad joke at that! In closing, Axapta comes from a very open/flexible approach...SOX basically wants everything locked down and segregation of dutys for each user so your task is to change the fundamental thinking of the design of Axapta! Good luck :) Some SOX examples (for your enjoyment and my rehabilitation - yes it was really that bad an experience doing it for XAL which does not have field level permissions!) ... I have a customer who has the MD's secetary as the user rights admin...why? Because they need someone who does not use the system for any financial transactions to be in charge of assigning rights etc...you can imagine the amount of hotline calls I have had from this person who knows nuts about IT and even less about access rights!!! All the best James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: 14 July 2005 22:28 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] SOX compliance of Axapta Hi, We just went through a massive worldwide SARBOX audit and in myself and our auditors' opinion, Axapta is not SOX compliant. We did pass the audit however because of the implementation of a number of mitigating controls. Some of the issues were: 1. Source version control and project locking in Axapta is insufficient. 2. Development tools need to be enabled in live environment to be able to import XPO's from test environment. This was a major problem. 3. The fact that projects (XPO's) need to be recompiled in the live environment after importing (you may not recompile code in live) 4. Axapta does'nt automatically force a password change after first logon when the Administrator resets your password. 5. Passwords can be cleared through the database. 6. Data model changes are made by developers through the AOS and not the DBA. These were only some of the issues/shortcomings that came up. Cannot think of everything right now. Ironic thing is that in 1995 the USA proclaimed the Paper Reduction Act and now with SARBOX additional, filed paperwork with signoffs
[Axapta-Knowledge-Village] SalesParmTable, SalesParmSubTable, SalesParmLine SalesParmUpdate tables
Title: Message Hi, Can anyone please tell me what the purpose of this tables are? The way I understood it is that it is tables that temporarily keep data for the purpose of posting sales orders. Once posted to the GL, they wont ever be referenced again. Is this assumption correct? Can I safely purge old data from this tables once posted to the GL? (We do have "Delete Order after Invoicing" selected in Sales Ledger parameters causing Axapta to purge SalesTable and SalesLine once posted) Thanx in anticipation Hennie -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] SOX compliance of Axapta
Hi, We just went through a massive worldwide SARBOX audit and in myself and our auditors' opinion, Axapta is not SOX compliant. We did pass the audit however because of the implementation of a number of mitigating controls. Some of the issues were: 1. Source version control and project locking in Axapta is insufficient. 2. Development tools need to be enabled in live environment to be able to import XPO's from test environment. This was a major problem. 3. The fact that projects (XPO's) need to be recompiled in the live environment after importing (you may not recompile code in live) 4. Axapta does'nt automatically force a password change after first logon when the Administrator resets your password. 5. Passwords can be cleared through the database. 6. Data model changes are made by developers through the AOS and not the DBA. These were only some of the issues/shortcomings that came up. Cannot think of everything right now. Ironic thing is that in 1995 the USA proclaimed the Paper Reduction Act and now with SARBOX additional, filed paperwork with signoffs for just about everything is encouraged. Hennie -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ramyakrishnan_1023 Sent: Thursday, 14 July 2005 14:39 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SOX compliance of Axapta Hi All, can somebody throw light on whether Axapta is SOX compliant. If so where can I find some details on the same. thanks ramya Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Localmacro help please
Title: Message Hi all, When a localmacro list object is defined in the classDeclaration, only a certain number of variables are allowed.The pack and unpack methods gives the following compiler error:"Overflow in an internal compiler stack." #LOCALMACRO.ParmList parmId, . . //variable listof 108 variables #ENDMACRO Is this an Axapta problem? Should more than 1 localmacro list object be used? How would more than 1 localmacro list object be implemented? -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Page load error on print archive
Title: Message Hi Axapta gurus! Please help! When I create a big document in my print archive and I want to print it to printer or file, I get a "Cannot load page" error on some of the pages. There is no pattern to this that I can establish. It seems as if it generates pages and then suddenly just cannot load the next page.If you specify pages to print you can usually skip the affected page and it will print the rest without any problem. This usually only appears on documents in excess of 400 odd pages. Does anyone have any idea on what might cause this to happen and how to fix it? Regards, -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Settlement reversal
Title: Message Hi, We quite often have to reverse payments and general journal vouchers that have been settled against a customer (Sales Ledger Customers Functions Closed Transaction editing). This occasionaly give us problems amongst which 1) Voucher ' ' could not be found errors, 2) The marked transactions do not balance errors are the most frequently encountered. Usually I have to go into table.SpecTrans and delete the affected records and then redo the reversal. This usually solves the problem. Ocasionally however (like now) I find that regardless of the tick box status in Closed Transaction editing there exist no records is table.SpecTrans. The records do however exist in table.CustSettlement but never go through to SpecTrans regardless of the fact that I tick the records on the Closed Transaction editing form. The result is that I cannot reverse any of the settlements. It keeps saying Voucher ' ' does not exist. Does anyone have any idea how to solve this? -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Payment reversal !!!!!!!
Title: Message Hi Ricardo, I have the exact same problem just under settlement reversal in Sales Ledger (See my question "SettlementReversal"). If you find anything please let me know. I will do the same. Regards, -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo CortésSent: Tuesday, 24 May 2005 20:52 PMTo: foroSubject: [Axapta-Knowledge-Village] Payment reversal !!! Hi everyone, I have an issue with this function, when I try to use it, the system shows me an error message in which says me that the voucher doesn't exist, although the voucher exist. The function Paymente reversal is located in the Cheks form in the function button Payment reversal. I'm using Axapta 3.0 sp3. I hope someone can help me with this issue. Thanks in advance. Ricardo Cortes Do You Yahoo!?Yahoo! Net: La mejor conexión a internet y 2GB en tu buzón de Correo Yahoo! por $100 al mes.Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Payment reversal !!!!!!!
Title: Message Hi Ricardo, To fix your problem you can look up the voucher number in table.VendSettlement or table.CustSettlement and then take the OffsetRecId and join it up with table.SpecTrans. Delete all the found SpecTrans records and then re-attempt the reversal. This usually works. I want to know how it can be prevented or if it is an Axapta program bug? Occasionally however it does not work. Regards, -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo CortésSent: Tuesday, 24 May 2005 20:52 PMTo: foroSubject: [Axapta-Knowledge-Village] Payment reversal !!! Hi everyone, I have an issue with this function, when I try to use it, the system shows me an error message in which says me that the voucher doesn't exist, although the voucher exist. The function Paymente reversal is located in the Cheks form in the function button Payment reversal. I'm using Axapta 3.0 sp3. I hope someone can help me with this issue. Thanks in advance. Ricardo Cortes Do You Yahoo!?Yahoo! Net: La mejor conexión a internet y 2GB en tu buzón de Correo Yahoo! por $100 al mes.Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Settlement reversal
Title: Message Hi, We quite often have to reverse payments and general journal vouchers that have been settled against a customer (Sales Ledger Customers Functions Closed Transaction editing). This occasionaly give us problems amongst which 1) Voucher ' ' could not be found errors, 2) The marked transactions do not balance errors are the most frequently encountered. Usually I have to go into table.SpecTrans and delete the affected records and then redo the reversal. This usually solves the problem. Ocasionally however (like now) I find that regardless of the tick box status in Closed Transaction editing there exist no records is table.SpecTrans. The records do however exist in table.CustSettlement but never go through to SpecTrans regardless of the fact that I tick the records on the Closed Transaction editing form. The result is that I cannot reverse any of the settlements. It keeps saying Voucher ' ' does not exist. Does anyone have any idea how to solve this? -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] SpecTrans help please
Title: Message Hi everyone, I need to know a few things about the use of the SpecTrans table in Axapta. When we are doing Closed Transaction editing we are getting all kinds of errors on Axapta. It happens only on some customers and I cannot see what is different between the affected customers and the rest. In closed transaction editing I select a single payment and Axapta then marks the corresponding invoice line. When I then click Reverse, it tells me that Voucher " cannot be found. When I debuged through this process I found that even though I only selected one payment (and the corresponding invoice) 3 records gets written to table.SpecTrans. I cannot figure out where the third record comes from. The only obvious difference between this record and the other two is that this third one has the Payment field ticked and the others not.In the reversal process the program then loops through the records in SpecTrans and finds the first two records without problems in both CustTrans and LedgerTrans tables and validates OK. It can however not find a voucher for this third (unrelated) record and then the reversal process crashes and the reversal gets cancelled. Also sometimes when I select the payment and the corresponding invoice and click reverse Axapta tells me that The marked transactions do not balance. Again table.SpecTrans revealed that there sits one unrelated record in SpecTrans apart from the 2 that I expect (the payment and the invoice). Has anyone experienced something like this before and be able to offer some advise? I would also like to know whih processes writes data into table.SpecTrans? Regards, Hennie Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Settlement reversal
Title: Message Hi, I have a serious problem and hope someone can help.. When doing closed transaction editing in Sales Ledger, I select a payment and Axapta then selects all corresponding invoices. I then click reverse to unlink the payments and invoices in the settlement. Axapta then gives me an error message saying: Voucher " does not exist. Reversal cannot be executed. I checked table.CustSettlement and it shows that the transaction is indeed reversible and the voucher numbers exist as expected. Any ideas? Hennie Potgieter -* Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] In use records (again)
Title: Message Hi, One of my users marked a number of records for settlement on a specific customer in open transaction editing in Accounts Receivable. (about 700 records). After marking the records (but before settling) his session got terminated by the AOS. All marked records now sit with a red hand in the "In Use" column of the open transaction editing form and nobody is able do anything with the In Use records. How do I remove the red hand and make the records available again? Hennie Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] In use records (Please help)
Hi, One of my users were busy capturing a payment journal in Accounts Receivable and while she was capturing the lines of the journal, her PC lost connection to the AOS and her session was subsequently killed. When she logged back on, she discovered that the journal header that she was working on, now has a InUse flag set (a small lightning icon) and she can not open up the lines any longer. When I remove the tick in LedgerJournalTable.SystemBlocked, the lightning icon change to a cross.. What is the solution for this? How can I make the journal available again? Hennie Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ attachment: winmail.dat
[Axapta-Knowledge-Village] Exporting data import/export definition groups
Title: Message Hi, I have set up a big data import definition group job that I use to import legacy data into Axapta. I now want to move this job to my live environment but the "Export" button is disabled. Why is this or how am I suppose to export a definition group? Hennie Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Axapta conferences
Title: Message Hi, Does Microsoft hold any (annual) dedicated Axapta conferences anywhere in the world that is worthwhile to attend? (We are not a MS partner - merely Axapta customers). Any info would be appreciated I did notice that the Convergence 2005 user conference will focus on all the solutions that fall under MBS (obviously including Axapta). Has anyone maybe attended Convergence 2004 and what were your impressions (especially from an Axapta point of view)? Hennie Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] String Manipulation
See AOT System Documentation Functions for all the string manipulation functions available in X++ viz: stralpha,strcmp,strcolseq, strdel,strfind,strins,strkeep,strlen,strline,strtrim,strlwr,substr etc. You can do pretty nifty stuff with combinations of these functions. Hennie -Original Message- From: anton_tjiptadi [mailto:[EMAIL PROTECTED] Sent: Tuesday, 07 December 2004 06:23 AM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] String Manipulation Hi, what is the syntax for string manipulation in X++, for ex (in VB): MyText -- left(string,2) -- My MyText -- right(string,4) -- Text MyText -- Substring(string,4,2) -- ex or format string like 0123456789 to be display like 01-234-567- 8.9 thanks, Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Purpose of Axapta Tables
If you find this, I would like to see it too. This would be a tremendous help. Hennie -Original Message- From: madtrs [mailto:[EMAIL PROTECTED] Sent: Friday, 03 December 2004 20:38 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Purpose of Axapta Tables Hello, Does anyone know where I can find a reference to Axapta tables? I'd like to know what tables are populated when a sales order is created? What tables are created when an invoice is created and posts, etc? Thanks... __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Performance amd open periods
Title: Message Hi, Can it slow down my system's overall performance if I have more than one posting period open at a time? We suspect that it does but I just want to make sure that I'm not imagining things. Hennie Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Data migration speed
We are importing sales orders and posting them on a daily basis from a legacy system. We are importing between 22000-25000 sales orders daily. We have been forced to run the import on 1 AOS only because of DB locks when running on multiple AOS's. Our import and posting runs at about 32 minutes per 1000 sales orders (every SO has between 3 and 5 lines) Regards, Hennie -Original Message- From: mgsrush [mailto:[EMAIL PROTECTED] Sent: Thursday, November 25, 2004 06:07 To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Data migration speed Does anyone have any benchmarks for data import speed into Axapta from legacy systems? Specifically customers and business relations are taking a much longer time to import than I would anticipate. Are there any optimal configurations for the AOS server concerning data importing? Thanks Mike Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Credit limit check performance
Title: Message Hi, We do not do credit limit checking in Axapta because credit limits gets checked in our legacy system that feeds into Axapta. Our credit limit checking is therefore set to "none". Am I right in assuming that this will not have any performance implication as far as credit checking goes? Hennie -Original Message-From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 04:23To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Credit limit check performance I understand the credit limit check can get pretty slow if set to anything other than 'Balance' but has anyone actually figured out how to speed it up without changing the basic checking it does? Mcohen from technet are you out there on this group? If so can you share how you changed it in your system. My customer checks 'Balance+All', deletes sales order invoiced lines but leaves the sales order header so I thought this would mean things dont get too slow. I thought the slowness came from the system having to checkevery existing sales line whether it had delivered or on order balance so I figured if I minimised the number of sales lines it would be okay Thanks James Disc:#10457 Subj: Trade Series Art: None 10457.1 Performance issue with Credit check (philm, 15 Jul 2004 18:18:41 CET) 10457.2 It is a well known issue (mcohen, 20 Jul 2004 19:33:52 CET) Contribution 10457.2 from mcohen, United States: It is a well known issue Regardless of the version 2.5 or 3.0, the credit limit check is very slow when the setting is other that just "Balance". We had to redesign it because of the large number of transactions. I do not know why Microsoft has not addressed this issue.Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Axapta performance
Title: Message Hi, I want to rant about Axapta and if anyone wants to listen me out and give any advise it would be appreciated. Some Background: We are a company in the courier and freight forwarding business and are using Axapta mainly for financials (AR, AP, GL). We do not have warehouses, BOM's, costing modelsetc. Our few (about 15) services that we offer has been captured as service items in the Inventory module, but other than this, we do not use inventory at all. Because Axapta is more geared towards manufacturing, we had to customize quite a fewcomponents to suit the services industry we're in. 1. We have major performance problems on Axapta - especially around month end when the volumes of transactions reach a peak. 2. We are creating and posting around 25000 sales order per day with an average of5 lines per sales order. The performance of the posting is not acceptable. We also get lots of database locks from this posting process that sometimes takes minutes to resolve. We are running3 AOS's on the application server (dual 3GHz Intel box; 4GB RAM) and a SQL Server DB on another hyper threaded 3GHz dual processor box with 4GB memory. What is your volumes like? Is ours exceptionally big or not really? Our AOS server is not straining. Our DB server sometimes hits abottleneck on disk I/O. 3. Because of our volumes, our database grows at an alarming rate. We are 8 months into Axapta now, and our database size is around 54GB, and growing at about 4 to 5 GB / month. If we need to keep like 5 years' financial data I do not want to do the calcs. How big are your databases and how do you manage the size? Has anyone developed some purging/archiving solution yet or are we holding our breath for Microsoft to come up with one in the next release? 4. We are getting serious database locks on SQL Server when running big tasks simultaneously. What isolation level (allow dirty reads, read committed, serializable etc.) does Axapta use for its transaction processing and do I have any control over this? It sometimes seems as if Axapta prefers locking on a table level rather than on a row level and if these locks are exclusive, everyone waits! 5. Do you allow reporting off your main database, or do you have a replicated / snapshot'ed database for reporting? Our performance problems get 10 times worse when a user kicks off a biggish report. Also Axapta was sold to us with the promise of users doing self-help reporting, which seemed nice back then. But if a user filters / sorts on a column that is not indexed on a table with 2.5 million rows it brings the DB server to it's knees. Also if the user accidentally klicks on the column heading on a form that displays a couple thousand rows and the DB tries to sort the grid, it kills the performance. That was my 2 cents... Any tips/hints appreciated! Hennie Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Which module is active
Hi, Is there any way of determining in code which module a user is currently working in? I need to determine if a user is maintaining alternate addresses from SalesLedger, PurchaseLedger or CRM side but have no clue. Thanks, Hennie Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ attachment: winmail.dat