Skip to Content
avatar image
Former Member

Today's run

Does SBO hold any report tht displays details of all Postings or Document creation done through the day? i hav seen 'Transactional Journal Report' displaying all transactions, but i need to see the details of 'SO' , 'Quotations' , 'PO' along with those things.

If the way to get those things all together is achieved thro query, then help me with the query!

if so can i hav it displaying the user name who hav created the document in addition to above

Thks in Advance!

dhana.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2007 at 02:47 PM

    Dhana,

    Whatis the information you would like to see on that report. List the columns / exact information and I could help you

    Suda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Enriquillo Thk u very much! thks for giving the way to achieve the report!

      based on ur way i hav written my query like this,

      SELECT T0.Memo as 'Details of Document', T0.TransId as 'Transaction No./Document No.', T0.LocTotal as 'Document Total', T0.UserSign FROM OJDT T0 WHERE T0.TaxDate = [%0]

      Union All

      Select T0.JrnlMemo, T0.DocNum, T0.DocTotal, T0.UserSign From OQUT T0 where T0.TaxDate = [%0]

      Union All

      Select T0.JrnlMemo,T0.DocNum, T0.DocTotal, T0.UserSign From ORDR T0 where T0.TaxDate = [%0]

      Union All

      Select T0.JrnlMemo,T0.DocNum, T0.DocTotal, T0.UserSign From OPOR T0 where T0.TaxDate = [%0]

      Dhana.

  • avatar image
    Former Member
    Oct 16, 2007 at 12:59 PM

    There is not a report with exactly this kind of detail. But you can obtain some of this information with the sales and purchases report.

    Don't you have any experience with SQL querys?

    Regards,

    --

    Enriquillo

    Add comment
    10|10000 characters needed characters exceeded