[Axapta-Knowledge-Village] importing data for smmQuotationLines from excel
Hi group, Getting problem when Importing data (smmQuotationLines table) from excel sheet I want to insert records in smmQuotationTable and smmQuotationLine tables from excel sheet. I am able to insert record for smmQuotationTable. But getting problem while inserting records for smmQuotationLine. I am trying to insert records with only mandatory fields. It seems smmQuotationLine table required inventTransID,inventDimID and some dimension related fields. But these fields I am not able to insert.Its giving error The value 48 is not found in the map. I am getting other error like: Currency code 'empty' with triangulation No after the 5/11/2006 has no exchange rate. Note:We are handling with USD only. Please suggest me something on this, there is very urgent requirement for this. Any kind of help is appreciable. Thanks, Aryan 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.
[Axapta-Knowledge-Village] Re: Axapta Security Precedent
Hello all, There's one exception to what Hans wrote. If you use Axapta's record level security feature, a restriction via one group will override access granted via other groups. This is because Axapta RLS is basically a filter, rather than an extension of normal security. --- In Axapta-Knowledge-Village@yahoogroups.com, Hans-Walter Bous [EMAIL PROTECTED] wrote: Hi, user goup rights are cumulative. In your example: access to table is perimtted. But consider that you have a) function rights (is a user enabled to use menu item e.g. CustTable and in what way) b) table rights So if you set up table right full access and menu item right read only then the user has only the possibility to read (as you don't give him rights in AOS where you can add records using the table browser). John Ilan Gluzman [EMAIL PROTECTED] schrieb: Dear Community, In Windows, permission groups override each other to the most restrictive setting. Do you know how Axapta Security Groups override each other? Another words, if one group permits access to a table, and another group does not permit access to a table, does a user that belongs to both groups see the table? Thanks, Ilan 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. - H.W. Bous - Jetzt mit Yahoo! Messenger Tickets zur FIFA WM 2006 gewinnen. [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.
[Axapta-Knowledge-Village] Re: Cost calculation crisis
Hi, Can Subbu or anyone who received additional information about inventory close-generated cost adjustments please e-mail me? Thanks, Joe --- In Axapta-Knowledge-Village@yahoogroups.com, DIEGO MARIANO GAGLIANO [EMAIL PROTECTED] wrote: Hi James, Long time a go I have the same problem with couple customers. This problem can be produced by the Item cost calculation in production orders, when the Item not have any specific cost attach to. If you want, please send me an email to me, to discuss if your problem is the same, and I send you a Fix. Best regards Diego Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi James, Sorry for my late reply as I was swamped with TARGIT developments. Anyway, I have sent you an private email to start with and if you have any specific questions, please let me know so that I can get you. Have a great day. Take care, Subbu James Flavell [EMAIL PROTECTED] wrote: Hi Subbu, Would be interested to know what you found with MS as we are using SP4 and have serious closing problems where production costing is involved. We have submitted it to MBS who have escalated it but would really like any other input. Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi Sent: 28 February 2006 08:16 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Cost calculation crisis Hi there, We contacted MS when one of the item got costed in hundreds of millions. I I am not directly involved as I was a silent wtacher for that painfull effort that went for 3 months sent you a personal email on this... Please let me know if you need any specific info. Thanks Regards, subbu [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thanks subbu_oh! Unfortunately, the HF30SP3_058 - Axapta IC Rollup for 3.0 SP3 patch is already in. It does not solve all of our problems - only a small portion. Have you run the close successfully? Thanks. -- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Mkye, 1. which verson of axapta you are running? 2. if you are running Ax3.0 , did you put HF30SP3_058 - Axapta IC Rollup for 3.0 SP3 HF30SP2_034 - Axapta IC Rollup for 3.0 SP2 I think your problem should be solved if you put that hot fix. Happy Days and good Luck. Thanks Regards, subbu [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: We are running Axapta with standard costing selected and are having serious issues with the Inventory close process. The system seems to be making a lot more adjustments than what we want to see and calculating costs at incorrect amounts. Is anyone out there running inventory close - and for standard costs? __ __ Try Juno Platinum for Free! Then, only $9.95/month! Unlimited Internet Access with 1GB of Email Storage. Visit http://www.juno.com/value to sign up today! 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 Bring photos to life! New PhotoMail makes sharing a breeze. [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 __ __ Try Juno Platinum for Free! Then, only $9.95/month! Unlimited Internet Access with 1GB of Email Storage. Visit http://www.juno.com/value to sign up today! 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 Bring photos to life! New PhotoMail makes sharing a breeze. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit
Re: [Axapta-Knowledge-Village] Cubes
Akshay, you can try to join client with your domain? Rick Akshay [EMAIL PROTECTED] wrote: Hi People, In order to achieve a consolidated report for AR, AP and Inventory, in a Multi-Company environment, we need data across all the units when i log into Axapta (Please refer my previous Support Call). This however cannot be achieved from within Axapta as the AOT allows me to see only the data of the company logged into. As a result we have developed a Data Cube in SQL Olap Server which selects all the data and gives me the info required by the customer. I can register the cube in Business Analysis and see the same. BUT HOWEVER, I CAN SEE THE DATA PROVIDED I'M SITTING AT THE SERVER ITSELF, I.E. ONLY IN A 2-TIER ARCHITECHTURE. I WOULD LIKE TO VIEW THE SAME EVEN AS A CLIENT IN A 3-TIER MODE. Attached is a screen shot of the error occurring when i try to view the cube as a client through an AOS. Has somebody tried doing this. Please advice ASAP 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. - - 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] Digest Number 787
Akshay, Have you evaluated any 3rd party applications for data analysis of your cubes (e.g., Targit)? It might be what you're looking for . . . Best regards, Bill Curtis, PMP Message 4 From: Rick [EMAIL PROTECTED] Date: Sat May 13, 2006 8:07am(PDT) Subject: Re: Cubes Akshay, you can try to join client with your domain? Rick Akshay [EMAIL PROTECTED] wrote: Hi People, In order to achieve a consolidated report for AR, AP and Inventory, in a Multi-Company environment, we need data across all the units when i log into Axapta (Please refer my previous Support Call). This however cannot be achieved from within Axapta as the AOT allows me to see only the data of the company logged into. As a result we have developed a Data Cube in SQL Olap Server which selects all the data and gives me the info required by the customer. I can register the cube in Business Analysis and see the same. BUT HOWEVER, I CAN SEE THE DATA PROVIDED I'M SITTING AT THE SERVER ITSELF, I.E. ONLY IN A 2-TIER ARCHITECHTURE. I WOULD LIKE TO VIEW THE SAME EVEN AS A CLIENT IN A 3-TIER MODE. Attached is a screen shot of the error occurring when i try to view the cube as a client through an AOS. Has somebody tried doing this. Please advice ASAP 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. - - 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. Yahoo! Groups Links http://groups.yahoo.com/group/Axapta-Knowledge-Village/ _ avast! http://www.avast.com Antivirus: Inbound message clean. Virus Database (VPS): 0619-3, 05/12/2006 Tested on: 5/13/2006 1:23:56 PM avast! is copyright (c) 2000-2006 ALWIL Software. _ avast! Antivirus http://www.avast.com : Outbound message clean. Virus Database (VPS): 0619-3, 05/12/2006 Tested on: 5/13/2006 2:13:39 PM avast! is copyright (c) 2000-2006 ALWIL Software. [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] Digest Number 787
Try using Cognos BI Data Manager to extract this data, it is possible to achieve what you what, SK _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bill Curtis Sent: Sunday, 14 May 2006 5:14 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Digest Number 787 Akshay, Have you evaluated any 3rd party applications for data analysis of your cubes (e.g., Targit)? It might be what you're looking for . . . Best regards, Bill Curtis, PMP Message 4 From: Rick [EMAIL PROTECTED] Date: Sat May 13, 2006 8:07am(PDT) Subject: Re: Cubes Akshay, you can try to join client with your domain? Rick Akshay [EMAIL PROTECTED] wrote: Hi People, In order to achieve a consolidated report for AR, AP and Inventory, in a Multi-Company environment, we need data across all the units when i log into Axapta (Please refer my previous Support Call). This however cannot be achieved from within Axapta as the AOT allows me to see only the data of the company logged into. As a result we have developed a Data Cube in SQL Olap Server which selects all the data and gives me the info required by the customer. I can register the cube in Business Analysis and see the same. BUT HOWEVER, I CAN SEE THE DATA PROVIDED I'M SITTING AT THE SERVER ITSELF, I.E. ONLY IN A 2-TIER ARCHITECHTURE. I WOULD LIKE TO VIEW THE SAME EVEN AS A CLIENT IN A 3-TIER MODE. Attached is a screen shot of the error occurring when i try to view the cube as a client through an AOS. Has somebody tried doing this. Please advice ASAP 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. - - 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. Yahoo! Groups Links http://groups.yahoo.com/group/Axapta-Knowledge-Village/ _ avast! http://www.avast.com Antivirus: Inbound message clean. Virus Database (VPS): 0619-3, 05/12/2006 Tested on: 5/13/2006 1:23:56 PM avast! is copyright (c) 2000-2006 ALWIL Software. _ avast! Antivirus http://www.avast.com : Outbound message clean. Virus Database (VPS): 0619-3, 05/12/2006 Tested on: 5/13/2006 2:13:39 PM avast! is copyright (c) 2000-2006 ALWIL Software. [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 http://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business+fin ance+coursew2=Business+to+business+financew3=Small+business+financew4=Bus iness+finance+consultantw5=Business+finance+magazinew6=Business+finance+sc hoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w finance course Business http://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Busines s+finance+coursew2=Business+to+business+financew3=Small+business+financew 4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finan ce+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA to business finance Small http://groups.yahoo.com/gads?t=msk=Small+business+financew1=Business+fina nce+coursew2=Business+to+business+financew3=Small+business+financew4=Busi ness+finance+consultantw5=Business+finance+magazinew6=Business+finance+sch oolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw business finance Business http://groups.yahoo.com/gads?t=msk=Business+finance+consultantw1=Business +finance+coursew2=Business+to+business+financew3=Small+business+financew4 =Business+finance+consultantw5=Business+finance+magazinew6=Business+financ e+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA finance consultant Business http://groups.yahoo.com/gads?t=msk=Business+finance+magazinew1=Business+f inance+coursew2=Business+to+business+financew3=Small+business+financew4=B usiness+finance+consultantw5=Business+finance+magazinew6=Business+finance+ schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg finance magazine Business
RE: [Axapta-Knowledge-Village] Re: Cost calculation crisis
Hi Let me know what problems you had during closing. Based on what information you need I can let you know or send u what ever information I have. Hope subbu would have sent you the jobs and other useful information... Raj -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of joeinvcost Sent: Saturday, May 13, 2006 2:21 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Cost calculation crisis Hi, Can Subbu or anyone who received additional information about inventory close-generated cost adjustments please e-mail me? Thanks, Joe --- In Axapta-Knowledge-Village@yahoogroups.com, DIEGO MARIANO GAGLIANO [EMAIL PROTECTED] wrote: Hi James, Long time a go I have the same problem with couple customers. This problem can be produced by the Item cost calculation in production orders, when the Item not have any specific cost attach to. If you want, please send me an email to me, to discuss if your problem is the same, and I send you a Fix. Best regards Diego Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi James, Sorry for my late reply as I was swamped with TARGIT developments. Anyway, I have sent you an private email to start with and if you have any specific questions, please let me know so that I can get you. Have a great day. Take care, Subbu James Flavell [EMAIL PROTECTED] wrote: Hi Subbu, Would be interested to know what you found with MS as we are using SP4 and have serious closing problems where production costing is involved. We have submitted it to MBS who have escalated it but would really like any other input. Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi Sent: 28 February 2006 08:16 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Cost calculation crisis Hi there, We contacted MS when one of the item got costed in hundreds of millions. I I am not directly involved as I was a silent wtacher for that painfull effort that went for 3 months sent you a personal email on this... Please let me know if you need any specific info. Thanks Regards, subbu [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thanks subbu_oh! Unfortunately, the HF30SP3_058 - Axapta IC Rollup for 3.0 SP3 patch is already in. It does not solve all of our problems - only a small portion. Have you run the close successfully? Thanks. -- Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Mkye, 1. which verson of axapta you are running? 2. if you are running Ax3.0 , did you put HF30SP3_058 - Axapta IC Rollup for 3.0 SP3 HF30SP2_034 - Axapta IC Rollup for 3.0 SP2 I think your problem should be solved if you put that hot fix. Happy Days and good Luck. Thanks Regards, subbu [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: We are running Axapta with standard costing selected and are having serious issues with the Inventory close process. The system seems to be making a lot more adjustments than what we want to see and calculating costs at incorrect amounts. Is anyone out there running inventory close - and for standard costs? __ __ Try Juno Platinum for Free! Then, only $9.95/month! Unlimited Internet Access with 1GB of Email Storage. Visit http://www.juno.com/value to sign up today! 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 Bring photos to life! New PhotoMail makes sharing a breeze. [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 __ __ Try Juno Platinum for Free! Then, only $9.95/month! Unlimited Internet Access with 1GB of Email Storage. Visit http://www.juno.com/value to sign up today! 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!