Re: [Axapta-Knowledge-Village] Weighted Average over multiple site
Hi !! You have to apply Inventory Model Group to 'Weighted Avg.' for each item in the Item Card. Somnath Jana From: Abdullah Al-Nunu aaln...@netways.com To: Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge-Village@yahoogroups.com Sent: Sun, 30 May, 2010 2:17:20 PM Subject: [Axapta-Knowledge-Village] Weighted Average over multiple site Dears, I have the following requirements, I have a multi-site company. And I want to have the cost of the items to follow the weighted average model overall the company; the cost is the same in all sites. Any idea ? Regards Abdullah Al Nunu
Re: [Axapta-Knowledge-Village] ECC no for differnet Warehouses
Hi !1 Yes, Please configure your warehouse information card for ECC setup.. Thanks Somnath Jana From: Abhay ab...@b2bsoftech.com To: development-axa...@yahoogroups.com Cc: Axapta-Knowledge-Village@yahoogroups.com Sent: Fri, 21 May, 2010 11:07:13 AM Subject: [Axapta-Knowledge-Village] ECC no for differnet Warehouses Dear All, Can anybody tell me how to give different ECC nos for different warehouses in Trading concern, Manufacturing Concern.? Regards Abhay THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed.
Re: [Axapta-Knowledge-Village] How can we upgrade AX2009 to SP1 with customization
Hi !! Can't understand why u hiden your name as (ax_consult...@yahoo.com). Any way. Grate mistake happend. Steps will be as follows 1. Take a SQL Backup 2. Create a New Project and collect there all the relavent devlopment (modification) like table, forms, reports ,baseenam,edt etc every thing as per development. 3. If required fresh installation then install AX 2009, then SP1 4. Stop AOS and run compilation 5. Set the configuration and update Index 6. import the Project 7 Compile the AOT again 8. if required collect the data to your specific table (newly) created. 9. Test the new functionality you created 10. Start AOS and Run Axapta Cheers !!! it will work fine Thanks and Regards, Somnath Jana Microsoft Dynamics Technology Specialist, From: Ax Consultant ax_consult...@yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Sun, 8 November, 2009 6:33:45 PM Subject: [Axapta-Knowledge-Village] How can we upgrade AX2009 to SP1 with customization Hi, Currently our client is having AX2009 and added 4 new tables through AOT which are having data in SQL db. Now we have to install SP1, I have done it in following sequence on new test machine: Restored Sql db Did fresh installation of AX2009 Replaced application folder from production to test machine installed SP1 Run checklist, but during upgrade code step it finds new tables in sql and gives message to delete them to continue. Hence, at the end we could not see those tables added through AOT. Can you please help me , how should this be done. how can we upgrade AX2009 to SP1 with customization. Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos
Re: [Axapta-Knowledge-Village] Calculattion of Deprecciattion by proposal when Assets are imported in Ax 2009
Hi!! Fixed Asset relates no of linked information like (a) Asset Group - with Asset , (b) Depreciatiation books, (c) Fixed Asset Posting information and finally If Fixed asset as Capital Goods. I gauss that there is some thing missing, when you import the fixed asset data in th the Fixed asset table. Please check all related link informaion. I think it may solve you quiry... Thanks and Regards, Somnath Jana From: Abhay ab...@b2bsoftech.com To: ax forumdev development-axa...@yahoogroups.com Cc: ax knowledge village Axapta-Knowledge-Village@yahoogroups.com Sent: Sat, 24 October, 2009 10:58:27 PM Subject: [Axapta-Knowledge-Village] Calculattion of Deprecciattion by proposal when Assets are imported in Ax 2009 Dear All. I have a strange problem I have imported all Fixed Assets and then tried to calculate depreciation proposal but that is not worling so I checked the Deprecaiton in the FA-Value models - Inquiy- Profile the depreciation calaculation the calculation is done. but when i try to fun in from GL- Generral Jounral- Depreciation proposal the same is not calculated on the imported Assets. Hence I created and Asset in Ax and the acquired it through General Journal the same process above was repeated the depreciation runs fine. in the acquistion proposal the same can be run and posted . I dont know why it runs why acquired through acquistion General Journal and does not worked when imported. Regards Abhay THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed. Add whatever you love to the Yahoo! India homepage. Try now! http://in.yahoo.com/trynew
Re: [Axapta-Knowledge-Village] Ax 2009 in Spain
Hi Sebastian... Oviously don't hesitate to implement Axpta 2009 in Spain. Localized version (country specific) you required for Spain. So far the legal is concern, you may serious about the configuration setting and taxation setup. More report you have to customized... nothing is very serious.. Thanks and Regards, Somnath Jana Microsoft Dynamics Technology Specialist, From: Sebastian Ohlsson agcom...@gmail.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tue, 6 October, 2009 8:40:19 PM Subject: [Axapta-Knowledge-Village] Ax 2009 in Spain Hi! Is there anybody that has experience in implementing Ax 2009 in Spain? Does Ax meet the legal requirements or have you been forced to adjust standard to meet the legal requirements? Best regards, Sebastian Yahoo! India has a new look. Take a sneak peek http://in.yahoo.com/trynew
Re: [Axapta-Knowledge-Village] Lookup filter
Dear Betpe You have to select 'Parent Type' Thanks and Regards, Somnath Jana From: Belal Marzouk belal_marz...@yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tue, 6 October, 2009 8:16:18 PM Subject: [Axapta-Knowledge-Village] Lookup filter [1 Attachment] [Attachment(s) from Belal Marzouk included below] Hello, By following this path: CRM - (Common Forms) - Activity Details - Association tab How can I filter the lookup Parent ID 3rd column beside Contact to list only contacts of the customer selected in another Grid line Customers ? see the attached pdf for more clarification. Regards, Belal Try the new Yahoo! India Homepage. Click here. http://in.yahoo.com/trynew
Re: [Axapta-Knowledge-Village] Fixed Assets import into AX 2009
Hi Abhay AssetBook and Asset Group table Take Asset Group table first then assetBook Thanks and Regards, Somnath Jana From: Abhay ab...@b2bsoftech.com To: Axapta-Knowledge-Village@yahoogroups.com Cc: development-axa...@yahoogroups.com Sent: Tue, 6 October, 2009 7:57:12 PM Subject: [Axapta-Knowledge-Village] Fixed Assets import into AX 2009 Dear all, Has anybody imported Fixed Assets data in Ax-2009. Please tell me the tables to be used for master data import Regards Abhay THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed. Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos
Re: [Axapta-Knowledge-Village] Urgent: Amount Credit Note in AX2009
Hi, I think your have to change you consept of increasing inventory value and quantity other way. No other way to solve your problem Regards, Somnath From: ax_consultant ax_consult...@yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, 27 August, 2009 10:11:27 AM Subject: [Axapta-Knowledge-Village] Urgent: Amount Credit Note in AX2009 Kindly help me on this issue: When we send purchase order to the vendor in some cases vendor (Publisher) charge us prices as against agreed. For example if 100 quantity of an item was ordered at US$15.00 the publisher sends us invoice at US$16.00 ,so we write to the Vendor and if agreed the vendor sends us Credit Note for US$100.00 (100 * $16-$15). Credit note available in AX is used to adjust quantity but not prices. Is there any way to adjust vendor balance and item cost at the same time in AX? Beauty is just a click away. Find beauty parlor listings on Yahoo! India Local http://in.local.yahoo.com/
Re: [Axapta-Knowledge-Village] purchpurchorder report
Dear Pooja, If I can understood your problem clearly. Listen how you can solve your problem 1. Create one report using the Table PurchHeader 2. For the executable portion for (A) rules and regulation (B) footer for Agreement signature, write in the fatch method of that report, By using send method you can use to print as per your requirement. 3. All the above you have to use only Programmable Section in your repot. Try it... can solve your problem. Remember: Don't float other informations which system automatically provide in the report body.. Cheers !!! Thanks and Regards, Somnath Jana Microsoft Dynamics Technology Specialist. From: Pooja . dyna.a...@yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, 24 August, 2009 12:15:05 PM Subject: [Axapta-Knowledge-Village] purchpurchorder report Hi Sumith Im workign on the purchpurchorder report. I have header,pagefooter ..which are ok But 1.I need to print the agreement signature bottom of the pagefooter but it should be last page. 2.I need to print rules and regulations which are full page in fresh page ,may be it should be in epilog. but text is huge. how to do ?ax can not accommodate it. please can u help me on this Pooja From: Sumit Loya loya.su...@gmail. com To: Axapta-Knowledge- vill...@yahoogro ups.com Sent: Wednesday, 19 August, 2009 4:16:49 PM Subject: Re: [Axapta-Knowledge- Village] EP installation Hi, Looks like you dont have Service Pack 2 for SQL Server 2005 installed on your system. First upgrade SQL Server to SP2 and then install Reporting Extensions and Analysis Extensions. Regards, Sumit Loya On Wed, Aug 19, 2009 at 10:56 AM, nageshsinha nageshsinha@ yahoo.com wrote: Hi All, I am trying to install Reporting extensions and Analysis extensions. When I check on these checkboxes in the installation process, a message appears saying 'SQL Server 2005 reporting services SP2' and 'SQL Server 2005 Analysis services SP2'must be installed before installing Reporting extensions and Analysis extensions respectively. Please tell what exactly needs to be done in this case. I have a confusion that where to install these two services, i mean on the database server or on the machine where the application is installed. Thanks in advance Find local businesses and services in your area with Yahoo!7 Local. Get started. Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com
Re: [Axapta-Knowledge-Village] Unit of Measure conversion -- URGENT Pls. FOR POSTED TRANSACTIONS.
Hi, Khan If I am not clear to your requirement, there will be no quantitative problem and calculation will 100% correct based on the Base unit of Measure. So. be careful about base unit of measure. Stock will calculated and show as per Base Unit of Measure. Thanks and Regards, Somnath Jana Microsoft Certified Axapta Consultant. From: Khan Axapta khanaxa...@yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, 25 July, 2009 12:14:20 PM Subject: [Axapta-Knowledge-Village] Unit of Measure conversion -- URGENT Pls. FOR POSTED TRANSACTIONS. Hi Friends, I have a few Raw Materails for which i have made Purchase Invoice - Posted with Unit of Measure conversion 1 kg - 1Liters. Later we found that there is a specific gravity for these items which we need to consider while consuming these items. eg. for few Raw Materials specific gravity is 1 kg - 1.4 Liters and few Raw Materials 1 kg - 1.8 Liters I have tested a few UOM conversion for indiviual items and it is working fine on TEST MACHINE. I just want to know that if i use the UOM conversion for these items on LIVE SYSTEM will it have any Inventory effect when we make INVENTORY closing or INVENTORY recalucation for the posted transaction. Kindly advice me. Best Regards, Khan Love Cricket? Check out live scores, photos, video highlights and more.. Click here http://cricket.yahoo.com
Re: [Axapta-Knowledge-Village] Trade Agreements
Hi !! Recardo, Please go to the Microsoft Partner Source.. you will find lots of informaion in PDF format on your requirement. Also see Mibosu website... Cheers Axapta friend - Original Message From: ricardodegouveia [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, 26 March, 2008 11:28:44 PM Subject: [Axapta-Knowledge-Village] Trade Agreements Hi Everyone Does anyone know where i could find some good documentation on trade agreements in AX? Like how they work and how to set them up? Thanking you in advance Ricardo Now you can chat without downloading messenger. Go to http://in.messenger.yahoo.com/webmessengerpromo.php
Re: [Axapta-Knowledge-Village] How to find PATH for a report in menus
pls find menu items of output type... first find the which menu item from property of a report som - Original Message From: khalid_akkawi [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, 25 February, 2008 8:02:14 PM Subject: [Axapta-Knowledge-Village] How to find PATH for a report in menus Hi all, I am facing a problem in documentation for end user.. i need the fastest way to find the path of a report in manus OR MAIN MENU. it takes from me long time to reach the path using the report name .. e.g. using find on (Output) then another find on (Forms) then another find on (menus) then to open the form and try to find if it is the right report or not !! if report name is CustCollectionJour i can find it using this path \Menus\MainMenu\ Sales ledger\Inquiries\ Interest and dunning letter\Dunning letter journal but i have to document 200 reports and that is time consuming using that way ! Thanx in advance, Best regards.. Khalid Akkawi Dynamics AX Developer Bollywood, fun, friendship, sports and more. You name it, we have it on http://in.promos.yahoo.com/groups [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] How to find PATH for a report in menus
Hi... In your project area... drag the required menu... then asper your report type drag the report as per its position ... hi u will find it takes few see only Cheers Somnath Jana - Original Message From: khalid_akkawi [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, 25 February, 2008 8:02:14 PM Subject: [Axapta-Knowledge-Village] How to find PATH for a report in menus Hi all, I am facing a problem in documentation for end user... i need the fastest way to find the path of a report in manus OR MAIN MENU. it takes from me long time to reach the path using the report name ... e.g. using find on (Output) then another find on (Forms) then another find on (menus) then to open the form and try to find if it is the right report or not !! if report name is CustCollectionJour i can find it using this path \Menus\MainMenu\ Sales ledger\Inquiries\ Interest and dunning letter\Dunning letter journal but i have to document 200 reports and that is time consuming using that way ! Thanx in advance, Best regards.. Khalid Akkawi Dynamics AX Developer Save all your chat conversations. Find them online at http://in.messenger.yahoo.com/webmessengerpromo.php [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Best way to delete DEL_ fields?
In axapta it is recomended do not delete field(s) from systables it may cresh the database Thanks and Regards, Somnath Jana Microsoft Certified Axapta Consultant. - Original Message From: padmaja_wipro [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, 21 February, 2008 3:14:18 AM Subject: [Axapta-Knowledge-Village] Best way to delete DEL_ fields? Hi, I would like to delete the fields that were obsolete during upgradation. I have to delete one field that starts with DEL_ from a table. Please note that this field is at sys layer in the table.. So to delete that, do I need to delete from SQLDictonary table which is a system table? Did anyone have tried to delete DEL fields?. if so, what the best way to do this? Thanks in advance. Padma Meet people who discuss and share your passions.. Go to http://in.promos.yahoo.com/groups [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Picked qty for over-delivery?
Dear all Axapta consultants, I request to all the Axapta Consltants, don't miss use the Axapta knowledge Village zone, as a personal mailing information. Thanks and Regards, Somnath Jana 5, 50, 500, 5000 - Store N number of mails in your inbox. Go to http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Main Menu
Hi Anthony GO to the Mail Menu form open the design change the property of Resize (Yes/No) to No Cheers// Som From India - Original Message From: Anthony [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, August 2, 2007 6:35:53 PM Subject: [Axapta-Knowledge-Village] Main Menu We are on Axapta 3.0 SP 5 using KR1. I have a request to change the Main Menu so that it does not resize. For instance, if the menu is maximized and you choose the General Ledger option, the menu stays maximized in the background. I have looked through the options and I could not find anything. Any suggestions? Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mailp=summer+activities+for+kidscs=bz [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Can we Set the Axapta not to close
I think not possible... Somnath Jana - Original Message From: Yahya Yanto [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, July 5, 2007 10:41:34 AM Subject: [Axapta-Knowledge-Village] Can we Set the Axapta not to close Dear all, Can we set the axapta main windows not to close as long there is an active module windows. Example, we open the customer module, as long as the customer module still opened, i want users cannot close/exit from axapta. Thanks for your help. Best Regards. Yahya [Non-text portions of this message have been removed] Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=listsid=396545433 [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Lookup
Hi VG Use a class extends runbaseReport, write dialog addfield (x) in the dialog as to get the value of x like lookup, Please use field EDT type. Try it. Chareers... Thanks and Regards, Somnath Jana Microsoft Certified Axapta Consultant. - Original Message From: V G [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com; [EMAIL PROTECTED] Sent: Wednesday, May 16, 2007 11:16:12 PM Subject: [Axapta-Knowledge-Village] Lookup Hi In the report parameter I have to show all the unique values of a field of some table as selection. So if there are three records in that table A where in the field X has values 1,2,3,2,1 I have to show the values 1,2,3 in the parameter of the report as selection. I know this possible using lookup form. Can someone please tell me how. I can get all the five values if I write a relation on the extended datatype but I need just the unique values. Thanks [Non-text portions of this message have been removed] The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] failed to establish connection
Hi Under domain installed the AX 4.0 Ax 4 requires domain information Thanks and Regards, Somnath Jana Xenolith Microsoft Certified Axapta Consultant. Mobile: 098313 66010 - Original Message From: Navision371 371 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, May 10, 2007 7:56:44 AM Subject: RE: [Axapta-Knowledge-Village] failed to establish connection v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}..shape {behavior:url(#default#VML);}st1\:*{behavior:url(#default#ieooui) } Check access right for AOS service. - From:[EMAIL PROTECTED]:[EMAIL PROTECTED] On Behalf Of onurkiyik Sent: 星期三, 9 五月, 2007 PM 9:15 To:Axapta-Knowledge-Village@yahoogroups.com Subject:[Axapta-Knowledge-Village] failed to establish connection Hi Friends, I am having a problem with AX 4.0. I have installed AX 4.0 successfully on windows 2003 server. But i can not start the axapta because of an error failed to establishedconnection What are the possible solutions? what can i do? Please help me. With Kind Regards, Onur KIYIK. - Real people. Real questions. Real answers. Share what you know. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mailp=summer+activities+for+kidscs=bz [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Batch job setting
Hi Use BasicSetupbatch Use processing Thanks and Regards, Somnath - Original Message From: rueibin88 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, May 9, 2007 3:35:26 AM Subject: [Axapta-Knowledge-Village] Batch job setting Dear All: Is there any one know how to setup batch job to run at the last day of each month? Thanks a lot Get the free Yahoo! toolbar and rest assured with the added security of spyware protection. http://new.toolbar.yahoo.com/toolbar/features/norton/index.php [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Help required
It is better to down load the material from Microsoft site. Regards, Som - Original Message From: somanna gl [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, February 10, 2007 11:25:51 AM Subject: [Axapta-Knowledge-Village] Help required hai Plz send me some material related to axapta 3.0 thank you somanna - - --- Heres a new way to find what you're looking for - Yahoo! Answers [Non-text portions of this message have been removed] Yahoo! Music Unlimited Access over 1 million songs. http://music.yahoo.com/unlimited [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Error 1053
Hi Can any one help on this I installed Ax4.0, finally I found AOS Service not started, float an error 1053. Thanks Somnath Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Client Installation in Axapta 3
Hi !! Radw Please check and connect the ODBC. Test the ODBC Connection. Provide that you have already create SQL database within the SQL instant. If I am correct, you may miss some configuration information. Don't worry try again. Thanks and Regards, Somnath Jana Microsoft Certified Axapta Consultant. SREI (India) - Original Message From: Radwa Youssef [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Cc: [EMAIL PROTECTED] Sent: Sunday, December 24, 2006 3:09:07 AM Subject: [Axapta-Knowledge-Village] Client Installation in Axapta 3 Dear Sirs Axapta 3, SP5 We had installed the server, but the client unfortunately can not connect to the SQL instance on the server through the ODBCa Radw [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Print Management
Hi !! Both are same Thanks Somnath Jana Thanks and Regards, Somnath Jana Microsoft Certified Axapta Consultant. Mobile: 098313 66010 - Original Message From: Nihar Saraiya [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, December 7, 2006 4:32:46 PM Subject: [Axapta-Knowledge-Village] Print Management Hi Group What is the difference between Print Management form, from AP Setup Form Form Setup Print Management button AND Purchase Order Setup button Print Management. Regards Nihar Saraiya [Non-text portions of this message have been removed] Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Setup Wizard instead of import/export
Is there any way to use setup wizard to upload the abjects we add so we dont use import/export dialogs any more? No. copy *.aod and paste in you application area. OR Copy and Export your project, and finally import the aod into your application. Compile it and run it. Thanks Somnath - Original Message From: Amer Adnan [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, November 29, 2006 11:51:57 AM Subject: [Axapta-Knowledge-Village] Setup Wizard instead of import/export Hi guys, We are an MBS providers company. When we add/modify objects in Axapta, we use import and exprot processes to upload those modifications at the customer/user side. Is there any way to use setup wizard to upload the abjects we add so we dont use import/export dialogs any more? thak you :) Amer - - --- Want to start your own business? Learn how on Yahoo! Small Business. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] how to convert Real value as a string?
Hi Vijay Karthik, Don't warry. Hi please do the following Str Text; Text = numeralsToTxt(1200.56); info(Text); This will help you. Thanks and regards Somnath Jana Kolkata, India vijay karthik [EMAIL PROTECTED] wrote: hi, i need for help regarding a real value as converted into string. for example: real value : 1200.00 rs, this value is converted in to 'One Thousand Two hundred'. Is there any inbuilt function in Axapta. help me... Thanks in advance.. regards, vijaykarthik.k 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. 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. - - Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] 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] How to get the EDT Name of Table Field
Hi Ashish Singh Please go to the CustTable Field CustGroup see the properties Cheers Somnath Jana Ashish Singh [EMAIL PROTECTED] wrote: Hi, Can somebody tell me as to how to find the name of the EDT that is in use for a table field. viz. i want to know the name of the EDT that have been used in CustGroup field of CustTable which is CustGroupId. Please point as to which class i can make use of to get this info programatically. Please help me as soon as possible. Have a nice day. Ashish Singh [Non-text portions of this message have been removed] 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. - - 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. 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] lookup form field problem
Hi Vijay In Table field group use AutolookUP and add two fields into it. and see what happened. Thanks Somnath Jana vk [EMAIL PROTECTED] wrote: Hi, I create the lookup form with LedgerJournalTrans table. it has 2 fields ( accountnum accountname).The account number is coming from LedgerJournal trans table. the account name field is a string edit field(externally i have created). the account name field mapped to the datamethod() regarding the account number.while i am running the form the account name doesn't come properly how can i get properly.? thanks in advance... 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. 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. - - 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. 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] Urgent Opening Balance Uplode!!!!!
Hi Shanmug !! The tips may help you, follow the steps 1. Create a temptable according to the value of customer/vendor which fields u r going to import. 2. Create a defination group for importing the data, type should be Custom and take the 'Name of table as u create just now. 3. Import the data into that temporary table. 4. Create a command button into the journal form and write codes on its and click button 5. See the data comes to your journal. Note in this case it does not require the CSV format just .xls file. Thanks Somnath Jana shanmug P [EMAIL PROTECTED] wrote: Hi , I have to import the Opening Balance for the Vendors and customers, for vendors i tried in Vendor Invoice Jn, by template and CSV file. In the earlier case the template is not creating for LedgerjournalTrans in the later case its getting imported but datas are not visible in the form. It will be really useful if some one give some tips. Regards Shanmugavel. - 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. 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 with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] 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] Movement journal
Hi Radek If I understood correct, it may occure due to non-availability of stock in that perticular warehouse. Hence, it will create another entry as per default warehouse. Regards Somnath Jana (India) Radek Krawiecki [EMAIL PROTECTED] wrote: Hi group, one of users of Axapta 3.0 SP3 post movement journal. It was inwentory issue 10pcs of item with specyfic serialId and warehouseId - in one journal line. In InventTransTable system create 2 transaction lines, one with 1pcs and another with 9pcs. Both have line have the same InventTransId and only InventDimFixed, and qty, costAmount fields was different. First line have inventDimFixed = 1, and second > Could anyone tell me what means value 3 in inventDimFixed field? We use only Serial Number, Warehouse and 4 financial dimensions. In what situation system works the way I described above? I try repeat such situation and create several journals in test environment, but I always have only 1 line in InventTransTable. Thanks in advance. Radek Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links - Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1cent;/min. [Non-text portions of this message have been removed] 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] Re: Display of activity in Axapta status bar
Hi This is Somnath Jana If you wish to display any information in the Axapta status bar, please do the following 1. Go to Tools (at the menu bar) 2. Click on Option (at the end option ellipes) May got your answer. Thanks Somnath Jana Salt Lake, Kolkata India mlefoa [EMAIL PROTECTED] wrote: --- In Axapta-Knowledge-Village@yahoogroups.com, opussolution_pk [EMAIL PROTECTED] wrote: If you are running 3tier the symbol should always look like a server- icon. Always when this is animated that means that either the client is communicating with the AOS or the client is calculating something. The other icon (a PC with screen and a data base can and an arrow between) is animated when Axapta communicates with the DB. This icon should only be used in a 2tier envoirment. Best regards Patrick I see the same icons no matter if I'm running 2-tier og 3-tier. Isn't that normal? Currently we hope to solve the performance problems by upgrading to KR1 and SQL 2005. Thanks for all answers. Best regards, Morten 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. - - Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] 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] Doc on doing openning balances
Hi James Can you explain in detail ? Somnath James Flavell [EMAIL PROTECTED] wrote: Hi Can any recall there was a doc by MS on how to setup new company and do the openning balances. I am not sure was it for XAL or Axapta... Can anyone let me know if they remember or have such a doc (for XAL or Axapta makes no difference). Thanks James [Non-text portions of this message have been removed] 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! Mail goes everywhere you do. Get it on your phone. [Non-text portions of this message have been removed] 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] Questions For Posting Layers
Hi ! Leo Please see the information Posting layer in transactions Posting layer for fixed asset transactions utilizes the functionality of General ledger to post into three different layers. Three posting layers can be used: Current, Operations, and Tax. Current is the default layer and is used like Operations for entry of transactions, which are a part of the periodic financial reporting. The layer Tax is meant to be used for transactions, which are not a part of the external or internal reporting, but for recording of special tax transactions, for example, as tax depreciation for fixed assets. For the same fixed asset, tax depreciation often differs from the depreciation, which is calculated for accounting purposes. For tax purposes, companies usually wish to calculate and post the highest possible depreciation in order to reduce their tax payments as much as possible. For accounting purposes, there will be a different basis for depreciation calculation because the company has to follow accounting laws and accounting standards, which in many countries, are based on principles different from the tax rules. The depreciation and the fixed asset value for accounting purposes and for tax purposes will very often be different even for the same fixed asset and the same period. Therefore, both have to be calculated, but only accounting amounts have to be included into accounting reporting and only tax amounts into tax reporting. One of the options to achieve this is to set up the posting layer for value models, used for accounting purposes as Current or Operations, and the posting layer for value models used for tax purposes as Tax. A different solution could be to set up special ledger accounts for tax transactions and place those accounts at the end of the chart of accounts with account numbers, which clearly differ from account numbers used for usual accounting transactions. As for posting of transactions with the posting layer Current, Operations, and Tax, it is important to emphasize that normally only one posting layer can be posted in one journal. The reason is that each journal name is defined with a posting layer. It is not possible to alter the posting layer for journal lines. Thus, for each posting layer, at least one journal name has to be created. This is done in General ledger, Setup, Journals, Journal names, tab page General, field Posting layer. When a journal is used for transaction entry, the posting layer can be viewed on tab page General, but not altered. Therefore, each journal will only contain transactions for the same posting layer. The only exceptions are transactions posted with setup of derived value models. In this case the derived value model can be of a different posting layer than the primary value model. This is not due to the journal, but to the special functionality of derived value models. Thanks Somnath Jana India leolql2003 [EMAIL PROTECTED] wrote: Hi, all, In Axapta 3.0, each account has three posting layers. They are Current, Operations and Tax. Meanwhile, I can find 6 fields corresponding to these 3 layers in the table LedgerBalancesTrans. They are DebitMST, CreditMST, DebitOPRMST, CreditOPRMST, DebitTaxMST and CreditTaxMST. When I get the account balance in the form chart of accounts, Axapta will return different balance for different posting layer according to the balance setup in Genernal ledger/Chart of Accounts/Balance/Setup. And I am confused with the account balance for the 3 posting layers. So I raised 4 questions about it as follow and hope someone can give me some directions. Thanks in advance. 1. What are the 3 posting layers (Current, Operations and Tax) used for? What is the purpose of the posting layers concept in Axapta? 2. Which layer will be the amount posted to, when posting an invoice in sales order or purchase order. 3. What layers account balance will be printed out when I print out a finacial statement and trial balance report? 4¡¢Can I increass or decrease one or more posting layers in the system myself? Best Regards Leo 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! Messenger with Voice. Call regular phones from your PC and save big. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS
Re: [Axapta-Knowledge-Village] Re: Questions For Posting Layers
Hi Leo Find my reply in blue. Regards, Somnath Jana hi, Somnath, Many thanks for your reply. But I am still confused with the 3 questions of posting layers as follow. 1. Which layer will be the amount posted to, when posting an invoice in sales order or purchase order. Current layer 2. What layers account balance will be printed out when I print out a finacial statement and trial balance report? Current layer 3¡¢Can I increass or decrease one or more posting layers in the system myself? No. not possible (This is an Axapta sysLevel functionality) Regards Leo 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! Messenger with Voice. Call regular phones from your PC and save big. [Non-text portions of this message have been removed] 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] Value ## is not found in the Map during Excel Import
Hi Jack Koh You may forgot me. I am Somnath Jana. Please specify the XLS file into 'Import file name' field in Table setup form. Thats a mistake... Best regards. Somnath Jana Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi all, I tried to preview the data under Data Export / Import using Excel Import, the following message come out Value ## is not found in the Map However i still manage to import the data into Axapta. Can someone tell me what's going on? Best Regards, Jack Koh - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] 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. - - Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1cent;/min. [Non-text portions of this message have been removed] 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] Axapta beginners
Hi Dipankar Are u in Axapta ? Yes, Microsoft publised a number of books of Axapta, and it's cost above 6000/-. You can order through internet to Microsoft. Thanks Somnath Jana Kolkata India Dipankar Paul [EMAIL PROTECTED] wrote: Hi..i am very much new to this tech AXAPTA, only 10 days over.i already studied the developers guide that comes up with axapta.but i m geting tough in implementing with actual coding like which method need to write for which application etc etc which is not given in details in the guide,and exploring the DEMO project takes lot of time as i dont have any prior knowledge and dont have any materials too.Here i am requesting u if u have any Online materials or any book that is available in market, then pls suggest me.I m a member of Axapta-knowledge-village and got ur Email id from there only. Thanks and Best Regards, Dipankar. Bangalore, India. [Non-text portions of this message have been removed] 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. - - Get amazing travel prices for air and hotel in one click on Yahoo! FareChase [Non-text portions of this message have been removed] 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] User ID's switching to DAT on log off / Back on
Hi Brandon If i am sure, please change in the Company in Axapta Configuration Utility as per your company (three digited code) in Company Account Code, you see the company automatically changed as per your requirement. Thankx, Somnath Jana (India) Brandon George [EMAIL PROTECTED] wrote: Hello All, I have a very strange issue that I am facing. Right now, we have a case where randomly when users log off of Ax and then back into it, their default company has been changed to DAT. The strange thing is, we are 100% for sure we had them in 310 as they were just working in 310. I have not been able to reproduce this, so I am not for sure what is causing this. I am about to turn on database logging so that I can see who and when this is happening. Has anyone ran across this before? We are on Ax 3.0 SP3, To Increase IEM v1.0.1 SP1, NA DIS Layer for SP3. Please let me know if anyone has ever ran into this, and what was the fix? Thanks, Brandon 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! Messenger with Voice. PC-to-Phone calls for ridiculously low rates. [Non-text portions of this message have been removed] 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] Validation of date format
Hi sherin francis If I am sure, what I understood... You have to write a class or a global function for your specific requirement by useing Date2Str(date,321,2,2,2,2,2), here 321 - indicate the date formating. (Year,month,day). Here 2,2), the first 2 indicate the '-' parameter. as you require -MM-DD I think this may help you. Thankx Somnath Jana (India) sherin francis [EMAIL PROTECTED] wrote: Hi group, Is there any function which checks the format of the date field...? Suppose i have a date field which i want the user to enter only in this manner -MM-DD Incase the user enters it in a different manner ... say.. DD-MM- , I should be able to validate that date field and issue an error if it isn't in the required format. Any help will be greatly appreciated. Regards, Sherin - Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] 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. - __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] 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] Question: Sending Reports By E-mail
Hi atilla adnan sahin !! On any report, you see a quary form appears, from that form click the 'Option' button and select e-mail recipient and select message format. and click ok, it will automatically open the mail to option after generating the report, and the report will automatically be in attached document. Thanks Somnath Jana (India) atilla adnan sahin [EMAIL PROTECTED] wrote: Hi; I have a problem. I want Axapta to send reports to users by e-mail when they want to have a report from Axpata. Can I make this on Axapta? Thanks for your help. Adnan - 24 FIFA World Cup tickets to be won with Yahoo! Mail. Learn more [Non-text portions of this message have been removed] 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. - __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] 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.
Re: [Axapta-Knowledge-Village] Inventory Dimensions in PO
Hi in report BankDepositByCustomer clue: public void footer(ReportSection _footerSection, tableId _tableId, fieldId _fieldId) { int Ctrl; ; if (_FooterSection _footerSection.control(fieldnum(CustTrans,AmountCur),Tablenum(CustTrans))) { if (_tableid == tablenum(CustTrans) _FieldId == fieldnum(CustTrans,CurrencyCode)) _footerSection.control(fieldnum(CustTrans,AmountCur),Tablenum(CustTrans)).show(); else _footerSection.control(fieldnum(CustTrans,AmountCur),Tablenum(CustTrans)).hide(); } super(_footerSection, _tableId, _fieldId); } Yes u can hide the column Snj Akshay [EMAIL PROTECTED] wrote: Hi, I wanted to know , whether there is some setting in Axapta with the help of which i can hide or unhide the Item dimensions showing up in the Purchase Order Report. The reason why i ask, is that we get 2 different kinds of report outputs in 2 different machines with the same settings for AP and for Inventory. In one of them i get the dimension columns irrespective of the fact that whether dimensions are assigned or not, while in the other one the dimension columns just dont appear. Could someone throw some light on this. Thanks Akshay [Non-text portions of this message have been removed] 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. - - Celebrate Earth Day everyday! Discover 10 things you can do to help slow climate change. Yahoo! Earth Day [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.
Re: [Axapta-Knowledge-Village] Document Handling - Create Excel worksheet via COM
Dear Koh, I don't think, Axapta does not support u from document management for your specific purpose, as u have not any option to select the sales order for sales line(s). Here the purpose is different in document management. I don't know what is your actual purpose. I am confident, that from document management, u can't fullfil your requirement, what i understood is. I think its better to use export/import. That's your choise. Thanks and regards Somnath Jana Koh Meng Chiat [EMAIL PROTECTED] wrote: Dear Somnath, Actually i'm now making use of the Document Handling function under Basic module Setup Document Management Document Type whereby i can define the attachment type. After i've define the document type and i open the Sales Order and click on document handling button and select the document type i've defined earlier, the sales header is able to transferred to the Excel, however, only one salesline can be transferred even though there are multiple saleslines in my order. Any feedback is much appreciated. Best Regards, Jack Koh somnath jana [EMAIL PROTECTED] wrote: Hi ! Assume that u may select only sales line table on data definition group and have type standard. Use crioterion on table setup form from criteria button give the sales order no. save it and export it. Thanks... Snj Koh Meng Chiat [EMAIL PROTECTED] wrote: Dear all, I've set up the a document type which make use of the job Create Excel worksheet via COM which is able to transfer data from SalesTable and Salesline to the Excel template. My query is, now my Salesline has multiple lines and when i use the document handling function the system is only able to transfer the last line of the Salesline table ( ONE line only) to the Excel template, not all the Saleslines. Can anyone shed some lights on it? Could someone also explain to me the hard return in the Document Type setup means? What is that index used for? Thank you. Best Regards, Jack Koh - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [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! Messenger with Voice. Call regular phones from your PC and save big. [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 with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] 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.
Re: [Axapta-Knowledge-Village] Document Handling - Create Excel worksheet via COM
Hi ! Assume that u may select only sales line table on data definition group and have type standard. Use crioterion on table setup form from criteria button give the sales order no. save it and export it. Thanks... Snj Koh Meng Chiat [EMAIL PROTECTED] wrote: Dear all, I've set up the a document type which make use of the job Create Excel worksheet via COM which is able to transfer data from SalesTable and Salesline to the Excel template. My query is, now my Salesline has multiple lines and when i use the document handling function the system is only able to transfer the last line of the Salesline table ( ONE line only) to the Excel template, not all the Saleslines. Can anyone shed some lights on it? Could someone also explain to me the hard return in the Document Type setup means? What is that index used for? Thank you. Best Regards, Jack Koh - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [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! Messenger with Voice. Call regular phones from your PC and save big. [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 * 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] data archive through axapta !!!!
Hi By using recurrence, starting date and end date, it is possible for taking a backup of three years and by chosing the recurring pattern as year. Other as follows Thanks Snj Suresh Gattapur [EMAIL PROTECTED] wrote: hi U can do as follows create new company and new Data Base .. Copy / move only 3 year ( Date range) data to new Database from the Existing database. regards suresh Anil Ozay [EMAIL PROTECTED] wrote: Hi Sam, Axapta doesn't have this property.. May be in the future.. Anil Ozay MBSCP, MCP Software Engineer, Axapta Specialist Anadolu Group (www.bilisimanadolu.com) Mob: 0505 5033786 On 4/16/06, sam axapta [EMAIL PROTECTED] wrote: hi all, in axapta any feature where i directly sql data archive. or if not there how can i archive data to sql. example: in axapta/database have last 10 year data. so now the problem is database performance down and data volume high . i need only last 3 year data in axapta/database . and rest year data i want to archive through axapta (if feature are not there ) then sql and if in future require archive data i'll call again. how could i do thanks sam - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [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-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/. -- -- [Non-text portions of this message have been removed] 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! Messenger with Voice. Call regular phones from your PC and save big. [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. - - Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice. [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 * 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] Formatting
Hi !!! Please create a new setup (custom) in the printer according to the paper size, this not the problem of axapta. As you know for cheque printing the printer has to set accordingly Thanks Somnath Jana Akshay [EMAIL PROTECTED] wrote: Hi All, I have a problem with the SalesInvoice report. Could anybody tell me, whether the height of the body BodyCustInvoiceTrans( SectionGroup:CustInvoiceJourBodyCustInvoiceJourSectionGroup:CustInvoiceTransBodyCustInvoiceTrans) in the SalesInvoice report is dynamically fixed. This is the same body where the list of all items invoiced is printed out one below the other. Even when i set the height of this body to a minimum in the report designer, it still manages to get a fixed height in the actual paper print. I have tried tracing the execution of the Invoice, but still haven't located anything. If this height is dynamically set, i would like to know in which class/method its happening and how i can channge that. Thanks Akshay [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. - __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] 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] Warning: Bank account must have check method 'Fixed'
Hi Khurram Z. Uz zaman Don't worry. Please do to the following 1. Goto bank card, click setup button, 2. click check layout, 3. 'one new form will be open, 4. in general tab page see check number method, use free your problem would be solved. Thanks and cheers !!! Somnath Jana (India) Khurram Z. Uz zaman [EMAIL PROTECTED] wrote: Hello Everyone, I am really new to Axapta and to this group, so excuse me if my question is trivial. In the Bank Management module, I am trying to create check for a particular bank, and I get this: Warning: Bank account must have check method 'Fixed' I tried looking at all the settings in Bank account creation but could not find anything matching to that. Can anyone please help me on that? Secondly, while browsing through trade and logistics modules, I could not find any interface to generate 'Requisitions'. Is it the case that Axapta 3.0 does not support item requisitions? Thanks Cheers! Khurram [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! Messenger with Voice. Call regular phones from your PC and save big. [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 * 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] Warning: Bank account must have check method 'Fixed'
Hi regred my prevoius mail Check number method select as Fixed Thanks Somnath Khurram Z. Uz zaman [EMAIL PROTECTED] wrote: Hello Everyone, I am really new to Axapta and to this group, so excuse me if my question is trivial. In the Bank Management module, I am trying to create check for a particular bank, and I get this: Warning: Bank account must have check method 'Fixed' I tried looking at all the settings in Bank account creation but could not find anything matching to that. Can anyone please help me on that? Secondly, while browsing through trade and logistics modules, I could not find any interface to generate 'Requisitions'. Is it the case that Axapta 3.0 does not support item requisitions? Thanks Cheers! Khurram [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 with Voice. PC-to-Phone calls for ridiculously low 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 * 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] AtlasXl users
Please do not open client on server. May be a mistake... Somnath Yavuz YILDIZ [EMAIL PROTECTED] wrote: We use Terminal Server. All clients can login four at same time. --- axaptos [EMAIL PROTECTED] wrote: All, Our client buys 2 license users, standard edition. But only 1 user can login. I have restarted the AOS, delete the axdat.udb but still only 1 user can login at a time. There is a warning that the users have exceeded the purchased rights. Axapta licence users are more than enough, any idea? Regards, John Yavuz YILDIZ ERP Developer Star Group Glass Processing __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.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. - - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [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 * 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 order problem
I think your problem is to display only the open purchase order. If yes please follow the step 1. go to the purchase order form 2. click the status field 3 right click the and the select filter You will see the purchase order now show you only Open order wise lise Thanks Somnath (OSL) vk [EMAIL PROTECTED] wrote: hi, how to create the lookup for PO order with the status of open order only? i had tried by using EDT, it means create the EDT( outstandingPO) and set the realtion outstandingPO == PurchTable.purchId (in Normal ) 1 == purchtable.purchstatus (in Related field fixed). it displays the purchase order with the status of Open order only. my query is, if i select the value from lookup, the purch status(Openorder ) to be returned to the field.but i want purchase number. how to do? any one help me... Thanks in advance... 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. - - New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. [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 * 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] Problem on InventDimId
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. I am confident sure that Profit/Loss journal is for Opening Entries of Inventory. Hi Girish I solved my inventory dim problem.. Thanks for coopreation Thanks Somnath Jana Girish Bhatkal [EMAIL PROTECTED] wrote: 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. 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! Messenger with Voice. Call regular phones from your PC and save big. [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 * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group
Re: [Axapta-Knowledge-Village] Problem on InventDimId
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. I am confident and sure that Profit/Loss journal is for Opening Entries of Inventory. Hi Girish I solved my inventory dim problem.. Thanks for coopreation Thanks Somnath Jana Girish Bhatkal [EMAIL PROTECTED] wrote: 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. 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. - - 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 * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group
Re: [Axapta-Knowledge-Village] Query on inserting data from more tables
Hi !! Hi gopala krishna !! Answer: Select itemid from each table and collect data accordingly... Use find method() Thanks Somnath Jana gopala krishna [EMAIL PROTECTED] wrote: hi every one, I am trying to get the data from two tables that i want to insert in another table. For example i have created table2(itemid, color, size, warehouse) now i want to get the data from InventTable, InventColor,InventSize, InventLocation and insert the same into new table. How can i do that. - Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [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 * 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 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 * 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/