[Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation
Hi All, I am resending this query. No member of this group has any information about Consolidation/Intercompany elimination entries? Please do send some information and best practices. I really appreciate it. Thanks, Asrar 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.
SV: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation
Hi Asrar I don't know what's best practice in this area, so this is just a suggestion for a simple solution. If you use separate ledger accounts for intercompany entries you can use a consolidation account in the ledger table to eliminate automatically when you consolidate. As far as I know there's no other functionality in Axapta to do this. Regards Thomas -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af Asrar Shaik Sendt: 8. maj 2006 08:20 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation Hi All, I am resending this query. No member of this group has any information about Consolidation/Intercompany elimination entries? Please do send some information and best practices. I really appreciate it. Thanks, Asrar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links 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] FW: Intercompany Elimination Entries in Axapta Consolidation
Hi Thomas, Thank you very much for your response. It appears that there are some funcies also in this group.. Thanks, -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Jensen Sent: Monday, May 08, 2006 11:57 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: SV: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation Hi Asrar I don't know what's best practice in this area, so this is just a suggestion for a simple solution. If you use separate ledger accounts for intercompany entries you can use a consolidation account in the ledger table to eliminate automatically when you consolidate. As far as I know there's no other functionality in Axapta to do this. Regards Thomas -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af Asrar Shaik Sendt: 8. maj 2006 08:20 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation Hi All, I am resending this query. No member of this group has any information about Consolidation/Intercompany elimination entries? Please do send some information and best practices. I really appreciate it. Thanks, Asrar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links 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 display a value
Hi Sreekanth, This you can dot on two ways 1. when u call the second form from the first form. create a display menu item for the second form and place the menu item on the first form. goto proprities of that menu item and give the datasource as the first form table. and in the second form use the agrs()(element.args().record()) and u can get that record in the second form. 2. By Using the class we can do this. Just creare a class and store the value of that field warning(Text field) and get that value in the second form. [EMAIL PROTECTED] wrote: hi i need to know about how to display a field value of a form, which is reterived from another forms datasource for ex: say in my form a field called warning(Text field), say in another form there is a field in same name whose value will be stored in a Table. i need to take that value from that table and display it in my form field(Warning). thanks regards sreeka 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.
[Axapta-Knowledge-Village] Movement journal
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 one = 3. 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 Yahoo! Groups Sponsor ~-- Protect your PC from spy ware with award winning anti spy technology. It's free. http://us.click.yahoo.com/97bhrC/LGxNAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] 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.
[Axapta-Knowledge-Village] Invoicing Multiple Sales Orders into single Journal
Hi everybody, is it possible in Axapta to invoice multiple sales orders into single invoice? If yes can you give some details? Thanks a lot. Mehmet Özgür Genç Project Leader Tel : +90 212 285 22 34 Mobile: +90 533 225 93 05 http://www.veripark.com Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kiþinin yerine: Radek Krawiecki Gönderilmiþ: Pzt 08.05.2006 14:44 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: Re: [Axapta-Knowledge-Village] Movement journal We just start with Axapta in this company and for now we operate only with one warehouse. So this is not solution. Thanks for quick answer Radek somnath jana napisal(a): 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 one = 3. 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 [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ~-- Home is just a click away. Make Yahoo! your home page now. http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Consolidation of Reports
Hi People, Can anyone tell me if it is possible to consolidate Inventory, AR and AP in a multi-company setup. Inventory: Total stock available across all companies in terms of each Item AR: Total Recievable by a Customer to the entire company as a total of the individual recievable at each company.\ AP: Total Payable by a Vendor by the entire company as a total of the individual payable at each company. If i login into any one company, i can see only the data of that particular company in the AOT table. Is there someway i can consolidate the same to generate a report or atleast read data of all the companies in the requisite tables. 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.
Re: [Axapta-Knowledge-Village] Invoicing Multiple Sales Orders into single Journal
check the Posting invoice form , under the Other Tab and summar order group one of the two slections: Invoice account or Oder. sales order form---Posting Button--select invoiceleads u to the Posting invoice form. Invoice account will update sales order with same invoice account in one inovic, while Order will arrange different order for one customer as one order and update them in one invoice. Özgür Genç [EMAIL PROTECTED] wrote: Hi everybody, is it possible in Axapta to invoice multiple sales orders into single invoice? If yes can you give some details? Thanks a lot. Mehmet Özgür Genç Project Leader Tel : +90 212 285 22 34 Mobile: +90 533 225 93 05 http://www.veripark.com Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kiþinin yerine: Radek Krawiecki Gönderilmiþ: Pzt 08.05.2006 14:44 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: Re: [Axapta-Knowledge-Village] Movement journal We just start with Axapta in this company and for now we operate only with one warehouse. So this is not solution. Thanks for quick answer Radek somnath jana napisal(a): 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 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 [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 - 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] Switching between companies....
you can use changecompnay() method On 5/3/06, Anant Upreti [EMAIL PROTECTED] wrote: Hi group, I have one query that in Axapta. If a company is created and immediate after its creation we will switch into that company, then will one record create for that company in the CompanyInfo table?] I tried by myself in one environment it's happening but in other environment the record is not creating. Is there something wrong in the installation? Any ideas about the solution of this problem will be highly appreciated. Thanks in advance. Anant [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 [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] Is Triggers and Stored Procedures are available in Axapta.
Hi Friends, I want to add Triggers and Stored Procedures in back end.(SQL Server). Please help me in this regard. with regards, M.Premkumar 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] CRM implementation
Good morning everyone. I am in the process of implementing Customer Relationship Management at my company, a beverage manufacturing and distribution firm. However, it seems like a very grey area to us all as we are the first company in Jamaica attempting to implement it. Is there anyone in this group who has implemented CRM who could give me some tips and pointers for starting? I would really appreciate it. Regards, Nicholas Smith Axapta Administrator Lascelles deMercado Co. Ltd Kingston, Jamaica Phone: 876 757 5160 -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 8:49 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Digest Number 776 There is 1 message in this issue. Topics in this digest: 1. DataMethod Object Report From: Alfonso Collados Arroyo [EMAIL PROTECTED] Message: 1 Date: Fri, 5 May 2006 09:10:46 +0200 From: Alfonso Collados Arroyo [EMAIL PROTECTED] Subject: DataMethod Object Report I have a report with Objects String,..in a programmable section. Those Objects have a Datamethod. Can I pass a parameter to the DataMethod? Best Regards, Alfonso -- This e-mail and any attachments are confidential. If you are not the named or intended recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any medium. Any unauthorized disclosure, use or storage is prohibited and might be unlawful. -- This e-mail and any attachments are confidential. If you are not the named or intended recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any medium. Any unauthorized disclosure, use or storage is prohibited and might be unlawful. [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 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 I am not very sure about this, however this field is updated by Axapta while reserving the line. The field must have got updated when the user created the movement journal. The value of 3 signified the number of inventory dimensions that have been selected by the user. I know that this is not a complete answer but should give you some idea as to where to investigate. Please check the help on the EDT InventDimFixed regards harry From: Axapta-Knowledge-Village@yahoogroups.com on behalf of Radek Krawiecki Sent: Mon 5/8/2006 12:44 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Movement journal We just start with Axapta in this company and for now we operate only with one warehouse. So this is not solution. Thanks for quick answer Radek somnath jana napisal(a): 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 [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] Is Triggers and Stored Procedures are available in Axapta.
hi I guess you will have to post in SQL server forum regards harry From: Axapta-Knowledge-Village@yahoogroups.com on behalf of [EMAIL PROTECTED] Sent: Mon 5/8/2006 1:44 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta. Hi Friends, I want to add Triggers and Stored Procedures in back end.(SQL Server). Please help me in this regard. with regards, M.Premkumar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [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] Consolidation of Reports
Try setting virtual company accounts Maurice Cohen Senior consultant Advanced Systems Integration Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 Phone (949) 597-2170 Fax (949) 597-0720 Cell (949) 533-5966 -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Akshay Sent: Monday, May 08, 2006 5:55 AM To: Axapta-Knowledge-Village; Axapta Experts; development-axapta; Axapta_Documentation Subject: [Axapta-Knowledge-Village] Consolidation of Reports Hi People, Can anyone tell me if it is possible to consolidate Inventory, AR and AP in a multi-company setup. Inventory: Total stock available across all companies in terms of each Item AR: Total Recievable by a Customer to the entire company as a total of the individual recievable at each company.\ AP: Total Payable by a Vendor by the entire company as a total of the individual payable at each company. If i login into any one company, i can see only the data of that particular company in the AOT table. Is there someway i can consolidate the same to generate a report or atleast read data of all the companies in the requisite tables. 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 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] Invoicing Multiple Sales Orders into single Journal
There is a functionality called summary update that you can use to do this. Look at the other tab on this invoice posting tab. Maurice Cohen Senior consultant Advanced Systems Integration Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 Phone (949) 597-2170 Fax (949) 597-0720 Cell (949) 533-5966 -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Özgür Genç Sent: Monday, May 08, 2006 5:15 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Invoicing Multiple Sales Orders into single Journal Hi everybody, is it possible in Axapta to invoice multiple sales orders into single invoice? If yes can you give some details? Thanks a lot. Mehmet Özgür Genç Project Leader Tel : +90 212 285 22 34 Mobile: +90 533 225 93 05 http://www.veripark.com Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kiþinin yerine: Radek Krawiecki Gönderilmiþ: Pzt 08.05.2006 14:44 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: Re: [Axapta-Knowledge-Village] Movement journal We just start with Axapta in this company and for now we operate only with one warehouse. So this is not solution. Thanks for quick answer Radek somnath jana napisal(a): 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 [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 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] Invoicing Multiple Sales Orders into single Journal
Hi Yes, the summary update option allows that. Set this up on the Customer. This is then copied down to the orders that are created for the customer (and you can change the settings on a per-order basis too). Calculate the invoice as normal but click the Summary Update button before you post them. Regards Malcolm Burtt Touchstone People, Partnership, Solutions -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Özgür Genç Sent: 08 May 2006 13:15 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Invoicing Multiple Sales Orders into single Journal Hi everybody, is it possible in Axapta to invoice multiple sales orders into single invoice? If yes can you give some details? Thanks a lot. Mehmet Özgür Genç Project Leader Tel : +90 212 285 22 34 Mobile: +90 533 225 93 05 http://www.veripark.com Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: Radek Krawiecki Gönderilmiş: Pzt 08.05.2006 14:44 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: Re: [Axapta-Knowledge-Village] Movement journal We just start with Axapta in this company and for now we operate only with one warehouse. So this is not solution. Thanks for quick answer Radek somnath jana napisal(a): 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 one = 3. 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 [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ~-- Home is just a click away. Make Yahoo! your home page now. http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Home is just a click away. Make Yahoo! your home page now. http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Movement journal
Radek, A likely possibility is that the user who entered the sales line entered it with the default quantity of 1 (which will create the first inventTrans record), then went back and updated the line to quantity 10. This would create a second inventTrans record for the remaining 9. Hope this is of some use. Danny Ascend Systems Ltd. Suite 104 10410-81 Avenue, Edmonton, AB T6E 1X5 Canada Phone (780) 446-9087 Fax (780) 922-6942 --- In Axapta-Knowledge-Village@yahoogroups.com, Radek Krawiecki [EMAIL PROTECTED] wrote: We just start with Axapta in this company and for now we operate only with one warehouse. So this is not solution. Thanks for quick answer Radek somnath jana napisa³(a): 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. 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] FW: Intercompany Elimination Entries in Axapta Consolidation
Hi Asrar, This may help you, you need to set-up the eimination accounts, by going to the general ledger, setup, postings, intercompany journals, define the company account, the debit account and credit account, then you need to define the journal name of journal in company account for intercompany accounts. Then while creating a general ledger, journal, lines, on the general tab, select the offset company account ID, then the general ledger account. Let me know If I can further assist you. Regards Francisco O. - Original Message - From: Asrar Shaik [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation Date: Mon, 8 May 2006 13:55:00 +0400 Hi Thomas, Thank you very much for your response. It appears that there are some funcies also in this group.. Thanks, -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Jensen Sent: Monday, May 08, 2006 11:57 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: SV: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation Hi Asrar I don't know what's best practice in this area, so this is just a suggestion for a simple solution. If you use separate ledger accounts for intercompany entries you can use a consolidation account in the ledger table to eliminate automatically when you consolidate. As far as I know there's no other functionality in Axapta to do this. Regards Thomas -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af Asrar Shaik Sendt: 8. maj 2006 08:20 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation Hi All, I am resending this query. No member of this group has any information about Consolidation/Intercompany elimination entries? Please do send some information and best practices. I really appreciate it. Thanks, Asrar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links -- ___ Play 100s of games for FREE! http://games.mail.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.
[Axapta-Knowledge-Village] Re: Is Triggers and Stored Procedures are available in Axapta.
Execute Stored Procedure on Axapta Example. Connection con; Common common; str sql; Statement stmt; ResultSet set; ; super(); con = new Connection(); //SPAX_GetCustTable Procedure in SQL Server. sql = StrFmt(SPAX_GetCustTable '%1',curExt()); stmt = con.createStatement(); set = stmt.executeQuery(sql); while(set.next()) { //Retrive the first field (int Type) common.RecId = set.getInt(1); } Tuorto Emiliano From: Axapta-Knowledge-Village@yahoogroups.com on behalf of [EMAIL PROTECTED] Sent: Mon 5/8/2006 1:44 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta. Hi Friends, I want to add Triggers and Stored Procedures in back end.(SQL Server). Please help me in this regard. with regards, M.Premkumar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [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 display a value
Hi Thanks for your help can i get some sample code regarding thisbecause am new to Axapta... thanks Regards sreeka Mallikarjun Gudidevuni [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent by: cc: [EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] how to display a value groups.com 05/08/2006 03:34 PM Please respond to Axapta-Knowledge-Village Hi Sreekanth, This you can dot on two ways 1. when u call the second form from the first form. create a display menu item for the second form and place the menu item on the first form. goto proprities of that menu item and give the datasource as the first form table. and in the second form use the agrs()(element.args().record()) and u can get that record in the second form. 2. By Using the class we can do this. Just creare a class and store the value of that field warning(Text field) and get that value in the second form. [EMAIL PROTECTED] wrote: hi i need to know about how to display a field value of a form, which is reterived from another forms datasource for ex: say in my form a field called warning(Text field), say in another form there is a field in same name whose value will be stored in a Table. i need to take that value from that table and display it in my form field(Warning). thanks regards sreeka 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 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] Is Triggers and Stored Procedures are available in Axapta.
Hi, I know how to create Triggers and Procedures in SQL Server, but my doubt is how to handle this in Axapta.(back end SQL Server) with regards, Prem Harry Deshpande [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent by: cc: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Is Triggers and Stored groups.com Procedures are available in Axapta. 08/05/2006 08:50 PM Please respond to Axapta-Knowledge-Village hi I guess you will have to post in SQL server forum regards harry From: Axapta-Knowledge-Village@yahoogroups.com on behalf of [EMAIL PROTECTED] Sent: Mon 5/8/2006 1:44 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta. Hi Friends, I want to add Triggers and Stored Procedures in back end.(SQL Server). Please help me in this regard. with regards, M.Premkumar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [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 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 display a value
1.create a class // Changed on 22 Oct 2005 at 02:01:46 by Malik class qmCategoryCall_stc { qmCategoryCode_std cat1Code; qmCategoryCode_std cat2Code; } 2. Add a method to store the value in the class // Changed on 22 Oct 2005 at 02:02:52 by Malik qmCategoryCode_std Cat1code(qmCategoryCode_std c1=cat1Code) { cat1Code=c1; return cat1Code; } 3. call the 2nd form from this class // Changed on 22 Oct 2005 at 02:02:26 by Malik void callLevel2() { Args _args = new Args(); FormRun frObj; ; _args.name(Formstr(qmCategory2_stf)); _args.caller(this); frObj = ClassFactory.formRunClass(_args); frObj.init(); frObj.run(); frObj.wait(); } 4. In the 2nd form overried the init method // Changed on 22 Oct 2005 at 02:03:51 by Malik public void init() { super(); if(element.args().caller()){ _qmCategoryCall_obj = element.args().caller(); element.setValue(); } } i hope this will help u. bye Mallik [EMAIL PROTECTED] wrote: Hi Thanks for your help can i get some sample code regarding thisbecause am new to Axapta... thanks Regards sreeka Mallikarjun Gudidevuni [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent by: cc: [EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] how to display a value groups.com 05/08/2006 03:34 PM Please respond to Axapta-Knowledge-Village Hi Sreekanth, This you can dot on two ways 1. when u call the second form from the first form. create a display menu item for the second form and place the menu item on the first form. goto proprities of that menu item and give the datasource as the first form table. and in the second form use the agrs()(element.args().record()) and u can get that record in the second form. 2. By Using the class we can do this. Just creare a class and store the value of that field warning(Text field) and get that value in the second form. [EMAIL PROTECTED] wrote: hi i need to know about how to display a field value of a form, which is reterived from another forms datasource for ex: say in my form a field called warning(Text field), say in another form there is a field in same name whose value will be stored in a Table. i need to take that value from that table and display it in my form field(Warning). thanks regards sreeka 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 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.