JMast
Reputable Poster
Hello All,
I am having trouble with a standard JDE report. While any advice you have on this specific report is great, I am also interested if you have seen the same symptoms in other reports and how you resolved them.
We run the R10211B Income Statement and have not had problems until running it for this year. Running it for 2010 works fine.
What we are seeing is accounts being rolled up (subtotaled, for the non financials like me out there
) incorrectly. An account will print on the report, but the numbers will include the next account to be processed and the next account will not print. Essentially, Acccount 1 consumes Account 2 before the report breaks and prints Account 1.
The report uses V830001 which I have noticed has some history on JDEList. The view joins F0901 and F0902 on AID. Both tables contain MCU/OBJ/SUB fields which should match for a given AID. The MCU/OBJ/SUB fields from both tables are on the V8300001.
When I debug, I am seeing one set of MCU/OBJ/SUB advance to the next record, but the other set does not. The report then seems to be breaking on the set that is not advancing which means it doesn't break until after the next account has been processed.
I have attached screen shots of the debug variables. The first account is OBJ 7320 and works fine. 7330 is the problem. 7340 comes after 7330, but ends up in the 7330 totals. 7350 is shown to demonstrate that the report gets it right on the next account.
I read on the list the fact that V8300001 is left outer join, so I tested by changing the join to simple on my dev machine, but it still broke. As far as I can see in Access and UTB, the records in the database are all correct values.
I do have Oracle working on the case, but I know there is much expertise on the List which may give me things to look at or take to Oracle.
Has anyone seen a report business view do this before?
Thanks for your time,
Jer
I am having trouble with a standard JDE report. While any advice you have on this specific report is great, I am also interested if you have seen the same symptoms in other reports and how you resolved them.
We run the R10211B Income Statement and have not had problems until running it for this year. Running it for 2010 works fine.
What we are seeing is accounts being rolled up (subtotaled, for the non financials like me out there
The report uses V830001 which I have noticed has some history on JDEList. The view joins F0901 and F0902 on AID. Both tables contain MCU/OBJ/SUB fields which should match for a given AID. The MCU/OBJ/SUB fields from both tables are on the V8300001.
When I debug, I am seeing one set of MCU/OBJ/SUB advance to the next record, but the other set does not. The report then seems to be breaking on the set that is not advancing which means it doesn't break until after the next account has been processed.
I have attached screen shots of the debug variables. The first account is OBJ 7320 and works fine. 7330 is the problem. 7340 comes after 7330, but ends up in the 7330 totals. 7350 is shown to demonstrate that the report gets it right on the next account.
I read on the list the fact that V8300001 is left outer join, so I tested by changing the join to simple on my dev machine, but it still broke. As far as I can see in Access and UTB, the records in the database are all correct values.
I do have Oracle working on the case, but I know there is much expertise on the List which may give me things to look at or take to Oracle.
Has anyone seen a report business view do this before?
Thanks for your time,
Jer