[Axapta-Knowledge-Village] setup fixed exchange rate in sales order
Hi, all I really need help to know how to use fixed exchange rate in tab price / discount when creating sales order. cause i've inserted number in fixed exchange rate box but seems nothing happen, means that nothing change with the price each for that SO. I'm looking forward for the answer Thanks __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] External Item - Sales Order
This customer number could be seen only in picking list with that way. You should still type the axapta number when you create a sales order .. --- Rick Hardy [EMAIL PROTECTED] wrote: Francisco, Thanks for the response, but when I do this and I go to the sales order form and try to enter the external item number on a sales order to that particular customer I get the message that the item does not exist in the item table? Rick _ From: Francisco Orozco [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 3:31 PM To: Administrator Cc: Rick Hardy Subject: Re: [Axapta-Knowledge-Village] External Item - Sales Order Of course, go to Accounts Receivable, SetUp, Forms, Form Setup, Item Number =set it to BOTH, then go to the customer form, select the customer, then go to SetUp Button, then click on External Item Description. and enter as many ITEMS codes and descrptions for this particular customer., it should do it. Kind Regards Francisco Orozco - Original Message - From: rickhardy22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] External Item - Sales Order Date: Mon, 28 Mar 2005 19:51:48 - I was hoping somebody could help me out with external item numbers. We have customers that would like to use their own part numbers for ordering - which seems like a great fit for customer external item numbers. Is it possible to use the external item number on the sales order lines for ordering purposes? Thanks for you help... Rick Sharing the knowledge on Axapta. -- ___ Sign-up for Ads Free at Mail.com http://www.mail.com/?sr=signup http://mail01.mail.com/scripts/payment/adtracking.cgi?bannercode=adsfre ejump01 Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129i12l9f/M=298184.6018725.7038619.3001176/ D=groups/S=1705001380:HM/EXP=1112131683/A=2593423/R=0/SIG=11el9gslf/*htt p:/www.netflix.com/Default?mqso=60190075 http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=group s/S=:HM/A=2593423/rand=570584611 _ 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] mailto:[EMAIL PROTECTED] ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Regarding Axapta Installation
Hello, We need to install Axapta in our LAN network. Can any one suggest what the server configuration and client configuration should be to start of with 15 members. What is the installation steps. ie.. what is to be installed first, what is to be installed in server, what is to be installed in client. Also i would like to know what is the interface which connects Axapta client and Axapta server Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Regarding Axapta Installation
Hello, We need to install Axapta in our LAN network. Can any one suggest what the server configuration and client configuration should be to start of with 15 members. What is the installation steps. ie.. what is to be installed first, what is to be installed in server, what is to be installed in client. Also i would like to know what is the interface which connects Axapta client and Axapta server Regards V. Lakshmi Narasimhan Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Regarding Axapta Installation
Hello, there are a few question before you can talk about installation. What kind of enviorment do you want to have? A 2-tier or 3-tier? Zhe first thing you have to install is the SQL-Server Frank Werner-Vohrervlnarasimhan2004 [EMAIL PROTECTED] wrote: Hello,We need to install Axapta in our LAN network. Can any one suggest what the server configuration and client configuration should be to start of with 15 members.What is the installation steps. ie.. what is to be installed first, what is to be installed in server, what is to be installed in client. Also i would like to know what is the interface which connects Axapta client and Axapta serverSharing the knowledge on Axapta. Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Re: Regarding Axapta Installation
Hi, We need 3-tier environment. regards Lakshmi Narasimhan --- In Axapta-Knowledge-Village@yahoogroups.com, Frank Werner-Vohrer [EMAIL PROTECTED] wrote: Hello, there are a few question before you can talk about installation. What kind of enviorment do you want to have? A 2-tier or 3-tier? Zhe first thing you have to install is the SQL-Server Frank Werner-Vohrer vlnarasimhan2004 [EMAIL PROTECTED] wrote: Hello, We need to install Axapta in our LAN network. Can any one suggest what the server configuration and client configuration should be to start of with 15 members. What is the installation steps. ie.. what is to be installed first, what is to be installed in server, what is to be installed in client. Also i would like to know what is the interface which connects Axapta client and Axapta server Sharing the knowledge on Axapta. Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] URGENT!!!! RecId
Hi Chea, Just execute this command again: select _tblSales; VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] Chea [EMAIL PROTECTED] wrote: hi, any 1 know how to move record tofirst cursor in Axapta? eg. { SalesTable _tblSales; ; select _tblSales; while(_tblSales) { if(_tblSales.SalesId == '0005') info(_tblSales.SalesId); next _tblSales; } After this loop, I want move _tblSales point to 1st record and do comparison again! Thanks! from Chea Khem Hoong - MalaysiaSharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Re: Regarding Axapta Installation
Dear Sir 1. Regarding server and client configuration If you will go to the below link you will come to know that the system configuration required as per your requirement. http://www.fujitsu-siemens.com/solutions/strategic_partners/microsoft/axapta_sizing.html 2. Regarding installation If you open your Axapta product CD and you need to run Setup.exe file then it will open an window and in that window there is a link Documentation at the top. You click there it will show the Installation Guide in the left side.Click on Installation Guide it will give you all the information about the installations. Hope the above informations will fullfil your requirements. Regards Arabinda --- vlnarasimhan2004 [EMAIL PROTECTED] wrote: Hi, We need 3-tier environment. regards Lakshmi Narasimhan --- In Axapta-Knowledge-Village@yahoogroups.com, Frank Werner-Vohrer [EMAIL PROTECTED] wrote: Hello, there are a few question before you can talk about installation. What kind of enviorment do you want to have? A 2-tier or 3-tier? Zhe first thing you have to install is the SQL-Server Frank Werner-Vohrer vlnarasimhan2004 [EMAIL PROTECTED] wrote: Hello, We need to install Axapta in our LAN network. Can any one suggest what the server configuration and client configuration should be to start of with 15 members. What is the installation steps. ie.. what is to be installed first, what is to be installed in server, what is to be installed in client. Also i would like to know what is the interface which connects Axapta client and Axapta server Sharing the knowledge on Axapta. Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Re: Regarding Axapta Installation
If you do not intend to use a lot more than 15 users 2-tier would be the recommendation for better performance. If you are thinking about security and scalability then 3-tier is the better choice. The order in which you install the server, application, client and database is not relevant as long you setup the configurations correctly before running the application or client. This is important if you want one person to install and configure the clients while another installs the application and server. The order in which you configure the installation is however relevant. The database must be present when configuring the application (compiling etc.) but the AOS is not needed. The configuration process of the application will move faster using 2-tier. After this you can configure the AOS and then get it started. You should then ensure that the client(s) configuration is setup to point to the AOS. It is better to use one XPO configuration file for all the clients since is saves on maintenance. VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] vlnarasimhan2004 [EMAIL PROTECTED] wrote: Hi,We need 3-tier environment.regardsLakshmi Narasimhan--- In Axapta-Knowledge-Village@yahoogroups.com, Frank Werner-Vohrer [EMAIL PROTECTED] wrote: Hello, there are a few question before you can talk about installation. What kind of enviorment do you want to have? A 2-tier or 3-tier? Zhe first thing you have to install is the SQL-Server Frank Werner-Vohrer vlnarasimhan2004 [EMAIL PROTECTED] wrote: Hello, We need to install Axapta in our LAN network. Can any one suggest what the server configuration and client configuration should be to start of with 15 members. What is the installation steps. ie.. what is to be installed first, what is to be installed in server, what is to be installed in client. Also i would like to know what is the interface which connects Axapta client and Axapta server Sharing the knowledge on Axapta.Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem SpeicherSharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - You care about security. So do we. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] URGENT!!!! RecId
Hi, I want to upload General Journals, the header and its lines, so the tables that I want to upload are ledgerjournaltable and ledgerjournaltrans. This tablea are going to be added through an interface made in .Net, but my problem is asign the RecId. I'm using mssql, I hope some can help me.Subrahmanyam Mamidi [EMAIL PROTECTED] wrote: Hi Ricardo, Ok. Axapta Recids will be generated in Kernel. what exactly do you want to do?. Which Tables you want to upload?. Are you uploading vendors/Customer with Atl addresses???. Let us know. Someone from the group will help you, Be more specific always. thanks, subbu SDBCRicardo Cortés [EMAIL PROTECTED] wrote: Hi everyone, I new in the development in Axapta, I need to make some records directly in the Axapta tables, but i havea problem, because I don't know how Axapta asign the fieldRecId; how is createthe RecId? I hope someone can help me Thanks in advance Ricardo Cortes Interselect Do You Yahoo!?Yahoo! Net: La mejor conexión a internet y 2GB en tu buzón de Correo Yahoo! por $100 al mes.Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Do You Yahoo!? Yahoo! Net: La mejor conexión a internet y 2GB en tu buzón de Correo Yahoo! por $100 al mes. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [Axapta-Knowledge-Village] URGENT!!!! RecId
Hi Ricardo, am I hearing "LedgerJournalTable" and "LedgerJournalTrans"? If yes, do you use the Class "LedgerJournalEngine" too? I recently had to do something with inserting records into those two tables: I found out, that it's working smoother if you use the Class LedgerJournalEngine in addition to importing the data. The LedgerJournalEngine helps you doing as if you inserted the records manually. Herbert Von: Ricardo Cortés [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. März 2005 17:40An: Axapta-Knowledge-Village@yahoogroups.comBetreff: Re: [Axapta-Knowledge-Village] URGENT RecId Hi, I want to upload General Journals, the header and its lines, so the tables that I want to upload are ledgerjournaltable and ledgerjournaltrans. This tablea are going to be added through an interface made in .Net, but my problem is asign the RecId. I'm using mssql, I hope some can help me.Subrahmanyam Mamidi [EMAIL PROTECTED] wrote: Hi Ricardo, Ok. Axapta Recids will be generated in Kernel. what exactly do you want to do?. Which Tables you want to upload?. Are you uploading vendors/Customer with Atl addresses???. Let us know. Someone from the group will help you, Be more specific always. thanks, subbu SDBCRicardo Cortés [EMAIL PROTECTED] wrote: Hi everyone, I new in the development in Axapta, I need to make some records directly in the Axapta tables, but i havea problem, because I don't know how Axapta asign the fieldRecId; how is createthe RecId? I hope someone can help me Thanks in advance Ricardo Cortes Interselect Do You Yahoo!?Yahoo! Net: La mejor conexión a internet y 2GB en tu buzón de Correo Yahoo! por $100 al mes.Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Do You Yahoo!?Yahoo! Net: La mejor conexión a internet y 2GB en tu buzón de Correo Yahoo! por $100 al mes.Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Re: External Item - Sales Order
The extenal item number is on the general tab on the sales order lines. What I would expec is if I enter the external item number in this field then it should pull Axaptas (our) item number? What I'm trying to avoid is having to reference our item number at all. If I enter our item number the external item number does get filled in, but the reverse does not happen. --- In Axapta-Knowledge-Village@yahoogroups.com, UserM1837 [EMAIL PROTECTED] wrote: You can take an order using the customer's external item number. Just make sure that after you have done the set up for the customer external item number in the accounts receivable that on the sales order form, you have a field to enter the external item id. Your form should have two fields one for the item number (yours) and another field for the external item Id such that if you enter the item number it will pull up the customer external item number and the reverse is also true. Thanks rickhardy22 [EMAIL PROTECTED] wrote: So there is no way we can take an order using a customers external item number id? We just need to know that their item cross references to our item? This seems like a very poor solution... --- In Axapta-Knowledge-Village@yahoogroups.com, hakan köse [EMAIL PROTECTED] wrote: This customer number could be seen only in picking list with that way. You should still type the axapta number when you create a sales order .. --- Rick Hardy [EMAIL PROTECTED] wrote: Francisco, Thanks for the response, but when I do this and I go to the sales order form and try to enter the external item number on a sales order to that particular customer I get the message that the item does not exist in the item table? Rick _ From: Francisco Orozco [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 3:31 PM To: Administrator Cc: Rick Hardy Subject: Re: [Axapta-Knowledge-Village] External Item - Sales Order Of course, go to Accounts Receivable, SetUp, Forms, Form Setup, Item Number =set it to BOTH, then go to the customer form, select the customer, then go to SetUp Button, then click on External Item Description. and enter as many ITEMS codes and descrptions for this particular customer., it should do it. Kind Regards Francisco Orozco - Original Message - From: rickhardy22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] External Item - Sales Order Date: Mon, 28 Mar 2005 19:51:48 - I was hoping somebody could help me out with external item numbers. We have customers that would like to use their own part numbers for ordering - which seems like a great fit for customer external item numbers. Is it possible to use the external item number on the sales order lines for ordering purposes? Thanks for you help... Rick Sharing the knowledge on Axapta. -- ___ Sign-up for Ads Free at Mail.com http://www.mail.com/?sr=signup http://mail01.mail.com/scripts/payment/adtracking.cgi? bannercode=adsfre ejump01 Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129i12l9f/M=298184.6018725.7038619.30011 76/ D=groups/S=1705001380:HM/EXP=1112131683/A=2593423/R=0/SIG=11el9gslf/* htt p:/www.netflix.com/Default?mqso=60190075 http://us.adserver.yahoo.com/l? M=298184.6018725.7038619.3001176/D=group s/S=:HM/A=2593423/rand=570584611 _ 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ Sharing the knowledge on Axapta. Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Do you Yahoo!? Yahoo! Small Business - Try our new resources site!
RE: [Axapta-Knowledge-Village] Re: External Item - Sales Order
Rick, The external Item number is usually used when creating orders via an external interface such as Commerce gateway, or EDI. When using the Sales form in Axapta it is assumed that you will be using your internal item number so the logic that would do an external item ID look up is not present on that form, it would be a fairly simple modification to add a section of code on the modified method of the external item ID field that would perform the lookup and populate the standard item id , or present an item not found error. -Preston From: rickhardy22 [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 1:12 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: External Item - Sales Order The extenal item number is on the general tab on the sales order lines. What I would expec is if I enter the external item number in this field then it should pull Axaptas (our) item number? What I'm trying to avoid is having to reference our item number at all. If I enter our item number the external item number does get filled in, but the reverse does not happen. --- In Axapta-Knowledge-Village@yahoogroups.com, UserM1837 [EMAIL PROTECTED] wrote: You can take an order using the customer's external item number. Just make sure that after you have done the set up for the customer external item number in the accounts receivable that on the sales order form, you have a field to enter the external item id. Your form should have two fields one for the item number (yours) and another field for the external item Id such that if you enter the item number it will pull up the customer external item number and the reverse is also true. Thanks rickhardy22 [EMAIL PROTECTED] wrote: So there is no way we can take an order using a customers external item number id? We just need to know that their item cross references to our item? This seems like a very poor solution... --- In Axapta-Knowledge-Village@yahoogroups.com, hakan köse [EMAIL PROTECTED] wrote: This customer number could be seen only in picking list with that way. You should still type the axapta number when you create a sales order .. --- Rick Hardy [EMAIL PROTECTED] wrote: Francisco, Thanks for the response, but when I do this and I go to the sales order form and try to enter the external item number on a sales order to that particular customer I get the message that the item does not exist in the item table? Rick _ From: Francisco Orozco [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 3:31 PM To: Administrator Cc: Rick Hardy Subject: Re: [Axapta-Knowledge-Village] External Item - Sales Order Of course, go to Accounts Receivable, SetUp, Forms, Form Setup, Item Number =set it to BOTH, then go to the customer form, select the customer, then go to SetUp Button, then click on External Item Description. and enter as many ITEMS codes and descrptions for this particular customer., it should do it. Kind Regards Francisco Orozco - Original Message - From: rickhardy22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] External Item - Sales Order Date: Mon, 28 Mar 2005 19:51:48 - I was hoping somebody could help me out with external item numbers. We have customers that would like to use their own part numbers for ordering - which seems like a great fit for customer external item numbers. Is it possible to use the external item number on the sales order lines for ordering purposes? Thanks for you help... Rick Sharing the knowledge on Axapta. -- ___ Sign-up for Ads Free at Mail.com http://www.mail.com/?sr=signup http://mail01.mail.com/scripts/payment/adtracking.cgi? bannercode=adsfre ejump01 Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129i12l9f/M=298184.6018725.7038619.30011 76/ D=groups/S=1705001380:HM/EXP=1112131683/A=2593423/R=0/SIG=11el9gslf/* htt p:/www.netflix.com/Default?mqso=60190075 http://us.adserver.yahoo.com/l? M=298184.6018725.7038619.3001176/D=group s/S=:HM/A=2593423/rand=570584611 _ 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)
Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - --- ItemA 10 0 ItemB 10 10 can I do it in Axapta? thanks in advance, Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Posting Profile - Inventory (Purchase Order)
Hi all I am working on below posting profile. Purchase Order (Consumption) Path : Inventory Mgt/Setup/Posting/Posting-Purchase Order Can anyone advice me when does system use the posting profile for 'Consumption' what is the recommad account to use. Regards pp.cheah Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Posting Profile - Inventory (Purchase Order)
consumption account is used on return Items. Accountto use-- You must determineany PL account. Abin.ppcheah70 [EMAIL PROTECTED] wrote: Hi allI am working on below posting profile. Purchase Order (Consumption)Path : Inventory Mgt/Setup/Posting/Posting-Purchase OrderCan anyone advice me when does system use the posting profile for 'Consumption' what is the recommad account to use.Regardspp.cheahSharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Fixed Asset - Disposal Posting Profile
Hi all I am working on below posting profile. Purchase Order (Consumption) Path : General Ledger/Setup/Fixed Asset/Posting Profile/Disposal (buttom)/Sale or Scrap. Either select sale or scrap buttom; in 'Post Value' column may find 'Acquisition value' 'Sale value'. Pls advice me when does system use the posting profile what is the recommad account to use. Regards pp.cheah Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)
Hi Anton, You can use Axapta OLAP for that purpose. This requires MS Analysis Services SP3 installed. Regards, Agus -Original Message- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 9:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table) Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - --- ItemA 10 0 ItemB 10 10 can I do it in Axapta? thanks in advance, Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Fixed Asset - Disposal Posting Profile
Hello Poh Poh, Jack here. The acquisition account is the balance sheet asset acquisition account (in original purchase price) whereas the sales value is a PL account / disposal account used to calculate the gain / loss on disposal. Do try to create a disposal transaction andpost itthen by looking at the posted transaction you can determine which account to be used. ppcheah70 [EMAIL PROTECTED] wrote: Hi allI am working on below posting profile. Purchase Order (Consumption)Path : General Ledger/Setup/Fixed Asset/Posting Profile/Disposal(buttom)/Sale or Scrap.Either select sale or scrap buttom; in 'Post Value' column may find 'Acquisition value' 'Sale value'. Pls advice me when does system use the posting profile what is the recommad account to use.Regardspp.cheahSharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Fixed Asset - Disposal Posting Profile
Hi Cheah, When you use the disposal sale/scrap, it means that you are reversing previous transactions such as acquisitionadjustments, depreciation adjustments etc, and also take into account the gain/loss of disposal. You can find a perfect example if you look at the demo data for WELD value models Regards, Sun Fen - Original Message - From: ppcheah70 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, March 30, 2005 10:02 AM Subject: [Axapta-Knowledge-Village] Fixed Asset - Disposal Posting Profile Hi all I am working on below posting profile. Purchase Order (Consumption) Path : General Ledger/Setup/Fixed Asset/Posting Profile/Disposal (buttom)/Sale or Scrap. Either select sale or scrap buttom; in 'Post Value' column may find 'Acquisition value' 'Sale value'. Pls advice me when does system use the posting profile what is the recommad account to use. Regards pp.cheah Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Posting Profile - Inventory (Purchase Order)
Hi Cheah, Try the following and you will understand when consumption account is used. 1. Make sure standard cost price is unchecked in the inventory model group. (if checked, standard cost price accounts will be used instead of consumption) 2. Create and invoice a purchase order. see the item cost price 3. Create and invoice credit note for that purchase order. change the price each different from the cost price. 4. When you inquire the credit note invoice, you will see the consumption account is used. Regards, Sun fen - Original Message - From: ppcheah70 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, March 30, 2005 9:44 AM Subject: [Axapta-Knowledge-Village] Posting Profile - Inventory (Purchase Order) Hi all I am working on below posting profile. Purchase Order (Consumption) Path : Inventory Mgt/Setup/Posting/Posting-Purchase Order Can anyone advice me when does system use the posting profile for 'Consumption' what is the recommad account to use. Regards pp.cheah Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: External Item - Sales Order
Rick if youre going further down this path, this code sample might give you hand. It first searches the inventTable for the ItemID first, and if not found it searches the external Item table. -Preston inventTable getInventRec(externalItemID _itemID, custAccount _acct) { //Get the inventory record for the externalItemID inventTable inventTable; select firstonly inventTable where inventTable.ItemId == _itemID; if(!inventTable) inventTable = CustVendExternalItem::findExternalItemId( ModuleInventPurchSalesVendCustGroup::Cust, _acct, _itemid).inventTable(); return inventTable; } From: rickhardy22 [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 9:27 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: External Item - Sales Order Preston, Thanks for your response. I thought that was the case but I just wanted to be sure that there was not this functionality out of the box before I would start looking into the modification. Thanks for your help! Rick --- In Axapta-Knowledge-Village@yahoogroups.com, Preston A. Larimer [EMAIL PROTECTED] wrote: Rick, The external Item number is usually used when creating orders via an external interface such as Commerce gateway, or EDI. When using the Sales form in Axapta it is assumed that you will be using your internal item number so the logic that would do an external item ID look up is not present on that form, it would be a fairly simple modification to add a section of code on the modified method of the external item ID field that would perform the lookup and populate the standard item id , or present an item not found error. -Preston _ From: rickhardy22 [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 1:12 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: External Item - Sales Order The extenal item number is on the general tab on the sales order lines. What I would expec is if I enter the external item number in this field then it should pull Axaptas (our) item number? What I'm trying to avoid is having to reference our item number at all. If I enter our item number the external item number does get filled in, but the reverse does not happen. --- In Axapta-Knowledge-Village@yahoogroups.com, UserM1837 [EMAIL PROTECTED] wrote: You can take an order using the customer's external item number. Just make sure that after you have done the set up for the customer external item number in the accounts receivable that on the sales order form, you have a field to enter the external item id. Your form should have two fields one for the item number (yours) and another field for the external item Id such that if you enter the item number it will pull up the customer external item number and the reverse is also true. Thanks rickhardy22 [EMAIL PROTECTED] wrote: So there is no way we can take an order using a customers external item number id? We just need to know that their item cross references to our item? This seems like a very poor solution... --- In Axapta-Knowledge-Village@yahoogroups.com, hakan köse [EMAIL PROTECTED] wrote: This customer number could be seen only in picking list with that way. You should still type the axapta number when you create a sales order .. --- Rick Hardy [EMAIL PROTECTED] wrote: Francisco, Thanks for the response, but when I do this and I go to the sales order form and try to enter the external item number on a sales order to that particular customer I get the message that the item does not exist in the item table? Rick _ From: Francisco Orozco [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 3:31 PM To: Administrator Cc: Rick Hardy Subject: Re: [Axapta-Knowledge-Village] External Item - Sales Order Of course, go to Accounts Receivable, SetUp, Forms, Form Setup, Item Number =set it to BOTH, then go to the customer form, select the customer, then go to SetUp Button, then click on External Item Description. and enter as many ITEMS codes and descrptions for this particular customer., it should do it. Kind Regards Francisco Orozco - Original Message - From: rickhardy22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] External Item - Sales Order Date: Mon, 28 Mar 2005 19:51:48 - I was hoping somebody could help me out with external item numbers. We have customers that would like to use their own part numbers for ordering - which seems like a
[Axapta-Knowledge-Village] Account number for transaction type does not exist ???
Dear All, We get this error Account number for transaction type ' ' does not exist , when we do update costing on production order . Do we miss something on parameter setup posting Inventory management ? thx Sas Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: SQL Statement (crosstable / pivot table)
Hi Agus, thanks for your reply, but I guess I can't try it 'cause my company didn't buy the 'OLAP' things hahaha --- In Axapta-Knowledge-Village@yahoogroups.com, Agus Riyadi [EMAIL PROTECTED] wrote: Hi Anton, You can use Axapta OLAP for that purpose. This requires MS Analysis Services SP3 installed. Regards, Agus -Original Message- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 9:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table) Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - --- ItemA 10 0 ItemB 10 10 can I do it in Axapta? thanks in advance, Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: SQL Statement (crosstable / pivot table)
Hi Anton, A workaround is creating another table with array column. Create code to populate data to the new table. Using form/report, change the label appearance of each array in the runtime, based on the data that you want to be displayed as column name. If someone have a better workaround, I would like to know too :-) Regards, Agus -Original Message- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 14:13 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: SQL Statement (crosstable / pivot table) Hi Agus, thanks for your reply, but I guess I can't try it 'cause my company didn't buy the 'OLAP' things hahaha --- In Axapta-Knowledge-Village@yahoogroups.com, Agus Riyadi [EMAIL PROTECTED] wrote: Hi Anton, You can use Axapta OLAP for that purpose. This requires MS Analysis Services SP3 installed. Regards, Agus -Original Message- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 9:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table) Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - --- ItemA 10 0 ItemB 10 10 can I do it in Axapta? thanks in advance, Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/