Re: [Axapta-Knowledge-Village] Re: Delivery date mandatory before invoicing
if you want to make sure only the lines which has the delivery date should get invoiced, then put a validation in the salesFormLetter (check the methods chooseLine/ CreateParmLine). here you can control which saleslines should be included while posting. --- On Fri, 20/6/08, Axapta Material [EMAIL PROTECTED] wrote: From: Axapta Material [EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] Re: Delivery date mandatory before invoicing To: Axapta-Knowledge-Village@yahoogroups.com Date: Friday, 20 June, 2008, 9:33 PM Dates are not available when the sales order is created. Before invoicing sales must have the dates so that they should be able to do picking and packing without dates but not invoicing. Thanks - Original Message From: prasanna_koulgi prasanna_koulgi@ yahoo.co. in To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Friday, June 20, 2008 2:01:41 AM Subject: [Axapta-Knowledge- Village] Re: Delivery date mandatory before invoicing Hi Simplest way is to make make the salesline field mandatory. PRASANNA --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Axapta Material axapta_material@ ... wrote: Hi all, I am doing a customization where I have to make delivery field in sales line mandatory. I have to do validation before invoicing ..If the delivery date is empty then don't let the user invoice the sales order and give message that the delivery date field is mandatory. I am trying the best way to do it.Where should i put the code since if the date field is empty I have to send false for invoicing? Any suggestions or help? Thanks in advance __ Sent from Yahoo! Mail. A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
Re: [Axapta-Knowledge-Village] Re: Registration Access rights
we should never modify the temporary property of standard AX tables, by doing so you will lose the functionality (unless you go and modify the classes appropriately). Since these tables are created for a specific purpose it would be a BAD idea to change the temporary property to No. I think you must be missing rights on some other table (even though you cannot individually set rights on temporary table they must be enabled for some other user group). If nothing works then the last thing you could try is to take off the security key from that temporary table. regards Girish --- On Mon, 23/6/08, L Kalaiarasi [EMAIL PROTECTED] wrote: From: L Kalaiarasi [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Re: Registration Access rights To: Axapta-Knowledge-Village@yahoogroups.com Date: Monday, 23 June, 2008, 6:58 AM Hi, Anytable that starts with tmp is a temperary table that is mostly used in reports/processes to store the intermediate output. You can check the property of the table. Temperary is set to 'Yes' for all the tables start with 'tmp'. No temperary table is shown in the security map though the security key is set. Choice 1: You can remove the security key of this table. So that it can be accessed freely in the reports/processes. Choice 2: Can set the temperary property to No and grant the security key. But it affects the way the table is handled in Ax. I think that the better choice is to remove the security key. Regards Kalaiarasi --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, kardo_ax [EMAIL PROTECTED] . wrote: Hi all, Whenever a user is trying to access the registration form from PO line - --- Inventory --- registration, the following message is showing: Not enough rights to use table: Registration/ Picking (TmpInventTramsWMS) This table doesnt appear under invent tables as its security key property is set to. What is the way to solve this issue? Thanks __ Sent from Yahoo! Mail. A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
Re: [Axapta-Knowledge-Village] Arabization of Axapta
you can contact your local microsoft office to provide the label files ( i am not aware of labels in arabic language). If you need to change it yourself an arabic language license is available (especially for the labels which you have changed) then you need to find the each label while selecting the languages in the advanced tab , go to each label and then write the description against the label for the specific language. --- Khurram Zaki [EMAIL PROTECTED] wrote: - Hello everyone... I am interested in changing the labels, input text and reports in Axapta to Arabic language. Need a clue as to where to start from. Is there a way we can change all the labels to some other language. Similarly, I am looking for storing data in Arabic and later retreiving that via Crystal Reports. I would appreciate if any one of you who have worked on localization to any other language can guide me through ... I need some pointers to start the thought process :) Cheers! Have a happy day. Khurram Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - ___ NEW - Yahoo! 360 Your one place to blog, create, publish and share! http://uk.360.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" 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: [Axapta-Knowledge-Village] posting through X++ code
There is nothing wrong in the code which sundar had mentioned if you need to only post and print ones,but if you want to go back and reprint the packing slip (from say Purchase form / inquires) it would not be possible as no entries were made in the purchParmline table. alternately you can try the below code here you might have to change a few lines depending upon your requirement: purchFormLetter = PurchFormLetter::construct(DocumentStatus::PackingSlip); purchFormLetter.createParmUpdate(); purchFormLetter.createParmTable( purchParmTable, purchTable); purchParmTable.Num = packingSlipId; purchParmTable.insert(); while select purchLine where purchLine.PurchId == purchTable.purchId (purchLine.RemainPurchPhysical 0) { purchParmLine.ParmId = purchParmTable.ParmId; purchParmLine.InitFromPurchLine(purchLine); purchParmLine.ReceiveNow = purchLine.RemainPurchPhysical; purchParmLine.setQty(DocumentStatus::PackingSlip, false, true); purchParmLine.setLineAmount(); purchParmLine.insert(); } purchFormLetter.proforma (false); purchFormLetter.printFormLetter(true); purchFormLetter.specQty (PurchUpdate::All); purchFormLetter.transDate (today()); purchFormLetter.run(); hope this helps. cheers, Girish --- Sundararajan.T - Software Engineer (Enterprise Solutions Practice) - SIS [EMAIL PROTECTED] wrote: - Hi, you can Update the Receive now quantity in Purchline Can post the Purchase order with the following code purchFormLetter = PurchFormLetter::construct(DocumentStatus::packingslip); purchFormLetter.transDate(SystemDateGet()); purchFormLetter.update(purchTable,abcd, purchFormLetter.transDate(SystemDateGet()), PurchUpDate::receivenow,AccountOrder::None, false, false); Regards Sundar -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of gopala krishna Sent: Wednesday, May 10, 2006 10:01 AM To: axapta-knowledge-village@yahoogroups.com Subject: [Axapta-Knowledge-Village] posting through X++ code hi, I want to post the purchase order thru x++. And i should be able to post only qty 50 even if have qty 100 in my purchase line. which class can i use. and which method. thanks, Gopal. - Yahoo! India Answers: Share what you know. Learn something new. Click here Send instant messages to your online friends - NOW [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sundararajan.T - Software Engineer (Enterprise Solutions Practice) - SIS [EMAIL PROTECTED] ___ Visit us at www.sundaraminfotech.in ___ This E-mail may contain privileged information and is intended solely for the addressee, and any disclosure of this information is strictly prohibited, and may be unlawful. If you have received this mail by mistake, please inform us immediately and delete this mail. Any information expressed in this mail does not necessarily reflect the views of SUNDARAM INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH SOLUTIONS's policy, unencrypted mail via Internet is not considered secure. ___ Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - Send instant messages to your online friends http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" 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: [Axapta-Knowledge-Village] Problem on InventDimId
i am not sure if i understand your query completly, but i think you want to know how to get the inventDimId in the purchase line. if yes then while creating the purchase line you need to include inventDim.clear(); inventDim.InventLocationId = xxx; // warehouse //. you can include for other elements too else can leave without entering any dimensions. purchLine.inventDimId = InventDim::findOrCreate(inventDim).InventDimId; have a great week end. cheers, Girish --- janasomnath786 [EMAIL PROTECTED] wrote: - Hi Girish This is Somnath Jana from India, Kolkata ,Salt lake I have gone through the mail text (below text) which is clear to me. Girish Bhatkal [EMAIL PROTECTED] wrote: Priyank, are you sure you want to use Profit/loss journal to include the opening inventory in the system. I feel using Movement journal is a more appropriate one to include the opening inventory. It would be better if other people also gives their opinions on which journal to be used. --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Priyanka, You need to assign the inventdim programatically if you have to attach inventdim. I remeber Girish posted some sample code in the past.. the code looks like below... Tablename yourTable; InventDim inventDim; .. But I faced a new problem regarding InventDimId. Please try to help me. Problem : I am inserting data from a external tables, into PurchTable and also to PurchLine. Inserting data into PurchTable is working fine, but when inserting number of entries (items) to PurchLine it throws error on InventDimId. The error message as Item identification cannot be changed when inventory transactions have been generated. = Now my question is how to find InventDimId from InventDim Table. I use the code as given below and few assignment also. InventDim::findorcreate(inventDim).InventDimId; but failed. Please provide me the actual code instructions. I know the insert method exist in both PurchTable and also PurchLine - is this insert method creates the proble. Please try to solve as soon as possible. Thanks and regards Somnath Jana India, Kolkata Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! For Good - Sponsor a London Marathon runner - http://uk.promotions.yahoo.com/charity/london-marathon Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] How to convert Real value to String value
Hi Jana, Whenever you need to find any function look at AOT/SystemDocumentation/Functions. here you will find the various functions available in axapta. If you select (double click) the function , these functions are explained with an example. cheers, Girish --- somnath jana [EMAIL PROTECTED] wrote: - Hi vk use the function num2str(); as Num2Str (real number,int characters,int decimals,int separator1,int separator2) Num2Str(12345.6,10,2,2,1) returns 12.345,60. Num2Str(12345.6,1,0,1,0) returns 12346. thanks Somnath Jana (Ontrack Systems Ltd, INDIA) vk [EMAIL PROTECTED] wrote: Hi, How to convert the Real value as a String? for example the real value as 0.00,i have converted into empty string.how it is possible.please any one help me. regards, vijay Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - - How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Sales Tax
while setting the Misc charges, in the general tab did you select the Vat groups? --- matt [EMAIL PROTECTED] wrote: - I'm trying to set-up sales tax. I'm having trouble getting the Misc Charges(Shipping Handling) be included in the sales tax. Can anyone tell me how this is done? Thanks MAtt Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - ___ NEW Yahoo! Cars - sell your car and browse thousands of new and used cars online! http://uk.cars.yahoo.com/ Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Fresh Produce
our organisation (Index computer systems, in UK) is working on fresh produce module and are already live with a few customers. --- Craig Fidler [EMAIL PROTECTED] wrote: - Hi Anyone working on a fresh produce vertical? The views expressed in this email are, unless otherwise stated, those of the author and not those of the BS3 Group or its management. The information in this e-mail is confidential and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is, for whatever reason corrupted or does not reach its intended destination. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Fresh Produce
our organisation is working on fresh produce module and are already live with a few customers. --- Craig Fidler [EMAIL PROTECTED] wrote: - Hi Anyone working on a fresh produce vertical? The views expressed in this email are, unless otherwise stated, those of the author and not those of the BS3 Group or its management. The information in this e-mail is confidential and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is, for whatever reason corrupted or does not reach its intended destination. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - ___ NEW Yahoo! Cars - sell your car and browse thousands of new and used cars online! http://uk.cars.yahoo.com/ Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] creating sales line
Manoj, you can refer the following to create the functionality. static void createSalesLine(Args _args) { salesLine _salesLine; salesLine salesLine;// original sales line salesQtynewQty = 5; // new sales qty salesTable salesTable = SalesTable::find(salesLine.SalesId); ; _salesLine.clear(); _salesLine.initFromSalesTable(salesTable); _salesLine.initFromSalesLine(salesLine,true,true); _salesLine.SalesQty = newQty; salesLine::modifySalesQty(_salesLine,inventDim::find(_salesLine.InventDimId)); _salesLine.LineAmount = _salesLine.calcLineAmount(_salesLine.SalesQty); _salesLine.createLine(false,false,false,true,false,false,false); } cheers, Girish --- manoj kumar [EMAIL PROTECTED] wrote: Hi Girish, I have done that, while inserting it is updating the same record as it accessing the same recordset.I need to create a new record for the same sales order for which i have to retrieve values from the sales header and first sales line. Can you help how to create a new record.. Regards, Manoj manoj kumar [EMAIL PROTECTED] wrote: Hi Girish, I can return the mod value or multiples of 10 but not the both and where to create this sales line.Whether to write in salestable- datasource- salesline-salesqty -modified method or in saleslinecreate function. Please suggest regards, Manoj Girish Bhatkal [EMAIL PROTECTED] wrote: you need to make modification to achieve this. here below is a hint: Qty = salesLine.salesQty mod 10; // Qty would be the remainder if(QTY != 0) { write code to pop up the decision buttona and then update the sales line and then create a new line with salesQty = Qty. } hope this is helpful. cheers, Girish --- manoj kumar [EMAIL PROTECTED] wrote: Hi when i create a sales order and if the quantity is not in multiple of tens, for eg.,i create sales order for 15 quantity, system will ask to do it for 20, because i set it in multiples of 10.Now when i click no, then salesorder for 10 quantity should be done and as well as remaining 5 quantity is also done in another line with same details like ware house,item number and all. Please any body help.. Thanks, Manoj Send instant messages to your online friends http://in.messenger.yahoo.com ___ NEW Yahoo! Cars - sell your car and browse thousands of new and used cars online! http://uk.cars.yahoo.com/ Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Send instant messages to your online friends http://in.messenger.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - Send instant messages to your online friends http://in.messenger.yahoo.com ___ Yahoo! Photos NEW, now offering a quality print service from just 8p a photo http://uk.photos.yahoo.com Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] creating sales line
Manoj, Where to write the code depends on many factors. Should this functionality also be valid if sales line are created from any other place ? Its always advised not to write functions on the forms . you could check this validation on table salesLine validatewrite method. you can call the function (to calculate and create salesline, better write it in a class) from this method. There could be some better ways but this just came in the mind. You do can write function to calculate the multiple of 10 and remainder value, both. logic could be int Multi10 = salesqty / 10; int partial = salesqty mod 10; if partial is not equal to 10 then give a message and if selected No then create a new line for partial qty and update the present line with qty Multi10 * 10. if selected Yes then update the present line with (Multi10 + 1) * 10. you can find out a different logic to calculate, the above is one of the way to calculate. i am not sure why you need to return a value. for some reason if you want to return multiple values then you need to use containers. cheers, Girish --- manoj kumar [EMAIL PROTECTED] wrote: Hi Girish, I can return the mod value or multiples of 10 but not the both and where to create this sales line.Whether to write in salestable- datasource- salesline-salesqty -modified method or in saleslinecreate function. Please suggest regards, Manoj Girish Bhatkal [EMAIL PROTECTED] wrote: you need to make modification to achieve this. here below is a hint: Qty = salesLine.salesQty mod 10; // Qty would be the remainder if(QTY != 0) { write code to pop up the decision buttona and then update the sales line and then create a new line with salesQty = Qty. } hope this is helpful. cheers, Girish --- manoj kumar [EMAIL PROTECTED] wrote: Hi when i create a sales order and if the quantity is not in multiple of tens, for eg.,i create sales order for 15 quantity, system will ask to do it for 20, because i set it in multiples of 10.Now when i click no, then salesorder for 10 quantity should be done and as well as remaining 5 quantity is also done in another line with same details like ware house,item number and all. Please any body help.. Thanks, Manoj Send instant messages to your online friends http://in.messenger.yahoo.com ___ NEW Yahoo! Cars - sell your car and browse thousands of new and used cars online! http://uk.cars.yahoo.com/ Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - Send instant messages to your online friends http://in.messenger.yahoo.com ___ Yahoo! Exclusive Xmas Game, help Santa with his celebrity party - http://santas-christmas-party.yahoo.net/ Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] creating sales line
you need to make modification to achieve this. here below is a hint: Qty = salesLine.salesQty mod 10; // Qty would be the remainder if(QTY != 0) { write code to pop up the decision buttona and then update the sales line and then create a new line with salesQty = Qty. } hope this is helpful. cheers, Girish --- manoj kumar [EMAIL PROTECTED] wrote: Hi when i create a sales order and if the quantity is not in multiple of tens, for eg.,i create sales order for 15 quantity, system will ask to do it for 20, because i set it in multiples of 10.Now when i click no, then salesorder for 10 quantity should be done and as well as remaining 5 quantity is also done in another line with same details like ware house,item number and all. Please any body help.. Thanks, Manoj Send instant messages to your online friends http://in.messenger.yahoo.com ___ NEW Yahoo! Cars - sell your car and browse thousands of new and used cars online! http://uk.cars.yahoo.com/ Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Re: MST Round-off error in Invoice Approval Journal
i had also seen this error at a client's site. and as subbu has mentioned you need to go to General ledger/ parameters/ledger . here you enter the maximum penny difference and the maximum penny - rounding in secondary currency and it should solve the pbm. I am not a financial expert so i had tried different values and it worked on 0.02 for me. good luck, cheers, Girish --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Irving, Did you guy make any customization to increase the number of decimals?. However, we have these kind of problems earlier. How we did solve is: You may want to go to Parameters of the particular module: Goto - Settlement and then try to change max penny differences so that code should not ( like 0.001) if the MST differece = 0.1 . Please change the settling for the instalnece to 0.001 ( howber form shows 0.00 ). It should solve your problem. I bet on this. Let me know if this does not solve. thanks, subbu Irving [EMAIL PROTECTED] wrote: Hi Sun Fen Thank you for your suggestion, but it didn't solve my problem. It's when I post general expence invoices in the Invoice Approval Journal, that I get a penny difference. Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, Sun Fen Chen [EMAIL PROTECTED] wrote: Hi Irving, After you fetch the voucher (after fetching it will not balance), you have to click Function - Purchase order. When you post the Invoice approval journal, have you clicked Function - Purchase order in the Invoice journal line? This will post the purchase order invoice from Invoice journal. Regards, Sun Fen On 12/5/05, Irving [EMAIL PROTECTED] wrote: Dear All Thanks for the input, but I'm afraid it didn't solve my problem. The different account are set up correctly so I'm able to post penny differences. I can find round-off setup at GL/Setup/Exchange Rates, but I can't find any setup concerning secondary currency. Any input will be welcome, Thanks Regards koffidan --- In Axapta-Knowledge-Village@yahoogroups.com, Tarek Saleh [EMAIL PROTECTED] wrote: Dear Asrar The penny differances must have an account in GL befor setup its parameter thes account is located in the system accounts setup (GL\setup\posting\system accounts) and u should define a ledger account for thes penny differance system account befor setup the parameter, and about the folowing error you should check the vendor posting profile and the vendor setup for currency. Feed back after testing All the best Tarek saleh Asrar Ahamed [EMAIL PROTECTED] wrote: Hi, Set up penny difference field under GL/Parameters/Ledger. Thanks, Irving [EMAIL PROTECTED] wrote: I have posted an invoice in the Invoice Register Journal: Then I go to the Invoice Approval Journal and fetch the posted voucher/invoice. When I post the Invoice Approval Journal I get the following error message: Message (08:23:39) Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '0,01', amount MST '0,01', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '-25,25', amount MST '-25,25', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '13,88', amount MST '13,88', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '11,38', amount MST '11,38', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7411', amount currency '-126,25', amount MST '-126,25', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '7412', amount currency '126,25', amount MST '126,25', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '7421', amount currency '-101,00', amount MST '-101,00', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '3731', amount currency '55,50', amount MST '55,50', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '6321', amount currency '45,50', amount MST '45,50', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '3781', amount currency '0,00', amount MST '-0,02', alternative amount '0,00', currency 'DKK', text 'Øredifferencer, Bilag god-0015' The transactions on voucher
RE: [Axapta-Knowledge-Village] Invoice updating of PO
sorry, i could not understand your query. do you want to neglect the under delivery functionality and always close the order after posting the invoice with the received qty? If yes, then you will have to make modification to achieve this. --- Nihar Saraiya [EMAIL PROTECTED] wrote: Hi Girish I am aware of Under Delivery functionality and how it is set up. My question is can we have a work around of Invoice Updating the PO with 'receive' quantity only, ofcourse with setting the check box for 'Close' at line level. Am i asking a bit more of functionality in Axapta? Nihar _ From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 7:58 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Invoice updating of PO Did you also enable on the purchase ledger parameters/ updates tab the field accept under-delivery? it works with both the combination of entering the percentage on the PO line and also it should be enabled on the parameters. --- Nihar Saraiya [EMAIL PROTECTED] wrote: Hi Girish I tried what u said at PO line level. After allowing the underdelivery percentage, i got a message, 'Under-delivery of line is 52.38 percentage, but the allowed under-delivery is only 52.38 percent. Am i still missing something very basic!! nihar _ From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 5:38 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Invoice updating of PO yes, you need to allow under delivery (set the percentage on the Po line also enable accept underdelivery on the purchase ledger parameters). you could also set it on the item master. --- Nihar Saraiya [EMAIL PROTECTED] wrote: Hi All A small scenario. I have PO with an item line of quantity 13 units. Updated the PO having entered, units 'Received' as 10. Posting Receipt List and Packing List with 10 units. Now i want to close the PO, as i will not be receiving remaining 3 units. How this has to be done? While Posting Invoice, in the Quantity field in the Parameter tab i selected 'Receive now' and at the line level, lines tab i set the checkbox for 'Close'. Iwas not able to post the invoice since the infolog gave Under Delivery error. I dont think to cancel the remaining units i need to set the 'Under-delivery'. What am i missing? Regards Nihar Saraiya, Confidentiality Notice This email is confidential and may also be privileged. If you are not the intended recipient please notify the sender immediately. You must not copy or use it for any purpose or disclose its contents to any other person. The sender accepts no responsibility for viruses received with or changes made to this email after it was sent. Any opinion expressed in this email may be personal to the sender. ___ Yahoo! Model Search 2005 - Find the next catwalk superstars - http://uk.news.yahoo.com/hot/model-search/ http://uk.news.yahoo.com/hot/model-search/ http://uk.news.yahoo.com/hot/model-search/ http://uk.news.yahoo.com/hot/model-search/ Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools _ YAHOO! GROUPS LINKS * Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ http://docs.yahoo.com/info/terms/ . _ ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com http://uk.security.yahoo.com === message truncated === ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM
RE: [Axapta-Knowledge-Village] Invoice updating of PO
Did you also enable on the purchase ledger parameters/ updates tab the field accept under-delivery? it works with both the combination of entering the percentage on the PO line and also it should be enabled on the parameters. --- Nihar Saraiya [EMAIL PROTECTED] wrote: Hi Girish I tried what u said at PO line level. After allowing the underdelivery percentage, i got a message, 'Under-delivery of line is 52.38 percentage, but the allowed under-delivery is only 52.38 percent. Am i still missing something very basic!! nihar _ From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 5:38 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Invoice updating of PO yes, you need to allow under delivery (set the percentage on the Po line also enable accept underdelivery on the purchase ledger parameters). you could also set it on the item master. --- Nihar Saraiya [EMAIL PROTECTED] wrote: Hi All A small scenario. I have PO with an item line of quantity 13 units. Updated the PO having entered, units 'Received' as 10. Posting Receipt List and Packing List with 10 units. Now i want to close the PO, as i will not be receiving remaining 3 units. How this has to be done? While Posting Invoice, in the Quantity field in the Parameter tab i selected 'Receive now' and at the line level, lines tab i set the checkbox for 'Close'. Iwas not able to post the invoice since the infolog gave Under Delivery error. I dont think to cancel the remaining units i need to set the 'Under-delivery'. What am i missing? Regards Nihar Saraiya, Confidentiality Notice This email is confidential and may also be privileged. If you are not the intended recipient please notify the sender immediately. You must not copy or use it for any purpose or disclose its contents to any other person. The sender accepts no responsibility for viruses received with or changes made to this email after it was sent. Any opinion expressed in this email may be personal to the sender. ___ Yahoo! Model Search 2005 - Find the next catwalk superstars - http://uk.news.yahoo.com/hot/model-search/ http://uk.news.yahoo.com/hot/model-search/ Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools _ YAHOO! GROUPS LINKS * Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . _ ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/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] Vendor invoices
let me know if my understanding of the requirement is right. a. The supplier sends the packing slip per order (if some orders are received in parts then multipe packing slips are received). b. the supplier then sends the invoice which has multple packing included in it (the list of delivery notes is available on the invoice). c. now you want to post the invoice by delivery notes. If my understanding is right, then you need to make changes to achieve this requirement . Using standard functionality this cannot be achieved. I remember there were a few discussion earlier also regarding a similar requirement. --- Syner P [EMAIL PROTECTED] wrote: Hello, I am new to Axapta and have a problem about invoice recording. We have purchase orders related with a supplier. They send us a packing slip per order but a combined invoices including more than one order. How can can I record this invoices and match with corresponding packing slips ? Thanks - Yahoo! Personals Single? There's someone we'd like you to meet. Lots of someones, actually. Yahoo! Personals ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Help Sudanese refugees rebuild their lives through GlobalGiving. http://us.click.yahoo.com/V42rFC/EbOLAA/cosFAA/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] Harry ! this one for u: Journal Upload
Priyank, are you sure you want to use Profit/loss journal to include the opening inventory in the system. I feel using Movement journal is a more appropriate one to include the opening inventory. It would be better if other people also gives their opinions on which journal to be used. --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Priyanka, You need to assign the inventdim programatically if you have to attach inventdim. I remeber Girish posted some sample code in the past.. the code looks like below... Tablename yourTable; InventDim inventDim; ; inventDim.clear(); inventDim.configId = 'configid' // coming from external source like flat file; inventDim.inventLocationId = 'your ware house';//coming from external source like flat file; your can attach your InventDimId to yor table like this yourTable.inventDimId = InventDim::findorcreate(inventDim).InventDimId; this is just for your infoPlease browse the forum for the more details . thanks, subbu Priyank Krishna [EMAIL PROTECTED] wrote: I have to upload the Profit Loss Inventory Journal for initialising the item stock on-hand in a fresh system. I tried it to upload with sample code mentioned in your site.The code is fabulous but I could not upload Inventory Journal since there is InventDim Datasource is attached additionally with its transactions form. Pls help how to tackle it. Thanks in advance ! Priyank - Enjoy this Diwali with Y! India Click here Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! FareChase - Search multiple travel sites in one click. ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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] we have 120 license,but only 110-114user logined and axapta give not enought license message,why?
This situation happens when users/clients do not log off normally from the AOS, an example is that they are forcing their system to reboot while still connected on the AOS. This causes the users connection to appear as still active. One soluton is as Varden has mentioned You have to stop both AOS and delete the axdat.udb, then restart again the AOS cluster. A drawback on this solution is you need to logoff all the clients connected to the server before you shutdown the AOS. Other soluton is tweaking / adding some keys at the Windows (OS) registry where the AOS machines are running. a) Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip. b) Add a value (DWORD) by the name KeepAliveTime. c) Change the value to the time in miliseconds you require (typically 3-5 minutes, (I.e. 18 to 30 decimal). d) Reboot the system to make the change take effect. You should note that the KEEP_ALIVE checking in Windows by default is checking for dead connections every 2 hours. The connection from the disrupted client will therefore be active on the system for up to 2 hours. To reduce this time adjust the AOS machines TCP/IP settings in the registry (refer to Microsoft Knowledge Base article: Q158474). The issue is really that dead connections can only be detected by using them for transport - and thus the KEEP_ALIVE packets transmitted should be reduced to the least acceptable level. WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. good luck cheers, Girish --- Varden Morris [EMAIL PROTECTED] wrote: This is usually a result of the axdat.udb file not being properly updated as a result of improper shutting down of the AOS (Possible power outage or the AOS service was stopped while the various instances of Axapta were running). You may fix the problem by stopping the AOS and deleting the axdat.udb file. After startup the problem should go away. Varden Morris Senior Developer WellPoint Systems Inc. Suite 2000, 500 - 4th Ave SW Calgary, Alberta, Canada T2P 2V6 (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: dear all, some times we can login 115 users,sometimes we only can login 112,and then the system give me the following message: cannot start navision axapta,as more users are running the system than the purchased rights allow. could some one give me some sollution or advice?? Best regards, qhpeng [EMAIL PROTECTED] 2005-10-24 Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! FareChase - Search multiple travel sites in one click. ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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] Urgent : How to upload data to generate Sales orders
even though only SalesTable and SalesLine are required its important to get the correct InventDimId in the salesLine table. As everyone knows that the inventDimId is created depending upon the dimension combination i dont use the standard axapta template import. I would write a function and use it to import the sales orders. if we do want to use standard axapta template then we should use all the 3 tables, SalesTable, SalesLine and InventDim. --- Hemant Kumthekar [EMAIL PROTECTED] wrote: I will try uploading using your template and let you know the outcome. Hemant Priyank Krishna [EMAIL PROTECTED] wrote: I tried as per u said but no luck...help lukas nugroho [EMAIL PROTECTED] wrote: Dear preety, to create sales order form excel, you need to use SalesTable and SalesLines only. You ought to fill the requirement field (yellow field). do not change or delete some field on excel regenerated from axapta. hope it helps --- Priyank Krishna [EMAIL PROTECTED] wrote: Thanks for reponse ! I have used existing Excel template Import functionality for creating sales orders but could not succeed. you please tell me correct format.I used SalesTable,SalesLine,InventDim what else is remaining into it. Your response is waited Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, You may like to create the Excel spreadsheet from Axapta AdministrationPeriodicData export/Import Excel Spreadsheet. I have upload sales orders Lines using the same technique, quite simple. If you need the format let me know. Hemant Priyank Krishna [EMAIL PROTECTED] wrote: Can anyone please tell me the way to upload data in SalesTable SalesLine with the purpose of creating Sales orders. Any responses are welcome. Cheers, Preety - Yahoo! India Matrimony: Find your partner now. - Yahoo! Music Unlimited - Access over 1 million songs. Try it free. Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! India Matrimony: Find your partner now. __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com Sharing the knowledge on Axapta. - Yahoo! India Matrimony: Find your partner now. Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! FareChase - Search multiple travel sites in one click. ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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]
what error are you getting. i am using this environment since a long time. THe only time you can get into problem is trying to connect to a client to connect to a higher version of application. i,e we should not use Sp2 client to connect to Sp3 or SP4. If you have multiple installations on your machine and if you want to work on Axapta v3 - Sp3 and SP4 application then you have the client and server upgraded to Sp4 . This way you can use the same client to connect to the SP3 and SP4 applications. --- sri ram [EMAIL PROTECTED] wrote: hi girish, Sorry to say I tried the same with Axapta 3.0 installed on my AOS and as a 3 tier sp4 thin client tried to acess the same. Its giving me an error. Please suggest if any cheanges are to be made during client installation. Thanking you. Regards Sri Ram On 10/20/05, Girish Bhatkal [EMAIL PROTECTED] wrote: its alright for you to use the SP4 client to run Sp3 or lower level applications/servers. But you should not connect Sp3 client to Sp4 application. --- Alessandro Ghidini [EMAIL PROTECTED] wrote: Hi group.. I'd like to install two different Axapta service packs on the same computer.. Basically i need an sp3 client for a 3 level connection to an sp3 server and an sp4 installation on my pc for testing purposes. If i try to make a new Axapta client installation on my pc, installer recognizes the old installation and tries to use that for repairing or changing.. So i can install a new client.. Any suggestion? Thanks in advance. Alessandro 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] ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. SPONSORED LINKS Business finance coursehttp://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w Business to business financehttp://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA Small business financehttp://groups.yahoo.com/gads?t=msk=Small+business+financew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw Business finance consultanthttp://groups.yahoo.com/gads?t=msk=Business+finance+consultantw1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA Business finance magazinehttp://groups.yahoo.com/gads?t=msk=Business+finance+magazinew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg Business finance schoolshttp://groups.yahoo.com/gads?t=msk=Business+finance+schoolsw1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA -- YAHOO! GROUPS LINKS - Visit your group Axapta-Knowledge-Villagehttp://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. - To unsubscribe from this group, send an email to: [EMAIL PROTECTED][EMAIL PROTECTED] - Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/. -- ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Yahoo! Groups Sponsor ~-- Help Sudanese refugees rebuild their lives through GlobalGiving. http://us.click.yahoo.com/hjNroD/EbOLAA/cosFAA/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
Re: [Axapta-Knowledge-Village]
its alright for you to use the SP4 client to run Sp3 or lower level applications/servers. But you should not connect Sp3 client to Sp4 application. --- Alessandro Ghidini [EMAIL PROTECTED] wrote: Hi group.. I'd like to install two different Axapta service packs on the same computer.. Basically i need an sp3 client for a 3 level connection to an sp3 server and an sp4 installation on my pc for testing purposes. If i try to make a new Axapta client installation on my pc, installer recognizes the old installation and tries to use that for repairing or changing.. So i can install a new client.. Any suggestion? Thanks in advance. Alessandro 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] ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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] Axapta Demo Installation Error : 1602
on which machine have u installed the AOS. it is better to install on the same machine on which the application is installed. If the database server is on another machine then see that you have proper access to that machine. (you can check that by connecting to the database using the odbc ). i feel this problem is because of access problem. you also try to restart the machine on which the AOS is installed and try again. good luck, --- Pushpa Bherwani [EMAIL PROTECTED] wrote: hi Thanks a lot for the help I have installed AOS Its running in Services but through Control Panel it shows status as Stopped and when I start it , it again goes Stopped within seconds What could be the reason ? Thanks Pushpa Lalith Jayantha [EMAIL PROTECTED] wrote: Hi You need to install Aos. its in axapta installation CD. Lalith --- Pushpa Bherwani [EMAIL PROTECTED] wrote: Hi Thanks for the reply That gave me a clue what is to be done but i m still not getting the actual way firstly i have a confusion regarding AOS Does it need some separate installation or what ?? I have installed MSDE and Microsoft Axapta 3.0 SP3 demo so do i need something else to get AOS coz i can't see AOS service manager running in my machine's services ...Plz answer this. Girish Bhatkal [EMAIL PROTECTED] wrote: in the axapta configuration you set the application path (system directory). here you give the path of the application (in your case it would be the path where the application is set on server B).make sure that you give the proper access rights for the application folder on server B and see that the folder can be accessed from machine A. i hope you are looking for this answer? --- Pushpa Bherwani [EMAIL PROTECTED] wrote: Hi I have now created a new database in my server and noe I can run Axapta Demo through that dsn. Anyhow its working Thanks to all for the help But can someone tell me that if I have Axapta running on some machine say Server A and my application is in some client machine say Machine B then how can I logon to Axapta which is o Machine A through my application which is on Machine B Thanks I hope someone will come with a solution Pushpa Hi, Can you check whether the AOS is running. Control Panel Navision Axapta Object Server. Check what is the AOS name, and also check your 3-tier configuration the Client tab. HK Lalith Jayantha [EMAIL PROTECTED] wrote: Hi can you run the axapta without server in 2tire Lalith --- Pushpa [EMAIL PROTECTED] wrote: Hi I am getting the following error ahile installing Axapta Demo Server not found : 1602 I have server and application on same machine. The strange thing is that I first installed demo which ran smoothly for 2-3 days and then suddenly in stopped working giving server not found errro , I am using the local as server I reinstalled it but now its not working on my system. Please help me to sort out this. Thanks Pushpa __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com - Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! India Matrimony: Find your partner now. ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com === message truncated === ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM
Re: [Axapta-Knowledge-Village] Axapta Demo Installation Error : 1602
in the axapta configuration you set the application path (system directory). here you give the path of the application (in your case it would be the path where the application is set on server B).make sure that you give the proper access rights for the application folder on server B and see that the folder can be accessed from machine A. i hope you are looking for this answer? --- Pushpa Bherwani [EMAIL PROTECTED] wrote: Hi I have now created a new database in my server and noe I can run Axapta Demo through that dsn. Anyhow its working Thanks to all for the help But can someone tell me that if I have Axapta running on some machine say Server A and my application is in some client machine say Machine B then how can I logon to Axapta which is o Machine A through my application which is on Machine B Thanks I hope someone will come with a solution Pushpa Hi, Can you check whether the AOS is running. Control Panel Navision Axapta Object Server. Check what is the AOS name, and also check your 3-tier configuration the Client tab. HK Lalith Jayantha [EMAIL PROTECTED] wrote: Hi can you run the axapta without server in 2tire Lalith --- Pushpa [EMAIL PROTECTED] wrote: Hi I am getting the following error ahile installing Axapta Demo Server not found : 1602 I have server and application on same machine. The strange thing is that I first installed demo which ran smoothly for 2-3 days and then suddenly in stopped working giving server not found errro , I am using the local as server I reinstalled it but now its not working on my system. Please help me to sort out this. Thanks Pushpa __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com - Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! India Matrimony: Find your partner now. ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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] DataStatus on inventtrans
i belive the fields in the index should be in proper order. In case (in table inventTrans) you are using the Index StatusItemIdx then you need to include in your select statement first statusReceipt, then StatusIssue, then ItemId and then DateStatus. If you dont want to use any of these in the select statement then you can exclude it but have it in a proper order. This is the reason we see multiple Indexes created on the table (take ex InventTrans). The ItemIdx should be used when you are going to have Item first in the index. Take another example of SalesLine. If you are making a search by SalesId and SalesStatus we use SalesStatusIdx (see the method calcCreditBalance in the salesLine table and see the order of fields used in the statement). Also should consider no of times the record/combination of records are available. If we see the find methods we usually see that the index used is the one which is unique or least nos of lines. This is also because there would be only one/least record with the combination. Ex; SalesLine table SalesLineIdx. May be all my assumptions/findings may not be right. but we are here to learn. cheers, Girish --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi 1. the order of where clause statement is not important 2. I would recommend not putting any index hint to begin with and check the sql trace to see which index is being selected. 3. If you are not happy with the performance then try things like #placeholder etc. Depends on how many times this statement is being called. regards harry James Flavell [EMAIL PROTECTED] wrote: Hi can somebody tell me the field 'DateStatus' on inventtrans is set at what points? I am just trying to improve performance on inventtrans searchs and can see the index 'StatusItemIdx' is useful to me. Basically I want to find all the inventtrans cost for sales invoices for a period of time and hence why any index that has a date in it would be very useful. My thinking is if date financial exists on inventtrans can I assume date status will ALWAYS be the same date as financial for that particular inventtrans record? And therfore replace in my select using datefinancial with datastatus... Part of my select originally would be (basically the std select to calc cost for an custinvoicetrans but with date range added): inventTrans.dateFinancial = _runStart inventTrans.dateFinancial = _runEnd inventTrans.ItemId == 'ABC' inventTrans.qty != 0 inventTrans.packingSlipReturned == 0 inventTrans.statusReceipt = StatusReceipt::Purchased inventTrans.statusIssue = StatusIssue::Sold _invoiceTrans.InventTransId != but I am wondering can I change it to: inventTrans.dateStatus = _runStart inventTrans.dateStatus = _runEnd inventTrans.ItemId == 'ABC' inventTrans.qty != 0 inventTrans.packingSlipReturned == 0 inventTrans.statusReceipt = StatusReceipt::Purchased inventTrans.statusIssue = StatusIssue::Sold _invoiceTrans.InventTransId != and be sure of always getting the same result (i.e. once data finanical then the inventtrans datastatus will not change)? Also I am just wondering the order of my where clause statements is important or not? I know in XAL previously that supposedly it was best to put them in the same order as the fields used in the index but not sure if any such 'feature' is still present in Axapta If I can use dateStatus would you recommend I use this StatusItemIdx as an index hint? I am just wondering since ItemId is not the first component then to me the search will have to go through ALL inventtrans that are sold or purchased. If I use an index with itemid as the first component then the search will immediately be narrowed down to the item Thanks James Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! for Good Click here to donate to the Hurricane Katrina
RE: [Axapta-Knowledge-Village] DataStatus on inventtrans
Hi James, during one of my previous implementation (2 yrs back) we had some performance issues and a Consultant from MS had visited us. he asked me to change the order of the select statements in order to improve the performance. This is because of the way the data is read. Since then i have been following this. If anyone feels what i have mentioned is wrong, then please do let us know. cheers, Girish --- James Flavell [EMAIL PROTECTED] wrote: - Thanks Grish, The part about fields being in order I was thinking about the where clauses in my select statments...whether they needed to come in the same order in my select statement as the order of the fields in the index. TO clarify, are you saying the order of the clauses in the select statement have an impact on performance? In terms of order of fields in the index I fully understand the importance of getting those right. Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Girish Bhatkal Sent: 28 September 2005 18:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] DataStatus on inventtrans i belive the fields in the index should be in proper order. In case (in table inventTrans) you are using the Index StatusItemIdx then you need to include in your select statement first statusReceipt, then StatusIssue, then ItemId and then DateStatus. If you dont want to use any of these in the select statement then you can exclude it but have it in a proper order. This is the reason we see multiple Indexes created on the table (take ex InventTrans). The ItemIdx should be used when you are going to have Item first in the index. Take another example of SalesLine. If you are making a search by SalesId and SalesStatus we use SalesStatusIdx (see the method calcCreditBalance in the salesLine table and see the order of fields used in the statement). Also should consider no of times the record/combination of records are available. If we see the find methods we usually see that the index used is the one which is unique or least nos of lines. This is also because there would be only one/least record with the combination. Ex; SalesLine table SalesLineIdx. May be all my assumptions/findings may not be right. but we are here to learn. cheers, Girish --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi 1. the order of where clause statement is not important 2. I would recommend not putting any index hint to begin with and check the sql trace to see which index is being selected. 3. If you are not happy with the performance then try things like #placeholder etc. Depends on how many times this statement is being called. regards harry James Flavell [EMAIL PROTECTED] wrote: Hi can somebody tell me the field 'DateStatus' on inventtrans is set at what points? I am just trying to improve performance on inventtrans searchs and can see the index 'StatusItemIdx' is useful to me. Basically I want to find all the inventtrans cost for sales invoices for a period of time and hence why any index that has a date in it would be very useful. My thinking is if date financial exists on inventtrans can I assume date status will ALWAYS be the same date as financial for that particular inventtrans record? And therfore replace in my select using datefinancial with datastatus... Part of my select originally would be (basically the std select to calc cost for an custinvoicetrans but with date range added): inventTrans.dateFinancial = _runStart inventTrans.dateFinancial = _runEnd inventTrans.ItemId == 'ABC' inventTrans.qty != 0 inventTrans.packingSlipReturned == 0 inventTrans.statusReceipt = StatusReceipt::Purchased inventTrans.statusIssue = StatusIssue::Sold _invoiceTrans.InventTransId != but I am wondering can I change it to: inventTrans.dateStatus = _runStart inventTrans.dateStatus = _runEnd inventTrans.ItemId == 'ABC' inventTrans.qty != 0 inventTrans.packingSlipReturned == 0 inventTrans.statusReceipt = StatusReceipt::Purchased inventTrans.statusIssue = StatusIssue::Sold _invoiceTrans.InventTransId != and be sure of always getting the same result (i.e. once data finanical then the inventtrans datastatus will not change)? Also I am just wondering the order of my where clause statements is important or not? I know in XAL
Re: [Axapta-Knowledge-Village] Form refresh from a class
Hi Subbu, suppose i want to call the doRefresh method on the salesTable form, from a class/job then TreeNode treeNode = TreeNode::findNode('Forms').AOTfindChild('SalesTable'); treeNode.AOTrefresh(); treeNode.treeNodeRelease(); treeNode = NULL; but what should i do to include the method doRefresh from the salesTable. i tried a few things but i get error that the Treenode object is not initialised. i had modification as treenode = TreeNode::findNode('forms').AOTfindChild('\\salesTable\methods\doRefresh'); can you tell me where am i going wrong. thanks cheers, Girish --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Girish, How are you doing?. what if I use to get the same result as follows. // TreeNode treeNode = TreeNode::findNode('Forms').AOTfindChild('Form'); ; treeNode.AOTrefresh(); treeNode.treeNodeRelease(); treeNode = NULL; /*/ is there any problem if I use this?. BTW, I will send you a seperate email with all info. your buddy, subbu Girish Bhatkal [EMAIL PROTECTED] wrote: hi, i understand the way to send the element and refresh. But what if we want to update a datasource of a form (which is already open). In this case the data is updated in a class but the class is not directly called from the form . --- wb [EMAIL PROTECTED] wrote: - Hi Girish, You can see for example form LedgerJournalTable, at method init journalFormTable = new LedgerJournalFormTable(element); LedgerJournalTable ledgerJournalTable() { return ledgerJournalTable; } hope this help you, wb 2005/9/21, Girish Bhatkal [EMAIL PROTECTED]: Hi Guys, I have a bookrefresh method on a form (which refreshes the datasource). Is it possible in someway to run this method from a class (provided we know the FORM name). I understand the way where in we get the caller name when the class is run from the form and execute the method. But in my case the class which is going to call this method on the form is not directly called from the Form. i tried to use the sysGlobalCache but i could not get the solution. can anyone let me know how can we achieve this. thanks, cheers, Girish Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! for Good Click here to donate to the Hurricane Katrina relief effort. ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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] Form refresh from a class
Hi Guys, I have a bookrefresh method on a form (which refreshes the datasource). Is it possible in someway to run this method from a class (provided we know the FORM name). I understand the way where in we get the caller name when the class is run from the form and execute the method. But in my case the class which is going to call this method on the form is not directly called from the Form. i tried to use the sysGlobalCache but i could not get the solution. can anyone let me know how can we achieve this. thanks, cheers, Girish ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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] Hiding confidential data in axapta
i believe the record level security should help achieve what you are looking for. cheers, Girish --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi I seem to remember a discussion that said it is possible encrypt a string. If it is not available then it should be easy to write your own function regards harry tj_jayson [EMAIL PROTECTED] wrote: Hi All, Is it possible to hide (or encrypt) salary data field from viewing from everybody other than HR manager? This includes stopping viewing from Table browser and backend SQL data base by IT department. Thanks JJT Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance uk - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! for Good Click here to donate to the Hurricane Katrina relief effort. ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! Groups Sponsor ~-- Help Sudanese refugees rebuild their lives through GlobalGiving. http://us.click.yahoo.com/hjNroD/EbOLAA/cosFAA/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] Adjusting Global Data Types
there should not be any problem. but i would advice to take a database backup before doing any changes. good luck, --- Roberto Pineda [EMAIL PROTECTED] wrote: - Hello to All. We have to increase the Account Number size from 11 to 15, but i want to know what happens if we do it at this moment, now the system has almost two years working. Is there a problem with the data or SQL database? How could we do this without severe issues? We have Axapta 3.0 SP3. Thanks in advance. Roberto Pineda __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/ Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/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] Invoice amount number to letter, printed in the invoice !!!!!!!!!!!
Hi Ricardo, you may have to write a display method here below is a job which is used to print number to text. use the code in the display method ... static void numberToWords(Args _args) { global global = new global(); print global::numeralsToTxt_ES(12121.39); print global::num2Text(12121.39); pause; } hope this would help. cheers, Girish --- Ricardo Cortés [EMAIL PROTECTED] wrote: Hi everybody Does anymone know, how to translate the invoice amount to letter and print it in the invoice? Thanks in advance Ricardo Cortés __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.yahoo.com.mx/ ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/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] Need your exp on Purchasing for Items of type Service
did you also check the Round-off on the exchange currency form / round-off tab? --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi, I need your different experiences on packing slip / invoicing of expense items ( Service ). For example, I have this funny scenario going on. 1. I created a Unit called 'M' for meters and I gave 3 decimals for that in the Unit Table. 2. Since Its an Service Item, I didn;t include Units on InventTable-Quantity Table for this item for 'Purchase Order' quantity. 3. I created a PO with 'quantity' 25.04. So it shows up '25.04' on the PuchQty on the PurchOrder purch Lines Tab. but it shows orderedQty as '25' only as it rounds off to Zero decimals since it has no units InventTable - Quantity- Unit. 4. I put the debugging points right from PurchLine.ModifyPurchQty to InventUpdate, Inventupd_* classes. to see the complete process and I understood how the inventory movement is happening in the code. But I have problem at the time of invoice due to '0.04' in update in Inventupd_Pysical.updateNow as its throwing an error So what is your experiences in invocing the PO for service Items, i.e expense. Do we need to have to specify the Unit of Measurement for that item tied to a InventTable - Quantity-purchaseorder Column - Unit ?. is there any way, we can avoid hitting inventory for this service items?. Appreciate your experiences. Thanks Regards, Subbu - Start your day with Yahoo! - make it your home page ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/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] Picking list created when no onhand stock was available
Hi everybody, The following is the scenario: The picking lists are generated from salesLedger/ periodic/Sales Update/ picking list on the Item stock model group the following are set: Physical negative stock - not active Financial negative stock - active Registration requirements - active picking requirements - not active the client said that a pick list was printed this morning even when the stock was not available. i tried to post another picking list for the same line but i could not as i got the expected error that no stock was available. But when i got to salesorder/ posting/ picking list registration i can see the picking list posted, today , with this item (with a particular batch, warehouse and location) which does not have any onhand stock. when i see the transactions i see that the stock avaiable was deducted yesterday and hence i believe there was never any stock today. had anyone seen this problem earlier and can any one tell what could be the condition when the picking list was created. This had happened earlier too. i would appreciate any thoughts on this issue. cheers, GIrish ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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] Grouping and sorting at the same time
X++ DOES NOT allow to use both in the same select statement. this is one of the main difference between X++ and SQL. --- vishnu verma [EMAIL PROTECTED] wrote: hi all, I am having one problem. I want to group the records based on customer account and sort them by their names.how can i do that.If any one can help me then i'll be highly obliged. Thanks Vishnu Prakash Verma. - Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and lots more. http://in.promos.yahoo.com/rakhi/index.html ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hgf3os3/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1124813425/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- 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] Deleting posted Journals
Nihar, there are ways to delete records from the table (using jobs) even after posting. But because many other tables also get posted and because of data consistency its always adviced not to forcefully delete the posted transaction data. you have to reverse the journal posting by posting the reverse entry. This will make sure that all the postings are adjusted. good luck, cheers, Girish --- Nihar Saraiya [EMAIL PROTECTED] wrote: Hi Girish. Thanks for the reply. The thing is that we have now exported the data from development server to live server with the posted transactions. Now we need to delete these transactions from the live server. There are not more than 5 posted journals in the Live server. How can these be deleted? If one can provide us with the details of which table need it to be deleted from, to start with, will be very highly appreciated. I am not quiet sure, but is there any way thru AOT, these journals be deleted? Waiting for the reply. Regards Nihar -Original Message- From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: Sunday, August 21, 2005 10:57 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Deleting posted Journals while exporting the data you first create the defination group. in the include table groups tab you can unselect the groups which you dont want include. after exporting the data using the defination group you can choose the same setup to import in the live system. good luck, cheers, Girish --- sherin francis [EMAIL PROTECTED] wrote: Hi All! We are transferring data from the development server to the live server for one of our clients. Some dummy data in Journals were entered and even posted in the development server. We now require to restore only the setups and none of the posted journal data into the live server. In short we would like to delete all the posted journals. I believe there is some macro that can be run within Axapta that does this work. Can anyone shed some light on this issue? Regards, Sherin Francis - Start your day with Yahoo! - make it your home page ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com http://uk.security.yahoo.com Sharing the knowledge on Axapta. _ YAHOO! GROUPS LINKS * Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms http://docs.yahoo.com/info/terms/ of Service. _ ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h3tek6j/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1124717960/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- 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] Why so slow???
yes as subbu has mentioned in the select method if the field has an index then always use index hint. if you see any of the find methods on the tables index hint is always used. This acts like pointers in C. This will improve the performance a lot. But in your code it would be best if you use SalesTable = SalesTable::find(_salesId); --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Brandon, I am also running in the 3 tier. Basically you are reading the ascii file record fields to fetch the SalesId for that customer. Since you are using SalesTable , since SalesId is the unique index, you can include firstonly the statement to: Select firstonly SalesTable where SalesTable.SalesId == _salesId; this is speed up the fetching the record rather than selecting whole Table j. Its just better way. ( You can use Select SalesTable Index SalesIdx where SalesTable.SalesId == _salesId; ). but since you are SalesId is uniuque, its nice to use 'firstonly'. I am afraid what other things are causing slowness. Umm, will see if anyone has any thoughts.Sicne you said you are experiencing slowness only for Confirmation , I am curious to know anyone has any explike this. Can anyone share if you have this kind of exp?. Best of luck, subbu Brandon George [EMAIL PROTECTED] wrote: Ok, Thanks for the reply... btw, this is running in a 3-tier environment - Client - AOS - Database. You said you could make use of the SalesIdx, what do you mean by that? How in code can you make use of the SalesIdx? Can you give me an example of explain? To give you a better understanding of this code, it is being called from in a Batch type of process, where a Flat File is read in with information that supplies info - to get SalesId. So this runs on about 300-2000 orders a day, depending on the Orders and time of year. Anyway any more advice, on how to use the SalesIdx would be great! thanks, Brandon - From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi Sent: Monday, August 15, 2005 2:40 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Why so slow??? or may be use firstonly. But I am not sure why this is executed slowly on your environment. will see if anyone has other thoughts like, run on clinet/server etc etc... Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Brandon, I created a sales order with quatation and tried to confirm your code. Its confirming to salesorder and its pretty fast . However i am doing in a job. But if I use SalesIdx on the select SalesTable statement, i could save 1/4 of the execution time ( just by using WinAPI:;GetTickCount() before and after trcy catch block ) But I am not sure what else is causing the slowness. Actually, I was also doing the same std code by keeping the job ( confirming/postings etc etc ) attached a menu item. but ours run very fast. Umm, I am handsup :(. We will see for others comments. hope you will get rid of this soon. Thanks, subbu Brandon George [EMAIL PROTECTED] wrote: Sure thing, We are running Axapta 3.0 with SP3. Below is the code used to Confirm the Orders: public boolean confirmSalesOrder(SalesId _salesId) { SalesFormletter SalesFormletter; SalesTable SalesTable; boolean b = false; ; try { SalesFormletter = SalesFormletter::construct(DocumentStatus::Confirmation,true); SalesTable.clear(); Select SalesTable where SalesTable.SalesId == _salesId; SalesFormletter.update(SalesTable, systemDateGet(), SalesUpdate::All, AccountOrder::None, false, false); b = true; } catch { // error occured b = false; } return b; } Thanks for reviewing it, maybe you can give me some pointers! thanks, Brandon - From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi Sent: Monday, August 15, 2005 10:26 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Why so slow??? Hi Brandon, Can you please post your code here to see if I can run it in my development server?. We also do the similar kind of stuff using connectivitty studio. Anyway, Can you please share the code what exactly you are doing?. which version of axapta and which version of SP?. Thanks,
Re: [Axapta-Knowledge-Village] reading table outside axapta database
Hi Andres, i think there was a few postings earlier too on this did you check the earlier postings on this group ? anyway one of the job is as below static void Update(Args _args) { // connection ODBCConnection oDBCConnection; gTest gTest; // new table in axapta created to test LoginProperty loginProperty; Statement statement; ResultSet resultSet; companyId Company; str FMrequestId; ; // Initialize Connection loginProperty = new LoginProperty(); loginProperty.setServer(SQL-UK); // server name loginProperty.setDatabase(FM_AXAPTA); // database name loginProperty.setUsername(sa); // userId on the database loginProperty.setPassword(mn); // password on the database // Create Connection Object oDBCConnection = new ODBCConnection(loginProperty); statement = oDBCConnection.createStatement(); while select gTest where gTest.Complete == NoYes::Yes { FMrequestId = gTest.Comments; // the field with which is used to filter and select the external table resultset = statement.executeQuery(SELECT * FROM RequestTable where RequestTable.FMRecid = ' + FMRequestId + ' + AND DATAAREAID = ' + company + ' + UPDATE RequestTable set Status = 'EXPORTED' where FMRecid = ' + FMRequestId + '); // working while(resultset.next()) { print resultset.getString(1); // the first field in the external table which is a string print resultset.getReal(2); // the second field in the external table which is real } } pause; } --- Andres Janno [EMAIL PROTECTED] wrote: Hello! Is it possible to get value to form field outside axapta database? For example completly different table from other mssql database? Regards, Andres Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hot3nls/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1124091606/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Sharing the knowledge on Axapta. Yahoo! Groups Links http://groups.yahoo.com/group/Axapta-Knowledge-Village/ [EMAIL PROTECTED] ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hason8f/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1124103017/A=2894354/R=0/SIG=11qvf79s7/*http://http://www.globalgiving.com/cb/cidi/c_darfur.html;Help Sudanese refugees rebuild their lives through GlobalGiving/a./font ~- 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] Re: Questionnaire
I am not sure what is the actual requirement in complete. But i assume that record to be attached can be any table (not predefined), something like in standard questionnaire we can select from a list of tables. But along with this it is required to go a step further and against the table also select the record (from the table). --- Amit Jain [EMAIL PROTECTED] wrote: Hello Ananth, For Which type of transaction you want to attach a questionaire because there can be inventory transactions, financial transactions and different base tables are used for the same. I agree with the solution given by Girish (my mate, who worked with me for 2 years) but where to put the code to make the reference with the newly(or existing) created table for the questionaire has to be figured out depending on the transactions type in business. Regards Amit Jain girish_axapta [EMAIL PROTECTED] wrote: Hi Ananth, with the present functionality its not possible. you have to make changes to achieve this. i would advice not to touch the present functionality but create a new functionality to attach the questions to the transaction records. you can take the tableId and the recordId as the references to attach. Good luck, cheers, Girish --- In Axapta-Knowledge-Village@yahoogroups.com, anantha raman [EMAIL PROTECTED] wrote: Hi all i want to attach a questionnaire to a transaction level. Can anyone help me in doing this. thanks in advance. Regards Ananth - Sell on Yahoo! Auctions - No fees. Bid on great items. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - - Start your day with Yahoo! - make it your home page ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hebd1v9/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123688588/A=2894354/R=0/SIG=11qvf79s7/*http://http://www.globalgiving.com/cb/cidi/c_darfur.html;Help Sudanese refugees rebuild their lives through GlobalGiving/a./font ~- 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] run time lookup - get value
The lookup now works... i am not sure earlier why it used to always return value 0. --- Girish Bhatkal [EMAIL PROTECTED] wrote: - Hi, i am trying to have a lookup on a stringEdit field no datasource/field/EDT attached in the properties. i have written the following lookup method on the stringEdit field and I AM ABLE to get the lookup. But when i select the record the value does not get selected in the stringEdit field. can anyone tell me what am i missing. here tableId and fieldId are selected from another table. public void lookup() { Query query = new Query(); QueryBuildDataSourcequeryBuildDataSource; SysTableLookup sysTableLookup; ; sysTableLookup = SysTableLookup::newParameters(tableId,StringEdit); sysTableLookup.addLookupfield(fieldId,true); sysTableLookup.addLookupfield(tableId, fieldId); queryBuildDataSource = query.addDataSource(tableId); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); } thanks, Girish ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - ___ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h2hjnpb/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123524935/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- 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] Infolog Log error - Record is dele ted by another user.
that's what i said. when you have a record in form 1 which uses table1. Now when a class is called from form1 and in the class if the record from the table1 is deleted in the class if the refresh is not properly made, it will give the said error. --- Nihar Saraiya [EMAIL PROTECTED] wrote: Hi Girish No, I am not trying to delete an axapta form per se, but a record (line) from a form. To be precise, I had this problem, when trying to delete a CoA line. Regards Nihar Saraiya -Original Message- From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 7:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Infolog Log error - Record is deleted by another user. i think its to do with refresh. Do you get this problem while deleting the standard axapta forms? if you have created a function in which the delete happens through a class and on the form you try to refresh it, it gives that message??? i am not sure if the same thing you are facing. If you delete/update the record from another form and want the parent form to be refreshed then you need to refresh the parent form from the child form itself. --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: I don;t know the any standard solution is there. But if I get the similar kind of message 'Record is already deletd by another user' , Axapta asks me refresh the form by clicing 'restore' button on the command menu... will see if anyone has any std solution... -subbu Nihar Saraiya [EMAIL PROTECTED] wrote: Hi All One has Often noticed when at a particular point of time, when data is being tried to be deleted, an Infolog pop's up mentioning that, the record is deleted by another user. I did check that all the end users have been logged in with different User Log In names, and would be accessing different forms. Many users may not have faced this error, but still I would like to know, what can be done to avoid it happening again. Any setup or configuration modifications required? Regards Nihar Saraiya Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com http://mail.yahoo.com ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. ? LSpots keywords ?? HM ADS ? _ YAHOO! GROUPS LINKS * Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ribe * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. _ ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com 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] Infolog Log error - Record is dele ted by another user.
in the method which calls the class in the form, after the class is called (where the line is deleted) you could write table_ds.executeQuery() --- Nihar Saraiya [EMAIL PROTECTED] wrote: That's fine, since I do not have the technical background, I may not have understood your reply on the 1st place. Can I conclude that one need to press F5 or use 'Restore' from the menu, 'Command'. Regards Nihar Saraiya -Original Message- From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: Sunday, July 17, 2005 5:59 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Infolog Log error - Record is dele ted by another user. that's what i said. when you have a record in form 1 which uses table1. Now when a class is called from form1 and in the class if the record from the table1 is deleted in the class if the refresh is not properly made, it will give the said error. --- Nihar Saraiya [EMAIL PROTECTED] wrote: Hi Girish No, I am not trying to delete an axapta form per se, but a record (line) from a form. To be precise, I had this problem, when trying to delete a CoA line. Regards Nihar Saraiya -Original Message- From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 7:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Infolog Log error - Record is deleted by another user. i think its to do with refresh. Do you get this problem while deleting the standard axapta forms? if you have created a function in which the delete happens through a class and on the form you try to refresh it, it gives that message??? i am not sure if the same thing you are facing. If you delete/update the record from another form and want the parent form to be refreshed then you need to refresh the parent form from the child form itself. --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: I don;t know the any standard solution is there. But if I get the similar kind of message 'Record is already deletd by another user' , Axapta asks me refresh the form by clicing 'restore' button on the command menu... will see if anyone has any std solution... -subbu Nihar Saraiya [EMAIL PROTECTED] wrote: Hi All One has Often noticed when at a particular point of time, when data is being tried to be deleted, an Infolog pop's up mentioning that, the record is deleted by another user. I did check that all the end users have been logged in with different User Log In names, and would be accessing different forms. Many users may not have faced this error, but still I would like to know, what can be done to avoid it happening again. Any setup or configuration modifications required? Regards Nihar Saraiya Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com http://mail.yahoo.com http://mail.yahoo.com http://mail.yahoo.com ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com http://uk.messenger.yahoo.com http://uk.messenger.yahoo.com http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. ? LSpots keywords ?? HM ADS ? _ YAHOO! GROUPS LINKS * Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village === message truncated === ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com 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] Aos exam
there are a few file uploaded on axapta links site. http://www.axapta-links.com/ a few documents are available on the axapta CD itself. which document are you precisely looking for? --- Mike Matta [EMAIL PROTECTED] wrote: My company is signing the contract to purchase Axapta and consulting as we speak. I will be heavily involved with developing and implementation. I am having major trouble finding training materials (can't get anything from the VAR until the deals is inked). Gloria has an outstanding question. Maybe this is common knowledge to Axapta veterans, but to newbies, training materials are non-existent. Any help obtaining training materials would be greatly appreciated. Thanks! Mike - Original Message - From: Gloria Sun To: Axapta-Knowledge-Village@yahoogroups.com ; [EMAIL PROTECTED] Sent: Thursday, July 14, 2005 8:46 AM Subject: Re: [Axapta-Knowledge-Village] Aos exam Thanks for your all answer, I am very appreciated for this. Where can I find 'Deployment (AOS) Course Manual' ebook? Thanks again, Gloria. ANIL OZAY [EMAIL PROTECTED] wrote: Hi, B and F. I selected these answers in exam. This title is explained on Deployment (AOS) Course Manual ebook. Regards, Anýl ÖZAY Software Engineer / Axapta Specialist MBSCP , MCP Anadolu Biliþim Hizmetleri A.Þ. Telefon : +90 212 449 39 82 Faks : +90 212 554 12 66 e-Posta : [EMAIL PROTECTED] www.bilisimanadolu.com Gloria Sun [EMAIL PROTECTED] Sent by: Axapta-Knowledge-Village@yahoogroups.com 14.07.2005 13:50 Please respond to Axapta-Knowledge-Village@yahoogroups.com To Axapta-Knowledge-Village@yahoogroups.com cc Subject [Axapta-Knowledge-Village] Aos exam Hi all, I am preparing for the Axapta server. I found this question on the partner quide. i would appreciate if anyone tell me what's the right choices. An Axapta Server Cluster has been established behind a firewall, and each Axapta Server runs one AOS instance. Below is a description of the IP addresses and the TCP port numbers of each instance. Axapta Server One: IP address = 192.168.10.1, TCP Port = 22035 Axapta Server Two: IP Address = 192.168.10.2, TCP Port = 22035 Cluster name is Finance. The following rules exist on the firewall: - Allow all incoming TCP traffic on TCP port 22035, to IP address 192.168.10.1 - Allow all incoming TCP traffic on TCP port 22035, to IP address 192.168.10.2 - Allow all outgoing UDP traffic on Internet interface - Allow all outgoing TCP traffic in Internet interface What rules need to be set up to gain access to the Axapta Server Cluster Finance located behind the firewall? (Please select TWO responses) A: Allow incoming TCP traffic on TCP Port 22035, from 127.0.0.1, to IP address 192.168.10.1 B: Allow all incoming UDP traffic on TCP Port 2712, to IP address 192.168.10.1 C: Allow incoming TCP traffic on TCP Port 22035, from 127.0.0.1, to IP address 192.168.10.2 D: Allow all incoming UDP traffic on UDP Port 2712, to TCP Port 22035 E: Allow all incoming TCP traffic on TCP port 22035, to IP address 192.168.10.255 F: Allow all incoming UDP traffic on TCP Port 2712, to IP address 192.168.10.2 Thanks. Danny Gaethofs [EMAIL PROTECTED] wrote: Dear all, In the CRM module there is an import relation/prospect journal function which can be found under CRM, Periodic, Import. The file format for importing these relations can be defined under CRM, Setup, Contact Management, Import I have not used this functionality before but am investigating whether it could be usefull. I need some help here! If I understand it well. The relations and contact persons are imported in journals, more precisely smmImportRelationJournal, smmImportContactPersonJournal, smmImportBusSectorJournal. So they are not directly imported in the smmBusRelTable nor ContactPerson and smmContactPersonsDetails. Using the transfer functionality the records in the journals can be transferred to the smmBusRelTable, ContactPerson and smmContactPersonsDetails. What I need to know here is how should I import
Re: [Axapta-Knowledge-Village] Infolog Log error - Record is deleted by another user.
i think its to do with refresh. Do you get this problem while deleting the standard axapta forms? if you have created a function in which the delete happens through a class and on the form you try to refresh it, it gives that message??? i am not sure if the same thing you are facing. If you delete/update the record from another form and want the parent form to be refreshed then you need to refresh the parent form from the child form itself. --- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: I don;t know the any standard solution is there. But if I get the similar kind of message 'Record is already deletd by another user' , Axapta asks me refresh the form by clicing 'restore' button on the command menu... will see if anyone has any std solution... -subbu Nihar Saraiya [EMAIL PROTECTED] wrote: Hi All One has Often noticed when at a particular point of time, when data is being tried to be deleted, an Infolog pops up mentioning that, the record is deleted by another user. I did check that all the end users have been logged in with different User Log In names, and would be accessing different forms. Many users may not have faced this error, but still I would like to know, what can be done to avoid it happening again. Any setup or configuration modifications required? Regards Nihar Saraiya Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com 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] [development-axapta] Clearing an Axapta Database of All transactional data
as subbu has mentioned its better to use impor/export. i would have created a new defination group and would exclude the transactions and others which are not required and import it in a new company and then delete the original company. i feel its risky to force delete the transactions. --- Dyachenko, Dmitry [EMAIL PROTECTED] wrote: Ok then. Perhaps, I didn't realize what was the problem. _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi Sent: Wednesday, July 13, 2005 5:02 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] [development-axapta] Clearing an Axapta Database of All transactional data Hi Dimitry, Just adding my experiece... SalesOrders/SalesLine etc etc etc also come under dynamic data kind of thing.( worksheet and lines) I think Brandon wants to delete those kind of stuff also along with postings Actually, we had the same scenario. but we actaully eliminated these in the Import Template We unchecked all except what we wanted..But as you said its not easy I learnt a new classDatabaseTransDelete. I didn;t know till now... Thanks regards, subbu Dyachenko, Dmitry [EMAIL PROTECTED] wrote: As far as I understood guys want to delete just those transactions, which they created during their development step. Or I've missed the idea? BTW, the class deletes the following categories of tables TableGroup::Transaction:, WorksheetHeader, TableGroup::WorksheetLine _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hemant Kumthekar Sent: Wednesday, July 13, 2005 4:16 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] [development-axapta] Clearing an Axapta Database of All transactional data Hi, There is a class called DatabaseTransDelete, this claa will delete all the transactions from all the tables. Note only TRANSACTIONS, not the master tables. Hemant Dyachenko, Dmitry [EMAIL PROTECTED] wrote: Afaik, there is no such a class in core axapta. You guys need to figure out which tables you want to clean up manually and which criteria you want to apply. Anyways you'll need to recalculate gl balance and inventory. Well, taking into account that you need to clean up ledger transactions... well, it's not gonna be easy. _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: Wednesday, July 13, 2005 3:23 PM To: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.com Subject: [Axapta-Knowledge-Village] [development-axapta] Clearing an Axapta Database of All transactional data Hello All, We are working with our Axapta Dev environment, and part of the development process involves Sales Transactions, for testing out the code we have wrote. We are now ready to cut the Application and Database to our training environment, BUT we want to get rid of all Transactions before we do so. Does anyone know of a Class / Job / Code that will run on an Axapta Database and clear it CORRECTLY of all transactional data? thanks in advance, Brandon Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course http://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business +finance+coursew2=Business+to+business+financew3=Small+business+financ ew4=Business+finance+consultantw5=Business+finance+magazinew6=Busines s+finance+schoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w Business to business finance http://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Bus iness+finance+coursew2=Business+to+business+financew3=Small+business+f inancew4=Business+finance+consultantw5=Business+finance+magazinew6=Bu siness+finance+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA Small business finance http://groups.yahoo.com/gads?t=msk=Small+business+financew1=Business+ finance+coursew2=Business+to+business+financew3=Small+business+finance w4=Business+finance+consultantw5=Business+finance+magazinew6=Business +finance+schoolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw Business finance consultant === message truncated ===
RE: [Axapta-Knowledge-Village] SP2 line with zero qty in Update is still shown in printout of delivery and invoice
i changed the qty on SalesEditLines i.e the posting screen. There on Lines tab/Update --- James Flavell [EMAIL PROTECTED] wrote: - Thanks girish, You set the qty to zero in the psosting screen is it? Or on actual sales line/deliver now? Just want to check because I tried 2 different std system and they both still show for delivery notes and invoices Mmm just had a thought is it maybe something to do with selecting to see backorder quantity??? Let me check Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Girish Bhatkal Sent: 01 July 2005 17:16 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] SP2 line with zero qty in Update is still shown in printout of delivery and invoice Hi James, yes i have tried that too. Infact when there was a requirement from a client that they needed to post the invoice by delivery note then i that case all i did was the lines which were not to be posted i updated the qty to zero and these lines were neglected. So i am not sure why this is happening at ur end. Might be some changes were made to include all the lines. --- James Flavell [EMAIL PROTECTED] wrote: - Sorry Girish, I forgot to mention I had several lines to update and I just set one of them as zero qty. Can you try that instead and see whether the zero line appears on the print out with zero qty. Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Girish Bhatkal Sent: 01 July 2005 01:07 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] SP2 line with zero qty in Update is still shown in printout of delivery and invoice Hi James, i am not sure why its happening at ur end. I just now created a SO then when posting the delivery note i changed the Update qty to zero . The order did not get posted and i got a msg that No lines for posting or quantity = 0. earlier when there was a requirement of posting the invoice for only certain lines i just made the qty = 0 and did have to delete the lines. --- James Flavell [EMAIL PROTECTED] wrote: Hi I just noticed for sales order quotation and confirmation that if I select Qty 'All' and then cahnge the update qty to zero then these zero lines do not get printed BUT when I do the same during delivery or invoice printing the zero lines still get printed!!! In order to not get the zero lines printed I have to delete the lines from the posting update screen... Can anyone tell me any good reason for why Axapta behaves this way? Personnally I think this is an error (i.e. it is not consistent and if I say update zero then it should consider it outside of the updating) Anyone know how to fix to make consistent? Thanks James ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com 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] New demo data
thanks. i will give it a try. i have in any case will contact the MS office at uk to see if we can get the new demo (if any is available). cheers, Girish --- Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi Girish, I think if you delete the company and re-import the data base it will work. In my case also it gave error on Axapta 3 Sp3 , I didn't see any items, so I deleted the company and re-created the company and imported, it will give you the error message for inventdims but this time I can see the data in all tables. Just give a try. HK Girish Bhatkal [EMAIL PROTECTED] wrote: Hi , does anyone know from where can we get any new demo data (after the one provided with Sp1). With the old data (Sp1) i am facing one or the other problem. When we import the data on Axapta 3, SP4 we get a message that inventDimId axapta is already available and did not create this record. Because of this on the forms like Item Master, sales/purchase form we cannot view the lines. When i created a new Item it created a new InventDimId in the InventDim table (where in the earlier versions it used to be Axapta). Has anyone any idea about how to get the new demo data. I have also gone through the dataupgrade process in the application. thanks, Girish ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com 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 the Yahoo! Terms of Service. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com 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] Reserve by code
Hi Harry, what i have done is that while transfering if the qty is less in the fromwarehouse i check if its reserved against a sales line (in inventtrans table). if i find the line then i remove the reservation and also include the record (i.e towarehouse, salesLine.inventTransId, qty) in a new table. Then when the transfer is done i will go back and again reserve against the salesLine (i pick the records from the new table which holds the salesLine and new warehouse details). It works well. thanks again. cheers, Girish --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Yes, this method is used when you know the sales order line that has to be reserved. However, this method will not solve your problem. The problem you have is that there is no link between the transfer journal and the sales order line. The axapta logic is as follows: User has transferred 10 items from warehouse A to warehouse B. After the transfer is posted, select any lines totalling 10 quantities from the previous dimension of the transfer journal (i.e. warehouse A) and try to re-reserve the line. The reservation is handled via multiple methods but you will have to make sure that you are calling the correct method. if confused, take a look at updateReserveAgain method. The paramters passed to this method are old dimension and quantity. This method will first select issue transactions from the old dimension that matches the quantity and will try to rereserve the lines. regards harsh Girish Bhatkal [EMAIL PROTECTED] wrote: Hi Harry, thanks for the info. i had found that the following method from class InventUpd_Reservation is used while reserving from standard sales order form. InventUpd_Reservation::updateReserveFromForm thanks again. cheers, Girish --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Say Sales order is on Warehouse MW, Location A1 Say Purchase order is received on Warehouse MW, Location A2 Say a transfer journal is posted from MW-A1 to MW-A2 Your sales order is still on MW-A1 so Axapta cannot reserve the stock against MW-A2. However, the sales order inventory line status remains ReservPhysical this is incorrect since there is no stock in MW-A1 to reserve against. This is a bug. What you could perhaps do is Class: InventUpdate. Copy method UpdateReserveAgain to a new method called say UpdateReserveAgainPhysical (or pass new paramters to the existing method). The above method looks for transaction that are reserveOrdered, you will have to change this to look for transactions that are reservedPhysical. next look at method writeInventTrans line 75 and 76 has the following code. if (reserveAgainDimId) this.updateReserveAgain(reserveAgainDimId,_inventTrans.qty); Insert your own code after these lines ..say... if (_inventTrans.Qty 0 !reserveAgainDimId _inventTrans.TransType == InventTransType::InventTransfer) this.newmthod(_inventTrans.inventDimId ,_inventTrans.qty *-1); This will atleast set the status of the sales order back to Ordered I have not tested this to find out side-effects but something like this should work. regards harsh Girish Bhatkal [EMAIL PROTECTED] wrote: Hi harsh, here is the scenario in detail 1. i create a PO for an Item A in warehouse MW and location 001. i receive the Item A in location 001. 2. Now i create a SO (with auto reservation) for Item A and warehouse MW. Now the system will automatically reserve the received item. 3. Now since 002 is the outbound location the user wants to move (transfer journal) the item from location 001 to 002. 4. right now since the item was already reserved, the user has to first go to the sales line , unreserve the line. then make the transfer journal posting. then go back to sales line and reserve again. 5. the requirement was that when the transfer journal is posted, the system should first find the reserved sales line (if pick list not posted) and unreserve it. Now the transfer posting should be complted and then again the reservation to the sales line has to be done (as this time it will be from new location). i hope the query is clear now. if you have worked on something like this then let me know. have a nice week end. cheers, Girish --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Girish questions: If a line has the status of reserved that means its not yet received. How can you transfer an item that has not yet been received? What am I missing? What you say should work in standard axapta regards harsh Girish Bhatkal [EMAIL PROTECTED] wrote: Hi Guys, Has any one worked
Re: [Axapta-Knowledge-Village] Reserve by code
Hi Harry, thanks for the info. i had found that the following method from class InventUpd_Reservation is used while reserving from standard sales order form. InventUpd_Reservation::updateReserveFromForm thanks again. cheers, Girish --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Say Sales order is on Warehouse MW, Location A1 Say Purchase order is received on Warehouse MW, Location A2 Say a transfer journal is posted from MW-A1 to MW-A2 Your sales order is still on MW-A1 so Axapta cannot reserve the stock against MW-A2. However, the sales order inventory line status remains ReservPhysical this is incorrect since there is no stock in MW-A1 to reserve against. This is a bug. What you could perhaps do is Class: InventUpdate. Copy method UpdateReserveAgain to a new method called say UpdateReserveAgainPhysical (or pass new paramters to the existing method). The above method looks for transaction that are reserveOrdered, you will have to change this to look for transactions that are reservedPhysical. next look at method writeInventTrans line 75 and 76 has the following code. if (reserveAgainDimId) this.updateReserveAgain(reserveAgainDimId,_inventTrans.qty); Insert your own code after these lines ..say... if (_inventTrans.Qty 0 !reserveAgainDimId _inventTrans.TransType == InventTransType::InventTransfer) this.newmthod(_inventTrans.inventDimId ,_inventTrans.qty *-1); This will atleast set the status of the sales order back to Ordered I have not tested this to find out side-effects but something like this should work. regards harsh Girish Bhatkal [EMAIL PROTECTED] wrote: Hi harsh, here is the scenario in detail 1. i create a PO for an Item A in warehouse MW and location 001. i receive the Item A in location 001. 2. Now i create a SO (with auto reservation) for Item A and warehouse MW. Now the system will automatically reserve the received item. 3. Now since 002 is the outbound location the user wants to move (transfer journal) the item from location 001 to 002. 4. right now since the item was already reserved, the user has to first go to the sales line , unreserve the line. then make the transfer journal posting. then go back to sales line and reserve again. 5. the requirement was that when the transfer journal is posted, the system should first find the reserved sales line (if pick list not posted) and unreserve it. Now the transfer posting should be complted and then again the reservation to the sales line has to be done (as this time it will be from new location). i hope the query is clear now. if you have worked on something like this then let me know. have a nice week end. cheers, Girish --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Girish questions: If a line has the status of reserved that means its not yet received. How can you transfer an item that has not yet been received? What am I missing? What you say should work in standard axapta regards harsh Girish Bhatkal [EMAIL PROTECTED] wrote: Hi Guys, Has any one worked on unreserving and then reserving automatically (by coding). Is there anything that should be taken care of during this development. The requirement is that if a reservation is done for an sales line for item A in warehouse MW then when a transfer journal is posted to move the item A from warehouse MW to warehouse Main then the reservation against the sales line should be removed and then automatically reserve against the item in Main warehouse. Has anyone worked on this functionality? thanks, cheers, Girish ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com 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 the Yahoo! Terms of Service. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com 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/ === message
Re: [Axapta-Knowledge-Village] Reserve by code
Hi harsh, here is the scenario in detail 1. i create a PO for an Item A in warehouse MW and location 001. i receive the Item A in location 001. 2. Now i create a SO (with auto reservation) for Item A and warehouse MW. Now the system will automatically reserve the received item. 3. Now since 002 is the outbound location the user wants to move (transfer journal) the item from location 001 to 002. 4. right now since the item was already reserved, the user has to first go to the sales line , unreserve the line. then make the transfer journal posting. then go back to sales line and reserve again. 5. the requirement was that when the transfer journal is posted, the system should first find the reserved sales line (if pick list not posted) and unreserve it. Now the transfer posting should be complted and then again the reservation to the sales line has to be done (as this time it will be from new location). i hope the query is clear now. if you have worked on something like this then let me know. have a nice week end. cheers, Girish --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Girish questions: If a line has the status of reserved that means its not yet received. How can you transfer an item that has not yet been received? What am I missing? What you say should work in standard axapta regards harsh Girish Bhatkal [EMAIL PROTECTED] wrote: Hi Guys, Has any one worked on unreserving and then reserving automatically (by coding). Is there anything that should be taken care of during this development. The requirement is that if a reservation is done for an sales line for item A in warehouse MW then when a transfer journal is posted to move the item A from warehouse MW to warehouse Main then the reservation against the sales line should be removed and then automatically reserve against the item in Main warehouse. Has anyone worked on this functionality? thanks, cheers, Girish ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com 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 the Yahoo! Terms of Service. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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] Multiple packing slips to one sales invoice
you need to do some modifications for this. earlier a few daus back there was a question about a similar function for which i had explained a work around. in that case you could select the packing slip nos and the corresponding qty was updated on the lines. good luck, --- ll_guok [EMAIL PROTECTED] wrote: - Hi, Has anyone tried printing multiple packing slips on 1 sales invoice in Axapta Ver 3.0 SP2? I have the following scenario: Sales Order Number: A001 Sales Order Quantity: 10 pcs Packing Slip No: P001 Packing Slip Quantity: 2 pcs Packing Slip No: P002 Packing Slip Quantity: 3 pcs Packing Slip No: P003 Packing Slip Quantity: 3 pcs I only want to invoice packing slip P001 and P002. If I go to Accounts Receivables - Periodic - Sales Update - Invoice, in my query selection, I link the CustPackingSlipSalesLink to the Sales Order table, and select the Packing Slip Id P001 and P002, I notice that the Update quantity will reflect 8 and not 5. When I post the invoice, all three packing slips are posted on the invoice, which is not what I have selected. Any way that I can select packing slips to post to the invoice? Thanks, Lee Lee 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 the Yahoo! Terms of Service. ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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] Reserve by code
Hi Guys, Has any one worked on unreserving and then reserving automatically (by coding). Is there anything that should be taken care of during this development. The requirement is that if a reservation is done for an sales line for item A in warehouse MW then when a transfer journal is posted to move the item A from warehouse MW to warehouse Main then the reservation against the sales line should be removed and then automatically reserve against the item in Main warehouse. Has anyone worked on this functionality? thanks, cheers, Girish ___ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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] Purchase Rejections
you need to create and post the credit note. --- deepa_ramarao [EMAIL PROTECTED] wrote: - Hi, How are purchase rejections handled in Axapta DR 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. Send instant messages to your online friends http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/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] Hi
yes, the second database (in second system) should be able to be connected from the first machine using ODBC. --- panda arabinda [EMAIL PROTECTED] wrote: - HI Girish, Thanks for giving idea.But as per your solution the other database should be there in the intranet or not ? I think one application should be able to talk with the other database. is not it ? Regards Arabinda --- Girish Bhatkal [EMAIL PROTECTED] wrote: Hi santosh, Well almost everything is possible. But do they want just the Sales order and purchase order to synchronise. What about the inventory? even though you get a solution of having the same SO's and PO's created and posted, this could happen only if inventory is also updated. But if the other things are thought of then you could write code to read the data from another database (using to ODBCConnection). After getting the data you need to write a function to create the SO's and PO's. This function has to be written at both the applications (assuming they are just copy of the same application). Then setup to run this function in batch, set to run at the end of the day. hope this would help you. cheers, Girish --- Varden Morris [EMAIL PROTECTED] wrote: Hi santosh I think the solution would be journal entries. You can use standard Axapta to export the data from the SalesTable and SalesLine tables for the sales orders and the PurchTable and PurchLine tables for the purchase orders. After this you could then create tables in Axapta to hold the data from these tables so that you can use standard Axapta to import the data. You then need to write code to create journal entries from these tables and then use standard Axapta to post the journals. Varden Morris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226 Fax: (876) - 923 - 5372 Cell: (876) - 3833566 Email: [EMAIL PROTECTED] [EMAIL PROTECTED] santosh padhi [EMAIL PROTECTED] wrote:Hi all Hi all, My client's requirement is there is 2 location.there they wants to setup 2 separate application and database.There is no centrlize server. In 1 location they create 10 p.o and 15 s.o. In another location they creates 5 p.o and 10 s.o. on the same day all the p.o and s.o will synchronize.Mean in both of the location all the p.o and s.o record should updated.How it is possible? any solution highly appreciated. santosh Yahoo! India Matrimony: Find your life partner online Go to: http://yahoo.shaadi.com/india-matrimony 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. - Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web Send instant messages to your online friends http://uk.messenger.yahoo.com __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ 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! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/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] Hi
Hi santosh, Well almost everything is possible. But do they want just the Sales order and purchase order to synchronise. What about the inventory? even though you get a solution of having the same SO's and PO's created and posted, this could happen only if inventory is also updated. But if the other things are thought of then you could write code to read the data from another database (using to ODBCConnection). After getting the data you need to write a function to create the SO's and PO's. This function has to be written at both the applications (assuming they are just copy of the same application). Then setup to run this function in batch, set to run at the end of the day. hope this would help you. cheers, Girish --- Varden Morris [EMAIL PROTECTED] wrote: Hi santosh I think the solution would be journal entries. You can use standard Axapta to export the data from the SalesTable and SalesLine tables for the sales orders and the PurchTable and PurchLine tables for the purchase orders. After this you could then create tables in Axapta to hold the data from these tables so that you can use standard Axapta to import the data. You then need to write code to create journal entries from these tables and then use standard Axapta to post the journals. Varden Morris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226 Fax: (876) - 923 - 5372 Cell: (876) - 3833566 Email: [EMAIL PROTECTED] [EMAIL PROTECTED] santosh padhi [EMAIL PROTECTED] wrote:Hi all Hi all, My client's requirement is there is 2 location.there they wants to setup 2 separate application and database.There is no centrlize server. In 1 location they create 10 p.o and 15 s.o. In another location they creates 5 p.o and 10 s.o. on the same day all the p.o and s.o will synchronize.Mean in both of the location all the p.o and s.o record should updated.How it is possible? any solution highly appreciated. santosh Yahoo! India Matrimony: Find your life partner online Go to: http://yahoo.shaadi.com/india-matrimony 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. - Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web Send instant messages to your online friends http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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] Re: Alternate Parts
Hi vshan, just be careful before including the dimensions (i am assuming that by dimensions you mean Configurations) to identify the alternate items. Because if you are including the configurations only to include the alternates then remember that this configuration would be activated against this Item for every transacction you make (inventory transactions, purchases, sales etc..). i would have advised to include a new table and make modifications to include the new requirement. good luck, cheers, Girish --- vshan12_rao [EMAIL PROTECTED] wrote: - Hi, Thank You. But the user requires a facility wherein he has an option to choose from a list of alternates. He may do this as the rates may vary. We are trying the option of defining one part number and using dimensions to indicate alternates vshan --- In Axapta-Knowledge-Village@yahoogroups.com, Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, The existing Alternate part is only used in Sales Order module. Axapta will use the Alternate item depending upon the option you had chosen 1. Never - No action 2. Nothing In Inventory - Stock for Item A is checked and if nothing is found looks for Item B which you had defined as alternate and if found in stock Axapta replaces the Sales Order line with Item B 3. Always - whenever Item A is entered in Sales Order line, it will be replaced by Item B If you have to have a list of alternate items for one item then you may have to build a relation as shown below Item # Alternate Item ITEM A -- ITEM B ITEM B -- ITEM C ITEM C -- ITEM A So when you try to sell Item A , and if B is not in stock but C has some Qty in Stock , Axapta will suggest Item C when you try to save the Sales Order Line. The above example is true for the option Nothing in Inventory. HK vshan12_rao [EMAIL PROTECTED] wrote: Hi, What is the facility for multiple alternate parts in Axapta? How does the existing alternate part feature work? vshan 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 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. Send instant messages to your online friends http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/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] postal code from uk as file for axapta
you may have to purchase it from Royal mail or some other agency. you can check the below link http://www.royalmail.com/portal/rm/jump2?mediaId=600127catId=400084 cheers, Girish --- [EMAIL PROTECTED] wrote: hi all, does anybody knows, where i could get a file for axapta whith the postal code from the UK? thank`s sascha guettler Send instant messages to your online friends http://uk.messenger.yahoo.com Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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: RE: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.
Hi Raul, yes it should always be partner's initialls and not customers. But suppose if you are directly working for an end client then you could have their Initial. This is to identify what's standard and what's new. If your firm has got some outsource work then the client (which would be an MBS parnter) would always suggest to have their intials. When i was working for my ex-employer we used to get many developement work outsourced by some solution centres in the US and other countries. They always wanted us to use their initials (in fact this was one of their requirement).So this would mean that these organisation would have a unique initials , no matter if it was outsourced or work was done inhouse. this we did since way back when we used to work on version 2.1. This was the requirement of most of the Solution centres. In this way i cultivated the habit of adding the prefix as a rule for naming. Guys, I am not saying adding suffix or not adding any identification is wrong. Every one is RIGHT in what they follow. This is not any individual's decision. This rule is always decided on Organisational level, whether if we need any prefix/sufix added as a rule for naming conventions and all the developers , within the organisation, have to follow this rule. As a technical consultant all i could do was give advise to our clients and it was upto the client to decide. But i felt this was a very good discussion and i am sure we all will be benifited from all the views. Have a nice day cheers, Girish --- Raul Llorente Peña/OPENSOLUTIONS [EMAIL PROTECTED] wrote: - The problem of prefixes comes when you want to copy funcionality from a customer to other, and have a maintenance plan on them... customer 1: PelbetPrefix: PLB_ customer 2: Ibmosher Prefix: IBM_ Object: PLB_Class1, PLB_CustReport, etc... Export them, import in Ibmosher... objects called IMB_ with others PLB_ make no much sense... rename them before importing, or after exporting... ok, now objects have the right prefix... Pelbet suddenly complaints about a bug, or want to add funcionality... Shall I rename every corrected object in every customer with that funcionality? Urgh, that doesn't sound clear for me. An intermediate solution could be to prefix objects with the Partner initials, instead. I don't use to prefix objects with company names (customer's nor mine). Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS -Paulius Cerniauskas [EMAIL PROTECTED] escribió: - Para: Axapta-Knowledge-Village@yahoogroups.com De: Paulius Cerniauskas [EMAIL PROTECTED] Fecha: 18/02/2005 09:43 Asunto: RE: [Axapta-Knowledge-Village] High Importance Syntax error after a Int declaration. You can find both advantages and disadvantages of using prefixes. In my practice prefixes is good for version control and client based object grouping. Sufixes is good to trace inheritance, e.g. class or EDT inheritance. As always it depends on your coding style... And try to get used to shortcuts F2, F11, Shift+F2 etc. I have found it very usefull... regards Hmmm... are u a systems administrator by any chance? Your reasoning is perfectly logical if one is thinking from system administrator's point of view. For me as a programmer, it's the ease of reading the code and ease of upgrade that is more important. As said earlier, while reading the code, I don't want the prefix to interfere in my thinking and if I extend an Axapta table (new table to hold relevant information) or create an inheritance of a class then I want the new objects listed in relevance. (for e.g. I have extended InventMov_Purch class and given it the name InventMov_Purch_ShipmentMMS, this will make sure that my class is grouped together correctly. Adding tables to data import export groups has a very limited advantage, how many times does anyone do that? And I never use the F2 (lookup) functionality for coding. I was using a prefix in 2001 and have been using a suffix since then and I can confidently tell you that suffix will improve the coding speed in the long term. In fact all the solution centres that I have worked for have gone for the suffix. I would say try it for a week and see the results.*s* Regards harry _ From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: Friday, 18 February 2005 12:41 p.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] High Importance Syntax error after a Int declaration. Hi Harry, from my experience i feel there is always an advantage of naming with identifier as a prefix. i.e if your client's name is ABCDE then you could pick the first 3 digits and then write ABC_TableName1. some of the advantages are: 1. if you want to include the new