[Axapta-Knowledge-Village] Data import Error - Help need

2009-01-29 Thread Siva kumar
hi friends,       I got an error while importing the .CSV file using custom type. The error is "Error in call of method  inventupdateonhand.insertinventsum" and Data import is cancelled"   Did any one of you come acroos this error. if so, please let me know what is the reason for this error a

Re: [Axapta-Knowledge-Village] Printing multiple selected records

2008-12-11 Thread Siva kumar
Hi,      Please find the attached .xpo which will help you to solve your problem       "Hands that Help is Holier than Lips that Pray" --- On Thu, 12/4/08, k_otickashka <[EMAIL PROTECTED]> wrote: From: k_otickashka <[EMAIL PROTECTED]> Subject: [Axapta-Knowledge-Village] Printing multiple selec

[Axapta-Knowledge-Village] how to Create temp table in runtime

2008-12-01 Thread Siva kumar
Hi all,      Is any body have idea about  how to create temporary table during runtime.   "Hands that Help is Holier than Lips that Pray"

Re: [Axapta-Knowledge-Village] Re: How to add Values into Report at runtime

2008-11-25 Thread Siva kumar
(Customization Consultant Ms. Dynamics Axapta) --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Siva kumar <[EMAIL PROTECTED] .> wrote: > > Hi all, >   >   >    I had come across a situation where I need to print the table field value as report field column in the

[Axapta-Knowledge-Village] How to add Values into Report at runtime

2008-11-24 Thread Siva kumar
Hi all,        I had come across a situation where I need to print the table field value as report field column in the middle of the report during runtime.     Lets say I have a table xxxTable with one field which has the values "10k,18k and 22k.     I want this values to be printed as report col

Re: [Axapta-Knowledge-Village] Salestable -Sales line - Query

2008-10-20 Thread Siva kumar
automatically set to the header table by DAX.   Varden Morris  276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] com     ----- Original Message From: Siva kumar <[EMAIL PROTECTED] com> To: Axapta Development ; MBS

[Axapta-Knowledge-Village] Salestable -Sales line - Query

2008-10-17 Thread Siva kumar
Hi,    I am using a query form where I have provided SalesId(salesTable), ItemNumber(Saesline) as selection criteria.   I have joined the datasources Salestable and Salesline table with delay linktype.(As Sales order form).     When I select SalesId from selection criteria, records are coming

Re: [Axapta-Knowledge-Village] Option Button in Class dialog

2008-07-10 Thread Siva kumar
lass dialog To: Axapta-Knowledge-Village@yahoogroups.com Cc: "Axapta Development" <[EMAIL PROTECTED]> Date: Friday, July 4, 2008, 11:55 AM Dear SivaKumar, Are u asking about check box in dialog. if its so, then you can use "NoYesId" EDT for showing option button in dialog.

[Axapta-Knowledge-Village] Option Button in Class dialog

2008-06-27 Thread Siva kumar
Hi,   When I have created an dialog through class, It is not showing the option button. It is showing Select and Default button. Is there any way to add Option button through Code?   If anyone come across this please need your suggestion/solution.     Thanks, MGS   

[Axapta-Knowledge-Village] Path for BLOB

2008-05-04 Thread Siva kumar
Hi all, I need to get the path of image which is stored in BLOB. If there is any solution please let me know... Thanks, Siva "Hands that Help is Holier than Lips that Pray" - Be a better friend, newshound, and know-it-all wit

[Axapta-Knowledge-Village] Excel - Via COM

2008-04-08 Thread Siva kumar
Hi Buddies, I have a problem in Inserting TextBox into Excel sheet Range where there is picture already inserted. I am creating a Excel sheet from axapta using COM. I created a Excel template in which I added Company logo at A1...M1. I need to place some text using Te

[Axapta-Knowledge-Village] Inventory Dimension Setup - Help

2008-03-18 Thread Siva kumar
Hi, Here is the problem say for Item ITEMA I have OnHand quantity (say 10) at W/h / Location (FG / B001). Now I assign a new dimension group (say Tray) which is checked on active for Tray management and checked on for Allow Blank Receipt and Allow Blank Issue. Now if I transfer this 10

[Axapta-Knowledge-Village] Array field in report

2008-01-22 Thread Siva kumar
Hi, I need to print the array field in a report. I am having a String Array field called "ArrayTest" which has 10 element of size 10. I want to print these field in the report in this format. Field1Field2 ArrayTestfield: XXXx

Re: [Axapta-Knowledge-Village] Inventory dimension - help

2008-01-11 Thread Siva kumar
ing of inventory dimensions is concerned, it can be done from IM --> Setup --> Parameters form and tab "Inventory dimensions". Hope this is what you are looking for. Regards, Sumit On Jan 10, 2008 9:59 PM, Siva kumar <[EMAIL PROTECTED]> wrote: > Hi , > > I need to disab

[Axapta-Knowledge-Village] Inventory dimension - help

2008-01-10 Thread Siva kumar
Hi , I need to disable the some fields[SerialId,BatchId,ColorId,SizeId,PalletId] from the inventdimparmfixed form. Is this possible?. if possible how? Any suggestion is appreciable. thanks, SIva We Born to Win... -

[Axapta-Knowledge-Village] Report Section Error

2007-12-05 Thread Siva kumar
Hi, When I am running Purchpurchaseorder report Iam getting error as " Section in the report is higher than the actual page allow size". Has anyone come across such error. If so, Please let me what your suggeston to solve this issue? Thanks, MGS

Re: [Axapta-Knowledge-Village] Urgent Help - Alert

2007-07-12 Thread Siva kumar
Hi kapil, I have attached the document earlier. No problem again Iam attaching the document. Thanks, Siva Kapil Khanna <[EMAIL PROTECTED]> wrote: document Siva kumar <[EMAIL PROTECTED]> wrote: Hi Friends, I have problem in firing Emai

[Axapta-Knowledge-Village] Urgent Help - Alert

2007-07-10 Thread Siva kumar
Hi Friends, I have problem in firing Email alert from dynamics Ax. I have attached the document which contains the steps I followed. Can anyone go through this document and help me on this issue. If any solution will be greatful to you. Thanks, Siva We Born to Win...

Re: [Axapta-Knowledge-Village] Delete alerts

2007-06-26 Thread Siva kumar
ht We Born to Win Regards Nitesh Siva kumar <[EMAIL PROTECTED]> wrote: Hi, I am having sround 9 lacs alerts in the eventInBox table. I tried to delete it, It took 4 hrs to delete 1 records. To complete 9 lacs It will take an week. Is there any easy way to delete quickly. Ev

[Axapta-Knowledge-Village] Delete alerts

2007-06-22 Thread Siva kumar
Hi, I am having sround 9 lacs alerts in the eventInBox table. I tried to delete it, It took 4 hrs to delete 1 records. To complete 9 lacs It will take an week. Is there any easy way to delete quickly. Even I tried to delete the alert in manahe alert tule form. Same thing happe

[Axapta-Knowledge-Village] Need help in alert Rule

2007-06-20 Thread Siva kumar
Hi Friends, I am struggling with Create alert rule. I am working from remote desktop. I want to get the alert mail to my outlook account when the created alert rule event occurs. I have given the Email parameters from administrator\setup\Email parameter as Outgoing mailserver

[Axapta-Knowledge-Village] sysQueryForm

2007-04-29 Thread Siva kumar
Hi Guys, I want to check the condition from the report that whether the sort and groupby checkbox is checked/not in the sysQueryForm sort tab. Suggestion will be appreciated. Thankx, kumar We Born to Win... - Ahhh...ima

Re: [Axapta-Knowledge-Village] Create alert rule

2007-03-21 Thread Siva kumar
ceive Alerts every(minutes). Can you tell me what is this value in your system? Cheers On 3/22/07, Siva kumar <[EMAIL PROTECTED]> wrote: > > Hi Basu, > > I have set the alert frequency as No End Date, and for all orders. My > understanding is this for alert frequency. If not

Re: [Axapta-Knowledge-Village] Create alert rule

2007-03-21 Thread Siva kumar
quency you have set? On 21 Mar 2007 05:27:28 -0700, Siva kumar <[EMAIL PROTECTED]> wrote: > > Hi All, > > > Create alert rule is not woking for me for the event: has changed, when > record created. But it is working for Date postponed. > > Any suggestion will be hi

[Axapta-Knowledge-Village] Create alert rule

2007-03-21 Thread Siva kumar
Hi All, Create alert rule is not woking for me for the event: has changed, when record created. But it is working for Date postponed. Any suggestion will be highly appreciated. Thanks, Siva We Born to Win... - Finding fabulou

Re: [Axapta-Knowledge-Village] Date to String Conversion

2007-01-24 Thread Siva kumar
Hi you can use the inbuild function Date2Str() E.g date2str(today(),213,1,4,4,4,4); It prints January/25/2007 It may help you.. Thanks, Siva Imthiyaz Ahamed <[EMAIL PROTECTED]> wrote: Hi Group, In one of my Report, I wish to display date in str

Re: [Axapta-Knowledge-Village] RunbaseReport

2007-01-03 Thread Siva kumar
Hi, Consider you want to retain the last value entered for the field "From date". In dialog, modify it as dialogFromDate = dialog.addFieldvalue(typeid(TransDate), fromDate, "Labelname"); But the field fromdate should be added in Macro. I think It may help you... thank

Re: [Axapta-Knowledge-Village] Re: Trade & Logistics Training Material

2006-12-06 Thread Siva kumar
Hi, Can you please send me the soft copy of the Document for T&L if you don't mind. I have plan to give up the T&L exam by this month end. thanks in advance, Siva Khurram Zaki <[EMAIL PROTECTED]> wrote: Hello guys, I got this breakup of T&L paper when I was preparing fo

Re: [Axapta-Knowledge-Village] Missing Select Button in Report

2006-11-23 Thread Siva kumar
ties of report and set the inetractive option to yes. if i have misunderstood ur question. explain the question with an example. thanks, Saravanan J kbi kbi <[EMAIL PROTECTED]> wrote: Hi Siva, can you give an example? Thanks Khue ----- Original Message From: Siva kumar <[EMAIL PROTECTE

[Axapta-Knowledge-Village] Missing Select Button in Report

2006-11-22 Thread Siva kumar
Hi Friends, I found Select Button is missing in some Reports. I couldn't able to fix it. Please if anyone came across this Problem. welcome your suggestion. I found this happens in Standard Ax 4.0 also. Path: Production\Reports\BaseData\Operation Relation I

RE: [Axapta-Knowledge-Village] how to convert Real value as a string?

2006-05-31 Thread Siva kumar
Hi,      For printing the paise   just modified  the numeralstotxt() as    case 100 :     {     _test = _test MOD 100;     // Modified to be done   if(_test==0)     returntxt = returntxt + ' ' + hundreds;   

Re: [Axapta-Knowledge-Village] Trade & Logistics Training Material

2006-05-29 Thread Siva kumar
Hi Rishika,         Iam siva from India. Could you please send me the material for T&L  . Iam going to give up my exam next month.      Thanks in advance,   Siva Dhiraj yadav <[EMAIL PROTECTED]> wrote:   plz send me rashika iwant to clear this exam as soon as possible thanx in advance

Re: [Axapta-Knowledge-Village] Changing the tabpage color (Caption)

2006-05-01 Thread Siva kumar
Hi,        Change the Colorscheme to RGB then you try, it will work.         Wishes,   Siva tgodg <[EMAIL PROTECTED]> wrote:   Hi, i want to change the background color of a tabpage.  I changed the backgroudcolor properties but the tabPage caption stay the same color.  Someone kno

Re: [Axapta-Knowledge-Village] creating password field

2006-04-25 Thread Siva kumar
Hi hema,       Please have a look into this form, it may help to solve your requirement.   Administration-> setup - > system -> license information form         wishes,   Siva venkat raghavan <[EMAIL PROTECTED]> wrote:   Hai hema,      Go to the password field property sheet, and set th

Re: [Axapta-Knowledge-Village] Report problem - urgent plss

2006-04-04 Thread Siva kumar
Hi. Iam not clear with your requirements. Iam providing solution for what I understood. Are you storing the palletid in the table. if so, In fetch method use query(). fetch() { boolean ret; QueryQ = new Query(this.query()); Que

Re: [Axapta-Knowledge-Village] Report Writing

2006-04-04 Thread Siva kumar
Hi, Use the function systemdateget() to get the asofdate. I think It will suits your requirement. Thanks & regards, siva yrbeach <[EMAIL PROTECTED]> wrote: How do I get an "As of" date into a report? I need to get information "as of" the end of a month/qtr/year

Re: [Axapta-Knowledge-Village] Programmable Section Query?

2006-03-30 Thread Siva kumar
Hi, Sorry , You can write a method under the Report-> method1() { return "Hi"; } and you can call from programable section.Write a method in programmable section programmablesection() mtd() { return element.method1(); } Siva Siva

Re: [Axapta-Knowledge-Village] Programmable Section Query?

2006-03-30 Thread Siva kumar
Hi, I don't think so, it is possible to place the method for P.Section in a common place. Regards, MGS vk <[EMAIL PROTECTED]> wrote: Hi, In my report having 2 programmable section.One is BullTozer and another one is Excavator.Getting Record from Database table,

Re: [Axapta-Knowledge-Village] How to get distinct records in report?

2006-03-29 Thread Siva kumar
Hi vijay, Use Fetch() { QueryQ = New Query(this.Query); QueryRun QR; EquipmentTableEquipmentTableTmp; ; this.query().datasourcetable(tablenum(EquipmentTable)).OrderMode(OrderMode::Groupby); this.query().datasourcetable(tablenum(EquipmentTable)).addso

Re: [Axapta-Knowledge-Village] Re: Trade and Logistics Exam

2006-03-29 Thread Siva kumar
Hi Raj, Iam also planned to give T&L exam sooner. If you provide the exam topics It will be useful for me. Please mail me the topics to my mail Id: [EMAIL PROTECTED] Thanks, MGS Nag K <[EMAIL PROTECTED]> wrote: Hi Raj, Would you be able to email me the exam topics (T & L)

Re: [Axapta-Knowledge-Village] Urgent : The Report is not being scaled.

2006-03-27 Thread Siva kumar
Hi Priyank, In prompt method before Super() try this code: element.printjobsettings().fitToPage(True); Thanks & regards, Siva Priyank Krishna <[EMAIL PROTECTED]> wrote: hi guys, I am facing strange thing on the report. In a report, I have added 30 controls in a p

Re: [Axapta-Knowledge-Village] has been released!!!

2006-03-14 Thread Siva kumar
Hi *Hi qhpeng,* Iam happy to hear that you have written a book on axapta from your experience. Yes, we would like this has to be translated into English language. Iyour E-Book should be used by different people around the world. So, Can you make it and I need a copy of it. All t

[Axapta-Knowledge-Village] Lookup

2006-03-09 Thread Siva kumar
Hi Pals, First I will explain the situation, In a form Iam having two field, name and desc., the name field has the Lookup, lookup values comes from the utilelements table.(Here I grouped the field name in the utilelement table. , if I further filter / finding name by right click

Re: [Axapta-Knowledge-Village] Calling Dialog class when creating new record

2006-03-05 Thread Siva kumar
called see this class for reference... or just call ur class on the create method of the form... use accessors method for the value selected in the combo box Hope this will work Regards, Shiv Siva kumar <[EMAIL PROTECTED]> wrote: Hi Pals, I

[Axapta-Knowledge-Village] Calling Dialog class when creating new record

2006-03-01 Thread Siva kumar
Hi Pals, I overcome the situation where , When Iam clicking the ctrl+N to create record in the form , I have to call the dialogbox In which I should select an enum type Item from combobox. when I click ok the selected value should return from where I called this dialog. I tr

Re: [Axapta-Knowledge-Village] Re: Type Casting in Axapta Urgent Please

2006-02-15 Thread Siva kumar
Hi Gayathri, How you can check for equality of ItemId with the EDT ItemCode which has the value All,Table,Group. It won't be match.because ItemId will have value like "DD00w3wy". Regards, Siva "Subrahmanyam, Mamidi" <[EMAIL PROTECTED]> wrote: Hi, pls post top some piece of

Re: [Axapta-Knowledge-Village] Temporary table

2006-02-12 Thread Siva kumar
Hi, You can catch the data into the temp. table by using this.. while some constraint { tempTable.data(Origtable); } All the Best, Siva Setiaji <[EMAIL PROTECTED]> wrote: Thx for your immediate answer. How can i catch the data? - setiaji - kumar gaurav

RE: [Axapta-Knowledge-Village] Multi select in a form and perform operation

2006-01-22 Thread Siva kumar
Thank u Daniel, Its working fine. Siva daniel lim <[EMAIL PROTECTED]> wrote: hi Siva, in .clicked method of a button and this button must be enabled for multiselect. daniel Siva kumar <[EMAIL PROTECTED]> wrote: Hi Daniel, Where did you try

RE: [Axapta-Knowledge-Village] Multi select in a form and perform operation

2006-01-19 Thread Siva kumar
Hi Daniel, Where did you try this code, I mean in which method you tried. Let me know please. Thanks, siva daniel lim <[EMAIL PROTECTED]> wrote: hi Lennart, its working fine for single and multiselect records.thx lot! daniel Lennart Conrad <[EMAIL PROTECTED]> w

RE: [Axapta-Knowledge-Village] Filter option in Display method

2006-01-05 Thread Siva kumar
Thank you Mittal for the suggestion.  I think  we have to call the filter method during runtime. But My Question is I Need to get Filter and Find Option when rightclick on display control. I know It is only a display control Its not and edit control. I want to clarify whether it is possible

[Axapta-Knowledge-Village] Filter option in Display method

2006-01-03 Thread Siva kumar
Hi Pals,       I want the find and Filter option in the display Control of the Grid. Normally, If we place an display method in the Grid, If rightClick we will get only hide and setup popup. But I need to have Filter and Find option as in table field in Grid.   One more thing,  In a Dial

[Axapta-Knowledge-Village] RecID

2006-01-02 Thread Siva kumar
Hi,       The RecID is generated sequentially from the Table "SystemSequences" from the System Documentation folder..       Siva.     We Born to Win... Yahoo! DSL Something to write home about. Just $16.99/mo. or less Sharing the knowledge on Axapta. Visit www.frappr.com/axapta

[Axapta-Knowledge-Village] AOS Certification

2005-12-13 Thread Siva kumar
Hi Guys,     Iam preparing for the AOS certifiation Exam. Can anyone give suggestion what material can I read, If any sample questions, Please let me know. Thanks in Advance.   Thanks & Regards, siva   We Born to Win... Yahoo! Shopping Find Great Deals on Holiday Gifts at Y

Re: [Axapta-Knowledge-Village] Vendor invoices

2005-11-30 Thread Siva kumar
Hi,     Check with the AP-Setup-Parameter-Summaryupdate. It may be in auto summary. Change it to None. and also check in purchase order setup, summary update. otherwise, we can override the selection while posting the invoice, in the posting form, other tab, select the summaryupdate to non

[Axapta-Knowledge-Village] Clearing Sort field

2005-11-23 Thread Siva kumar
Hi pals,   I got a problem while prinitng report. Iam adding 3 fields in the report datasource sorting. While running the report Iam selecting (checking) only one field in the select query Sorting tab. I want only the selected field should be sort. IS there any way to clear the non se

Re: [Axapta-Knowledge-Village] India&ERP scholarship

2005-11-16 Thread Siva kumar
Hi  Tansu Tosun,     Iam from Chennai(India). Iam also working in Axapta platform. Axapta is new to Indian Companies. Only few of them are using Axapta. I couldn't get you, Whether you are coming for research work or for higher studies. Pleasely mention your requirement. If pos

[Axapta-Knowledge-Village] Catching infolog

2005-11-03 Thread Siva kumar
Hi pals,     We have some requirements.Can anyone pls help us on this.The requirement is:- We want to catch all the errors & warnings that were being thrown from different classes and finally need to show it in the report.So if there is any means by which we can access the infolog c

[Axapta-Knowledge-Village] Moving more than one item to another form

2005-11-03 Thread Siva kumar
Hi morris & Harry,       Thanks for your valuable suggestions.   Thanks & Regads,   Siva   Varden Morris <[EMAIL PROTECTED]> wrote: Hi Siva   Here is an attached example I prepared for you. Open form1 and enter vlaues in the integer edit boxes then select the menu to load form2 and you wil

[Axapta-Knowledge-Village] Moving more than one item to another form

2005-11-02 Thread Siva kumar
Hi pals,     How can I Pass more than one item from a form to another form. In my problem, If Iam selecting an item it is passed through the method called parmitem. When Iam calling this class from another form, I can get the Item through the parm method of the class. I need to select mu

[Axapta-Knowledge-Village] Hi Pals,

2005-10-19 Thread Siva kumar
Hi Pals,     I Need to create a salesordercreation wizard with 2 screens. In First screen, It should get the SalesTable information and in the second wizard SalesLine information.if we click the finish button, it should insert records in SalesTable and SalesLine. If anybody come across t

[Axapta-Knowledge-Village] MBS - X++ Exam

2005-10-11 Thread Siva kumar
Hi Brandon George,   This is Sivakumar. I had some suggestion on MBS X++ Certification. Exam Consist of Objective Type ( Multiple Answer also to be selected). This test consist of    1. General Machine Architecture    2. Development Tools    3. Application Objects