[Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation

2006-05-08 Thread Asrar Shaik
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

SV: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation

2006-05-08 Thread Thomas Jensen
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

RE: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation

2006-05-08 Thread Asrar Shaik
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:

Re: [Axapta-Knowledge-Village] how to display a value

2006-05-08 Thread Mallikarjun Gudidevuni
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

[Axapta-Knowledge-Village] Movement journal

2006-05-08 Thread Radek Krawiecki
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

Re: [Axapta-Knowledge-Village] Movement journal

2006-05-08 Thread somnath jana
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

[Axapta-Knowledge-Village] Invoicing Multiple Sales Orders into single Journal

2006-05-08 Thread Özgür Genç
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

[Axapta-Knowledge-Village] Consolidation of Reports

2006-05-08 Thread Akshay
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

Re: [Axapta-Knowledge-Village] Invoicing Multiple Sales Orders into single Journal

2006-05-08 Thread Kareem
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

Re: [Axapta-Knowledge-Village] Switching between companies....

2006-05-08 Thread Dhiraj yadav
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

[Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta.

2006-05-08 Thread premkumarm
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

[Axapta-Knowledge-Village] CRM implementation

2006-05-08 Thread Nicholas Smith
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

RE: [Axapta-Knowledge-Village] Movement journal

2006-05-08 Thread Harry Deshpande
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

RE: [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta.

2006-05-08 Thread Harry Deshpande
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]

RE: [Axapta-Knowledge-Village] Consolidation of Reports

2006-05-08 Thread Maurice Cohen
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

RE: [Axapta-Knowledge-Village] Invoicing Multiple Sales Orders into single Journal

2006-05-08 Thread Maurice Cohen
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)

RE: [Axapta-Knowledge-Village] Invoicing Multiple Sales Orders into single Journal

2006-05-08 Thread Malcolm Burtt
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

[Axapta-Knowledge-Village] Re: Movement journal

2006-05-08 Thread dannyband
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

RE: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation

2006-05-08 Thread Francisco Orozco
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

[Axapta-Knowledge-Village] Re: Is Triggers and Stored Procedures are available in Axapta.

2006-05-08 Thread Emiliano
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 =

Re: [Axapta-Knowledge-Village] how to display a value

2006-05-08 Thread sreekanthrs
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]

RE: [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta.

2006-05-08 Thread premkumarm
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:

Re: [Axapta-Knowledge-Village] how to display a value

2006-05-08 Thread Mallikarjun Gudidevuni
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