formatted search query for displaying invoice items details
hi all,
i need to display all the items in AP invoice.kindly suggest me a query for that.
in AP invoice
Ex. row items
code--
desc
qty--
price
total
I0001--
XXXXXXX--
5
100 -
500
-
query should display this row as
code----
desc
price
I0001----
XXXXXXX
100
I0001----
XXXXXXX
100
I0001----
XXXXXXX
100
I0001----
XXXXXXX
100
I0001----
XXXXXXX
100
=================================
the query should display as the qty is 5 so it will display the same item 5 times
kindly suggest me some query for formatted search
its very urgent
regards
sandip