[development-axapta] AOS name in online user form and search for item id in config id lookup

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

[development-axapta] Converting Axapta Oracle DB to MSSQL2005 using MSSQL Migration Assistant?

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

[development-axapta] Re: Open cursors

Hi Thomas (affekatz)! The Axapta Implementation guide states: OPEN_CURSORS By default, Axapta creates up to 90 open cursors. Check that the according value in the init.ora file (OPEN_CURSORS) is set to at least 200 That's in the Setting up Oracle 9i part of the guide. You can also find

[development-axapta] Axapta and Oracle Parallel Query Execution

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

[development-axapta] Which Oracle version for Axapta 3.0 SP3/SP4?

Hi all! I am trying to figure out which version of Oracle 9i I should use for Axapta 3.0SP3 or SP4. I sent a question to Microsoft and the answer I got was a link to the german MBS site: http://www.microsoft.com/germany/businesssolutions/axapta/systemanfor derungen.mspx The site is in

[development-axapta] Re: Electronic Banking and missing IBAN

this essential information: we are running 3.0 SP3. Best regards, Arthur. --- In development-axapta@yahoogroups.com, hwimmer [EMAIL PROTECTED] wrote: Hi Which version of Axapta are you running. In my 3.0 SP4, I can see the following statements: Class EDIFACT_Segements_AT, method

[development-axapta] Lookup ConfigId in Query

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

[development-axapta] Error RECID exists twice when upgrading to Axapta 3.0SP4

Hi I tried to install Axapta 3.0 SP4. I wanted to do it like that (the way I did it a thousand times before starting fom Axapta 2.1): * Copied an existing 3.0SP3 application in a new directory * Deleted all non-standard *.aod files and all index files * Duplicated database * Copied all

[development-axapta] Oracle First Row Fix

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

[development-axapta] 2 datasources, 1 grid, outerjoin

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

[development-axapta] Oracle and ClusterIndex?

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