How to get a specific consult of sap bo 9.2

[Former Member]

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?

[Johan_H]

Hi,

Do you mean that you need a query?

Regards,

Johan

[Former Member]

I leave the answer as a comment, thanks.

[gonzalogomez · Accepted solution]

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

[Former Member]

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.

[kothandaraman_nagarajan]

Hi,

Please explain your requirement with an example.

Thanks

[Former Member]

I leave the answer as a comment, thanks.

[Former Member]

Hi,

Can I help you?

Regards

Edmund

[Former Member]

I leave the answer as a comment, thanks.

[kothandaraman_nagarajan]

Hi,

Please explain your requirement with an example.

Thanks

[Former Member]

I leave the answer as a comment, thanks.