Skip to Content
0
Former Member
Oct 24, 2007 at 06:33 AM

formatted search query for displaying invoice items details

10 Views

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