The Order History by Title report shows you how your library has ordered specific titles in the past. This report helps to determine how often and in what quantity to reorder these items.
Here is a series of screens that depict the Order History by Title report, using EasyAsk to display it:
Use the horizontal scroll bar to view the rest of the report as it continues to the right:
This section expains how to do the following:
• | Generate an Order History by Title report from the navigation bar. |
• | Generate a Order History by Title report with a query. |
To generate an Order History by Title report from the navigation bar
1 | Start the Order History by Title process. |
The default location of this process is the
Your third-party reporting tool opens and displays the Order History by Title report.
2 | If you want to do so, print this report or save it to a file. |
Make sure that you print this report using the landscape setting on your printer. (For instructions, see the user's guide for your reporting tool.)
To generate an Order History by Title report with a query
1 | Open your reporting tool. (For example, open the English Wizard EasyAsk Query Builder.) |
2 | On the same line, enter this query to run the Order History per Title report: |
select i.po#, i.bib#, i.author, i.title, i.isbn, i.line,"completion date"=dateadd(dd,p.completion_date,"Jan 1, 1970”),p.vendor#,v.name,i.unit_price, "order date"=dateadd(dd,l.order_date,"Jan 1, 1970"),"receive date"= dateadd(dd,l.receive_date,"Jan 1, 1970"), "invoice date"=dateadd(dd,l.invoice_date,"Jan 1, 1970"), "cancel date"=dateadd(dd,l.cancel_date,"Jan 1, 1970"), "next claim date"=dateadd(dd,l.next_claim_date,"Jan 1, 1970") from po_line i, po p, vendor v, po_line_item l where i.bib#=18579 and i.po#=p.po# and p.vendor#=v.vendor# and p.po#=l.po# and i.line=l.line
Note: Enter this text exactly as shown. Where text wraps, insert one space. Do not insert carriage returns or extra spaces.
3 | If you want to do so, print this report or save it to a file. |
Make sure that you print this report using the landscape setting on your printer. (For instructions, see the user's guide for your reporting tool.)
4 | If you are using EasyAsk, save this query in your dictionary. |
© 1998-2017 Sirsi Corporation