cancel
Showing results for 
Search instead for 
Did you mean: 

Using Schedule in Query Manager, SAP Business One

0 Kudos

Hello

I'm sure what I am trying to do is very straight forward and wonder if anyone can help. Basically I have set up a Query in SAP Business One and I want to Schedule this report so it runs every day or every week, but when I go into Query Manager and select the query I want to schedule I get the error message of 'print layout for selected query is missing'.

How do I attach a print layout to a query? I do not want to print anything, all I want is a scheduled data dump of this report straight into .CSV or .XLS etc

Is there any easy way to schedule queries to run at a certain time of the day and take the data into a separate folder, I am not looking for anything complicated like using SAP BPA.

Many thanks, Gareth.

lenastodal
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Gareth,

Thank you for visiting SAP Community to get answers to your questions. I am here to help you to get the most out of it.

First of all, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't done so already), as it provides tips for preparing questions that draw responses from our members.

Please also make sure you're using all appropriate tags, so the right experts can find your question. Overall, the more details you provide, the more likely it is that members will be able to assist you. Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question - but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards,
Lena (SAP Community Moderator)

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos