Hi Guy, I have seen the full discussion. I had a very bad experience with Axapta Master Planning Customization. For your problem, can it be solved using two different Coverage Group for two different Business Unit? Regards Anil --- In Axapta-Knowledge-Village@yahoogroups.com, ssb axapta <[EMAIL PROTECTED]> wrote: > Thanks for such a long mail.Implementing all three options have their own restrictions here.Even with the record level security option,it would be difficult to have financial transaction across the logical unit.With a small customization,I tried solving the problem.I suppose it works.:) The login logical unit will be captured in user setup.So,in covcalc,I will select items for planning which belongs to the login site.So the user may have two plans.And I will run MRP with this small customization.So Only their items will be visible to the user on the plan. > I hope I have not much of problems with this approach.I have tried testig it with some scnerios.It looks fine. > And as far as consultancy is concerned,It was a two way Invoice ..You had time in hand.My question helped you to spend that time effectively. :) :) :) Just kidding... > Thanks Harsh. > Regards, > SB. > > Harry Deshpande <[EMAIL PROTECTED]> wrote: > Hi > > I have some time on my hand and here is the full discussion (or at least > an attempt). > > Option 1: Create 2 different plans and ask the users to run different > plan per site. In this case both the plans will overwrite the same > dynamic plan specified on reqparameters. Ofcourse you can change this > behaviour so that dynamic plan is associated with a static plan (instead > of reqparameters) in this case you will also have change the way net > requirements is accessed (for e.g.) from salesline, you will have to > select dynamic plan on the basis of item from which the net requirements > form is being accessed. ('net requirements' screen usually opens with a > dynamic plan'). > > In case of option 1, you should modify the covcalc method (reason > explained later). > > Option 2: Create a single plan run by 2 users. > > While running a master plan, axapta checks if there is any range > specified on the inventTable datasource (i.e. when you click on the menu > item 'Master Scheduling' you can put a range on itemid's). If no range > is found then axapta will delete all previous transactions relating to > that master plan from the database. > > Now if you put a range in covcalc method, axapta will not find any range > on the query and delete all previous transactions, which means your > users are going to override each others data. > > So the solution is to use site as a range in the query used by 'master > scheduling'. However, this is going to create serious performance > problems since Axapta will try to delete previous planning transactions > item by item. Master planning as it is sucks the server of all resources > especially if you have multiple levels of BOM. (multiple level of BOM is > anything more than 2, seriously). > > Ofcourse you can modify axapta to take care of this problem (deleting > transactions item by item) but it will still hurt the performance. > > Further, if the users end up running the master plan simultaneously then > you are going to have big-time locking issue. I am not an SQL Expert but > what I feel is row level locks are never going to happen when running > master planning. With page level locks (whatever that means) pagelevel > locks may block each others plans (since reqPlanId is the first field on > primary index of reqtrans and reqpo). There are quite a few other > considerations as well. > > Option 3: put record level security on the basis of site. Run master > plan from a login which is not affected by record level security. > Planners will only see items which belong to them and not of someone > else's. As far as I have seen RSL really does not affect performance to > a great extent. > > In this case you don't have worry about BOM lines, since users cannot > see items from other site they cannot include them in BOM lines. > > No modifications required for this option. > > What I would recommend is option 3, if that is not possible then > > If your server hardware is good enough then option 2 (very unlikely no > server is good enough to manage master planning) otherwise option 3. > > > Hope the above discussion helps. Where do I sent u the invoice for > consultancy? *s* Please ignore the grammatical mistakes in the above > mail. > > Regards > > Harshawardhan deshpande > > > > -----Original Message----- > From: Harry Deshpande > Sent: Wednesday, 19 January 2005 9:41 a.m. > To: 'Axapta-Knowledge-Village@yahoogroups.com' > Subject: RE: [Axapta-Knowledge-Village] MRP - Customization > > Hi > > Putting a range in covcalc will muck up things. To explain this will > need a long discussion. > > why don't you just put a range on inventTable while running a master > plan (i.e. when you open Master Scheduling menu)? > > You still have a problem with settings on the master planning parameters > which are common across the company, but they might not be very > important except the calendar. > > Regards > > harsh > > > -----Original Message----- > From: ssb axapta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 18 January 2005 4:54 p.m. > To: Harry Deshpande > Subject: RE: [Axapta-Knowledge-Village] MRP - Customization > > Not possible since they are not very distinct.As u see > below in that diagram,it is not a different company in > terms of finance and accounts. :) > > Will I face any other problems if i customize in > covcal? > > = = = Original message = = = > > Hi > > In fact why don't you create two companies? Are they > distinct enough? > > Regards > > harsh > > -----Original Message----- > From: ssb axapta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 18 January 2005 4:22 p.m. > To: Harry Deshpande > Subject: RE: [Axapta-Knowledge-Village] MRP - > Customization > > > hi, > > There are two different planning department in two > locations.But same company. > Axapta doesnt have this facility.Check the following > diagram.We cant replicate this in axapta > > Company > | > | > ------------------------------- > | | > | | > Business Unit 1 Business Unit 2 > | | > ------------------ ------------------- > | | | | | | > Wh1 Wh2 Wh3 Wh1 Wh2 > Wh3 > > I dont think we can implement ths in Axapta.Tahtz y ,I > m goin for a customization.What do u think?can u tell > me about the problems which You think i would be > encountering? > > Regards, > SB > > > = = = Original message = = = > > Hi > > > > Sorry, did not think enough with my last email. > > > > You are going to land into massive problems this way. > > > > Why do u need to run two master plans? Why not just > one master plan? > > > > It will help if you specify the critical business > requirement i.e. the ultimate end-purpose. > > > > Regards > > > > Harry > > > > > From: ssb axapta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 18 January 2005 3:31 p.m. > To: Harry Deshpande > Subject: RE: [Axapta-Knowledge-Village] MRP - > Customization > > > > > Hi > > > Thanks Harsh.I am also on the same thought. > > > > > > Thanks for the confirmation.You can expect more > troubles from me .Sorry for that :)) > > > > > > Regards, > > > SB > > Harry Deshpande <[EMAIL PROTECTED]> wrote: > > Hi > > > > covCalc is the correct method to restrict the items at > the top level. > > > > Instead of cross-checking whether the BOM lines are > from the same warehouse, I would recommend checking > this at the BOM set up level > > > > regards > > > > harsh > > > > > From: ssb axapta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 18 January 2005 3:23 p.m. > To: Harry Deshpande > Subject: RE: [Axapta-Knowledge-Village] MRP - > Customization > > > > > Hi > > > The input items are distinct to that site.So When the > user defines BOM,He will be giving items only from his > site.But then I should be able to cross check it once > again.I think this can be done in Covcalc itself.It > picks up the items for planning only in this part.Is > there any other apt method to put my code in ? > > > > > > Regards, > > > SB > > Harry Deshpande <[EMAIL PROTECTED]> wrote: > > Hi > > > > So each item has an associated site and you want to > run master planning only for the site for which a > particular plan is being run. > > > > What about underlying items in BOM? Are the distinct > for each site? Do you have any transactions within two > sites? > > > > Regards > > > > harsh > > > > > From: ssb axapta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 18 January 2005 3:13 p.m. > To: Harry Deshpande > Subject: RE: Hi > > > > > Hi > > > > > > Thanks for the immediate response. > > > > > > We have a setting in this factory to run MRP based on > site (ie) one level higher to Warehouse.So,When two > different site users run the plan,I should be able to > select items belonging to the particular site.So there > is a setup of site for each n every item.I should be > filtering the items depends on the site from which > they are running. > > > > > > > > > So my requirement is to Filter the items by site (ie) > when MRP puts the items for planning ,I have to filter > it.So as I mentioned below,I m planning for a > customization in these two places.Am I doing the right > thing? > > > > > > Hope I ahve made it clear. > > > > > > Regards, > > > Sb > > Harry Deshpande <[EMAIL PROTECTED]> wrote: > > Hi > > > > I read your post in the yahoo forum and not very clear > as to what u want to do > > > > Regards > > > > Harshawardhan deshpande > > > > > From: ssb axapta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 18 January 2005 2:17 p.m. > To: Harry Deshpande > Subject: Hi > > > > > I am new to axapta and trying to customize MRP.I would > like to put a filter(customization) based on some > certain creteria(ie) item selection should be > controlled inside the code by checking some > conditions.I am planning to do this in two places. > 1.class-->Reqcalc.additem2reqtranscache -- for > controlling the selection of BOM Items(FG). > 2.Class-->Reqcalc.covcalc -- for controlling the > selection of Input items ie components in the BOM. > > > Am I doing the customization at the right place?Need > your suggestions please. > > > Thanks in Advance, > SB. > > Harry Deshpande <[EMAIL PROTECTED]> wrote: > > > Hi > > > > Check whether there is a record in InventTrans (even > if the work order was deleted) > > > > Regards > > > > harry > > > > > > > > > > > > > > > Harry Deshpande > > > Senior Consultant > > > CGNZ Middle Market Solutions > > > Website: www.cgnz.com/middlemarketsolutions > > > Ph +64 29 277 5133 > > > Fax +64 9 358 1018 > > > > > > CGNZ Limited and its predecessor organisations (Cap > Gemini Ernst & Young, and Ernst & Young Consulting) > have a proud track record of market leadership and > excellent service delivery in all areas of systems > delivery both for New Zealand clients and in > supporting regional and global projects. CGNZ is a > licensed affiliate of Cap Gemini S.A. (one of the > world’s leading management consulting and IT > services companies), wholly owned by NZ > employee-shareholders, with over 150 IT professionals > in our Auckland and Wellington offices. Middle Market > Solutions specialises in the implementation of > business solutions for small corporate and middle > market companies. The core activity of our team is > the implementation and support of Enterprise Resource > Planning (ERP), Customer Relationship Management > (CRM), E-Business solutions and related technologies > from Microsoft Business Solutions. Find out more > about what we do at > http://www.cgnz.com/middlemarketsolutions > > > > > > CGNZ DISCLAIMER: This email and any attachments are > confidential and intended exclusively for the person > to whom the email is addressed. If you are not the > intended recipient, do not read, copy, disclose or use > the contents in any way. Please notify us immediately > by return email and destroy the email and attachments. > CGNZ does not accept any liability for any changes > made to this email or attachments after sending by > CGNZ. You must scan this email and attachments for > viruses. The opinions expressed are not necessarily > those of CGNZ. > > > CGNZ accepts no liability for any loss, damage or > consequence, whether caused by our own negligence or > not, resulting directly or indirectly from the use of > this email and attachments. > > > > > > From: Myrl Stadnick [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 18 January 2005 5:56 a.m. > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] MRP problem with > certain items. > > > > > > > > We have an assembly that when you run MRP against the > item, the MRP shows that we have and open work order > for 30 pieces. This work order was deleted. I can > delete this work order our of ReqTrans, but when you > then rerun MRP it comes back in again. How do we > permanently get rid of this ghost. I have a similar > situation with at least 6 other items. > > > > > > Myrl > > > > > > > > > Sharing the knowledge on Axapta. > > > > Sharing the knowledge on Axapta. > > Yahoo! India Matrimony: Find your life partner online. > > > Yahoo! India Matrimony: Find your life partner online. > > > > > Sharing the knowledge on Axapta. > > Yahoo! India Matrimony: Find your life partner > online. > > Yahoo! India Matrimony: Find your life partner online. > > > 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 the Yahoo! > Terms of Service. > > ___________________________________________________________ > Sent by ePrompter, the premier email notification > software. > Free download at http://www.ePrompter.com. > > ______________________________________________________________________ __ > Yahoo! India Matrimony: Find your life partner online > Go to: http://yahoo.shaadi.com/india-matrimony > > > > > 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 the Yahoo! > Terms of Service. > > ___________________________________________________________ > Sent by ePrompter, the premier email notification > software. > Free download at http://www.ePrompter.com. > > ______________________________________________________________________ __ > Yahoo! India Matrimony: Find your life partner online > Go to: http://yahoo.shaadi.com/india-matrimony > > > > > 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 the Yahoo! Terms of Service. > > > Yahoo! India Matrimony: Find your life partneronline. ------------------------ 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/