decimal places by branch/plant

[BillFClark]

Sorry I haven't had chance to look into this yet but thought I would post it in case someone had experience with this.

We presently have our BOM's quantity field (QNTY) set at 3 decimal places. We just purchased another company and are looking at bringing them onto our system. They will be a separate branch/plant. They said they need to have BOM's go out to 8 decimal places preferred but whatever we can extend would be better than 3. My question is can we set that decimal quantity different based on branch plant? The only place I know to set that is the data dictionary which is not b/p specific. I think I was told that there are two places to control decimals 1) inventory system and 2) PDM. We would also need to run the decimal conversion pgm on menu G3031.

Any ideas besides having our existing b/p's go to more decimal places?

 

[bruce_meyer]

To answer your question, no you can't have different decimals for quantity
or for BOM's by branch. You are correct that it is a system setting.

I would investigate the reason to have the BOM decimals go to 8 decimal
places. Could a UM change be done on the components to resolve the issue?

You should also review BOM reports, inquiries, maintenance programs, costing
screens, etc. to see if you change the decimals to 8 to make sure you are
not truncating off other significant display positions.

 

[andyklee]

Although I've never verified this with thorough testing, I have heard that
you can set the quantity field in the Bill of Material with a different
number of decimals than the other quantity fields. This is the only
exception I know of to the general rule that all quantity fields must be the
same number of decimals.

I agree with all of Bruce's comments, below.

Andy Klee
www.JDETips.com

 

[vasuvv2300]

We had similar situation but it was regarding currency. On a single database
we had to have domestic currency with 3 and 2 decimal point. We had a multi
site (different countries). The solution to this is to make a copy of the DD
and change the decimals in the DD.

You have not mentioned whether you are on world/one world. You have to have
different library lists in world and different path codes in one world for
accessing this single database. Make sure there are no common users between
these companies. If there are, then users will have to be careful on which
environment they are logging into. Distribution and Manufacturing decimal
settings are tricky where in financials it goes by currency decimal. So when
you change the quantity decimal then you need to do thorough testing.
Best Regards

 

[vasuvv2300]

We had similar situation but it was regarding currency. On a single database we had to have domestic currency with 3 and 2 decimal point. We had a multi site (different countries). The solution to this is to make a copy of the DD and change the decimals in the DD.

You have not mentioned whether you are on world/one world. You have to have different library lists in world and different path codes in one world for accessing this single database. Make sure there are no common users between these companies. If there are, then users will have to be careful on which environment they are logging into. Distribution and Manufacturing decimal settings are tricky where in financials it goes by currency decimal. So when you change the quantity decimal then you need to do thorough testing.
Best Regards

 

[Mike Dupaix]

The proposed approach requires more than a new
instance of the DD. You must replicate all
distribution and manufacturing data and will be
required to maintain each inventory item in both data
bases. This is due to the fact that inventory data
(F4111, F41021, etc) is not stored with decimals. Any
attempt to merge the two values for the same part will
result in incorrect information for analysis. You are
looking at an ongoing task that is prone to numberous
data management issues by doing this. Be sure and
talk this issue through from needs (data decimals) to
implications in inventory valuations and general
ledger cost data.
--- vasuvv2300 <[email protected]> wrote:
http://www.jdelist.com/ubb/showflat.php?Cat=&Board=W&Number=47251


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



World, OW B733X and Xe

 

[peterban]

Hi Andy!

You can set the display decimals independently across the whole of the
system if you wish - probably wont work though!

Early in my JDE life I changed the BoM, BPL and a few others to have what
the client wanted - when we went through testing boy did I change it back
quick!
As a rule the quantity fields should be changed as a group or there will be
rounding errors creeping into the system.

Merry Xmas to you !

Peter Bannister

1st Consulting Ltd
www.1stconsulting.biz

Mobile : +(44)-7711-649358
Fax : +(44)-7739-256227
E-mail on the move : [email protected]



Product Specialist

 

[vasuvv2300]

I think two instances of DD should work. what should be done is excusive usage of branch/plants. Let us assume there are two sets of users User group A for the first company and user group B for the second. Set up Business unit security for user group A so that they are able to access and enter information for their company only. Since this posting on the world software I assume that it is world software we are talking about. Even if there are common item it should not create problems unless you have a costing method which is at item level. We made this work with different library list and there was no issue and our costing method was weighted average at item / Branch level. From the post which started this discussion the assumption is we talking about only 2 brn/Plants, one for each company.

I will surely recommend that you try out what Andy has recommended whether there are ways of changing the quantity decimals in PDM which will resolve the issue.

 

[peterban]

Hi Guys!

I think that one of the original posters really had the answer (or at least
the right question to ask) - why do they need 8dp. Just think about the
level we are taking about hear - its got to be down to the microgram level
of less.

I would also like to reiterate that question and its follow on - why not
change the UoM??

Best regards

Peter

Peter Bannister

1st Consulting Ltd
www.1stconsulting.biz

Mobile : +(44)-7711-649358
Fax : +(44)-7739-256227
E-mail on the move : [email protected]



Product Specialist

 

[zuccoa]

As someone already wrote, I also strongly recommend NOT to go with such a
big number of decimal places : we - unfortunately - accepted the
manufacturing people's request and started with 4 dp's.

The result is that many fields on the screens get the most significant
figures truncated (in some program the truncation affects the calculations
and the DB values also !!!) and they would need more and more dp's anyway :
the ONLY way to go is UM conversions

A.Zucconi
IS Manager
TUBILUX PHARMA Spa



zuccoa

 

[BillFClark]

Re: RE: decimal places by branch/plant

Just got back from vacation. Thanks all for feedback and suggestions.