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/
