Re: [development-axapta] How to use TFS with Axapta.
Hi Alok, There is a whitepaper on partnersource. That document should be good enough for you. In case you face any problem, then please drop me an email. Regards Amit --- On Fri, 1/10/10, alokmishra_004 alokmishra_...@yahoo.com wrote: From: alokmishra_004 alokmishra_...@yahoo.com Subject: [development-axapta] How to use TFS with Axapta. To: development-axapta@yahoogroups.com Date: Friday, 1 October, 2010, 7:17 AM Hi Friends, Please help me to use TFS with Axapta. Have you any document related with Configuration of TFS with Axapta. [Non-text portions of this message have been removed]
Re: [development-axapta] DB Upgrade Tool Error
hi Nitin, Check if you have any external tables in SQL Server (tables which are not there in AX but they are present in SQL Server AX database). If you have such tables, please follow below mentioned steps: 1. Export data from those tables 2. Delete all those tables from SQL Server 3. run this tool and import these tables in new database. Hope it works for you. In case it doesn't, do let me know. Regards Amit --- On Tue, 15/9/09, nitinmathur_jpr nitinmathur_...@yahoo.com wrote: From: nitinmathur_jpr nitinmathur_...@yahoo.com Subject: [development-axapta] DB Upgrade Tool Error To: development-axapta@yahoogroups.com Date: Tuesday, 15 September, 2009, 3:58 PM Hi, I am trying to migrate from AX 4.0 SP1 to AX 2009 SP1 with indian localization. After running the 'DBUpgrade Tool' shipped with Ax 2009 i am facing the problem. - - - - - - OCC: Updating table SqlDictionary Error while execution the following sql:DECLARE TABLES CURSOR FOR SELECT DISTINCT TABLEID FROM [DynamicsAx2009Test ].[dbo].[ SQLDICTIONARY] DECLARE @RECVERSIONNAME NVARCHAR(20) SET @RECVERSIONNAME = N'RECVERSION' DECLARE @TABLEID INT OPEN TABLES FETCH TABLES INTO @TABLEID DECLARE @STATEMENT NVARCHAR(2000) DECLARE @RECID INT WHILE (@@FETCH_STATUS =0) BEGIN SET @RECID = 0 SELECT @RECID = RECID FROM [DynamicsAx2009Test ].[dbo].[ SQLDICTIONARY] WHERE TABLEID = @TABLEID AND FIELDID = 61450 IF @RECID = 0 BEGIN SELECT @RECID = (CASE WHEN MAX(RECID) 0 THEN MAX(RECID) ELSE 0 END) + 1 FROM [DynamicsAx2009Test ].[dbo].[ SQLDICTIONARY] SET @STATEMENT = N'INSERT INTO [DynamicsAx2009Test ].[dbo].[ SQLDICTIONARY] ' + N'(TABLEID,FIELDID, ARRAY,NAME, SQLNAME,FIELDTYP E,STRSIZE, SHADOW,RIGHTJUST IFY,NULLABLE, FLAGS,RECID, RECVERSION) VALUES ' + N'(' + CAST(@TABLEID AS NVARCHAR(10) ) + N',61450,1,' '' + @RECVERSIONNAME + N''',''' + @RECVERSIONNAME + N''',1,0,0,0, 0,0,' + CAST(@RECID AS NVARCHAR(10) ) + N',1)' EXECUTE SP_EXECUTESQL @STATEMENT END FETCH TABLES INTO @TABLEID END CLOSE TABLES DEALLOCATE TABLES SqlState 22003, NativeError 8115: [Microsoft][ ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type int. SqlState 22003, NativeError 8115: [Microsoft][ ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type int. SqlState 23000, NativeError 547: [Microsoft][ ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the CHECK constraint CK__SQLDICTIO_ _RECID__496B2A13 . The conflict occurred in database DynamicsAx2009Test , table dbo.SQLDICTIONARY , column 'RECID'. SqlState 01000, NativeError 3621: [Microsoft][ ODBC SQL Server Driver][SQL Server]The statement has been terminated. - - - - - - Please help ASAP. Thanks and Regards, Nitn Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com [Non-text portions of this message have been removed]
[development-axapta] Urgent!!!Post synchronization job taking too much time
Hi Guys, I am upgrading Axapta 3.0 SP3 to AX 4.0 SP2. Client has around 125 GB of data. During upgrade checklist, post synchronization is taking too much time and system totally goes into processing mode (sort of hangs). It is running almost for past 40 hours. Is there any way to fasten the process, or find the problem area. Also please tell me, is it ok, if i restart AOS and restart post syncronization process in middle of this process (when 60% of post synch has already been completed). Second issue is that for one of the table, some duplicate record is automatically getting created, during DBUpgradeTool exe execution. Please advice on these issues. Regards Amit Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ [Non-text portions of this message have been removed]
[development-axapta] urgent!!!Deployment plan document for AXapta upgrade project!!!
Hi, Does anybody has recommended deployment plan document for Axapta upgrade preferably from AX 3.0 to AX 4.0? Regards Amit Add more friends to your messenger and enjoy! Go to http://in.messenger.yahoo.com/invite/ [Non-text portions of this message have been removed]
[development-axapta] Validate Data upgrade from Axapta 3.0 SP3 to Axapta 4.0 SP2
Hi, Is there any way to validate, if the whole data has been migrated while performing upgrade from 3.0 to 4.0 SP2? I know that we can number of records in each table by running the report in each version, but still it is kind of partial solution, which we cannot rely on. Any help or suggestions would be highly appreciated. Regards Amit Bollywood, fun, friendship, sports and more. You name it, we have it on http://in.promos.yahoo.com/groups/bestofyahoo/ [Non-text portions of this message have been removed]
Re: [development-axapta] How to call a job
Make a menuitem of Job and then run that menuitem through code. William S. Jacobsen [EMAIL PROTECTED] wrote: Anyone who knows how to call a Job from code? /William [Non-text portions of this message have been removed] - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed]
Re: [development-axapta] Setting filter
Manoj Just try using the dynalinks property on the datasource I think that should be sufficient. shruti [EMAIL PROTECTED] wrote: Hi Manoj, Where do u have this item field on the new form? If u have this on the new form then u can do the desired task by defining a QueryBuildRange object in the 'classDeclaration' and then setting this object range in the 'init' method of the data source and setting the value for the range in the 'executeQuery'. U can view smmQuotationTable form for the same. Regards Shruti - Original Message - From: manoj kumar [EMAIL PROTECTED] To: development-axapta@yahoogroups.com Sent: Thursday, December 22, 2005 11:32 AM Subject: [development-axapta] Setting filter Hi I need to set a filter to display the item i select in another form.Is there any solution that i can do by some coding Manoj Send instant messages to your online friends http://in.messenger.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange - YAHOO! GROUPS LINKS Visit your group development-axapta on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Best Practice error (Wrong security key. Security key must match position in main menu)
Hello Vikas, I think you have not put the security key in the menu item. Just put the security key in that. Be careful in putting the security key, because it should be according to the module and submenu you put that menu item in. Regards Amit vikas garg [EMAIL PROTECTED] wrote: Hello all, I am facing a best practice error with mess as Wrong security key. Security key must match position in main menu. please tell me what is the cause of this error and what can be done to solve this issue. I am using Axapta 3.0 with SP3. Thanks Vikas Garg - Yahoo! DSL Something to write home about. Just $16.99/mo. or less [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange - YAHOO! GROUPS LINKS Visit your group development-axapta on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Music Unlimited - Access over 1 million songs. Try it free. - Yahoo! Music Unlimited - Access over 1 million songs. Try it free. [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Urgent!!! how to set the mail body through prinjobSettings class
Hello, I have a scenario, that when i post the purchase order (confirmation) and the format of the purchase order confirmation is selected as e-mail, i want to customize the body of the mail according to some criteria(in standard Axapta it is always 'Axapta Report', which is taken from classes/info/reportSendMail method). I can see that i can modify the mailTo, mailSubject,mailCC and even from field, but there is no method or properties to modify the body of the mail Can anybody suggest me something on this. Regards Amit Jain - Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: YNT: [development-axapta] SalesFormLetter_invoice from salespackingslipfor.
H yes there is no salestable but salesparmtable or salesparmline. but as you want to have the quantities also, you can do one thing add a new field in the salesparmline table and update it during updatenow method, when salesparmline is updated. Also add a range to the Salesparmline datasource in the saleseditlines form. hope it helps Cenk Ince [EMAIL PROTECTED] wrote: Hi Amit There is no salestable in saleseditlines form. So i can't join it. My aim is to bring qty of packingslip to salesparmline. Thanks. Kimden: Amit Jain [mailto:[EMAIL PROTECTED] Gönderilmiþ: Sal 22.03.2005 14:32 Kime: development-axapta@yahoogroups.com Konu: RE: [development-axapta] SalesFormLetter_invoice from salespackingslipfor. i think you do not require to code this. only thing you have to do is to add another datasource custPackingSlipJour, in the query in SalesEditLines form, and link it with the salestable. You can select the range packingslipid and see the selected records. Regards Amit Gülden Saylan wrote: Hi, Yes, it is possible, You can do it by coding in SalesFormLetter Class. -Original Message- From: Cenk Ince [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 10:29 AM To: development-axapta@yahoogroups.com Subject: [development-axapta] SalesFormLetter_invoice from salespackingslipfor. Hi all; My customer wants it to be possible select some packingslip and directly invoice it. But on salestable if i select that salesorder all packing slips not invoiced comes to saleseditlines form. My customer wants to select some packingslips from custpackingslip form and there should be a button like posting/invoice and saleseditlines should be opened in this way, with quantities of selected packingslips. Is it possible to do something like this. How can i do this? Thanks. [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links - Do you Yahoo!? Yahoo! Small Business - Try our new resources site! [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] Yahoo! Groups Links - Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: YNT: [development-axapta] SalesFormLetter_invoice from salespackingslipfor. (ignore my last mail)
Hello Ignore my last mail, because may be i did not read the full requirement. Regards Hans-Walter Bous [EMAIL PROTECTED] wrote: Hello Cenk, I don't understand that. How long do you think it will take you ? And: what will your customer pay for that ? From my own experience I can tell you that you have to make major adoptions in the following classes: - SalesFormLetter - SalesEditLinesForm - TradeLoopTrans - InventUpdate. So it might be cheaper to buy than to develop on your own. Hope to hear from you. H.W. Bous Cenk Ince [EMAIL PROTECTED] wrote: Thanks Bous But i can't pay for it, so i must complete it myself. Kimden: Hans-Walter Bous [mailto:[EMAIL PROTECTED] Gönderilmiþ: Sal 22.03.2005 12:34 Kime: development-axapta@yahoogroups.com Konu: Re: [development-axapta] SalesFormLetter_invoice from salespackingslipfor. Hi Cenk, I did this already and I've got a little add-on module (with configuration key) thta does exactly what you need. You can contact me directly: [EMAIL PROTECTED] or [EMAIL PROTECTED] John Cenk Ince wrote: Hi all; My customer wants it to be possible select some packingslip and directly invoice it. But on salestable if i select that salesorder all packing slips not invoiced comes to saleseditlines form. My customer wants to select some packingslips from custpackingslip form and there should be a button like posting/invoice and saleseditlines should be opened in this way, with quantities of selected packingslips. Is it possible to do something like this. How can i do this? Thanks. [Non-text portions of this message have been removed] Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] Yahoo! Groups Links - Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher [Non-text portions of this message have been removed] Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [development-axapta] SalesFormLetter_invoice from salespackingslipfor.
i think you do not require to code this. only thing you have to do is to add another datasource custPackingSlipJour, in the query in SalesEditLines form, and link it with the salestable. You can select the range packingslipid and see the selected records. Regards Amit Gülden Saylan [EMAIL PROTECTED] wrote: Hi, Yes, it is possible, You can do it by coding in SalesFormLetter Class. -Original Message- From: Cenk Ince [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 10:29 AM To: development-axapta@yahoogroups.com Subject: [development-axapta] SalesFormLetter_invoice from salespackingslipfor. Hi all; My customer wants it to be possible select some packingslip and directly invoice it. But on salestable if i select that salesorder all packing slips not invoiced comes to saleseditlines form. My customer wants to select some packingslips from custpackingslip form and there should be a button like posting/invoice and saleseditlines should be opened in this way, with quantities of selected packingslips. Is it possible to do something like this. How can i do this? Thanks. [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links - Do you Yahoo!? Yahoo! Small Business - Try our new resources site! [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [development-axapta] Another inquiry on passing parameters
Hello Eya, you can do this in various ways, like returning to the datasource method or form method. If you are using form method then try this in the called form. object callerForm callerForm = element.args().caller(); create a new element method in caller form. Let it be initParmFromCalledForm(formal parameters list) then from some global variable put the values of global variables from formal parameters. Now whenever you want to send the parameters, use callerForm.initParmFormCaller(parameter1, parameter2) I hope it helps.. Still any pointer then let me know. Regards Amit then whenever you want send the values to the caller form, you have e_parungao [EMAIL PROTECTED] wrote: Hi again! This is the scenario: I have a source form that calls and passes parameter to the target form. It is already working.. My problem now is how I can return values back to the source form from the target form. How do I go with this? Do I still use Args? Thanks! Eya Yahoo! Groups SponsorADVERTISEMENT document.write(''); - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: AW: [development-axapta] strange behaviour of a table in the AOT
Hello Well i have a solution to this problem. This might not be technical one but always work. What you can do is create two new tables, one of which is placed before the corrupted table and other after. Select first new table and then select second new table using shift so that the table in between i.e. corrupted table is also selected and then delete the tables. This will solve your problem and you don't need to delete the VAR layer. Happy deletion of the corrupted table. Cheers Amit Jain Euroinfo systems (EIS) India Hi Sebastian, take a look in the system table SQLDictionary (Filter on your table name) Maybe the table is registered twice Otto -Ursprüngliche Nachricht- Von: Sebastian Draese [mailto:[EMAIL PROTECTED] Gesendet: Montag, 20. Dezember 2004 11:08 An: development-axapta@yahoogroups.com Betreff: [development-axapta] strange behaviour of a table in the AOT Hello, i have some trouble with a table in the AOT. The Table is placed at the VAR-Layer, but the funktion tablename2id gives me an 50002-Id, but it wasn't imported with ID, it was created in the AOT Sync and compile of the data dictionary works well. Also the rebuild index at the sql-administration-form. but when i select / click the table at the AOT, Axapta Crashes immediately ! i can't even delete the table ! when i use the sql-administration-form and use the menufunction search, i'll get the message: not enough rights for this table. but the user admin has full access on every sec-key exists at the aot ! what can i do ?? how can i remove / delete this table without delete the whole var-layer ? bxe, SebDra -- - Dipl.Ing. (BA) Sebastian Draese [EMAIL PROTECTED] [EMAIL PROTECTED] NEU +++ DSL Komplett von GMX +++ http://www.gmx.net/de/go/dsl GMX DSL-Netzanschluss + Tarif zum supergünstigen Komplett-Preis! Yahoo! Groups Links Yahoo! Groups Links - Do you Yahoo!? Send holiday email and support a worthy cause. Do good. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: AW: [development-axapta] closing the caller form
Hi guys, Yes Palle is correct, but there is a problem with that. As the caller form is using formrun.wait() method, even the close method of caller form is called, the form would not be closed. the best way (my personal opinion) to use the same code suggested by Palle but try to open the form with menuitembutton not using FormRun object. Hope it helps Cheers Amit Jain Euroinfo Systems Pvt. Ltd. India Palle Mølgaard [EMAIL PROTECTED] wrote: Hi, you must set the caller to the form instead of the button by using : args.caller(element); instead of : args.caller(this); In your clicked()-method. Regards Palle From: Jesmond Giordimaina [mailto:[EMAIL PROTECTED] Sent: 28. september 2004 13:32 To: [EMAIL PROTECTED] Subject: Re: AW: [development-axapta] closing the caller form Hi, thanks for fast reply. But it's still telling FormButtoncontrol Object does not have method close. The code that opens the second form is this: void clicked() { Args args = new Args(); //Passing args to form Form frm = new Form('ShowCustTableData'); FormRun formRun; ; args.object(frm); args.caller(this); formRun = classFactory.formRunClass(args); formRun.init(); formRun.run(); formRun.wait(); } The code that tries to close the form (from the second form) is : void clicked() { Args args = new args(); FormRun frm; ; frm = element.args().caller(); frm.close(); } reg Jesmond --- Matthias Schuster [EMAIL PROTECTED] wrote: Hi Jesmond, try this! FormRun frm; Frm = element.args().caller(); Frm.close(); Cu M _ Von: Jesmond Giordimaina [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 28. September 2004 11:05 An: [EMAIL PROTECTED] Betreff: [development-axapta] closing the caller form Hi all, does anybody know how to close a form from another form? I am trying to use the following code from the active form. Args args = new args(); Form frm; ; frm = args.caller(); frm.finalize(); Thanks in advance reg Jesmond ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129oqu6ba/M=295196.4901138.6071305.3001176/D=groups/S=1705006764:HM/EXP=1096452390/A=2128215/R=0/SIG=10 se96mf6/*http:/companion.yahoo.com click here http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=532916298 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129ocipta/M=295196.4901138.6071305.3001176/D=groups/S=1705006764:HM/EXP=1096457590/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=651599442 Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups SponsorADVERTISEMENT - Yahoo
RE: [development-axapta] Re: Warehouses in Master Planning
queryAddSortField method in inventdimparm table is the key. From here master scheduling process controls that fields configid, color, size and warehouse should be considered for the master scheduling. In case u want master schedule should not consider configId then u have to modify this method by searching the value which is used for configID. At least i can tell u that it uses value of x as 4 for the Batch ID field. Happy master planning cheers Harry Deshpande [EMAIL PROTECTED] wrote: Hi Yifat InventDim inventDimSearch; inventDimSearch.inventlocatoinid = InventDim::find(_reqPo.CovInventDimId)..InventDimId; reqTransBOM.CovInventDimId = InventDIm::findorcreate(inventdimsearch).InventDimId; this should solve ur problem. Since I am typing from memory, the above may have some typos. Regards harry _ From: Yifat Halili [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 June 2004 10:40 p.m. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [development-axapta] Re: Warehouses in Master Planning Hi Harry, I need some more help please... We are thinking of using item dimensions i.e. size and colour... The problem comes in where I am using the code that you gave me. The code populates the item dimensions for the raw material by looking at the item dimensions of the finished goods. I understand why it happens BUT, is there a way for the code to only populate the warehouse, and not all the dimensions?? Thanks in advance... Yifat From: Deshpande, Harry [mailto:[EMAIL PROTECTED] Sent: 21 April 2004 04:21 To: '[EMAIL PROTECTED]' Subject: RE: [development-axapta] Re: Warehouses in Master Planing hi Yifat, this is a one line modification. change method 'createBOM' on table 'reqTrans'. Put the following line somewhere in the 'Search' loop inside this method (say when the quantity is assigned to the BOM.) reqTransBOM.CovInventDimId = _reqPo.CovInventDimId; this should solve your problem regards harry --- In [EMAIL PROTECTED], yifath1 [EMAIL PROTECTED] wrote: Hi there, The problem occurs when you run the master scheduling, it populates the warehouse for the production order, but it does not populate the warehouse for the raw material. For our solution to work (for our client) we need to be able to run master planning... there is no problem when creating manual production, but this is not the an option at the moment. Thanks Yifat --- In [EMAIL PROTECTED], Theissen, Annette [EMAIL PROTECTED] wrote: Does your problem only occur when creating a Production from MasterPlan but not when creating a Production directly? -Ursprüngliche Nachricht- Von: mud_mullet [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. April 2004 16:24 An: [EMAIL PROTECTED] Betreff: [development-axapta] Re: Warehouses in Master Planing I looked at her Discussion And your reply but i am pritty sure that the changes are not made on the Table they need to be Made in one of the classes that are used Maybe the reqcalc Class but im not sure where --- In [EMAIL PROTECTED], Theissen, Annette [EMAIL PROTECTED] wrote: Hi Jason, seems like you're working on the same as Yifat does. Why don't you have a look at the mails titled Produce the same BOM in 2 independent warehouses. Bye, Annette Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette Theißen System Software Entwicklung __ Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 Hannover Phone: +49/511/94996-0 - Fax: +49/511/94996-900 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - http://www.viscom.de http://www.viscom.de http://www.viscom.de/ http://www.viscom.de/ -Ursprüngliche Nachricht- Von: mud_mullet [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. April 2004 15:24 An: [EMAIL PROTECTED] Betreff: [development-axapta] Warehouses in Master Planing Hi all I have independent warehouses that really produce, purchase and sell items. However, the item master and bills are shared between the warehouses i.e. item Z is manufactured in all warehouses with components that sit in the warehouse where it is produced. Once i create demand for the same item to be produced in warehouse 1 and warehouse 2, i run master planning which
RE: [development-axapta] Re: Warehouses in Master Planning
Select coverage by item dimensions in the item dimension group for each corresponding dimensions like warehouse. That way your requirements would be scheduled according to the warehouse Regards Amit Jain EIS, India Yifat Halili [EMAIL PROTECTED] wrote: Hi Harry, I need some more help please... We are thinking of using item dimensions i.e. size and colour... The problem comes in where I am using the code that you gave me. The code populates the item dimensions for the raw material by looking at the item dimensions of the finished goods. I understand why it happens BUT, is there a way for the code to only populate the warehouse, and not all the dimensions?? Thanks in advance... Yifat From: Deshpande, Harry [mailto:[EMAIL PROTECTED] Sent: 21 April 2004 04:21 To: '[EMAIL PROTECTED]' Subject: RE: [development-axapta] Re: Warehouses in Master Planing hi Yifat, this is a one line modification. change method 'createBOM' on table 'reqTrans'. Put the following line somewhere in the 'Search' loop inside this method (say when the quantity is assigned to the BOM.) reqTransBOM.CovInventDimId = _reqPo.CovInventDimId; this should solve your problem regards harry --- In [EMAIL PROTECTED], yifath1 [EMAIL PROTECTED] wrote: Hi there, The problem occurs when you run the master scheduling, it populates the warehouse for the production order, but it does not populate the warehouse for the raw material. For our solution to work (for our client) we need to be able to run master planning... there is no problem when creating manual production, but this is not the an option at the moment. Thanks Yifat --- In [EMAIL PROTECTED], Theissen, Annette [EMAIL PROTECTED] wrote: Does your problem only occur when creating a Production from MasterPlan but not when creating a Production directly? -Ursprüngliche Nachricht- Von: mud_mullet [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. April 2004 16:24 An: [EMAIL PROTECTED] Betreff: [development-axapta] Re: Warehouses in Master Planing I looked at her Discussion And your reply but i am pritty sure that the changes are not made on the Table they need to be Made in one of the classes that are used Maybe the reqcalc Class but im not sure where --- In [EMAIL PROTECTED], Theissen, Annette [EMAIL PROTECTED] wrote: Hi Jason, seems like you're working on the same as Yifat does. Why don't you have a look at the mails titled Produce the same BOM in 2 independent warehouses. Bye, Annette Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette Theißen System Software Entwicklung __ Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 Hannover Phone: +49/511/94996-0 - Fax: +49/511/94996-900 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - http://www.viscom.de http://www.viscom.de http://www.viscom.de/ http://www.viscom.de/ -Ursprüngliche Nachricht- Von: mud_mullet [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. April 2004 15:24 An: [EMAIL PROTECTED] Betreff: [development-axapta] Warehouses in Master Planing Hi all I have independent warehouses that really produce, purchase and sell items. However, the item master and bills are shared between the warehouses i.e. item Z is manufactured in all warehouses with components that sit in the warehouse where it is produced. Once i create demand for the same item to be produced in warehouse 1 and warehouse 2, i run master planning which creates production and purchases orders for the correct items. However, the warehouse for the components of the the BOM is not populated. Any Help would be Greatly Appreciated Thanks in Advance Jason _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ http://groups.yahoo.com/group/development-axapta/ http://groups.yahoo.com/group/development-axapta/ http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL
RE: [development-axapta] Really important
Hi Harry Actually i want to track all the classes that has been executed and for which object has been created for any posting. So i would like to maintain a database for the same. i want to avoid writing code in all the base classes as it would take hell lot of time. So i am looking if i can get the name of the class/method, which is called everytime a control is there for a particular class. Regards Amit Regards Amit Harry Deshpande [EMAIL PROTECTED] wrote: Hi Amit! What is your business requirement? Regards harry _ From: Amit Jain [mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 June 2004 10:19 p.m. To: [EMAIL PROTECTED] Subject: [development-axapta] Really important Hello Guys, I have raised this query once before also but failed to get any responses. I am repeating that as it is very important. I want to know if there any place where i can find which class is getting executed. In more detailed manner i am looking for the type of posting that is in the process. Suppose somebody is performing sales invoice and other user is running puchase invoice on other hand then i should be able to catch both tasks at a single place. If query is not clear then pls do not hesitate to ask. Regards Amit Jain - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT click here http://rd.yahoo.com/SIG=129jvker6/M=298184.5022502.6152625.3001176/D=gr oups/S=1705006764:HM/EXP=1086777901/A=2164331/R=0/SIG=11eaelai9/*http:/w ww.netflix.com/Default?mqso=60183351 http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group s/S=:HM/A=2164331/rand=724128987 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Re: Really important
Hi Yes definitely you are correct if i am talking about Sales order postings but i am concered with any postings that happen in Axapta. Let me put this another way. I want that if a postings or anything like record creation is been done in any module i want to capture the information regarding that in a database table at the same time. One way of doing it is that i can put my code in every base class like formletter etc but i don't want that. So is there any method / class which is bypassed if any class is called or any object of any class is created. In short i am saying is there any event triggring functionality in Axapta. Regards Amit drfate88 [EMAIL PROTECTED] wrote: Hi Amit, it think you want to catch current processing tasks within the axapta application, meaning you want to retrieve the existing objects (eg. SalesFormLetter_Invoice). You have to know, that in a 2- tier envrionment objects only exist on the client (not new :-)). Have you thought about modifying the baseclasses (e.g. SalesFormLetter) that it's makes an entry in a table containing the needed data. Maybe you use the function ClassNum to find out which classinstance is in process! Be carefull when modifying Classes like SalesFormLetter. cu M Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Really important
Hello Guys, I have raised this query once before also but failed to get any responses. I am repeating that as it is very important. I want to know if there any place where i can find which class is getting executed. In more detailed manner i am looking for the type of posting that is in the process. Suppose somebody is performing sales invoice and other user is running puchase invoice on other hand then i should be able to catch both tasks at a single place. If query is not clear then pls do not hesitate to ask. Regards Amit Jain - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Obtaining an invoice list
Yes, You are right on target. custinvoicejour and vendinvoicejour tables keeps the record of all the invoiced sales and purchase order. if you want to see the lines also which has been invoiced(as there are chances that ur SO/PO are partially invoiced), you can refer custinvoicetrans and vendinvoicetrans table. Jour and trans tables are related to each other through invoiceid and transdate. Cheers eradovevivevodare [EMAIL PROTECTED] wrote: I need the list of the posted invoices for cust and vend.. Actually i'm looking to the CustInvoiceJour and VendInvoiceJour.. I'm on the right way? Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Invoice payment..
Yes, through open transaction editing. regards Amit eradovevivevodare [EMAIL PROTECTED] wrote: Hi group.. i've been playing with the cust and supplier invoice payments.. Is there a way to understand if an invoice as been totally or partially payed? I need to know the invoice status for normal payments and also for bill of exchange and promissory notes. Please, hel me! Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Obtaining an invoice list
Yes, You are right on target. custinvoicejour and vendinvoicejour tables keeps the record of all the invoiced sales and purchase order. if you want to see the lines also which has been invoiced(as there are chances that ur SO/PO are partially invoiced), you can refer custinvoicetrans and vendinvoicetrans table. Jour and trans tables are related to each other through invoiceid and transdate. Cheers Amit eradovevivevodare [EMAIL PROTECTED] wrote: I need the list of the posted invoices for cust and vend.. Actually i'm looking to the CustInvoiceJour and VendInvoiceJour.. I'm on the right way? Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: R: [development-axapta] Obtaining an invoice list
Hi You can get those information from table custTransOpen, custTrans Regards Amit Alessandro Ghidini [EMAIL PROTECTED] wrote: Ok, thanks.. Ad about my other question (posted in another message)? Any idea for an invoice list with payment status? Ghidini Ing. Alessandro Kibuz SRL Galleria Ludovico Mortara, 2 - 46100 - Mantova Telefono: +39 0376 220605 Fax: +39 0376 367439 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] _ Da: Amit Jain [mailto:[EMAIL PROTECTED] Inviato: lunedì 7 giugno 2004 11.56 A: [EMAIL PROTECTED] Oggetto: Re: [development-axapta] Obtaining an invoice list Yes, You are right on target. custinvoicejour and vendinvoicejour tables keeps the record of all the invoiced sales and purchase order. if you want to see the lines also which has been invoiced(as there are chances that ur SO/PO are partially invoiced), you can refer custinvoicetrans and vendinvoicetrans table. Jour and trans tables are related to each other through invoiceid and transdate. Cheers eradovevivevodare [EMAIL PROTECTED] wrote: I need the list of the posted invoices for cust and vend.. Actually i'm looking to the CustInvoiceJour and VendInvoiceJour.. I'm on the right way? Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT http://rd.yahoo.com/SIG=129brpesj/M=298184.5022502.6152625.3001176/D=groups /S=1705006764:HM/EXP=1086689019/A=2164338/R=0/SIG=11ed4vqbv/*http:/www.netfl ix.com/Default?mqso=60183349 click here http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S= :HM/A=2164338/rand=904972093 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM ~- Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [development-axapta] Rounding in a invoice with total discount !
Use decround function. Regards Amit iogiul [EMAIL PROTECTED] wrote: I've got a little problem, perhaps some of you have already find out the solution I've got a 29 pages invoice in which there is a Document discount of 5%. the gross amount of the invoice is 43.405,30 Euro of course the amount of the discount is 2.170,265 Euro the disc. amount printed in the doc. is 2.170,27 Euro Why the total amount of the invoice is 41235,03 Euro instead of 41235,04 I WANT A MATHEMATIC ROUNDING AND IF THE THIRD NUMBER IS LESS THAN 5 THE AMOUNT MUST NOT BE ROUNDED TO A UPPER DECIMAL ! any of you could tell me why and where I must update programs or setup ? the last thing to say is that in this invoice VAT is not calculated because the VAT percentage is 0%. that is the Tax Summary section appears like this code tax TaxBaseAmount TaxAmount 91 41.235,04 0 Giulio Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Regarding Data access in another form
Hi Akash, I think you should get the quotation id in the form by iteself if you are using the same extended data type for quotationid field in both tables (datasource) of forms. Just write this code to get the quotationId in another form. TableName object; object = element.args().record().datasource(); print object.QuotationID will print the quotation id, which called this form Hope it helps. Regards Girish Bhatkal [EMAIL PROTECTED] wrote: i am not sure why you did not get the attachment as i did attach an doc. any way i am forwarding the attachment again. cheers, Girish -Original Message- From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 04:11 To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Regarding Data access in another form Thanks girish. By the way i didnt find any attachments u mentioned... Regards Akash --- Girish Bhatkal [EMAIL PROTECTED] wrote: you can send data though the following ways: 1. On the menuButton in the clicked method (Before super()) on the source form write { container contains; contains = ConIns(contains,1,QuotationId); // quotation id is the record you want to send xsysLastValue::putValue(contains,curext(),curuserid(),UtilElementType::Form, formstr(FormName),'Identification'); // formName is the name of the form and Identification is any unique identification } on the destination form init method container Quotation = xSysLastValue::getValue(curext(),curuserid(),UtilElementType::Form,formstr(a dt_FormName),'Identification'); in this container you have retrieved the data sent from the source form 2. As i told in the earlier mail you can check the example of any standard function and copy the same process. As you said that it should work like in quotation form, you check what relations are used and what are the index on the corresponding tables. 3. Global variables : check the attached document. Hope this would help you . cheers, Girish -Original Message- From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: 25 May 2004 13:52 To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Regarding Data access in another form Hi Girish, Thanks for your prompt reply. My requirement is : I have a Form having data. Say main and unique data is QuotationId. I am trying to copy this selected Quotation id data , to create another line , just like in Quotation Form. Hence when i click the copy Quotation button , it calls another form ( just like in Quotation copy Form) . I need to pass the selected Quotation id to this Form. But it always takes the first line data of the caller form. Can you tell me how can i pass the selected quotation id to the next form. Regards Akash --- Girish Bhatkal [EMAIL PROTECTED] wrote: Hi Akash, there are a few ways you can achieve this a. if like in case of Item master when you open the customer item description form you get to see only the details entered for the Item, this is acheived by relations. b. you can pass an args from the source form and get the same in the desitination form . if you could give an example of what you need to select i could get the better picture of ur query. cheers, Girish -Original Message- From: akash malohatra [mailto:[EMAIL PROTECTED] Sent: 25 May 2004 10:02 To: [EMAIL PROTECTED] Subject: [development-axapta] Regarding Data access in another form Hi All, I am a newbie in Axapta and trying to learn as early as possible and correct path. I have one doubt , hope you guys will help me. How can i access the current record ( selected record ), in another Form called from this current Form . i tried some way , but it always takes the first row of record in stead of the selection record. waiting for replies. Anyhelp will be appriciated. Regards Akash Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html Yahoo! Groups Sponsor ADVERTISEMENT -- -- -- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor Yahoo! Groups Links http://groups.yahoo.com/group/development-axapta/
RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES'
Hi Anil, Each transaction in the ledgerjournalTrans and LedgerTrans are related to each other by transdate and voucher and whereas the case of relation of one line of voucher to its transaction is concerned i think there is no relation other then voucher and transdate. thats why whenever you see the voucher from any of the line in ledgerjournaltrans, Ledgertrans table show all the lines of the same voucher number and transdate. If you want to designate a particular ledgertrans with ledgerjournaltrans by mean of line number may be you can create another field called linenum in the table. I hope it helps. This is what i know. If you get to know anything about the relation within linnum also then please let me know. Regards Amit Anil Ozay [EMAIL PROTECTED] wrote: Hi.. This problem generally occurs when sql server system rights changed. For ex, if you use bmssa user to connect to sql server, and if owner of many tables in AXDB is dmo, you can't select records. So this message occurs. You should change the owners of tables. Regards Anil _ From: mchiat [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 5:22 AM To: [EMAIL PROTECTED] Subject: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES' Hi all, Could anyone of you help me to resolve the problem? When i want to log into axapta the following SQL error occurs SQL has reported the following error: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object name `SQLSYSTEMVARIABLES' You may refer to the error log file for further details. Retry the operation? If i click 'Yes' the same message box will keep on emerging. However if i click 'No' the following message will appear: Cannot select a record in (). The SQL database has issued an error. If i proceed the following message will appear: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name `SQLSYSTEMVARIABLES'. [SELECT VALUE FROM SQLSYSTEMVARIABLES WHERE PARM = `SYSVARID'] If i continue the system will ask me to enter System Variables: One or more SQL system variables are unknown. System variable STR Permitted values Text New value After i enter the New Value as VARCHAR(%u)the system will automatically exit and if i want to log into Axapta again the same SQL error will appear. May i know what is happening? Is there anyway to resolve the problem? Hope you all can reply to me as soon as possible. Thank you in advance. Yahoo! Groups Sponsor ADVERTISEMENT click here http://rd.yahoo.com/SIG=129t3vmva/M=295196.4901138.6071305.3001176/D=gr oups/S=1705006764:HM/EXP=1085209839/A=2128215/R=0/SIG=10se96mf6/*http:/c ompanion.yahoo.com http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group s/S=:HM/A=2128215/rand=504037943 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Yahoo! Domains - Claim yours for only $14.70/year [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] How to refresh on the form
Hi you can refresh the data in other way also. just write a method ltes say bookrefresh on the datasource of the source form. if you are calling another form from the source form then you can call that method using the Object callerdatasource; callerdatasource = element.args().caller().datasource; callerdatasource.bookrefresh(); This way you can also perform operations on the caller form other just refreshing the form Happy refreshing Regards Amit Paulius Cerniauskas [EMAIL PROTECTED] wrote: Try to add code DataSource_ds.Reread(); DataSource_ds.Refresh(); on that form control --- hwangjw99 [EMAIL PROTECTED] wrote: hi.. all.. I inserted some data into table when I was clicked a RadioButton on the form. But.. I can't find that records on the grid in the form.. Actually, it was in the table.. So, I guess it needs form refresh function, but I can't find any refresh method's function or reference.. If you know about this issue, please let me know how to solve.. Thanks.. Best Regards, = Paulius Cerniauskas Phone: +37065923155 ICQ: 280959446 __ Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/ Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. [Non-text portions of this message have been removed] 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Error in update Memo field in Axapta using COM Connector with C#
Hi Hong I would like to see the code, before giving any suggestion. Rgds AmitYer Hong [EMAIL PROTECTED] wrote: Hi All, I'm trying to update a Memo typefield in Axapta using COM Connector with C#, however, I encountered "Invalid Argument" error message during the update...my program works fine for updating String type field or Integer type field, but it has error when update the Memo typefield...please help. Thank you. regards,Hong 04 Do you Yahoo!?Win a $20,000 Career Makeover at Yahoo! HotJobs Do you Yahoo!?Win a $20,000 Career Makeover at Yahoo! HotJobs Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Sending a report to a fax printer
Hi I think you can get the printmedium information and the printer properties from the sysprintoptions class. This class is used in the sysprintForm Form to set the printoptions while reporting. Form sysPrintForm is maintaining an object of Class sysPrintOptions i.e. clientSysPrintOptions. Using this object you can get any information regarding the print options. Regards Amitmmargaix [EMAIL PROTECTED] wrote: Hi all,When I send a report to a fax printer, I would like to know from the report that I am using a fax.Is there any way of get this info from PrintJobSettings? Or is there another way of knowing it?Thanks in advance,MCruz Do you Yahoo!?Win a $20,000 Career Makeover at Yahoo! HotJobs Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Customised Filtering
Hi For this u must have created a data field for itemgroup in the salesline form. you can anytime override the lookup method of the itemid field in SalesLine datasource to control the way look up behaves. All you have to do is use sysTableLookup Class. Refer Axapta's help for this. If you still face problem then let me know. Regards Amit"Deshpande, Harry" [EMAIL PROTECTED] wrote: hi On second thoughts... It will be better if you could change your look up form on the item id to the format of the look up form on the field warehouse (on salesline). So the new lookup with have two tabs. On first tab show itemgroup and on second tab show related items. this will make things easier. regards harry -Original Message-From: kamtt [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 27, 2004 7:18 PMTo: [EMAIL PROTECTED]Subject: [development-axapta] Customised FilteringHello,I am new for Axapta and I have encounter below problem.In Sales Line of Sales Order, I would like to select an ItemGroup first and then it will automatically filter and shows for Item Numbers which are only related to selected ItemGroup.I don't want to jump to Item Number and filter using standard. In this way, user need to select ItemGroup first and and it will show filtered Item Numbers when he dirll down on Item Number field. Please advice me how to solve the problem.Thanks in advance,kamtt Do you Yahoo!?Win a $20,000 Career Makeover at Yahoo! HotJobs Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Customised Filtering
Hi Harry First thing i m not suggesting that Kamtt should create another field for itemgroup, but from the statement of Kamtt it looks like that they are already using ItemGroup field in SalesLine table.Ifcreation of new field is a problem then might be he cancreate a new datasourcefor ItemGroup and then use sysTableLookTable class. but i won't suggest creation of new forms only for look until and unless it cannot be done another way. This is what my personal experience says. What ur opinion. Regards Amit "Deshpande, Harry" [EMAIL PROTECTED] wrote: hi Amit! Interesting! The problem with what you are proposing is ... Either I have to create a field to hold the value of 'ItemGroupId' on salesLine. This field does not serve any purpose after a line has been created and violates the 'Normalization' rule for the data. It also takes up unnecessary disk space. One can also create just an extended data type field on the saleTable form (in the sales line grid). However, this means..if i specify an item group and go to second line to specify a different item group the first item group changes. This will create confusion for the viewer. This is why I recommended a different lookup form on the ItemId with two tabs like the 'location' look up form. Do let me know if you find some problem with the above thinking. regards harry -Original Message-From: Amit Jain [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 28, 2004 4:50 PMTo: [EMAIL PROTECTED]Subject: RE: [development-axapta] Customised Filtering Hi For this u must have created a data field for itemgroup in the salesline form. you can anytime override the lookup method of the itemid field in SalesLine datasource to control the way look up behaves. All you have to do is use sysTableLookup Class. Refer Axapta's help for this. If you still face problem then let me know. Regards Amit"Deshpande, Harry" [EMAIL PROTECTED] wrote: hi On second thoughts... It will be better if you could change your look up form on the item id to the format of the look up form on the field warehouse (on salesline). So the new lookup with have two tabs. On first tab show itemgroup and on second tab show related items. this will make things easier. regards harry -Original Message-From: kamtt [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 27, 2004 7:18 PMTo: [EMAIL PROTECTED]Subject: [development-axapta] Customised FilteringHello,I am new for Axapta and I have encounter below problem.In Sales Line of Sales Order, I would like to select an ItemGroup first and then it will automatically filter and shows for Item Numbers which are only related to selected ItemGroup.I don't want to jump to Item Number and filter using standard. In this way, user need to select ItemGroup first and and it will show filtered Item Numbers when he dirll down on Item Number field. Please advice me how to solve the problem.Thanks in advance,kamtt Do you Yahoo!?Win a $20,000 Career Makeover at Yahoo! HotJobs Do you Yahoo!?Win a $20,000 Career Makeover at Yahoo! HotJobs Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Products By Truck
If you are talking about that whenever the sales order is created, the product is loaded on to the truck and then delivered. For that you can use transfer journal from main warehouse to truck (which is also a warehouse for you) as suggested by Girish, and then try to packing slip the sales order from warehouse (for truck). You can change this easily at the time of packing in Salesformletter_Packing / update now method. There can be one implication that if you consider the truck as the warehouse Qty onhand and hence master planning will also consider the Qty of item on truck. For that you can change the warehouse truck of any other type lets say truck and then modify the qty on hand and master planning routine. you must be thinking that i asked for one thing but these are sure implications you would face if you don't want to include the qty on truck in the master planning and qty on hand. Regards Girish Bhatkal [EMAIL PROTECTED] wrote: if you maintain a different specific location , for a truck, then if you receive the goods through purchase order then select this location and post delivery note as items are loaded. in case of sending goods out then you need to first use "transfer journal" to move the goods from one location to other, so that the items are still shown in the location (truck) and then finally when it is delivereduse this location (selected for truck) to post the sales order delivery note. Hope this could be a solution you are looking for. -Original Message-From: k_otickashka [mailto:[EMAIL PROTECTED]Sent: 08 April 2004 16:51To: [EMAIL PROTECTED]Subject: [development-axapta] Products By TruckI have to do a report that displays products or orders that are placed on trucks. The hard part is that trucks are treated as a warehouse. So when someone orders a specific product, that product is moved from the warehouse to the truck, then the truck delivers the product. How do I display what is placed on the truck.Do you Yahoo!? Yahoo! Tax Center - File online by April 15th 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Inventory posting
Hi The SalesLinetype.AccountSales method calls the inventposting method to find the Account numbers. Hope it helps. Regards Amitdgaethofs [EMAIL PROTECTED] wrote: Hi,Does anybody knows what class or method is responsible for searching the inventory posting record during or before creation of general ledger transactions?regards,Danny GaethofsDo you Yahoo!? Yahoo! Tax Center - File online by April 15th 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, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.