You can use the Table Wizard to create a report with all the Line Items.
Using Invoice as an example, the following explains how to create a report with Line Items:
for-eachINV_RECORD_NO - INV_TITLE
operator and leave your cursor.If you need to add a field for "group on" (for example, Inv_Li_Record_No), the grouping process is similar to the process explained in the preceding section. Since you have grouped the records by Invoice in the preceding section, you can leave the value blank.
The order of the selected columns must match the order that you want in your table, except for the column that you use for grouping, which is outside the table. In the "Which fields do you want to show in your report" window, match the order as shown here:
Inv Li Record No
--> In Li Record
Inv Li No
-->Inv Li No
Inv Li Desc
--> Inv Li Desc
Inv Li Unit Price
--> Inv Li Unit Price
Inv Li Quality
--> Inv Li Quality
Inv Li Amount
--> Inv Li Amount
Inv Li Uom
--> Li Uom
Code
--> CodeInv
Item
--> Item
The Table Wizard inserts the table and the necessary code:
for-eachINV_RECORD_No - INV_TITLE
Inv Li No | Inv Li Desc | Code | Item | Inv Li Quantity | Inv Li Uom | Inv Li Unit Price | Inv Li Amount |
---|---|---|---|---|---|---|---|
F INV_LI_NO | INV_LI_DE SC | CODE | ITEM | INV_LI_QUANTITY | INV_LI_UOM | INV_LI_UNIT_PRICE | INV_LI_AMOUNT E |
page breakend
You must run the report to see what information is generated. While the data is correct, you need to work on formatting the data. See Formatting Data for details.
Adding BI Fields to RTF File Header or Footer
Importing Template into Unifier
Legal Notices
Copyright © 2016, 2018,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, March 28, 2018