RE: [Axapta-Knowledge-Village] MRP - Customization
Hi I have shared Items which are used across sites. ** what exactly is this? How did u share the items. As far as I know,RLS works only on forms n reports. ** I would have thought RSL works everywhere. Have u tested this? I have setup coverage by wh and i have stock for BOM Line item with 3 different batches(one without batch).For the FG item,I have a sales forecast.So when it explodes,the MRP doesnt consider teh stock available for the input item. :( It just creats a PO for the FC Qty. :(( Trying to see where the problem is . :)) ** can u restate ur question, bit confused as to the sales forecast part? You have stock on hand at three batches and MRP does not consider the stock available. Now is batch a physical inventory and / or financial inventory? Is coverage plan by dimension selected for batch number? First step would be to create stock on hand without batch number and then see if MRP is considering this stock Regards harsh 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 worlds 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. 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.
RE: [Axapta-Knowledge-Village] MRP - Customization
Hi Aha! Now change the line type to item and see if it creates a purchase order considering the stock in hand. I think what u are talking about is a bug (feature) in standard axapta Regards harsh From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 2:56 p.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] MRP - Customization I have shared Items which are used across sites. ** what exactly is this? How did u share the items. *** I m not talking in terms of Axapta.The users have shared items.It will be stored in both the sites (say for eg,two diff wh). When planning is run for a specific site,it shd consider only the WH which belongs to the specific site.Only in case of shared items,it shd see across sites(ie two diff wh) .Hope it is clear. As far as I know,RLS works only on forms n reports. ** I would have thought RSL works everywhere. Have u tested this? *** No it doesnt.I ahve tested it.It works only on VISIBLE data. I have setup coverage by wh and i have stock for BOM Line item with 3 different batches(one without batch).For the FG item,I have a sales forecast.So when it explodes,the MRP doesnt consider teh stock available for the input item. :( It just creats a PO for the FC Qty. :(( Trying to see where the problem is . :)) ** can u restate ur question, bit confused as to the sales forecast part? You have stock on hand at three batches and MRP does not consider the stock available. Now is batch a physical inventory and / or financial inventory? Is coverage plan by dimension selected for batch number? First step would be to create stock on hand without batch number and then see if MRP is considering this stock *** this is the scenario item A | B Sales FC for Item A - 100 stock for Item B -- B1 = 10 B2 == 10 No Batch = 20 Now when I run MRP,It creates po for B for 100 Qty not for 60. clear? I ran Mrp with both options .with without coverage by batch .Nothing works.I am in thsi MRP for so long..I worked it other ERP packages..I have never seen such a weired output till now. :( Axapta is surprising.. :)) Regards harsh 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 worlds 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. Sharing the knowledge on Axapta. Yahoo! India Matrimony: Find your life partner online. Sharing the knowledge on Axapta. 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.
RE: [Axapta-Knowledge-Village] MRP - Customization
Hi Sorry about that. Its not a bug Next thing to check is the negative days and positive days. What is the date of the order that you are exploding? What is the date on which the purchase order is scheduled and what are ur positive days settings. Axapta master planning is amazing but it can be a bit of a pain with so many parameters. Regards harsh -Original Message- From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 3:11 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization oh..my god ! pls dont tell me it is a bug in Axapta !!! the line item is alrady of type item ..still this doesnt explode.. :( It can not b a BUG ...it s a mandatory thing for planning !!! have u done thin before? was it working ? if i have a direct sales FC for the line item ,it works.But if it s a derived requirement (ie) sales FC for op items,it donesnt work ..If it is a bug ,Then THIS IS A BIGG FUNCTIONAL BUg = = = Original message = = = Hi Aha! Now change the line type to item and see if it creates a purchase order considering the stock in hand. I think what u are talking about is a bug (feature) in standard axapta Regards harsh From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 2:56 p.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] MRP - Customization I have shared Items which are used across sites. ** what exactly is this? How did u share the items. *** I m not talking in terms of Axapta.The users have shared items.It will be stored in both the sites (say for eg,two diff wh). When planning is run for a specific site,it shd consider only the WH which belongs to the specific site.Only in case of shared items,it shd see across sites(ie two diff wh) .Hope it is clear. As far as I know,RLS works only on forms n reports. ** I would have thought RSL works everywhere. Have u tested this? *** No it doesnt.I ahve tested it.It works only on VISIBLE data. I have setup coverage by wh and i have stock for BOM Line item with 3 different batches(one without batch).For the FG item,I have a sales forecast.So when it explodes,the MRP doesnt consider teh stock available for the input item. :( It just creats a PO for the FC Qty. :(( Trying to see where the problem is . :)) ** can u restate ur question, bit confused as to the sales forecast part? You have stock on hand at three batches and MRP does not consider the stock available. Now is batch a physical inventory and / or financial inventory? Is #8216;coverage plan by dimension#8217; selected for batch number? First step would be to create stock on hand without batch number and then see if MRP is considering this stock *** this is the scenario item A | B Sales FC for Item A - 100 stock for Item B -- B1 = 10 B2 == 10 No Batch = 20 Now when I run MRP,It creates po for B for 100 Qty not for 60. clear? I ran Mrp with both options .with without coverage by batch .Nothing works.I am in thsi MRP for so long..I worked it other ERP packages..I have never seen such a weired output till now. :( Axapta is surprising.. :)) Regards harsh 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#8217;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
RE: [Axapta-Knowledge-Village] MRP - Customization
Hi Ok next thing to check is isDerivedDirectly. Open reqTrans in table browser go to the the line which contains on hand inventory and check if this flag is checked for the line. Regards Harsh -Original Message- From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 3:36 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization hiii tried with more days already..Never works = = = Original message = = = Hi The positive days setup of 0 will not work at all. Make sure that the positive days requirement days - todays date. Or just set the positive days to 1000. Regards harsh -Original Message- From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 3:25 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization Hi thanks for it .. i think i m taking lot of ur time.I extremely sorry about that. I have tried with all setups.potive Negative as 0 even. :( I have requirement in future date...so even thatz not a problem.Dont know where can it be wrong . :) let me try ..If i find some solution,surely will mail u .. we have time zone differences.So I will send u a mail across If i am successful :( = = = Original message = = = Hi Sorry about that. Its not a bug Next thing to check is the negative days and positive days. What is the date of the order that you are exploding? What is the date on which the purchase order is scheduled and what are ur positive days settings. Axapta master planning is amazing but it can be a bit of a pain with so many parameters. Regards harsh -Original Message- From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 3:11 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization oh..my god ! pls dont tell me it is a bug in Axapta !!! the line item is alrady of type item ..still this doesnt explode.. :( It can not b a BUG ...it s a mandatory thing for planning !!! have u done thin before? was it working ? if i have a direct sales FC for the line item ,it works.But if it s a derived requirement (ie) sales FC for op items,it donesnt work ..If it is a bug ,Then THIS IS A BIGG FUNCTIONAL BUg = = = Original message = = = Hi Aha! Now change the line type to item and see if it creates a purchase order considering the stock in hand. I think what u are talking about is a bug (feature) in standard axapta Regards harsh From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 2:56 p.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] MRP - Customization I have shared Items which are used across sites. ** what exactly is this? How did u share the items. *** I m not talking in terms of Axapta.The users have shared items.It will be stored in both the sites (say for eg,two diff wh). When planning is run for a specific site,it shd consider only the WH which belongs to the specific site.Only in case of shared items,it shd see across sites(ie two diff wh) .Hope it is clear. As far as I know,RLS works only on forms n reports. ** I would have thought RSL works everywhere. Have u tested this? *** No it doesnt.I ahve tested it.It works only on VISIBLE data. I have setup coverage by wh and i have stock for BOM Line item with 3 different batches(one without batch).For the FG item,I have a sales forecast.So when it explodes,the MRP doesnt consider teh stock available for the input item. :( It just creats a PO for the FC Qty. :(( Trying to see where the problem is . :)) ** can u restate ur question, bit confused as to the sales forecast part? You have stock on hand at three batches and MRP does not consider the stock available. Now is batch a physical inventory and / or financial inventory? Is #8216;coverage plan by dimension#8217; selected for batch number? First step would be to create stock on hand without batch number and then see if MRP is considering this stock *** this is the scenario item A | B Sales FC for Item A - 100 stock for Item B -- B1 = 10 B2 == 10 No Batch = 20 Now when I run MRP,It creates po for B for 100 Qty not for 60. clear? I ran Mrp with both options .with without coverage by batch .Nothing works.I am in thsi MRP for so long..I worked it other ERP packages..I have never seen such a weired output till now. :( Axapta is surprising.. :)) Regards harsh 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
RE: [Axapta-Knowledge-Village] MRP - Customization
Hi From the screen shots I am convinced that there is a mismatch. Your net requirements screen shows only on-hand items. Can you send me a screen shot showing the planned purchase order that has been created? I am leaving office in 45 mins (almost end of the day here). Regards harsh From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 4:11 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization ok Done.. sending u the screens now... Harry Deshpande [EMAIL PROTECTED] wrote: Hi Of course if there is something personal then do send email to this account, Regards harsh -Original Message- From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 4:05 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization I am sending u now.. can u come online for 5 mins? if free? = = = Original message = = = Hi Go to the BOM line item and go to net requirements screen. Can you mail the screenshot of this screen? Regards Harsh -Original Message- From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 3:55 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization it is not checked .. y ? watz is the problem?? = = = Original message = = = Hi Ok next thing to check is isDerivedDirectly. Open reqTrans in table browser go to the the line which contains on hand inventory and check if this flag is checked for the line. Regards Harsh -Original Message- From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 3:36 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization hiii tried with more days already..Never works = = = Original message = = = Hi The positive days setup of 0 will not work at all. Make sure that the positive days requirement days - todays date. Or just set the positive days to 1000. Regards harsh -Original Message- From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 3:25 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization Hi thanks for it .. i think i m taking lot of ur time.I extremely sorry about that. I have tried with all setups.potive Negative as 0 even. :( I have requirement in future date...so even thatz not a problem.Dont know where can it be wrong . :) let me try ..If i find some solution,surely will mail u .. we have time zone differences.So I will send u a mail across If i am successful :( = = = Original message = = = Hi Sorry about that. Its not a bug Next thing to check is the negative days and positive days. What is the date of the order that you are exploding? What is the date on which the purchase order is scheduled and what are ur positive days settings. Axapta master planning is amazing but it can be a bit of a pain with so many parameters. Regards harsh -Original Message- From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 3:11 p.m. To: Harry Deshpande Subject: RE: [Axapta-Knowledge-Village] MRP - Customization oh..my god ! pls dont tell me it is a bug in Axapta !!! the line item is alrady of type item ..still this doesnt explode.. :( It can not b a BUG ...it s a mandatory thing for planning !!! have u done thin before? was it working ? if i have a direct sales FC for the line item ,it works.But if it s a derived requirement (ie) sales FC for op items,it donesnt work ..If it is a bug ,Then THIS IS A BIGG FUNCTIONAL BUg = = = Original message = = = Hi Aha! Now change the line type to item and see if it creates a purchase order considering the stock in hand. I think what u are talking about is a bug (feature) in standard axapta Regards harsh From: ssb axapta [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 January 2005 2:56 p.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] MRP - Customization I have shared Items which are used across sites. ** what exactly is this? How did u share the items. *** I m not talking in terms of Axapta.The users have shared items.It will be stored in both the sites (say for eg,two diff wh). When planning is run for a specific site,it shd consider only the WH which belongs to the specific site.Only in case of shared items,it shd see across sites(ie two diff wh) .Hope it is clear. As far as I know,RLS works only on forms n reports. ** I would have thought RSL works everywhere. Have u tested this? *** No it doesnt.I ahve tested it.It works only on VISIBLE data. I have setup coverage by wh and i have stock for BOM Line item with 3 different batches(one without batch).For the FG item,I have a sales forecast.So when it explodes,the MRP doesnt consider teh stock available for the input item. :( It just
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 1Business 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
RE: [Axapta-Knowledge-Village] MRP - Customization
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 1Business Unit 2
RE: [Axapta-Knowledge-Village] MRP - Customization
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 worlds 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 againstthe 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! Groups Links To visit your group on the web, go
RE: [Axapta-Knowledge-Village] MRP - Customization
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 1Business 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