RE: [Axapta-Knowledge-Village] Online users in Axapta
Hi All I might have to correct something here. It is correct that the problem is the Axdat.udb, which holds the active Axapta user sessions and AOS instances. The problem is when network failure or a serious crash on the client site occurs. Windows doesnt recognize it and cant notify the aos instance about it. The solution is to delete the axdat.udb file, when all users and AOS instances are closed. Another solution that mostly works is to use the TCP/IP registry parameter KEEPALIVETIME. You can decrease the default value on the key from 2 hours to example 3 min. We are currently investigating another solution for version 4.0 to solve the problem. Thanks Happy New Year Med venlig hilsen / Best regards Kim Truelsen Escalation Engineer Microsoft Business Solutions Axapta EMEA Global Technical Support Center Direct / mobile: +45 4489 0100 / +45 29499958 E-mail: [EMAIL PROTECTED] Online support at: www.microsoft.com/support MBS Partnersource at: www.microsoft.com/BusinessSolutions/PartnerSource/default.mspx Security Updates at: www.microsoft.com/protect Microsoft Denmark Tuborg Boulevard 12 DK-2900 Hellerup Phone:+45 4489 0100 / Fax: +45 4468 5510 If you have any feedback about my work, please let either myself or my manager Kenneth Stubban know at [EMAIL PROTECTED] or telephone +45 4498 0750 Note: This email may contain confidential information. If you are not named on the addressee list, please take no action in relation to this email, do not open any attachment and please contact the sender (details above) immediately. From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: 28. december 2004 09:25 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Online users in Axapta Hi Sadiq, Do you know exactly which clients are not shown ? Like ..are they 2-tier or 3-tier ?? XP prof ? or NT Prof ?? How may AOS do you have ?? Only one or more than that ??? Regs Abin. Mohammed Sadiq [EMAIL PROTECTED] wrote: Hi Mamidi As you mentioned I have done it . But still I have the same problem. I deleted the file and restarted but still it will show some users and other users are not showing.Please suggest me . Thanks. From: Subrahmanyam Mamidi [mailto:[EMAIL PROTECTED] Sent: Monday, December 27, 2004 7:31 PM To: Axapta[EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] Online users in Axapta Hello Mohammed, We had the same probelm . We have initially 100 licenses. And the online users used to show 23 users. And if anyone tries to log on to Axapta, it used to complain max users exceeded When contacted Microsoft, they informed us that its a bug related to AOS and AXDAT.UDB file is getting corroputed. To temporarily solve this by MS folks, All you ( Admin) need to do is: 1. Stop AOS 2. delete AXDAT.UDB file. 3. restart AOS. When you restart AOS, the new and correct version of AXDAT.UDB will be created. Now it will show you the Correct Number of Online USERs. I don't find the reply email from MS to forward it you, but that should work. Enjoy Axapta Thanks, Subbu Mohammed Sadiq [EMAIL PROTECTED] wrote: Hi, Our axapta server is installed on Microsoft windows 2003 server with database on oracle . We have 100 user licenses. It is in Implementation phase. We are facing a problem in online users session as it is not showing correctly who is logged on currently .it doesnt show some users who are Actually online. What can be the problem and how to rectify? Sharing the knowledge on Axapta. Do you Yahoo!? Send holiday email and support a worthy cause. Do good. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Send a seasonal email greeting and help others. Do good. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Kernel Language
Hi there, I have some technical questions. Does anybody know in what language the axapta kernel is written. Is it Java or C++. Is it possible to access axapta from within a java environment like Netbean. Is there some kind of versioning system available, SVN or CVS. !erpdesert! 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/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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: [Axapta-Knowledge-Village] Item Alternative in Axapta
hi koh, Till now i dont know, but i have checked it and there is no such setup. So u need to customize it. if u get to know about such setup, please let everybody know about it. regards vaibhav pednekar --- Koh Meng [EMAIL PROTECTED] wrote: Hi pednekar, Really thanks for your prompt reply :). Actually what i want to know is can axapta automatically deduct the qty on hand (Item A) and create another line for extra qty (Item B)? Thank you. vaibhav pednekar [EMAIL PROTECTED] wrote: Hi Koh, The following is the way axapta reacts. Item A -- QTY - 1, Other - Use - Nothing in Inventory, Alternative Item - Item B Item B -- QTY - 10, Other - Use - Nothing in Inventory, Alternative Item - Item A. Now the sales line is created for Item A with 11 qty, axapta only records the line for 1 qty. Now you can create another line for Item A for qty 10, this line axapta will give message for replacing the item B with for 10 qty. Is this what you are looking or something else. If something different then explain. regards vaibhav pednekar --- Koh Meng [EMAIL PROTECTED] wrote: Hi all, I've a question here. The scenario is: I've Item A with qty of 10 and I've set the alternative item for Item A to be Item B if there is insufficient qty for Item A (Use = Nothing in Inventory under Item form Other ). Now i've a Sales Order which wants to ship 11 units of Item A. The system will immediately change Item A to Item B once it finds that Item A has no sufficient qty. How can i make the system to ship out 10 units of Item A and the extra 1 qty to be Item B? Is there any setting i overlook? Thousand thanks in advance and merry christmas to u all. :) Best Regards, Jack koh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo Sharing the knowledge on Axapta. Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 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 __ Do you Yahoo!? Send a seasonal email greeting and help others. Do good. http://celebrity.mail.yahoo.com 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/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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: [Axapta-Knowledge-Village] Item Groups - Costing Method Change !
Hi, Actually if u do in between, then be damn sure that u r inventory closing for previous periods are correct and u will not required to calculate it again, cuz u will be changing the method right. So for this purpose only do not change the existing inventory model group instead create a new with the new costing method and attach it. And take Back up before running closing with the new inventory model group - costing. Actually if everything is fine then there should not be a problem - but technically how the axapta behaves that u will know after you do. One more suggestion, do not try this on the Production server directly do it on Testing server and verify the results the CFO agree to this and then Go on for the Production. regards vaibhav --- Jim Jo [EMAIL PROTECTED] wrote: Hi Dost!, Thanx for the reply. I am plannig to do this after an inventory close. Cannot do at the year end. This should be done in the midst of an year :-). The grouping will not be ready by then ! Do you anticipate any issue in making all these changes?. If any please share !. Dont you see any issue in changing the costing methods in between ???. Will it unbalance the accounts during the next close ? Regs Abin vaibhav pednekar [EMAIL PROTECTED] wrote: Hello, Ok Question - when do you want to the new settings to take effect, for this financial year or the next financial year? My advise will be take it from the next financial year. Take the backup of the database after the year end closing, dont have any periods open in the new year i,e nobody uses the system till u set it. Create the new Item groups, the inventory model groups please dont change the existing ones instead use new let the old be there, also maintain the histroy of the changes on document for future references if required. At the master level attach the items to their respective groups. and then start the periods - open and do your transactions hope this helps you. regards vaibhav --- Jim Jo [EMAIL PROTECTED] wrote: Hello Masters ! I need your valuable advices on this!. Our system is live for last one year. Obviously we have a lot of transactions and Inventory closings. Now as our business in growing in a fast pace, management decided to have a regrouping of items and also the costing methods in our factory. As per the new standards, we are changing all the Item group names, also some items will belong to different group itself after the changes. We are also changing weighted avg costing method to FIFO. I have not done this in any of my previous implementations and I am not very sure of the issues that may come up after the change. How does these changes affect the system. Someone please explain me the implication of the change and also the best ways to do this. What is the best time to do this?. Before year end? . After closing the stock? etc All great thoughts are appreciated !! :-) Happy new year ! -- Abin. - Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. __ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250 Sharing the knowledge on Axapta. Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 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!? Read only the mail you want - Yahoo! Mail SpamGuard. __ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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/
[Axapta-Knowledge-Village] Slow Performance of Report
Hi Everbody, Well friends i have designed a report on SubLedger transaction. For that i have to take field from many tables viz. VendTrans,AssetTrans,BankAccountTrans,CustTrans,Ledgertable and not mention Ledgerttrans also. now i have inserted my desire dataset on a temp table which i have created. But mine problem is that when report is executed it takes a lot of time. I have all populated all the data on to the fetch method. Please tell me if there is any optimization techinque in terms of Coding or the deployment which can speed my report execution and whether this temp table strategy is the right one to be followed when data is to be extracted from many tables and many relation have to be implemented. Ultimately report is to deployed in 3-tier architecture. any suggestion is welcomed . Have a nice day to all Axapta Community members and advance wishes for New Year . 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/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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: [Axapta-Knowledge-Village] Online users in Axapta
HI Kim, Thank you very much for the feedback on this. regards vaibhav pednekar --- Kim Truelsen [EMAIL PROTECTED] wrote: Hi All I might have to correct something here. It is correct that the problem is the Axdat.udb, which holds the active Axapta user sessions and AOS instances. The problem is when network failure or a serious crash on the client site occurs. Windows doesn't recognize it and can't notify the aos instance about it. The solution is to delete the axdat.udb file, when all users and AOS instances are closed. Another solution that mostly works is to use the TCP/IP registry parameter KEEPALIVETIME. You can decrease the default value on the key from 2 hours to example 3 min. We are currently investigating another solution for version 4.0 to solve the problem. Thanks Happy New Year Med venlig hilsen / Best regards Kim Truelsen Escalation Engineer Microsoft Business Solutions Axapta EMEA Global Technical Support Center Direct / mobile: +45 4489 0100 / +45 29499958 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]@microsoft.com Online support at: www.microsoft.com/support BLOCKED::http://www.microsoft.com/support MBS Partnersource at: www.microsoft.com/BusinessSolutions/PartnerSource/default.mspx BLOCKED::http://www.microsoft.com/BusinessSolutions/PartnerSource/defau lt.mspx Security Updates at: www.microsoft.com/protect BLOCKED::http://www.microsoft.com/protect Microsoft Denmark BLOCKED::http://www.microsoft.dk/ Tuborg Boulevard 12 DK-2900 Hellerup Phone:+45 4489 0100 / Fax: +45 4468 5510 If you have any feedback about my work, please let either myself or my manager Kenneth Stubban know at [EMAIL PROTECTED] BLOCKED::mailto:[EMAIL PROTECTED] or telephone +45 4498 0750 Note: This email may contain confidential information. If you are not named on the addressee list, please take no action in relation to this email, do not open any attachment and please contact the sender (details above) immediately. From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: 28. december 2004 09:25 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Online users in Axapta Hi Sadiq, Do you know exactly which clients are not shown ? Like ..are they 2-tier or 3-tier ?? XP prof ? or NT Prof ?? How may AOS do you have ?? Only one or more than that ??? Regs Abin. Mohammed Sadiq [EMAIL PROTECTED] wrote: Hi Mamidi As you mentioned I have done it . But still I have the same problem. I deleted the file and restarted but still it will show some users and other users are not showing.Please suggest me . Thanks. From: Subrahmanyam Mamidi [mailto:[EMAIL PROTECTED] Sent: Monday, December 27, 2004 7:31 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Online users in Axapta Hello Mohammed, We had the same probelm . We have initially 100 licenses. And the online users used to show 23 users. And if anyone tries to log on to Axapta, it used to complain max users exceeded When contacted Microsoft, they informed us that its a bug related to AOS and AXDAT.UDB file is getting corroputed. To temporarily solve this by MS folks, All you ( Admin) need to do is: 1. Stop AOS 2. delete AXDAT.UDB file. 3. restart AOS. When you restart AOS, the new and correct version of AXDAT.UDB will be created. Now it will show you the Correct Number of Online USERs. I don't find the reply email from MS to forward it you, but that should work. Enjoy Axapta Thanks, Subbu Mohammed Sadiq [EMAIL PROTECTED] wrote: Hi, Our axapta server is installed on Microsoft windows 2003 server with database on oracle . We have 100 user licenses. It is in Implementation phase. We are facing a problem in online users session as it is not showing correctly who is logged on currently .it doesnt show some users === message truncated === __ Do you Yahoo!? Dress up your holiday email, Hollywood style. Learn more. http://celebrity.mail.yahoo.com 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/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to:
Re: [Axapta-Knowledge-Village] Kernel Language
Axapta Business Connector is a COM component. You can use Business Connector to access Axapta within a Java application just like any other COM component. Giray --- Raul Llorente Peña/OPENSOLUTIONS [EMAIL PROTECTED] wrote: - It's written in C++. The program emulates an development enviroment. But most of code is bussiness logical code, not general purpose library methods. Remember Axapta is an ERP, not a general purpose language and/or environment!! So, many funcions (specially the near-system calls) and calls are 'hidden' in kernel, so you can't access them... No, I've not heard about such things. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 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! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250 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/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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/
RES: [Axapta-Knowledge-Village] Kernel Language
We can start a Project to build some kind of build control and versioning for Axapta 3.0, including change log -Mensagem original- De: Anders Wancke [mailto:[EMAIL PROTECTED] Enviada em: tera-feira, 28 de dezembro de 2004 09:12 Para: [EMAIL PROTECTED]com Assunto: RE: [Axapta-Knowledge-Village] Kernel Language 1) The Axapta kernel is written in C++. 2) Through a java-COM bridge 3) Ive knows www.keyzonesolutions.com have a version control tool and I think there are a couple of others out there. Ive made my own tool, it quite easy. Just hook up on SysCompare. But rumors says its included in Axapta 4.0 .. Best Regards Anders Warncke HOB Business Solutions A/S From: erpdesert [mailto:[EMAIL PROTECTED] Sent: 28. december 2004 09:56 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Kernel Language Hi there, I have some technical questions. Does anybody know in what language the axapta kernel is written. Is it Java or C++. Is it possible to access axapta from within a java environment like Netbean. Is there some kind of versioning system available, SVN or CVS. !erpdesert! Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 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: [Axapta-Knowledge-Village] what is ABC and how to run it
ABC is Axapta Business Connector. You can register it through Configuration Utlity. Last tab page of the Axapta Configuration Utility has a button to register it. Kind Regards, Giray --- axapta_guru [EMAIL PROTECTED] wrote: While going through Work Procedures when tuning for AOS , I found an statement Run the ABC (or find/filter). Can anybody tell me what is the ABC and how to run it. __ Do you Yahoo!? Dress up your holiday email, Hollywood style. Learn more. http://celebrity.mail.yahoo.com Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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/
AW: [Axapta-Knowledge-Village] what is ABC and how to run it
yes no ;-)) in this case I believe it should read Axapta Best Practice Check and you can run it compiling your app. after setting the best practice options ... hth Tobias -Ursprngliche Nachricht- Von: Giray Simsek [mailto:[EMAIL PROTECTED] Gesendet: Di 28.12.2004 22:39 An: Axapta-Knowledge-Village@yahoogroups.com Cc: Betreff: Re: [Axapta-Knowledge-Village] what is ABC and how to run it ABC is Axapta Business Connector. You can register it through Configuration Utlity. Last tab page of the Axapta Configuration Utility has a button to register it. Kind Regards, Giray --- axapta_guru [EMAIL PROTECTED] wrote: While going through Work Procedures when tuning for AOS , I found an statement Run the ABC (or find/filter). Can anybody tell me what is the ABC and how to run it. __ Do you Yahoo!? Dress up your holiday email, Hollywood style. Learn more. http://celebrity.mail.yahoo.com Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links 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/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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/ winmail.dat
RE: [Axapta-Knowledge-Village] audit function on a field
Please explain audit function that is required here I Know in our business we had to purchase the Audit Logging System which works well in telling us who changed what and where in the system., otherwise enable the Created by and Modified by date stamping from the table propertiesalso helped. Rocco From: jeroen_vangheluwe [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 December 2004 6:35 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] audit function on a field Dear,How can I put an audit function on a field?I would like to put the audit on Acc. recc. - Sales order-tab general - finish sales orderAcc. recc. - Sales order-tab setup - field pool creation salesorder lineThanks in advance,JeroenSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 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: [Axapta-Knowledge-Village] [Urgent] I can't insert MarkupTrans with code
Hi Ince, Every record inserted to MarkupTrans must be unique based on these three fields as a key: - TransTableId - TransRecId - LineNum You can check index TransRecIdIdx for MarkupTrans to verify this. The value of field LineNum is assigned in method initValue() based on TransTableId and TransRecId. this.lineNum = MarkupTrans::lastLineNum( this.transTableId, this.transRecId) + 1; But the field transTableId (=??) and transRecId (=??) are not yet filled in at the time initValue() is called, which means lineNum's value built will NOT represent (the last lineNum + 1) for the expected transTableId and transRecId. So, instead of call table's method in this sequence: // assign lineNum mt.initValue(); // assign transTableId and transRecId mt.initFromSalesLine(trans.salesLine()); try to change the sequence like this: // assign transTableId and transRecId mt.initFromSalesLine(trans.salesLine()); // assign lineNum mt.initValue(); so the field transTableId and transRecId are guaranteed to be filled in before lineNum's assignment. Hope this helps. -Aji Sarosa- --- Cenk Ince [EMAIL PROTECTED] wrote: Hi all; I try to insert markuptrans, there are 3 markupCodes, for 1 of them i can insert markuptrans, but for 2 others i can't insert it, All setup for 3 of markupcodes are the same. i get error : Cannot create a record in Misc. charges transactions (MarkupTrans). Misc. charges code: Klise, . The record already exists.. Does anybody knows why does this happen? My code is like . ttsbegin; select forupdate mt where mt.TransTableId == tablenum(salesline) mt.TransRecId == trans.salesLine().RecId mt.MarkupCode == sg.MarkupCode; if(!mt) { mt.initValue(); mt.initFromSalesLine(trans.salesLine()); mt.initFromMarkupTable(MArkupTable::find(ModuleInventCustVend::Cust,sg.MarkupCode)); mt.MarkupCode = sg.MarkupCode; sairGider = (trans.Qty * trans.salesLine().DS_SatisFiyati * sg.Value ) / toplam; mt.Value = decround(sairGider,2); info(num2str(mt.Value,1,1,1,1)); mt.insert(); } else { mt.Value += decround(sairGider,2); info(num2str(mt.Value,1,1,1,1)); mt.update(); } ... Thanks ATTACHMENT part 2 application/ms-tnef name=winmail.dat __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo 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/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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/
[Axapta-Knowledge-Village] [Urgent] I can't insert MarkupTrans with code
Hi all; I try to insert markuptrans, there are 3 markupCodes, for 1 of them i can insert markuptrans, but for 2 others i can't insert it, All setup for 3 of markupcodes are the same. i get error : Cannot create a record in Misc. charges transactions (MarkupTrans). Misc. charges code: Klise, . The record already exists.. Does anybody knows why does this happen? My code is like . ttsbegin; select forupdate mt where mt.TransTableId == tablenum(salesline) mt.TransRecId == trans.salesLine().RecId mt.MarkupCode == sg.MarkupCode; if(!mt) { mt.initValue(); mt.initFromSalesLine(trans.salesLine()); mt.initFromMarkupTable(MArkupTable::find(ModuleInventCustVend::Cust,sg.MarkupCode)); mt.MarkupCode = sg.MarkupCode; sairGider = (trans.Qty * trans.salesLine().DS_SatisFiyati * sg.Value ) / toplam; mt.Value = decround(sairGider,2); info(num2str(mt.Value,1,1,1,1)); mt.insert(); } else { mt.Value += decround(sairGider,2); info(num2str(mt.Value,1,1,1,1)); mt.update(); } ... Thanks 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/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * 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/ winmail.dat
RE: [Axapta-Knowledge-Village] Online users in Axapta
HI Kim/ Subbu/ Sadiq, Thanks .. Subbu and Kim for thefeedbacks! That was a useful info! Sadiq .. Do you now have all online users on users online form after deletingand re-creating .udb file? Jusdiggin !! Are these two AOSholding the same configuration ?? Or you havedifferent DB ?? Happy new year Abin. Mohammed Sadiq [EMAIL PROTECTED] wrote: We are using all 3-tier clients and some clients are windows 98 and some are windows XP Prof / We have two AOS., one live and another for testing purpose. Thanks/Regards From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 28, 2004 11:25 AMTo: Axapta[EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] Online users in Axapta Hi Sadiq, Do you know exactly which clients are not shown ? Like ..are they 2-tier or 3-tier ?? XP prof ? or NT Prof ?? How may AOS do you have ?? Only one or more than that ??? Regs Abin. Mohammed Sadiq [EMAIL PROTECTED] wrote: Hi Mamidi As you mentioned I have done it . But still I have the same problem. I deleted the file and restarted but still it will show some users and other users are not showing.Please suggest me . Thanks. From: Subrahmanyam Mamidi [mailto:[EMAIL PROTECTED] Sent: Monday, December 27, 2004 7:31 PMTo: Axapta[EMAIL PROTECTED]Subject: Re: [Axapta-Knowledge-Village] Online users in Axapta Hello Mohammed, We had the same probelm . We have initially 100 licenses. And the online users used to show 23 users. And if anyone tries to log on to Axapta, it used to complain "max users exceeded" When contacted Microsoft, they informed us that its a bug related to AOS and AXDAT.UDB file is getting corroputed. To temporarily solve this by MS folks, All you ( Admin) need to do is: 1. Stop AOS 2. delete AXDAT.UDB file. 3. restart AOS. When you restart AOS, the new and correct version of AXDAT.UDB will be created. Now it will show you the Correct Number of Online USERs. I don't find the reply email from MS to forward it you, but that should work. Enjoy Axapta Thanks, Subbu Mohammed Sadiq [EMAIL PROTECTED] wrote: Hi, Our axapta server is installed on Microsoft windows 2003 server with database on oracle . We have 100 user licenses. It is in Implementation phase. We are facing a problem in "online users" session as it is not showing correctly who is logged on currently .it doesnt show some users who are Actually online. What can be the problem and how to rectify? Sharing the knowledge on Axapta. Do you Yahoo!?Send holiday email and support a worthy cause. Do good. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Send a seasonal email greeting and help others. Do good. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 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: [Axapta-Knowledge-Village] Item Groups - Costing Method Change !
Hi Vaibhav, Thanks for the thoughts!. That was quite useful. We'll try it very soon and leu know the results !! Regs Jimvaibhav pednekar [EMAIL PROTECTED] wrote: Hi,Actually if u do in between, then be damn sure that ur inventory closing for previous periods are correctand u will not required to calculate it again, cuz uwill be changing the method right.So for this purpose only do not change the existinginventory model group instead create a new with thenew costing method and attach it.And take Back up before running closing with the newinventory model group - costing.Actually if everything is fine then there should notbe a problem - but technically how the axapta behavesthat u will know after you do.One more suggestion, do not try this on the Productionserver directlydo it on Testing server and verify the resultsthe CFO agree to this and then Go on for theProduction.regardsvaibhav--- Jim Jo [EMAIL PROTECTED] wrote: Hi Dost!, Thanx for the reply. I am plannig to do this after an inventory close. Cannot do at the year end. This should be done in the midst of an year :-). The grouping will not be ready by then ! Do you anticipate any issue in making all these changes?. If any please share !. Dont you see any issue in changing the costing methods in between ???. Will it unbalance the accounts during the next close ? Regs Abin vaibhav pednekar [EMAIL PROTECTED] wrote: Hello, Ok Question - when do you want to the new settings to take effect, for this financial year or the next financial year? My advise will be take it from the next financial year. Take the backup of the database after the year end closing, dont have any periods open in the new year i,e nobody uses the system till u set it. Create the new Item groups, the inventory model groups please dont change the existing ones instead use new let the old be there, also maintain the histroy of the changes on document for future references if required. At the master level attach the items to their respective groups. and then start the periods - open and do your transactions hope this helps you. regards vaibhav--- Jim Jo [EMAIL PROTECTED] wrote: Hello Masters !I need your valuable advices on this!.Our system is live for last one year. Obviously we have a lot of transactions and Inventory closings. Now as our business in growing in a fast pace, management decided to have a regrouping of items and also the costing methods in our factory. As per the new standards, we are changing all the Item group names, also some items will belong to different group itself after the changes. We are also changing weighted avg costing method to FIFO. I have not done this in any of my previous implementations and I am not very sure of the issues that may come up after the change. How does these changes affect the system. Someone please explain me the implication of the change and also the best ways to do this. What is the best time to do this?. Before year end? . After closing the stock? etc All great thoughts are appreciated !! :-) Happy new year ! -- Abin. - Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. __ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250 Sharing the knowledge on Axapta.Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 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!? Read only the mail you want - Yahoo! MailSpamGuard. __ Do you Yahoo!? The all-new My Yahoo! - What will yours do?http://my.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Do you Yahoo!? Send holiday email and support a worthy cause. Do good. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 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: [Axapta-Knowledge-Village] Online users in Axapta
Hi Jim I dont get all the online users in Axapta but in Oracle Sessions it shows correct . I tried the deleting and recreating the .udb file with AOS shutdown and no users connected. I did not try the TCP/IP KEEPALIVE TIMEOUT . How to change the KEEPALIVE TIMEOUT and where should we do it (client or server).Both the AOS are holding the same configuration with Oracle 9.2 as the database on 3-tier architecture. Thanks/Regards From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 29, 2004 9:49 AM To: Axapta[EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Online users in Axapta HI Kim/ Subbu/ Sadiq, Thanks .. Subbu and Kim for thefeedbacks! That was a useful info! Sadiq .. Do you now have all online users on users online form after deletingand re-creating .udb file? Jusdiggin !! Are these two AOSholding the same configuration ?? Or you havedifferent DB ?? Happy new year Abin. Mohammed Sadiq [EMAIL PROTECTED] wrote: We are using all 3-tier clients and some clients are windows 98 and some are windows XP Prof / We have two AOS., one live and another for testing purpose. Thanks/Regards From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 28, 2004 11:25 AM To: Axapta[EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Online users in Axapta Hi Sadiq, Do you know exactly which clients are not shown ? Like ..are they 2-tier or 3-tier ?? XP prof ? or NT Prof ?? How may AOS do you have ?? Only one or more than that ??? Regs Abin. Mohammed Sadiq [EMAIL PROTECTED] wrote: Hi Mamidi As you mentioned I have done it . But still I have the same problem. I deleted the file and restarted but still it will show some users and other users are not showing.Please suggest me . Thanks. From: Subrahmanyam Mamidi [mailto:[EMAIL PROTECTED] Sent: Monday, December 27, 2004 7:31 PM To: Axapta[EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] Online users in Axapta Hello Mohammed, We had the same probelm . We have initially 100 licenses. And the online users used to show 23 users. And if anyone tries to log on to Axapta, it used to complain max users exceeded When contacted Microsoft, they informed us that its a bug related to AOS and AXDAT.UDB file is getting corroputed. To temporarily solve this by MS folks, All you ( Admin) need to do is: 1. Stop AOS 2. delete AXDAT.UDB file. 3. restart AOS. When you restart AOS, the new and correct version of AXDAT.UDB will be created. Now it will show you the Correct Number of Online USERs. I don't find the reply email from MS to forward it you, but that should work. Enjoy Axapta Thanks, Subbu Mohammed Sadiq [EMAIL PROTECTED] wrote: Hi, Our axapta server is installed on Microsoft windows 2003 server with database on oracle . We have 100 user licenses. It is in Implementation phase. We are facing a problem in online users session as it is not showing correctly who is logged on currently .it doesnt show some users who are Actually online. What can be the problem and how to rectify? Sharing the knowledge on Axapta. Do you Yahoo!? Send holiday email and support a worthy cause. Do good. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Send a seasonal email greeting and help others. Do good. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.