Producing a "text" document, order exported

CalD

Hi,

I have a text document I need to create that is an Invoice, it needs to have the basic invoice information (Supplier,Date.Inv no, Total, Total tax etc) as well as all of the invoice detail lines - (Product Code,Description,Unit, QTY, Total $,Total tax etc)

Have no problem achieving this, with one exception, the invoice lines have to be exported in a certain order - the same order as they are printed on the invoice, and I have this stored in a numeric field (RowNo)

I am producing the export with the data shown in export as "determined at runtime" because the invoice is already in context and being displayed with the lines in the correct order. How ever when I export then line detail doesn't come out in RowNo order? I actually can't think of a way, even defining a query etc to achieve this, as the query would just be finding the invoice header and the rows come from the busines objects relationship...

Any ideas? Its a very fixed format I have to fit in with, I can't change it as its required by an established system....

Thanks

aware_support

What exactly are you doing when you are producing a document? If you are creating a PDF report then use a sub-report with an ordered query. If you are producing a text or HTML or Word or Excel document use the LIST_TABLE function and specify an ordered query.

CalD

Hi Support,

It is a pure text document, not word or excel. - document type=Text document
I initially tried LIST_TABLE but it didn't work when I looked into it it seemed to me this wouldn't work for text docs, just word, excel or html? should LIST_TABLE work with text docs?

Currently the text template is
<<LIST(InvoiceHdr.om_InvoiceLine....>>

many thanks

aware_support

No, text documents do not support LIST_TABLE. Can you use HTML?

CalD

I have to end up with a text file called filename.INV
Does aware allow me to say the file is HTML but in reality its not got any HTML in it, its just text?

tford

I have a Document of Text Document type that has a series of sections that include both text and things like:

<<LIST('FIND Student WHERE (Student.T_050_Apply_YN=Yes AND Student.Status=Active AND Student.T_900_Type_NO=Yes AND Student.T_000_All_4_App_Docs_RecdYN=No AND Student.Current_School_Feeder=Feeder) ORDER BY Student.Current_School_Name ASC,Student.Name_Last ASC', -, Current_School_Name, Name, T_000_Missing_App_Docs)>>

The output is a ,txt file which is what I needed.

In your case, could you have a LIST that FINDs and displays the header info, then a LIST that FINDs the details lines?

Then possible rename it to .INV?

CalD

Thank you mr tford, that sorted it out for me just fine!

Cheers