[Axapta-Knowledge-Village] Import Records from Excel to Axapta
Dear Sirs What are the steps to import the opening balances for GL , A/P Fixed Assets from Excel to Axapta??? Radwa _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of bhasker vooradi Sent: Thursday, December 14, 2006 10:57 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Import Records from Excel to Axapta Hi Ashish Thank you very much for reply. I followed the same steps given by u, but at the end it is giving error same as below. The error document is attached to understand the exact error message, please go thruough it. Regards Bhasker Srivastava Ashish ashishdifferent@ mailto:ashishdifferent%40gmail.com gmail.com wrote: Hi Bhasker, For importing data in Item Master, you need to populate data in InventTable, InventTableModule InventItemLocation Tables. Only importing data in InventTable will not work. So delete records imported in InventTable and try importing for these 3 tables. Please let me know, what error you are getting for LedgerTable? Regards, Ashish Srivastava On 12/12/06, bhaskerv1 [EMAIL PROTECTED] mailto:bhaskerv1%40yahoo.co.in co.in wrote: Hi, Iam Bhasker, New to the group. Iam getting error messages at the time of importing records from Excel to Axapta as Item number already existing, it cannot be created. This problem is related to the tables LedgerTable InventTable. After importing the data from Excel to Axapta in the given format, the Data is not appearing in the respective form but where in it is appearing in the table( which we can see through table browser). So can anyone help me how to upload the data from ExcelFile to Axapata Regards Bhasker [Non-text portions of this message have been removed] Regards, Bhasker Vooradi, Sr. Software Engineer - MS Dynamics Axapta Mobile: 09892318466 - Find out what India is talking about on - Yahoo! Answers India Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
Hi Harry, I'm running in ax 3.0 sp 5. After invoice the first sales order there isn't any record on that table (InventSumtts) for the item. There are only two records on inventSum table. The net requirement form for that item shows two lines with on hand, one with positive quantity and other with negative quantity. Do you know what is happening? Regards Ricardo Cortes Harry Deshpande [EMAIL PROTECTED] escribió: hi Which version are you running? You will have to do some investigation after you invoice the first sales order, what are the records in InventSumLogtts table? regards harry From: Axapta-Knowledge-Village@yahoogroups.com [EMAIL PROTECTED] On Behalf Of Ricardo Cortés [EMAIL PROTECTED] Sent: Friday, December 15, 2006 10:53 PM To: foro Subject: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi all, I've been having troubles with the explosion at the sales line, it is showing that i have inventory on hand when there isn't. The scenario to reproduce teh problem is: Create a sales order for an item without inventory on hand Run the explosion from the sales line The explosion form will show you a planned purchased order, this is correct. Firm the planned purchased order, receive the item and invoice the sales order. Create a new sales order for the same item (the item don't have inventory) Run the explosion from the sales line again The explosion form will show that the item has inventory onhand when the reality there isn't. If you check the net requirement thru the sales order you can see that axapta is showing two lines in on hand one with a positive quantity and other with neative. So, like axapta is seeing lines with on hand for this item is not calculating the requirement and is not plannig the purchase order. I know that Axapta in the explosion only take into account a few transaction for the item, but in this case it seems that is not settling the previous transaction and that is why the result from the explosion is wrong. Only running the Master planning for all the items in the regeneration mode fix the problem. Does any one have an idea of what is happening or if this is a bug? Thanks in advance Ricardo Cortes __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.yahoo.com.mx/ [Non-text portions of this message have been removed] - Do You Yahoo!? La mejor conexión a Internet y 2GB extra a tu correo por $100 al mes. http://net.yahoo.com.mx [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0
You can use the runas command to change the user Confidentiality Notice: This e-mail contains confidential and/or privileged information and is intended to be read only by the person or authorized representative of the organization to whom it is addressed. If you are neither of these persons, you have received this e-mail in error. Please do not print, copy, re-transmit, disseminate or otherwise use the information, all of which are prohibited. Please immediately notify the sender by return e-mail or by telephone at (303) 593-1246 that you have received this communication in error and delete this e-mail from your system. Thank you. MBS Dynamics AX Master John T. Lindsay Micro Sciences 303 593-1246 720 982-4620 _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andreas Rudischhauser Sent: Saturday, December 16, 2006 4:48 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: AW: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0 Please contact Mr. Schuster on schuster(AT)back2.biz. Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Im Auftrag von Hardi Gesendet: Samstag, 16. Dezember 2006 00:52 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Betreff: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0 As Ax40 is integrated with active directory, I think what is required is to prompt user to re-enter login/password when application started. This is something being asked too from my customer. Thanks Hardi --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village%40yahoogroups.com , Jake [EMAIL PROTECTED] wrote: Hi Andreas - Do you have any info on how this is being done? Are you doing a second Active Directory login? Thanks, Jake http://axaptasource http://axaptasource.com .com --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village%40yahoogroups.com , Andreas Rudischhauser Andreas.Rudischhauser@ wrote: We're currently in development. I will post the link here in a few days Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village%40yahoogroups.com ] Im Auftrag von Agus Riyadi Gesendet: Donnerstag, 14. Dezember 2006 03:14 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village%40yahoogroups.com Betreff: [Axapta-Knowledge-Village] Ax 4.0 login screen as 3.0 Hi All, Is there any setting or workaround so that user can have a login screen in Axapta 4.0 like in 3.0 ? Thanks, Agus [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!
Hi It looks like the problem is with InventSumLogTTS and not with master planning. Check the records in inventsumlogtts after each step (the steps are slightly different) i.e 1. create sales order 2. create purchase order 3. receive item 4. post sales Ideally you should have records created in InventSumLogTTS after each step. Please also try this on standard installation. regards harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo Cortés Sent: 18 December 2006 02:00 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi Harry, I'm running in ax 3.0 sp 5. After invoice the first sales order there isn't any record on that table (InventSumtts) for the item. There are only two records on inventSum table. The net requirement form for that item shows two lines with on hand, one with positive quantity and other with negative quantity. Do you know what is happening? Regards Ricardo Cortes Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió: hi Which version are you running? You will have to do some investigation after you invoice the first sales order, what are the records in InventSumLogtts table? regards harry From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo Cortés [EMAIL PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mx] Sent: Friday, December 15, 2006 10:53 PM To: foro Subject: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line Hi all, I've been having troubles with the explosion at the sales line, it is showing that i have inventory on hand when there isn't. The scenario to reproduce teh problem is: Create a sales order for an item without inventory on hand Run the explosion from the sales line The explosion form will show you a planned purchased order, this is correct. Firm the planned purchased order, receive the item and invoice the sales order. Create a new sales order for the same item (the item don't have inventory) Run the explosion from the sales line again The explosion form will show that the item has inventory onhand when the reality there isn't. If you check the net requirement thru the sales order you can see that axapta is showing two lines in on hand one with a positive quantity and other with neative. So, like axapta is seeing lines with on hand for this item is not calculating the requirement and is not plannig the purchase order. I know that Axapta in the explosion only take into account a few transaction for the item, but in this case it seems that is not settling the previous transaction and that is why the result from the explosion is wrong. Only running the Master planning for all the items in the regeneration mode fix the problem. Does any one have an idea of what is happening or if this is a bug? Thanks in advance Ricardo Cortes __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.yahoo.com.mx/ [Non-text portions of this message have been removed] - Do You Yahoo!? La mejor conexión a Internet y 2GB extra a tu correo por $100 al mes. http://net.yahoo.com.mx [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]