Rabu, 25 Mei 2011

Re: [MS_AccessPros] Re: Setting up a work order module

 

Excellent idea, I am going to incorporate that.

With warm regards,

Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
 
1316 E. 7th Street
Sioux Falls, SD  57103  
SQL Server Development
Database Adminstration Services
Microsoft Access Development  
Grant Writing TA Services
IT Assessment Services
Software Application Training

From: Pamela Zimmerman <pzimmer@eci-consulting.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, May 25, 2011 11:26 AM
Subject: RE: [MS_AccessPros] Re: Setting up a work order module

 
Hi Art-

Instead of 'ServiceRequested' text field consider converting that to a
service memo field and adding a Service table with a drop down, so that over
time you would be able report/assess the type of work being done in
aggregate. I might even add a ServiceGroup table and assign each service a
group such that might be useful for you in negotiating contracts, looking at
trends, etc. For example plumbing (service group) and sink plugged, toilet
broken, washer not draining, etc. (services belonging to that group).

In terms of time, if you have start time and end time could you calculate
time rather than store a value in the totalTime field? It has been my
experience that storing anything that can be calculated usually leads to
problems.

Pam

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
Sent: Wednesday, May 25, 2011 10:54 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Setting up a work order module

Art: For once I shall attempt to contribute Instead of Just asking.

I think You may have to account for more than one employee on some jobs
(moving furniture maybe or a safety man when playing with electrical) and
that will require tracking time/cost for 2 or more people.

If You contract out often you may want a tblContractors with the usual
information maybe fed by a small tblContractorType to populate a drop down
field on the tblContractor (electrical, HVAC, Landscape, etc) and then a
tblContractDetail with :
WorkOrderID; linked from tblWorkOrder
Contract/InvoiceNumber;
ContactDate;
ContactWho;
ContactBy; linked to Employee table
Estimate; If supplied
SchedStartDate;
ActStartDate;
SchedCompletion;
ActCompletion;
OnBudget: You can track contractor performance on the last 5 fields
TotalCost; link to tblworkorderdetail.costContractedWork
Possibly add an attachment field (2007>) to scan a copy of the invoice so
you don't have to hunt for it in the file cabinet.
And Insert into the tblworkorderdetail the Contractor ID/Name field linked
from tblContractor

Hope This is helpful just my 2 cents worth
Walter Griffin

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Art"
<dbalorenzini@...> wrote:
>
> I am working on setting up a work order module for our unit manager
database. Structually I am thinking the following:
>
> tblWorkOrder
> WorkOrderID
> UnitID - the unit the workorder is tied to
> ScheduleID - link to schedule lookup table (Morning, Noon, Evening
> EstStartDate
> EmployeeTookCallID - link to employee table
> PermissionToEnterFlag
> TenantID - link to the Contact table
> ServiceRequested
>
> tblWorkOrderDetail
> WorkOrderDetailID
> WordOrderID - ties the detail record to the WorkOrder record
> Quantity
> Material/Service
> UnitCost
> TotalAmount
> CostContractedWork
> PerformedByID - link to Employee table
> DateCompleted
> InspectedByID - link to contact table
> DateInspected
> TimeStarted
> TimeEnded
> TotalTime
> TotalMateriaLabor
>
> That is all I can think of. Any more ideas? Does someone have an better
structure than this that they could share with me.
>
> Thank you
>
> Art Lorenzini,
> Sioux Fall, SD
>

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

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar