1. Home
  2. Point-Of-Sale Software
  3. Automatic Worksheet 250

Automatic Worksheet 250

Looking for a way to issue a complete worksheet 250 to run in the middle of the night when all stores are closed. Found some threads that people were talking about this but nothing that tells someone how to do it. I am aspiring to be better with SQL scripting but I am still a newbie to SQL. Not sure if maybe there is a batch file that I could create to do this, like I have made to backup the database every night. If someone knows of a way to do this please let me know I would greatly appreciate it. I have 3 stores and am using RMS Ver 1.3R, I doubt that matters just letting everyone know what I am working with.

Thanks in advance.

Neil

Reply to
nt8378
Loading thread data ...

I guess no one uses automatic 250 worksheets or everyone knows how to make them and I am in the dark.

nt

"nt8378" wrote:

Reply to
nt8378

Can u please explain it further? do u want to automatically create 250? what is your criteria? LastUpdated?

Reply to
Nashat

Thank you for your response. I was thinking about doing an entire 250 for all Suppliers. However if the database ever got too large it would be a good idea to have it do just LastUpdated items. I am mainly looking for a bone dry structure to follow and I could tweek it as I went. If you know how to make a worksheet run on a schedule please let me know. Thanks again.

Neil

"Nashat" wrote:

Reply to
nt8378

i have a job that creates 250 worksheets based on the LastUpdated field, it could be changed to look any other field, is it what u need? or u r much interested in the worksheet effective time?

Reply to
Nashat

Nashat,

Please send me your job that you created on the worksheet 250. It just may be what I am looking for. I would greatly appreciate it. My e-mail is snipped-for-privacy@kidsstuffsuperstore.com Thank you again for your reply.

Sincerely, Neil

"Nashat" wrote:

Reply to
nt8378

could I have a copy of the auto 250 worksheet too?

I'm very new to RMS (2-3 weeks), so just learning. How do I "get in" to the system to make changes in SQL (new to SQL too, I have a book, and want to be able to make these changes)

thanks

snipped-for-privacy@connaught-house.co.uk

Reply to
chris allsopp

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.