Scheduled Worksheets

Jun 10, 2005 8 Replies

There needs to be a way to schedule a recurring worksheet, i.e. a worksheet 250 every night at 7:30p.m.? We have purchasers that edit so many part numbers and prices a day, they forget to send a worksheet down to the stores for every item. If we could generate a recurring scheduled worksheet every day for all items after hours, this would solve our problem.


---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.



formatting link


You can solve your problem also with sql job..

antonio

You must insert data into [Worksheet], [WorksheetStore], [WorksheetHistory] and WorksheetItem for 250/260, and Worksheet_ItemPrice, ItemCost... ItemTax for sales information..

Do you need of more detail?

antonio

You can add to Worksheet_Item only items modified..

Antonio

Antonio,

I was just wondering if you would be able to create an Only Modified Item's Worksheet that can be scheduled to run everyday. In your previous post on this matter you give the information, but I am very new to SQL and definitely like some more information on doing this.

Rob F,

I know this post was a year ago but if you got this worksheet to work please share it with me. I would greatly appreciate it. I cannot believe that there are not more post on this problem. I would think that everyone would want RMS to automatically update the store items from the HQ Manager.

Thanks in advance for any help you can provide.

Neil T

"Ant> Rob F. wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required