COA 1characteristic keeps value 116

[Former Member]

hi

we are facing a problem on COA ; we need to write 5 characteristics but one always
keeps a fixed value which we don't know where it comes from !

on semi finish goods we are doing analysis batch type 89 for manual creation on production ;
derivation is activated between semi finish mat N°100158 and finsih good mat
N°100058 ; but the third characteristics always keeps the same value 116 ; and we don't know where it comes from.

Master Insp.Characteristic= 51000041

Result origin =inspection / batch from production chain

Insp Spec Origin = Materail spec from production chain

Info Field 2 = 60

Info Field 3 = 0193_50000023

we need help to understand what is going on , and so check if there are other errors and help to correct

thank you

Isabelle MITON+33681711382

[former_member42743]

First we need to really understand your process.

Is this a Batch derivation or a results copy process?  Is the result in the COA supposed to come from the SFG via the COA production chain?  Or are you expecting to derive the result from batch to batch in the production process?  Or are you using results copy to copy the SFG value to the FG inspection lot.

Exactly where are you expecting the COA to get the actual value from?  FG batch? SFG batch? FG inspection lot? SFG inspection lot?

What values is in the SFG batch record? What value is in the FG batch record?  What value is in the FG inspection lot?

I am very confused reading what you wrote.

BTW: infofield 2 & 3 would have not affect on this process unless you have customizations in place.  They are informational only.  If you have customizations, it might be very hard to help you.

Craig

[Former Member]

hello Craig

We are a chemical company

The SFG is a real big tank of thousand liters
and we are doing analysis 89 on it when we need to put the product in a bulk to
have the FG

The analysis on SFG shows good information

The derivation is in order to have the result of the SFG on FG’s COA

It works fine for other characteristics except for one which always shows value 116, even if on the SFG it is another value

We need to have COA at FG level

Hope those explanations would help to solve this point

Isabelle

[former_member42743]

Well it kind of sounds like you are getting a default value populating into the batch class characteristic over and over of the finished good.   I.E. whenever you create a batch, the characteristic is filled in with a value.  This would happen if in the class or in the mater master batch classification, some one entered a value and clicked on the "default" check box at the end of the line.  Then possibly, depending on your derivation rules, the value is not over written by the derivation.

I understand what you are doing,   It's a common practice and I've worked with it many times at different clients.

You still haven't clearly spelled out the exact process though.  There are several processes to do what you want using production chain, batch derivation and results copy.

So... It SOUNDS like from you earlier description....

The SFG tank is inspected and results copied to batch record.

When the FG is created the results are batch derived from the SFG to the FG batch.  (Maybe?)

The FG is maybe inspected for some of the properties.

The CoA takes results from the FG batch record?

Is that the way you do it?

You could also be,

inspecting the SFG, no batch characteristics used

inspecting some properties on FG, no batch characteristics

Generate COA using some inspection lot results from FG and some inspection lot results via the production chain from the SFG inspection lot.

you could also be

inspecting the SFG, using batch characteristics.

inspecting some properties on FG, no batch characteristics

Generate COA using some inspection lot results from FG and some batch results via the production chain from the SFG batch record.

You see what I mean?  You need to be VERY, VERY specific if we have hope of helping you!

Craig

[Former Member]

hello Craig

as you wrote

The SFG tank is inspected and results copied to batch record.

When the FG is created the results are batch derived from the SFG to the FG batch.

The FG is not inspected for some of the properties.

The CoA takes results from the FG batch record

on COA is only for FG , we need to copy data from SFG ;

COA only shows 5 characteristics ; 4 characteristics are good and 1 keeps value 116

it is "amazing" that this value appears because nowhere it is visible

do you any idea where i could check ? master data,

[former_member42743]

Ok.. while this won't solve the current issue, can I ask you why you are using the COA results via the production chain?

Since you indicate that the SFG results are batch derived into the FG batch record there is no reason to use the production chain in the COA.  Yet you still say "on COA is only for FG , we need to copy data from SFG"

Just report all the results directly from the batch record of the FG.

To help trouble shoot your problem, I would change the COA to report from FG batch and remove all reporting via the production chain.

This will at least verify where the issue lies.  If the correct value is reported from the batch, then the issue is in the production chain process of the COA.  It could be possible that the materials listed in the COA profile for the production chain is inaccurate or in the wrong order or something.  Why worry about maintaining all this extra data anyway when you can report the results directly from the batch record of the FG?

Craig