rekblad
Well Known Member
I have created a tabular financial report (copying standard JDE report R10111B) and want a UDC description (not the UDC itself, just the description) as the 1st column on the report followed by the actual account description, period amount, YTD amount, etc. The idea is to create a kind of outline to conform with the German reporting requirements.
The UDC (R001 -- aka 09/01) has blank as a valid value and "." as the description for blank. Level of detail 7 has all of the detailed transactions and for these accounts the UDC value is blank. For accounts at level 3, 4, 5, and 6 there are UDC values (not blank) and a description -- which is what I want in the 1st column.
1st try: drag the UDC value from the business view (V8300001) into the first position and then associate the description with this UDC. Hide the UDC field so only the description prints.
2nd try: add ER in Column Inclusion and use file I/O (F0005) by creating variables for the system code, UDC table, and using the BC value for the actual code associated with the account being processed to return the description001 field to a variable.
3rd try: use BF 'Get UDC' in Column Inclusion to return the description001 field to a variable.
4th try: move ER and 'Get UDC' to Do Section.
When I run the report I get the "." in front of the level of detail 7 records (which is what I expect) but nothing in front of the other levels (which is why I'm frustrated). In other words, the UDC associated with the detail lines (level of detail = 7) is captured and printed, but for the other accounts (level of detail 3-6) the value is not found and nothing appears on the report. This tells me the UBE is smart enough to find blank (".") on the UDC table so why isn't smart enough to find the others?
Using debugger for each of the 4 tries, I see the values in place just before the code which ought to return the description, but I get "NULL" after the code is executed except if the value is blank in which case I get ".".
One more thing which may or may not be relevant. Using UTB to look at F0005 (Format Data checked), I enter DRSY=09 and DRRT=01 which gives me the UDC table with all values. But I have to enter DRKY=*100 to view the specific code. In other words, I cannot simply enter 100 as expected. Is it possible the file is corrupt and this explains the problem?
Hope this explanation makes sense.......
Any ideas??
Rob
Xe 15.1 / Oracle / Sun / Unix
The UDC (R001 -- aka 09/01) has blank as a valid value and "." as the description for blank. Level of detail 7 has all of the detailed transactions and for these accounts the UDC value is blank. For accounts at level 3, 4, 5, and 6 there are UDC values (not blank) and a description -- which is what I want in the 1st column.
1st try: drag the UDC value from the business view (V8300001) into the first position and then associate the description with this UDC. Hide the UDC field so only the description prints.
2nd try: add ER in Column Inclusion and use file I/O (F0005) by creating variables for the system code, UDC table, and using the BC value for the actual code associated with the account being processed to return the description001 field to a variable.
3rd try: use BF 'Get UDC' in Column Inclusion to return the description001 field to a variable.
4th try: move ER and 'Get UDC' to Do Section.
When I run the report I get the "." in front of the level of detail 7 records (which is what I expect) but nothing in front of the other levels (which is why I'm frustrated). In other words, the UDC associated with the detail lines (level of detail = 7) is captured and printed, but for the other accounts (level of detail 3-6) the value is not found and nothing appears on the report. This tells me the UBE is smart enough to find blank (".") on the UDC table so why isn't smart enough to find the others?
Using debugger for each of the 4 tries, I see the values in place just before the code which ought to return the description, but I get "NULL" after the code is executed except if the value is blank in which case I get ".".
One more thing which may or may not be relevant. Using UTB to look at F0005 (Format Data checked), I enter DRSY=09 and DRRT=01 which gives me the UDC table with all values. But I have to enter DRKY=*100 to view the specific code. In other words, I cannot simply enter 100 as expected. Is it possible the file is corrupt and this explains the problem?
Hope this explanation makes sense.......
Any ideas??
Rob
Xe 15.1 / Oracle / Sun / Unix