AW: [development-axapta] How to get the used Table id in Ax 2009

Hi, why do you want to do that? The table ID is used internally in Dynamics AX to link objects in the development environment. It is also used to synchronize the data dictionary from Dynamics AX on the SQL Server. If you change the ID a table synchronizing the database will give you problems.

AW: [development-axapta] Vendor Invoice Journal from Business Connector

The number Sequence uses two sessions (two concurrent users?) to allocate a new number. Check the eventlogs on the server to see if you have problems with your license. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems

AW: [development-axapta] Inbound Create Purchase Order AIF service

Hi Jennifer, yes I do – I did ☺. What version are you implementing? Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.demailto:jesper

AW: [development-axapta] Inbound Create Purchase Order AIF service

Hi Jennifer, there is no standard service to create purchase orders. The service you found is the purchase requisition that requires a purchase order to work. You will need to create a new service to be able for create purchase orders. For a complete listing of the AX standard services please re

AW: [development-axapta] AX4.0 how to know batch process is running

Hi James, We are solving that problem for a customer at the moment. You could check if the batch user is logged on to the SQL server, only that will not give you the answer you are looking for. The user can be logged on, and the batch process has crashed, or the user is not logged on, but the b

AW: [development-axapta] Launching AX forms and creating records in the form through .Net

Hi, the short answer is no. The .net connector from ax does not support forms or reports. You would have to start the ax client to open the form. You need to modify ax to launch a form during startup. Or you can consider building a .net form and utilize the application integration framework t

AW: [development-axapta] AIF outbound acknowledgments

Hi, I only know the "Return Order Acknowledgement Document" within Dynamics AX 2009. I guess that is not what you are looking for, as Dynamics AX 2009 sends this. The process you describe we never solve within Dynamics AX, we prefer using the Biztalk server for that. The process monitoring wi

AW: [development-axapta] Help - AIF

Hi, Hope this helps. Generally we prefer using the Biztalk, but it is always an budget issue. a) pros & cons of using BizTalk v/s File adapter v/s MSMQ? The BizTalk server is often mistaken for being a batch engine, if you plan to use the Biztalk server like that, save your money and use serve

AW: [development-axapta] How To manipulate InventTable between companies

HI Why do you not create a table collection containing your table. You can setup an Virtual company account containing your table collection. Attach your two companies to your virtual company account. Your solution shares the table to all company accounts in the installation. Mit freundlichen

AW: [development-axapta] Using Ledger Purchase Invoice AIF Service

Hi, You can take a look at the standard documents (AX 4.0 and 2009). Inventory Journals "AxdProfitLossJournal" Ledger Journals "AxdCustPaymJournal". Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies Gm

AW: [development-axapta] Problem with accessing Oracle table using ODBC.

Hi, are you trying to access the ODBC driver on a 64 Bit OS? If so make sure that the client is installed in the Program Files folder, not the program files (x86). The ODBC connection does not like the (). Generaly I use the CC Classes to access the ADO.NET directly. Using the ADO.NET access y

RE: [development-axapta] Ax2009 and W2008

Hallo James, check the entries in the event log proir to your termination log entry. Jesper From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of James Flavell Sent: Dienstag, 3. November 2009 11:53 To: development-axapta@yahoogroups.com Subject: [dev

AW: [development-axapta] Disabling warming for number of companies licence

Hi, yes. You have exceeded your license you are missing the license key for unlimited Company accounts. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.jo

AW: [development-axapta] Hide Button Based on User Permissions

Hi, Load the macro #Admin Implement this Method in the class Global static boolean IsUserInGroup (UserGroupId _GroupId = '', UserId _userId = CurUserId()) { #Admin UserGroupList info; ; if (!prmisdefault(_groupId)) _groupId = #AdminUserGroup; return (select recid fr

AW: [development-axapta] Select statement is easy but I have trouble making the QueryBuildDataSource

Hi, You are adding the join condition twice qHeader.addRange(fieldnum(ALPurchReqTable, PurchReqId)) .value(strfmt(' (%1.%2 == %3.%4) ', purchReqLine_ds.query().dataSourceNo(1).name(), fieldStr(ALPurchReqLine, PurchReqId), purchReqLine_ds.query().dataSourceNo(2).name(), fieldStr(ALPurchReqTable, Pu

AW: [development-axapta] Re: How to show a webpage in Ax 3.0

HI Take a look at the form "DocuView". Microsoft uses an ActiveX control "Microsoft Web Browser". Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen.

AW: [development-axapta] How to call a form method from method of other form

HI, the class Global has a method "formHasMethod", to avoid a stack trace at runtime you might want to check if the caller has the method before you executes it using object. Object cannot validate the existence of the method during compilation. Best regards Jesper Von: development-axapta@yahoo

AW: [development-axapta] Run an EXE from AX 2009 - Code Example

HI Use the WinApi Class. WinApi::shellExecute('Notepad.exe'); Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.demailto:jesper.joer

AW: [development-axapta] Re: Carriage Return in SysMailer body

Hi, Use the HTMLBody for the sysMailer. For a new Line use #define.newLine('') Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.dema

AW: [development-axapta] Re: Integration with Axapta

Hi, if you are post 4.0 you should take a look at the AIF components. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.de

AW: [development-axapta] Borders in Excel with x++

Hi, Using the excel COM object you can select an range. In the range you can return the collector Borders and from there the object border. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH

AW: [development-axapta] HOW TO SENT FILE SFTP?

HI, you need an .net SFTP component you can add within Dynamics Ax. (Or an API as OCX / DLL / Com+ prior to 4.0). There are several providers for SFTP components. One of them is Eldos SecureBlackBox. http://www.eldos.com/sbb/sftp-net.php?referer1=google&referer2=adwords_kw_net_sftp_api&

AW: [development-axapta] List of tables which are Savedataprcompany == false

HI You are close to the result. You can't assume, that the counter has the same value as the table id... Try this. I have excluded the maps, views, tmptables, and the system tables as well. static void findGlobalTables(Args _args) { Dictionary Dictionary; sysDictTa

AW: [development-axapta] Printing BarCode Vertically in Report. Urgent!!!

HI, Have fun. You can not print Vertical and horizontal on the same report within Ax. I solved the problem by writing on a plain text printer, sending the native printer codes to a barcode printer. Not a nice solution, but it worked. The best solution is to look for a barcode printing so

AW: [development-axapta] Importing data into Invent table.

HI, is your InventDim there? (InventItemLocation.InventDimId = InventDim::findOrCreate(inventDim)? Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [E

AW: [development-axapta] InventTable

HI, if you are running a 3.0 remember to reindex the aod after deleting the record. The ADO index (*.aoi) seems to have an index lock that is not released by deleting the record within ax. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Pr

AW: [development-axapta] Problem with simple report.

Hi Try using the AX Standard way of getting an query for inventory on hand. You will find that on the table InventDim. Query query; QueryRunqueryRun; inventDimParm inventDimParmCriteria; inventDimParm inventDimParmGroupby; InventDim inve

AW: [development-axapta] Problem with try catch

Try this catch(Exception::Error) { Info("Failed"); } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] mailto:[EMAI

AW: [development-axapta] Newbie Question - Range Syntax

Hi Letron, first of all, use SysQuery::findOrCreateRange to get your range. Use Global:QueryRangeConcat to create your reange value. The syntax is xx1, xx2, xx3. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato sy

AW: [development-axapta] How to select distinct records from a column

No, select distinct is not implemented in Ax. You can achieve the same with: Select , from Group by , Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager Von: development-axapta@yahoogroup

AW: [development-axapta] CryptoAPI in 4.0 not available

HI Morten, Use cryptoblob2binary and cryptoblob2str from Global. If you want to protect your data using the WinApi_Server Class (cryptUnProtectData and cryptProtectData), be aware that the crypt / decrypt from Windows use a checksum from the machine doing the crypt, you need this machin

AW: [development-axapta] Axapta Backup Data

HI, SQL Backup. The export from Ax only exports one company account. If you mess up the recid's you are not able to restore the export. If you need a company based restore you restore your database with a new db name. In the company accounts you can restore one company from an external

AW: [development-axapta] How do I know which field is sorted at, and the sortorder in a grid?

Hi Tore, You need to add the menuitem to the form CustTable. Exportfile for AOT version 1.0 or later Formatversion: 1 ***Element: FTM ; Microsoft Dynamics MENUITEM : CustSort unloaded ; VERS

AW: [development-axapta] No Transaction Records

Hi, I would add the InventTrans with a not Existsjoin to the InventTable and pass from and to date as Range. In that case U only gets the Items that have no Transactions in the given period. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior

AW: [development-axapta] User Groups

Hi Ricardo, The User Groups are stored in UserGroupInfo. The User Groups for a specific user are stored in UserGroupList. Be aware that the access rights in AX can be setup depending on the domain of the company account. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jes

AW: [development-axapta] 4.0 installation

HI, Check the setup of the connection. Check if the Server is running. Can U ping the server in the port U use? Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18

AW: [development-axapta] Enum values in SQL database

Hi, I have made a solution for the problem. You need to extract the labels from the enums in the AOT. Goes something like this: public void run() { EDAViewWizardEnum viewWizardEnumTable; EDAViewWizardLanguage viewWizardLanguageTable; Dictionary dictio

AW: [development-axapta] Using Two localizations in One Application

Hallo Trinadh, this can not work. You will have two applications with differences in the data model. You need a database for each application. The US version is part of the sys layer in 4.0. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD S

AW: [development-axapta] Who locks the table?

In the online User Form U see the SPID for an Ax user. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]> Phon

AW: [development-axapta] Select records dinamically on form

HI, I have crated a form (Quick and Dirty) in 4.0 SP2 based on CustTable that shows U how to do that. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Güter

AW: [development-axapta] Bad response time on the CUSTINVOICEJOUR form

Hi Try using the code profiler to identify the problem. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager "Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschlie

AW: [development-axapta] Pass temporary table data from form to report

Hi, just to make sure you does not get a stack trace at runtime you should check if the Method exists on the caller object. Object fr ; Table tt; // fr = element.caller(); If (formHasMethod(fr,identifierstr(updateControls)) // formHasMethod is implemented in Global. tt = fr.retmethod(

AW: [development-axapta] Excel API

Hi, You could use the COM class wrapper wizard to implement all objects from a COM application in Dynamics Ax. You need to review a couple of objects after wrapping them. The wizard has problems with polymorph objects. The automatic implementation of e.g. the Range and the selection object w

AW: [development-axapta] Setting a break point

Check if the AOS Server allows breakpoints. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]> Phone: +49 5242 /

AW: [development-axapta] How we can Upload our images in axapta ?

HI, have a look at the COmpanyInfo and CompanyLogo table in Ax. The field storing the Photo should by of the base type Binary. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autob

AW: [development-axapta] xml

Hi Anette, use the XMLDocument Class to create the XML document, with the method "createProcessingInstruction" you can influence the XML document "header". Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems

AW: [development-axapta] Update field with switch-case

Hi there I have solved it a bit different, but you would be able to construct your scenario based on my code. I got a XML document with the table name or an alias for the table as XML element, as child elements I got the fields and needs to create a record in Axapta based on this. vo

AW: [development-axapta] How to find the data type of the field

Hi Try this: static void Job1(Args _args) {     SysDictTable    dictTable;     SysDictField    dictField;     SysDictType dictType;     SysDictEnum dictEnum;     str baseType;     Counter fieldCounter;     Counter arrayCounter;     ;     dict

AW: [development-axapta] Re: Determine if a module is included

U can use the configurationkey to determin is a function is active, if you want to query on the licensecode try this. static void Job2(Args _args) {    Dictionary  dictionary = new Dictionary();     SysConfig   sysConfigTemp;     select sysConfigTemp     where sysConfigTemp.id =

AW: [development-axapta] Creating a class from class name

Hi Try this XUtilIdElements::find(UtilElementType::Class, 'ABCBase').id; Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Entwicklung Axapta arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] http://

AW: [development-axapta] Urgent : How to upload data to generate Sales orders

Hi Preety, You should use the class SalesAutoCreate, or create an extension of it to meet your demands. Cheers Jesper Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von Priyank Krishna Gesendet: Mittwoch, 19. Oktober 2005 17:43 An: development-ax

AW: [development-axapta] How to connect to Axapta Installations for Data-Exchange

Hi Herbert, You can programme the inter company using COM, or use the commerce gateway and BizTalk in Standard. If you want the full inter company you need to implement it using COM, sorry. /Jesper   _  Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Gesend

AW: [development-axapta] statement "where not" and "not like"

Hi Lars, Sorry but I need to correct you concerning the support of like in Axapta. Axapta does support like. Try this out. static void TestLike(Args _args) {     InventTable it;     ;     while select it where !(it.ItemId like '1*')     {     info(it.ItemId);     }

AW: [development-axapta] Re: Formbuilddatasource - adding a datasource runtime to an already running form

HI Lars, Take a look at the form SysRecordInfo, The form generates a new form and uses FormBuildDatasource. I am having problems attaching a new data source to an existing form at runtime. You can add a new data source, but you can not attach a table to the data source. /Jesper

AW: [development-axapta] Launching a URL from a button in Axapta

Hallo You could also use "infolog.helpGenerator().showURL("www.microsoft.com");" to run your browser imbedded in Axapta. Regards Jesper Von: Max Belugin [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 30. März 2005 11:09 An: thestorm1974 Betreff: Re: [development-axapta] Launch

AW: [development-axapta] Fielproperties

Hi Herbert We are working on a module to dynamically convert charters upon import or export from Axapta. You need to substitute an Germany "ö" to "ö" and a "Ö" to "Ö" in a XML format (Other scenarios are EBCDICT, ASCII etc.). It would have been nice if I could just change the collation seq

AW: [development-axapta] Re: Terminal server/Printer

Hi Henrik. There have been a lot of answers to your problem. The correct setup depends on the used client infrastructure. You have a scenario where the Axapta environment is hosted at an ASP, depending in the parts that are hosted you can use more strategies to allocate printers. If on

AW: [development-axapta] Open a excelfile

HI, use SysExcelWorkbooks Open to open an existing file. Workbooks add will always add a new workbook to the existing instance of excel. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies GmbH An der A

AW: [development-axapta] Fielproperties

Hi Herbert, I know, but in the SQL Server I can set a single row to use a different collation. I an looking for a possibility to control this row property on the SQL server from Axapta. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklun

[development-axapta] Fielproperties

Hi all. Can I set a field (in a primary index) to case insensitive from within Axapta? I need to build hold the components "a" as well as "A" in the index. My database is set to Latin1_genarel_CP1_CI_AS. /Jesper Mit freundlichen Grüßen / Best regards / Med venlig hilsen Je

AW: [development-axapta] operation from combination of enum

Hi You can loop over an enum like this static void EnumTest(Args _args) {     SysDictenum dictEnum;     Counter counter;     ;     dictEnum = new SysDictEnum(EnumNum(ABC));     for (counter = 0; counter < dictEnum.values(); counter++)     {     print dictEnum.index2N

AW: AW: [development-axapta] Select where with a filter

HI, No I am using SQL 2000 server. I should work on a Oracle as well, as the Axapta transforms the X++ statement into a SQL statement. On 2.5 a ODBC statement on 3.0 a OCI statement. To se what statement Axapta issues to the database try to trace the statement into a text file.  yf Jesper

AW: [development-axapta] Select where with a filter

Hi, You need to use * in Aaapra. If you are selecting with wildcards you need to use the keyword "like" not "==". /Jesper Von: Padmaja Iyingar [mailto:[EMAIL PROTECTED] Gesendet: Montag, 14. März 2005 05:06 An: development-axapta@yahoogroups.com; Axapta-Knowledge-Village@yahoogro

AW: [development-axapta] Add dynalinks programatically

Hi Lars, try this _q.dataSourceNo(1).addDynalink(fieldNum(, ), element.args().record(), fieldnum(, ) ); Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies GmbH An der Autobahn 18 33311 Gütersloh

AW: [development-axapta] Error when calling WINGDI method..!

Hi, You need a handle to the windows process id. The example below gets the ID of Axapta.     DLL user    = new DLL('USER32');     DLLFunction getActiveWindow = new DLLFunction(user,'GetActiveWindow');     WINGDI  Absi;     ;     GetActiveWindow.returns(EXTTYPE

Re: [development-axapta] Re: return sqlstatement to user

HI try this static void SQLStmt_Demo(Args _args) {     Connection  Connection;     Statement   Statement;     ResultSet   ResultSet;     str myString;     ;     // Create a new connection to the Axapta database     connection = new Connection();     // Create a statement for the new co

Re: [development-axapta] return sqlstatement to user

You get a resultset(Class) from a statement. You extract a string with the method getstring. /Jesper Original Message Subject: [development-axapta] return sqlstatement to user (12-Nov-2004 13:33) From:    [EMAIL PROTECTED] To:  [EMAIL PROTECTED] > > > > Im using the

Re: [development-axapta] Re: LabelId's from Enum Values

Hi Ben, you get the result correct, but you change the language temporay for the session. I have solved the problem in the following manner: add this method to the class "SysDictEnum": LabelId Value2LabelLabel(int value) {     #Properties     SysDictEnum SysDictEnum;     TreeNode   

Re: [development-axapta] Catch SQL-Exceptions from CONNECTION Class

Hi Bodo, Take a look the ODBCConnection. I think Claudia Göries wrote an answer last week. The class conenction always creates an connection to the current Axapta database. /Jesper Original Message Subject: [development-axapta] Catch SQL-Exceptions from CONNECTION Class (

[development-axapta] SQL case statements

Hi all. Does anybody know a possibility to the SQL case statements in queries? /Jesper Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/  To unsubscribe from this group,

Re: [development-axapta] insert records SQL table outside axapta

Hi Girish, you should use the OBDCconnection class for this. Something like this: static void Job7(Args _args) {     OdbcConnection  _OdbcConnection;     LoginProperty   _LoginProperty =  new LoginProperty();     Statement   _statement;     ResultSet   _result;     str _sql

Re: [development-axapta] infolog after database synchronisation

you have a unique key violation. Start the SQL Administration in the Administration Menu. On all Tables you can now "Check/Synchronize" your Tables. If you activate all index options, you will be presented to all unique keys violations. You can delete the duplicates. /Jesper Orig

Re: [development-axapta] element and this

Hi, element would be the father object. This is the current control element. If you are in a datasource in a form, this would be the datasource, to address an mothod from the form, you need to address it using element. /Jesper Original Message Subject: [development-axapta]

Re: [development-axapta] Clustering-again

check the length on the clustername, only 10 char are used by Axapta. /Jesper Original Message Subject: [development-axapta] Clustering-again (29-Jun-2004 10:01) From:    [EMAIL PROTECTED] To:  [EMAIL PROTECTED] >  Hi all, > I would like to ask about clustering again.. I

Re-2: [development-axapta] Error when Creating Document in CRM Quotation

Hi Akash, The COM Object "ComTable" in an object in Word (ActiveDocument.Tables). The COM object in Axapta expects to find a table in your template. If not it throws an error . Axapta tries to output the quatation lines in a table. Take a look at the templete in \Share\Include\smm, the templa

Re: [development-axapta] Tmp-data in Grid

Hi Morten, cteate a datasource of the table you want to display. If the form is linked you must overwrite the linkActive method. In the Method you add .tmpdata(). Not the cursor of the datasource points to the tmpData. Take a look at the form "LedgerTransBase" in standard for an exampel. /Je

Re: [development-axapta] Error when Creating Document in CRM Quotation

Hi Akash, Take a look at the template in word. The statement tries to fetch the first table in the template. Does the template have a table (for quotation lines), and is it the the first table in the template? // Jesper Original Message Subject: [development-axapta] Error w

Re: [development-axapta] Speedup my Insert Records Process

Hi Jay, take a look at the update_recordset statement. /Jesper Original Message Subject: [development-axapta] Speedup my Insert Records Process (22-Jun-2004 6:52) From:    [EMAIL PROTECTED] To:  [EMAIL PROTECTED] > Hi Guys, >  > I am try to Update like 5000  or more

Re-2: [development-axapta] Moving code between layers

Hi Stefan, you need to "clean up" the system table SQLDictionary to avoid loosing data when moving objects to a lower ID. You need to create a class that scan the data dictionary in Axapta and match that to the SQLDictionary on name not on id as the standard. You can browse the SQLdictionar

Re-2: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIA

HI, Do you have Axapta tables in the database? If so the Axapta tables should be user tables. If all your tables are system tables you need to change the properties of the table. If the ownership on the tables is wrong you can eigther use the allready mailed solution to fix it. (sp_change_u

Re-2: [development-axapta] Sending Fax using COM

Title: Message You get a error form the faxserver that Axapta can not resolve to a errormessage. Check if you get an object of FaxDoc. /Jesper   Original Message    processed by Tobit InfoCenter  Subjec

Re: [development-axapta] Startup Menu

the class is xinfo method runStartupMenu(). Original Message Subject: [development-axapta] Startup Menu (18-Mrz-2004 14:36) From:    [EMAIL PROTECTED] To:  [EMAIL PROTECTED] > Hi, > > Is there someone that knows which class is responsible for composing > the startupme

Re-2: [development-axapta] Mutli-Country Implementation - Single Database

Hi Mai-Britt,   Now we are talking about DIS Layers. Are you planning a similar procedure for the LOS layers?   /Jesper   Original Message    processed by Tobit InfoCenter  Subject:  RE: [

Re-2: [development-axapta] want to understand how to create a record in the table (SQL) by writ

Hi Girish,   could you not use the a batch job?   /Jesper     Original Message    processed by Tobit InfoCenter  Subject:  RE: [development-axapta] want to understand how to create a record

Re: [development-axapta] want to understand how to create a record in the table (SQL) by writti

Hi Girish, I do not like external software writing in the Axapta tables. The reasons for that you describe yourself (problems with Recid). Whar I like to do on integrations is to create an table that Axapta cann't se. (Other User, and/or other Database). I then use the ODBC class to access th

Re: [development-axapta] Re: 45 GB Datebase with SQL2000

The SP3a should only be used with Axapta 3.0 SP2. Check the release notes. /Jesper Original Message Subject: [development-axapta] Re: 45 GB Datebase with SQL2000 (03-Mrz-2004 17:05) From:    [EMAIL PROTECTED] To:  [EMAIL PROTECTED] > I think they work still with SP2. To

Re: [development-axapta] Regarding AOS

Title: Meddelelse Hi. have you restarted your AOS after updating (and stopping) the Oracle server? /Jesper     Original Message    processed by Tobit InfoCenter  Subject:  [development-axapta] Rega

Re-4: [development-axapta] Transactions with multiple forms

HI, use Args.caller to access the caller object and write back the recordinsertlist /Jesper Original Message Subject: Re: Re-2: [development-axapta] Transactions with multiple forms (05-Feb-2004 13:12) From:    [EMAIL PROTECTED] To:  [EMAIL PROTECTED] > Thanks for the

Re-2: [development-axapta] Transactions with multiple forms

HI, It is no Problem having interaction before the transaction. I use the class RecordInsertList to avoid using temp tables. /Jesper Original Message Subject: RE: [development-axapta] Transactions with multiple forms (05-Feb-2004 12:06) From:    [EMAIL PROTECTED] To: 

Re: [development-axapta] Label with special user

Hi, check that the two users are both starting in the same language. If so try this: 1. Shut down the AOS. 2. Delete the file ax122.ali 3. Start axapta client on server in 2 tier mode searche any label, Axapta should now recreate the file *.ali if not existing. 4. Start the AOS again. /Jespe

Re-2: [development-axapta] How to change the filegroups of all the indexes of all tables

Title: How to change the filegroups of all the indexes of all tables Hidden in the development menu you will find a form "SYSSQLSetup" Use this to change the settings for the filegroups. Then Axapta will also use the settings doing the synchronization. /Jesper    

Re: [development-axapta] How to Launch browser and set the url via x++, script examples ?

hi Arief Use the EDT "URL", the lookup have a form SysURLlookup attachen. If you need to launch the browser from X++ use "infoLog.urlLookup('www.microsoft.com')" /Jesper     Original Message    processed by Tobit InfoCent

Re-2: [development-axapta] Creating Excel with X++

Title: Message Hi charles, try this. static void ExcelFormating(Args _args){    #Excel     SysExcelApplication excel;    SysExcelWorkbooks   books;    SysExcelWorkbook    book;    SysExcelWorksheet   sheet;    SysExcelRange   range;   

Re: [development-axapta] sum

As you need to return a real not a record. > static real MyTotal(Date _dd, Code _cc) > { > MyTable myTable; > ; > > return >    (select sum (realfield) >    from myTable >    where myTable.Date == _dd >    && myTable.Code == _cc).realfield; > } /Jesper

Re: SV: [development-axapta] Regarding Labels

Title: Meddelelse Hi Mikael, try deleting the .ali (index file) for the label file, start the application on the Server in 2-tier mode. Then restart the AOS. /Jesper     Original Message    processed by Tobit InfoCenter 

Re: SV: SV: SV: [development-axapta] SQL Server 2000: since some weeks DB-size grows

Title: Melding   Mit freundlichen Grüßen / Best regards / Med venlig Hilsen Jesper J¢rgensenConsulting mailto: [EMAIL PROTECTED] Aston Business Solutions GmbHKettelerstr. 3-11D-97222 Würzburg-RimparGermany Tel.   +49-9365-8075-0Fax   +49-9365-8075-300 Work with a Winner. Aston Business