Hi subbu, its really big,
But, do you > think its a good practice to setup other european > companies in the US environment due to differeces in > the Tables FIelds of the same table in both > environments?. --- I really dont know how to answer this question. but you can develop some new tables which can capture the data which you require from other companies. Example - You import stock data or Projects data from european company A and send it to US main or HO company. Here u can import to a custom developed tables where u can capture the company name and the relevant fields which u require to process for some business procedures. For financial consolidation you can just import the trail balances form each company into one company (i.e. database)where you can do the consolidation and take you reports financial statements. Managing you supply chain is to want extent, only for decision making or some approval process or other linked process are carried out in different country, example - US has control and it will execute some process on the supply chain related things (I dont know, just making up something) For this u can figure out what details level of information is required. Once again, does your supply chain information dependent on the statutory requirements of each company, if not then you can customize a generic module which will have tables and forms and reports (standarized) across all your installations (72 companies) to hold the respective data in able to meet your supply chain requirements We have three different databases - 1 - The company itself (Based on companies) 2 - The country database (Only for financial consolidation of all companies in one country) 3- The Group database ( Only for financail consolidation of the countries) You can work out, but i think at this stage it will be difficult to meet all the requirements. welcome with best regards vaibhav pednekar --- Subrahmanyam Mamidi <[EMAIL PROTECTED]> wrote: > Yeah. I understand what you are saying. But, do you > think its a good practice to setup other european > companies in the US environment due to differeces in > the Tables FIelds of the same table in both > environments?. Honestly, we have 24 companies in all > the environments. Just imagine, it will be 72 > companies all together if I want to setup in each > environment?. We have Fianance up and running for > the last 3 months. We have various cost center > reports and balance sheet reports taken out of > Axapta. For the P&L reports and consolidation, we > are using TARGIT as the reporting tool. Thats a big > mess as I am doing consolidation in the ATRGIT > database. But it works perfectly fine as of now as > we can produce the reports in all the global 5 > currencies and vice versa. Last month , we got our > Phase-II kicked off and have a lot of challenges in > the road map like Project Contracts etc and we have > many supply chains within a supply chain?. Just > going ahead..... > > Let us see and hope for the best....... > > Many thanks , > Subbu > > > vaibhav pednekar <[EMAIL PROTECTED]> wrote: > Hi Subbu, > > This is the most challenging part of all, > intercompany > solutions across multiple database. i.e. across the > Globe. > > Which at this stage is not possible, it becomes very > complex. > > For this, in the Last meeting with Microsoft for > Global development, they have plans for including > all > the localization in one package and then you can > activate them for the respective companies. But it > still in progress i think and wish so. > > Currently working for a big MNC which has multiple > locations in Mulitple countries, here we have the > same > challenge, but we have divided in phases. > > First we will do only the Financial Consolidation, > here we have once database consists of all > Consolidated companies from each country. I.e. one > country has one consolidated company in same > database. > and then we have the Group Consolidation company in > it > where we use the Axapta online consolidation after > importing the trail balances in it. > > But as per as Supply chain is concerned, still not > finalized the approach, as we will deal with it in > 2nd > phase. > > But u can setup different companies in your every > database, example in US - setup the US company, the > Europe company and the Spain company. > > Please dont get pissed off me with, as just trying > to > provide some base so that the logical thinking > processes is started and we can get to solution for > this. > > I think for supply chain means, need to know the > stock, requirements, may be even the purchases and > sales. i limit to this only > > So after setting up the companies in each database > you > can import the records of the stocks, requirements, > i.e. planned orders or may be confirmed purchase > orders and sales orders. > > You will be the best person to judge this, and then > you can have some reports or may be the approval > process at US company done and againg export the > relevant data to the respective compaines. > > The localization will be only for the statutory and > legal things, which u can handle in the respective > database's after importing the transactions from > other > databases. > > In this way you can also manage to handle > intercompany > transactions at some level. > > > > I may be totally wrong at this point of time, but > this > is it, how look at it. I still need to fully devote > time on this, as your are working on this situation > now, hope this can be of some help to you. > > regards > Vaibhav Pednekar > > --- Subbu <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > When we contacted Microsoft for the Localisation > > rememdations for > > our business profile, they suggested 3 > > localisations. In other > > words, the companies attached to these > localisations > > will be setup > > in different databases. > > > > Likewise, we have USA, EUROPE and SPAIN companies > > setup under the > > respective environments. We had problems in many > > ways due to the > > localisations in finance module like consolidation > > and multi > > currency , global reporting etc etc etc across > these > > 3 databases. > > > > We are implementing Supply chain for our business. > > We could n't do > > intercompany transactions ( SO/PO ) between EUROPE > > and SPAIN as they > > are not in the same database. Microsoft answers > are > > very vague and > > doesn't help me. > > > > Does any one have any idea in dealing with > > intercompany transactions > > in different localisations????. > > > > Thanks in advance, > > Subbu > > > > > > > > > > > > > __________________________________ > Do you Yahoo!? > Check out the new Yahoo! Front Page. > www.yahoo.com > > > > > 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!? > Check out the new Yahoo! Front Page. www.yahoo.com __________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/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/
