Vanila Report Query Storage.

[Former Member]

Hi,

I want to know that when any report in SAP Business One Vanila Product is generated, in what basis it is generated, can anyone tell me where is the query stored and executed for SAP Business One Basic Reports Reports ( Reports already in the Product) .

Regards,

Kawish Junaid Mazhari

[former_member583013 · Accepted solution]

Kawish,

It will depend on report. Some reports like BP Aging Report, etc are generated using a stored procedure and the selection paramaters are passed to the stored procedure as input parameters and the queries reside inside these stored procedure.

The queries for other reports probably reside as part of the core application code.

Suda