Skip to Content
avatar image
Former Member

How to get a specific consult of sap bo 9.2

I want to get an specific consult that it its included by default in sales a/r that it's a report, but i want to add some columns and fields, so how can i get the base consult?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Oct 28, 2016 at 10:15 AM

    Make a query from OINV if the information is based on invoices

    Select t0.Cardcode, t0.Cardname, sum(t0.Doctotal) from OINV t0 where t0.docdate>=[%0] and t0.docdate<=[%1] group by t0.Cardcode, t0.Cardname

    Add the fields that you need from OINV, or OCRD making a join

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2016 at 09:00 PM

    Hi,

    Please explain your requirement with an example.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 12, 2016 at 11:16 PM

    Hi,

    Please explain your requirement with an example.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 14, 2016 at 07:32 AM

    Hi,

    Can I help you?

    Regards

    Edmund

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2016 at 04:05 PM

    Thank you all for your support, i need the query of this system consult

    (Sorry for the language) I need the this query because i want to add some columns more.

    Add comment
    10|10000 characters needed characters exceeded