Re: [Axapta-Knowledge-Village] Importing transactions into Ax4.0

2007-07-11 Thread Kamal Kannan
Hi Barath, Check out this entry from Dax Guy's blogit should help you http://daxguy.blogspot.com/2007/04/excel-import-custom.html Regards Kamalakannan http://casperkamal.spaces.live.com On 6/28/07, barath <[EMAIL PROTECTED]> wrote: > > > > Hi All, > > I need to import(Excel format) transac

Re: [Axapta-Knowledge-Village] tab delimiter text file

2007-07-04 Thread Kamal Kannan
Hi Patrick try this code it works. static void exportToFile(Args _args) { Container con; sqlDictionary sqlDictionary; TableName TabName; TextIO txtIo; salestable salestable; ; TabName = "SalesTable"; select * from sqlDictionary where TableName2id(TabName) ==

Re: [Axapta-Knowledge-Village] Time sheet

2007-07-02 Thread Kamal Kannan
Hi Arun, You can use the "Electronic Time Card" in Shop floor Control to register the time sheet of employees. There is also an "Time sheet Journal" in Payroll module. IF what you are expecting is for sales guys then you can try out the snap in available for Outlook - Ax Time sheet integration

Re: [Axapta-Knowledge-Village] How can add fields to existing tables via X++ codes

2007-03-31 Thread Kamal Kannan
Hi try this code #AOT #TreeNodeSysNodeType DictTable dictTable = new DictTable(221); //find the table TreeNodetablenode = TreeNode::findNode(#TablesPath).AOTfindChild('LedgerTable'); TreeNodefieldNode, tn; Struct properties; Struct propertyInfo;

Re: [Axapta-Knowledge-Village] error with AIF and web services

2007-03-20 Thread Kamal Kannan
Hi Neal, The customer userid present in the xml must be mapped to the internal Ax user list, so that it can be imported. The other alternative is you can think of an XSLT transformation of the xml sent by the client such that you reconfigure it to put the userid from your domain. The XSLT transfo

Re: [Axapta-Knowledge-Village] Ax 4.0 sp1 + Reporting services

2007-03-20 Thread Kamal Kannan
Hi Mkris, Please refer to the following link that gives you detailes about the document for use of SSRS in Ax4.0. http://casperkamal.spaces.live.com/blog/cns!9138ED475277CD63!248.entry Regards Kamalakannan http://casperkamal.spaces.live.com (Tech blog on Ax) On 3/12/07, MKris <[EMAIL PROTECTED]

Re: [Axapta-Knowledge-Village] Infolog max size can be changed?

2007-03-20 Thread Kamal Kannan
Hi James, adding such a huge number of lines to the infolog would be a performance issue very first, so why don't you try other alternatives like you can use a temptable store or a Textbuffer(use TextIO) to store and then later display using a form which would be much better. Regards Kamalakannan

Re: [Axapta-Knowledge-Village] Tableid to TableBaffer

2007-03-20 Thread Kamal Kannan
Hi Try using the Dictable.makerecord() method, it returns a type common. should be someting like this. SalesTable salesTable = new SysDictTable(tablenum(salesTable)).makerecord(); Regards Kamalakannan http://casperkamal.spaces.live.com (Technical blog on Ax) On 3/19/07, dj3mb3 <[EMAIL PROTE

Re: [Axapta-Knowledge-Village] How to Get the DialogFile name from the RunBaseDialogModify

2007-03-16 Thread Kamal Kannan
Hi, Use the follwoing syntax to get the value from the query if you have access to the query. q.dataSourceName('InventTrans').findRange(fieldname2id(tablenum(InventTrans), 'itemid')).value(); Plz be more clear on your scenario so that we can better help you Regards Kamalakannan http://casperka

Re: [Axapta-Knowledge-Village] Report

2007-03-16 Thread Kamal Kannan
Hi VG To disable the quotationid and salesid, drag them to the ranges section and choose Enabled as no in the properties of those typical ranges. Regarding the lookup, only in the follwoing scenarios you get the look up 1. When it is an enum type 2. when it has table or dataType level relatio

Re: [Axapta-Knowledge-Village] Problem Regarding Report

2007-03-16 Thread Kamal Kannan
Hi Ajit, You can write a display method on the report and then drag it to the report design section, this display method will be called every time a record is fetched and the resultant value will be displayed in the report. Refer to the Morphx It Pre release material by steen anderson which give

Re: [Axapta-Knowledge-Village] CRM Quotation printing as word template

2007-03-14 Thread Kamal Kannan
Hi, why don't u try using this way ??? num2str(salesLine.LineNum, 1, 0, 0, 0) before you right it to the word. Regards Kamalakannan http://casperkamal.spaces.live.com/ (My tech blog on Dynamics Ax) On 3/14/07, jay_naik_99 <[EMAIL PROTECTED]> wrote: > > Hi, > We have a problem he