cancel
Showing results for 
Search instead for 
Did you mean: 

Modify System Query

former_member971497
Discoverer
0 Kudos

Hi Everyone,

Is there a way i can copy or modify the query of a report that was generated by the system such as Sales analyses or Sales report (Open item list) ? There's times that i do want to add more fields to that report and would be much easier if i could simple copy the query and add the fields i need such as salesperson's field etc or directly modify the query and save as new report? I use SAP Business one and have B1 up addon.

Need urgent help please.

nikunjmehta2290
Participant
0 Kudos

not possible.

Accepted Solutions (0)

Answers (1)

Answers (1)

Abdul
Active Contributor
0 Kudos

You cannot modify system queries, system reports use multiple queries, views and stored procedures. Best way is to write you own query its always flexible to modify a query written by you rather than understanding someone else's query.