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:
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! India Matrimony: Find your life partner
online.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
[EMAIL PROTECTED]
