E9.2 Figuring out how a field is calculated

[richchipper]

I apologize as I'm not a developer. But getting developer help on anything is a struggle for us....

We have a batch process that creates a calculation in a field in a customized table (such as summarize forecast quantity for next month and save that number in the field).

in our case, we are finding that the calculation doesn't make sense as it's too high. So we are trying to figure out if there is something else being added to the calculations that's causing the issue.

I've tried running the report for this item with the logs and the tracing to determine the "formula", but I'm not able to find what I'm looking for.

Any help would be greatly appreciated.

 

[DaveWagoner]

Sure! Can you tell us what version of JDE you're on? And which tools release?

If you're not on green screen we're probably going to look at event rule logic and worst case, some business functions. If this is the case, you need to use patwel's excellent tool ObjectBrowser, which you need to run on a "fat client" machine (at least that's the only way I've ever run it) http://www.patwel.com/downloads/ObjectBrowser.htm

If you're on green screen then heaven help you, because you might need to get into RPG

 

[richchipper]

9.2 release 22 and Tools is 9.2.6.5

 

[DaveWagoner]

Sweet! Here's what I'd do:

1) Log into a fat client machine (your CNC should have at least one if not multiple for your JDE Developers)
2) Download and install the patwel tool mentioned above
3) Run the patwel tool. It will prompt you for a JDE login if you're not already logged in to the fat client
4) Look up the UBE you're trying to analyze by searching for it. Double click the UBE you want to analyze to open it
5) Find the event(s) that are effecting your calc, and analyze


Step 5 is where i think you really probably need someone who knows their way around ER code. Calculation code, especially if written by a crafty/obfuscator-hungry developer, can be tough to find if you don't know where to look. Probably worth a few $$ of consulting time to be fully honest.

There is a way to "View All Code" for your UBE and export the whole thing to a text file, which you could paste in here or email to a helpful developer if you wanted to disclose company secrets. This has all sorts of caveats with it, but it would be an option.

I'm assuming with all of this that your UBE and calculation are custom for your company, right?