[Axapta-Knowledge-Village] AOS name in online user form and search item id in config id lookup

2006-05-30 Thread hwimmer
Hi all! I have posted 2 projects on my blog http://axaptafreak.blogspot.com The first is for displaying the AOS name in the online user form, the second is to be able to search for item ids in the standard config id lookup form. Enjoy ! Best regards, Helmut http://axaptafreak.blogspot.com

[Axapta-Knowledge-Village] Re: SP5 fix list

2006-04-10 Thread hwimmer
Hi I have posted the fixlists on my blog http://axaptafreak.blogspot.com Attention: the page where the files are located have very limited download capacity !!! So, if you cannot download the files, try later. Best regards, Helmut http://axaptafreak.blogspot.com --- In

[Axapta-Knowledge-Village] Re: Problem with Online users ...

2006-04-05 Thread hwimmer
Hi Jens! I think you are struggling with a standard error in the online user form that is occurring with Oracle only. Please check the Info class and there the methods: * licensedUsers* licensedComUsers* licensedAOSUsers* licensedObjectServers In all those 4 methods (well,

[Axapta-Knowledge-Village] Converting Axapta Oracle DB to MSSQL 2005 using MSSQL Migration Assistant?

2006-03-28 Thread hwimmer
Hi! I tried to convert our Oracle 9i database to MSSQL2005 using the MS SQL Migration Assistant (SSMA). We are running Axapta 3.0 SP3 and I installed the Kernel rollup. Everything is working except tables that have field names which seem to be keywords. Example: Table Address has the field

[Axapta-Knowledge-Village] Re: Axapta SP4

2006-03-21 Thread hwimmer
Hi Steve! When not a partner, a reference to Partnersource is not good, as we do not have access to it. Yes I know, I should ask my Axapta dealer to give the SP5 to me. I did that 14 days ago personally. I sent them another mail 6 days ago. I got NO response at all from them. As we also have

[Axapta-Knowledge-Village] Re: SQL Index Statistics

2005-10-18 Thread hwimmer
Hi! It seems that there is still some confusion in the Axapta world about index vs. index hint. Due to that reason, I have made a new entry in my blog that tries to explain it. You can go to my blog here: http://axaptafreak.blogspot.com What does it say: When you add the keyword INDEX to a

[Axapta-Knowledge-Village] Re: who can give me some document of Axapta V4.0?

2005-09-28 Thread hwimmer
Hi Andy! I have put a powerpoint file about Axapta 4.0 on my blog site: http://axaptafreak.blogspot.com Unfortunately, you have to click 2 times to get the file, couldn't convince GeoCities to open the file directly from the blog?!? Best regards Helmut http://axaptafreak.blogspot.com --- In

[Axapta-Knowledge-Village] Axapta and Oracle Parallel Query Execution

2005-09-27 Thread hwimmer
Hi! We are using Axapta 3.0SP3 on an Oracle 9.2.0.4. The DB server is a dual Xeon 3.2 Ghz (so I see 4 CPU threads in task manager). Now, from time to time one of the CPU threads goes up to almost 100% and the others are still at 1-2 %. So it seems to me that Oracle does not spread it's CPU load

[Axapta-Knowledge-Village] Re: caching of tables in Axapta

2005-08-26 Thread hwimmer
Hi James! The records will only be loaded for the current company and only at first access of the table. Best regards, Helmut http://axaptafreak.blogspot.com --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell [EMAIL PROTECTED] wrote: thansk harry its not so urgent, more a

[Axapta-Knowledge-Village] ZipCodeLookup: findrecord is soooo slow

2005-08-09 Thread hwimmer
Hi! Imagine your ZipCode table contains about 100.000 records. When you are in the CustTable form where the customer has a zipcode at the end of the table and you click on the lookup button, Axapta will open the form and then you'll have to wait and wait and wait until Axapta found the record.

[Axapta-Knowledge-Village] Re: [Urgent] Cannot Post Ledger Journal

2005-07-28 Thread hwimmer
Hi Cenk! Cannot help you with your exact problem, but if you want to find out where this error message is thrown, take a look at: http://axaptafreak.blogspot.com and read: Tip: How to find out where that error message comes from This should help you to figure out what your error is. Best

[Axapta-Knowledge-Village] Re: 2000 vs 2003 does performans differs?

2005-07-26 Thread hwimmer
There it says Axapta on Win2003 will be about 10-15 percent faster than on 2000. Best regards Helmut http://axaptafreak.blogspot.com --- In Axapta-Knowledge-Village@yahoogroups.com, hwimmer [EMAIL PROTECTED] wrote: Hi Cenk! I remember to have seen a document once (from Microsoft) where

[Axapta-Knowledge-Village] Re: MUIC locking

2005-07-12 Thread hwimmer
Hi If it seems that the MUIC has stopped working, it might be that is in the phase of making the ledger transactions. The MUIC works as follows: 1. You make the list of items that are to be calculated 2. You start n clients for the MUIC. Every client takes the next item number (may as well

[Axapta-Knowledge-Village] Lookup ConfigId in Query

2005-06-22 Thread hwimmer
Hi We are using config id's a lot for items. In standard forms, MBS programmed something so that e.g. in the SalesTable form, after you've entered the item id, you'll only get the config's of that item. In queries, however, this does not work. Go to any report that prints out item data and

[Axapta-Knowledge-Village] Re: SQL Server SP4

2005-06-15 Thread hwimmer
Hi ad question 2: the normal procedure by MBS is (as I know) that if a new version of Axapta is released, that new version will be certified (if possible) for the latest available versions of DB servers. So, as Axapta 3.0SP4 is released, MBS is probably now in the process of certifying it

[Axapta-Knowledge-Village] Oracle First Row Fix

2005-05-06 Thread hwimmer
Hi Having major performance problems with our Oracle DB, I played around with the First Row Fix Parameter. The Configuration help says (search for setting oracle options in help file): Special first Row fix should be checked if performance problems are experienced while sorting rows within

[Axapta-Knowledge-Village] 2 datasources, 1 grid, outerjoin

2005-05-03 Thread hwimmer
Hi Follwowing task: make a form that displays Inventtable and the name of the BOMCostGroup/CostgroupId, name of BOMCostgroup must be filterable. What did I do: Create a form with datasources InventTable and BOMCostGroup, set BOMCOstGroup to be Outerjoined on Inventtable. Create a grid on the

[Axapta-Knowledge-Village] Oracle and ClusterIndex?

2005-04-21 Thread hwimmer
Hi I have Axapta 3.0SP3 running on Oracle 9.2.0.2.1. (unfortunately I only have MSSQL experience and no Oracle). I know how Axapta creates an index if it is set in the property ClusterIndex on the table (Flag grouped on index is set to yes in MSSQL) and what the cluster means (organizing the