Scheduled Worksheets

Posted by Rob F.ùØ¬rë,Š‰ìš'+¢ÊµÊ& on June 10, 2005, 9:01 am

Please log in for more thread options

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.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=f8d824ab-fae7-45f2-8615-734f10f4c397&dg=microsoft.public.pos

Posted by Antonio Mazzeo on June 10, 2005, 8:16 pm

Please log in for more thread options

Rob F. wrote:

> 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.

You can solve your problem also with sql job..

antonio

Posted by Rob F.ùØ¬rë,Š‰ìš'+¢ÊµÊ& on June 10, 2005, 11:25 am

Please log in for more thread options

You wouldn't so happen to know how sql a worksheet would you, I am very
proficient with SQL, I just didn't know I could generate a worksheet from a
SQL script?!

"Antonio Mazzeo" wrote:

> Rob F. wrote:

> > 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.

> You can solve your problem also with sql job..

> antonio

Posted by Antonio Mazzeo on June 11, 2005, 2:51 pm

Please log in for more thread options

Rob F. wrote:

> You wouldn't so happen to know how sql a worksheet would you, I am very

> proficient with SQL, I just didn't know I could generate a worksheet from a

> SQL script?!

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

Posted by Rob F.ùØ¬rë,Š‰ìš'+¢ÊµÊ& on June 13, 2005, 4:33 am

Please log in for more thread options

No, that should work just fine, thanks for the example.

"Antonio Mazzeo" wrote:

> Rob F. wrote:

> > You wouldn't so happen to know how sql a worksheet would you, I am very

> > proficient with SQL, I just didn't know I could generate a worksheet from a

> > SQL script?!

> 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