Limit access to Shop employee table

You are correct. We put this rate in at the Employee Master level. You
could also accomplish the same thing by putting a rate at the operation
level, but I am pretty sure the operation rate takes priority. That would
mean that no matter how high your shop employee's rate might be, the
operation would be costed at the rate put in for the operation. You should
double check me about all that, though.

Nora Story
Spectra Technologies, Inc.
817-540-4475, ext. 105
Nora_Story@...
We only want a couple people to have access to the shop employee
table since it contains hourly rates. I have already limited access
to Shop Employee on the Master File menu to security managers.

The problem is with Report Builder since anyone who can create a
report can access the Shop Employee table and print out the hourly
rates. I believe that there is also a problem with the Vantage
Export utility.

I would appreciate any ideas on the best way to do this.

Thanks.

Brent O'Donnell
Take away their report builder toys and their Export access. I mistakenly
showed one of our VP's how to use the export and have regreted it ever
since. You wouldn't believe the amount of worthless data is spewed out.
Make them believe that only those with magical powers can use those tools
for good and not for evil.

Shirley Graver
Systems Administrator
Rubber Associates Inc.
Cleveland/Akron, OH


-----Original Message-----
From: vtaeroman [mailto:brento@...]
Sent: Tuesday, April 02, 2002 11:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Limit access to Shop employee table


We only want a couple people to have access to the shop employee
table since it contains hourly rates. I have already limited access
to Shop Employee on the Master File menu to security managers.

The problem is with Report Builder since anyone who can create a
report can access the Shop Employee table and print out the hourly
rates. I believe that there is also a problem with the Vantage
Export utility.

I would appreciate any ideas on the best way to do this.

Thanks.

Brent O'Donnell


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
Don't forget that anyone with access to the cost portion of job tracker
could do the math to determine any shop employee's rate. For this reason we
chose to go with a few standard rates based on job function.


Nora Story
Spectra Technologies, Inc.
817-540-4475, ext. 105
Nora_Story@...


> -----Original Message-----
> From: vtaeroman [mailto:brento@...]
> Sent: Tuesday, April 02, 2002 10:30 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Limit access to Shop employee table
>
>
> We only want a couple people to have access to the shop employee
> table since it contains hourly rates. I have already limited access
> to Shop Employee on the Master File menu to security managers.
>
> The problem is with Report Builder since anyone who can create a
> report can access the Shop Employee table and print out the hourly
> rates. I believe that there is also a problem with the Vantage
> Export utility.
>
> I would appreciate any ideas on the best way to do this.
>
> Thanks.
>
> Brent O'Donnell
>
>
Interesting.

How do you then reconcile your job labor costs to your payroll labor costs?
I suppose any differences are captured through a labor price variance; is
that correct? If so, is it then safe to say that your managers are somewhat
sophisticated with respect to managerial accounting procedures?

Regards,
Scott A. Lepley
Systems Administrator
Mauell Corporation
31 Old Cabin Hollow Road
Dillsburg PA 17019-8815
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...

-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Tuesday, April 02, 2002 12:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Limit access to Shop employee table

Don't forget that anyone with access to the cost portion of job tracker
could do the math to determine any shop employee's rate. For this reason we
chose to go with a few standard rates based on job function.


Nora Story
Spectra Technologies, Inc.
817-540-4475, ext. 105
Nora_Story@...


> -----Original Message-----
> From: vtaeroman [mailto:brento@...]
> Sent: Tuesday, April 02, 2002 10:30 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Limit access to Shop employee table
>
>
> We only want a couple people to have access to the shop employee
> table since it contains hourly rates. I have already limited access
> to Shop Employee on the Master File menu to security managers.
>
> The problem is with Report Builder since anyone who can create a
> report can access the Shop Employee table and print out the hourly
> rates. I believe that there is also a problem with the Vantage
> Export utility.
>
> I would appreciate any ideas on the best way to do this.
>
> Thanks.
>
> Brent O'Donnell



[Non-text portions of this message have been removed]
I understand that there are different ways companies handle the difference
in applied labor versus actual labor. You will always have the differences
between your labor rate and actual rate on any overtime hours. We have the
added issue for salaried engineers that work more than 40 hours a week on
job-related functions. You want to see the actual hours for future quoting
benefits, but they won't get actual pay, but may or may not take comp time
off some time in the future, etc.

I think most companies evaluate the difference for reasonableness (is that
really a word?) whether or not they journalize it. This is something we
will probably evaluate more in the future.
Nora Story
Spectra Technologies, Inc.
817-540-4475, ext. 105
Nora_Story@...
Nora,

In your original message, you stated "for this reason we chose to go with a
few standard rates based on job function." I'm still curious about how you
actually implement this, given the way Vantage calculates the labor costs
or, at least, the way I believe it does. I'm assuming that Spectra simply
stores a certain standard rate (based on average rates for a work center or
on a job classification/pay scale system or some other method) in the labor
rate field for each employee in the employee master record. I don't know of
any other way to achieve what you're doing; if there is one, I'd be happy to
hear about it.

Regards,
Scott

Question: How are job costs updated?

Actual costs are posted to manufacturing jobs through procedures in several
modules. Costs are posted to one of four cost categories; Labor, Burden,
Material and Subcontract.
Labor and Burden costs are posted through labor transactions entered in Data
Collection or through Labor Entry in the Job Management module. Labor costs
are calculated by multiplying the labor hours recorded times the Labor Rate
stored in the employee master record. Burden costs are calculated by
multiplying the burden (machine) hours recorded times the Burden Rate stored
in the work center master record.
Material costs are posted when you issue materials to jobs in the Inventory
Management module, or enter PO or miscellaneous material receipts to jobs in
the Shipping/Receiving module. Subcontract costs are updated when you enter
PO or miscellaneous subcontract receipts to jobs.
Purchased material and subcontract costs will be adjusted if necessary
through the Accounts Payable module. When you receive the invoice from your
vendor, the actual cost will be compared to the PO cost. Any variance will
be recorded on the job.

SEE ALSO:

How are material quantities updated to jobs?

Vantage Help 5.10, Release E


-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Tuesday, April 02, 2002 1:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Limit access to Shop employee table

I understand that there are different ways companies handle the difference
in applied labor versus actual labor. You will always have the differences
between your labor rate and actual rate on any overtime hours. We have the
added issue for salaried engineers that work more than 40 hours a week on
job-related functions. You want to see the actual hours for future quoting
benefits, but they won't get actual pay, but may or may not take comp time
off some time in the future, etc.

I think most companies evaluate the difference for reasonableness (is that
really a word?) whether or not they journalize it. This is something we
will probably evaluate more in the future.

Nora Story
Spectra Technologies, Inc.
817-540-4475, ext. 105
Nora_Story@...


-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Tuesday, April 02, 2002 12:29 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Limit access to Shop employee table

Interesting.

How do you then reconcile your job labor costs to your payroll labor costs?
I suppose any differences are captured through a labor price variance; is
that correct? If so, is it then safe to say that your managers are somewhat
sophisticated with respect to managerial accounting procedures?

Regards,
Scott A. Lepley
Systems Administrator
Mauell Corporation
31 Old Cabin Hollow Road
Dillsburg PA 17019-8815
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...

-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Tuesday, April 02, 2002 12:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Limit access to Shop employee table

Don't forget that anyone with access to the cost portion of job tracker
could do the math to determine any shop employee's rate. For this reason we
chose to go with a few standard rates based on job function.

Nora Story
Spectra Technologies, Inc.
817-540-4475, ext. 105
Nora_Story@...




[Non-text portions of this message have been removed]