Rauf
VIP Member
Please see the details
Tables involved : F4301, F4311
Module : Proccurement
Related Application : Document Tracer
Tree Structure
OR (75)
|_OQ (89)
|_OF (94)
| |_OV (15)
| |_OV (51)
|_OG (74)
| |_OV (88)
This is related with proccurement of an item.
The created OR(Requisition Order) is split into number of documents.
One of my application gives me the above structure.
The tree is formed because the data is stored as parent/child.
I need to create a report with the following format
Or No. Child1 Child 2 Child3
------------------------------------------------------
OR(75) OQ(89) OF(94) OV(15)
OR(75) OQ(89) OF(94) OV(51)
OR(75) OQ(89) OG(74) OV(88)
Is it doable in JDE Reporting.
Can you please share some logic behind the same.
I think the 'Looping' will work here.
Tables involved : F4301, F4311
Module : Proccurement
Related Application : Document Tracer
Tree Structure
OR (75)
|_OQ (89)
|_OF (94)
| |_OV (15)
| |_OV (51)
|_OG (74)
| |_OV (88)
This is related with proccurement of an item.
The created OR(Requisition Order) is split into number of documents.
One of my application gives me the above structure.
The tree is formed because the data is stored as parent/child.
I need to create a report with the following format
Or No. Child1 Child 2 Child3
------------------------------------------------------
OR(75) OQ(89) OF(94) OV(15)
OR(75) OQ(89) OF(94) OV(51)
OR(75) OQ(89) OG(74) OV(88)
Is it doable in JDE Reporting.
Can you please share some logic behind the same.
I think the 'Looping' will work here.