Acumatica Project Management

 

 

Table of Contents

Request for Information.. 3

Project Issues.. 18

Drawing Logs.. 21

Daily Field Report. 23

Photo Logs. 29

Submittals.. 34

Additional Useful Information.. 35

Projects. 35

Budget Details.. 42

Project Review by Period by Task.. 45

Purchases.. 47

 

 



 

Acumatica Project Management

The documentation below is a quick guide to Acumatica
Project Management module and helpful Project tools.

To begin, navigate to the CCI Acumatica login page. 
The link can be found on the employee home page or here:

https://clawsoncommunications.acumatica.com/Frames/Login.aspx?ReturnUrl=%2f

Once logged in, navigate to the “Project Management” module

You will find several hyperlinks under “Transactions”, all
of which will be useful tools for project tracking.

 

 

 

Request
for Information

The first hyperlink is “Request for Information”

A screenshot of a computer

AI-generated content may be incorrect.

Once you click “Request for Information” you will land on
“All Records” which is a history of all RFI’s.

The columns & viewable data in Acumatica is by default,
but we encourage users to sort the data in each module to their liking. The
process is the same for each module and is as follows:

A screenshot of a computer

AI-generated content may be incorrect.

From here, you will see a list of “Available Columns” on the
left and “Selected Columns” on the right.

A screenshot of a computer

AI-generated content may be incorrect.

To add/remove columns from your view, click the description
then the arrow to the left or right. Only the “Selected Columns” will be
visible in your view. The “Available Columns” descriptions will be hidden
from  your view.

A screenshot of a computer

AI-generated content may be incorrect.

Once you have the “Selected column” descriptions added to
your liking, you can move them up or down in your view using the up/down arrows
on the right side.

A screenshot of a computer

AI-generated content may be incorrect.

You can edit/change your views at any time as you start to
learn what information is important to you and in what order you wish to look
at it. Reminder, you can do this across all modules using the same process.

Back to RFI’s: The landing page will take you to all RFI’s
for all projects. There are a number of ways to sort and search these. If you
are looking for RFI’s for a specific project or owner you can type in the
search bar at the top right. Again, this search is available in all modules
across Acumatica.

A screenshot of a computer

AI-generated content may be incorrect.

In this example we are going to search for project 240248.
Once we enter that (note that it does not have to be an exact match to find
successful results) we can see all RFI’s for the project appear

A screenshot of a computer

AI-generated content may be incorrect.

You can also use the search to look up all RFI’s by owner
(RICHARD MILLER) in this case.  Another way to search RFI’s that you
created is to click from “All Records” to “My Requests”.

A white rectangular object with text

AI-generated content may be incorrect.

Additionally, you can filter any column. For example, if you
want to view “open” RFI’s, click the “Status” column and the below box will
appear:A screenshot of a computer

AI-generated content may be incorrect.

From here, you can “Clear All” statuses and select only
“Open”, or you can individually uncheck “New”, “Closed” and “Is Empty” to get
the same result. You can also sort ascending/descending. Remember these sorting
fields are available across all modules and all columns in Acumatica.

To create a new RFI, click the + sign

A screenshot of a computer

AI-generated content may be incorrect.

The RFI ID will default to “NEW”. 

A screenshot of a computer

AI-generated content may be incorrect.

 

To create the RFI, you will need to complete certain
mandatory fields. The first is “Class ID”. The options here are “Labor”,
“Material” or “Other”.  It is okay to choose any of these three as there
is no right or wrong answer, and does not impact the project revenue or cost
depending on your selection.  It is also a good idea to enter a brief
description in “Summary” as this field is visible in your landing page so it
will help in searching RFI’s after creation.

A screenshot of a computer

AI-generated content may be incorrect.

 

Next you have the option to add priority levels to your RFI.
Default is set to “Medium” but you can change it to “Low” or “High”

A screenshot of a computer

AI-generated content may be incorrect.

The owner information defaults to the user, but is editable

The next required field is the “Project”. You can start
typing either the project number or the project description, or you can click
the scope to the right and will pull up all projects, whether active or
inactive. Select the project. If you select an inactive project, you will see a
yellow warning symbol to the left. When you hover over the symbol it will tell
you that the project is completed and will not be available for data entry.

Project task is an option but not required. It is probably
easier to leave this field blank, but will not hurt anything if you complete
it.

 

 

 

 

 

 

 

 

 

 

 

 

The final required field is the “Contact”. This will be the
person you are addressing your question to.  You can start typing in a
name here or select the scope for a full list of contacts.  Note that ALL
created contacts are located here, not just Clawson employees.  Be
diligent when selecting the contact, be sure to select only a Clawson employee
for the time being. While we may extend the use of this RFI to external
contacts at some point, we are currently using this as an internal tool.

A screenshot of a computer

AI-generated content may be incorrect.

The next part to complete is under the “Details” tab, and
the question you are needing clarified:

A screenshot of a computer

AI-generated content may be incorrect.

You also have the option to note if there is potentially a
change impact to the project, either schedule, cost or design. Click any and
all appropriate boxes.

Next to “Details” you will see “Attributes”; nothing needs
to be done here. Next to “Attributes” you will find “Activities”.  We will
come back to this.

Next to “Activities” is “Relations”. Nothing needs to be
done with this at this time. Finally, next to “Relations” is “Drawings”. 
If there is a drawing that you want to link to the RFI, you will click “Link
Drawing” and the drawing log for this specific project will appear.  If no
drawings have been uploaded for the project, this section will be blank.

A screenshot of a computer

AI-generated content may be incorrect.

You can select the appropriate drawing(s) from the list by
checking the boxes on the left of the drawing log ID. Once you are done, click
“Link & Close” and the drawings will now appear under “Drawings”

A screenshot of a computer

AI-generated content may be incorrect.

You can also attach file(s) to your RFI. Click the “Files”
at the top right of the screen

A screenshot of a computer

AI-generated content may be incorrect.

To locate the file you want to attach, click the “Browse”, select
the file you want to attach then click “Upload”.  It is also good practice
to enter a brief description in the “Comments” next to the file name. This is
especially helpful when you have multiple files to upload so you can easily
select the correct file to view in the future.

A computer screen with a white box

AI-generated content may be incorrect.

Once you have completed all of the information for your RFI,
click the “Save” symbol at the top left.

A screenshot of a computer

AI-generated content may be incorrect.

You will then want to email the RFI to the appropriate
person for a response.

Click the 3 dots next to “PRINT” at the top of the
RFI.  You will have the option to “Email” or “Print”

A screenshot of a computer

AI-generated content may be incorrect.

Select “Email”.

“From” will default to “Accounting”.  Click the scope
to the right and you will see a list of available account email addresses.
Select projects@clawsons.com
“To” will default to the “Contact” you selected for your RFI

A screenshot of a computer

AI-generated content may be incorrect.

Next choose “Select Template”.

A screenshot of a computer

AI-generated content may be incorrect.

The following box will appear:

A screenshot of a computer

AI-generated content may be incorrect.

Click the scope and select the template “E-Mail RFI”

A screenshot of a computer

AI-generated content may be incorrect.

Then hit “Select”

A computer screen with a message

AI-generated content may be incorrect.

You can type in the text box of the email before sending if
you want but it is not necessary. Once you hit Send, the email will go out with
a link to the RFI for receiver’s viewing.

If you now navigate back to the “Activities” tab, you should
see the email activity. The contact can reply directly to the email with the
answer. If they do, you will see their response in the “Activities” tab. The
newest email will be on top

A screenshot of a computer

AI-generated content may be incorrect.

 

 The contact or the owner can enter the
answer/resolution of the RFI in the “Answer” section of the “Details” tab.

A screenshot of a computer

AI-generated content may be incorrect.

Once the RFI has been resolved, it is best practice to close
it out.  We do have the option to simply close it or to convert it to a
change request. For most cases we will simply close it. Should a change request
be necessary, you can always create a new one, it just will not be linked to
the RFI.

 

 

 

 



 

Project
Issues

The next hyperlink is “Project Issues”. Click to open.

A screenshot of a computer

AI-generated content may be incorrect.

The format here is similar to the RFI’s. “All Records” will
default to all project issues. You may search or filter to find a previously
submitted issue. And remember to change your column views to your liking. You
can also select “My Project Issues” and all issues listing you as the owner
will appear.

A screenshot of a computer

AI-generated content may be incorrect.

To create a new issue, click the + sign.

 

 

 

 

 

 

 

The required fields are “Class ID” which are again a choice
of “Labor”, “Material” or “Other”

A screenshot of a computer

AI-generated content may be incorrect.

After choosing the Class ID, the “Priority” will default to
“Medium”. You can change this to “Low” or “High” if necessary.

The only other required field is the Project number. Choose
the appropriate project.

It will be good practice to enter a summary for the issue.
Again, this will help with finding and sorting information.

Another field to consider is the “Project Issue Type”. 
These are things that Acumatica admin users can add/create. There’s only a
handful in there for now but feel free to provide feedback for additional issue
types that you would like to see added.

A screenshot of a computer

AI-generated content may be incorrect.

It is not necessary to enter a Project Task or Workgroup.
Similarly to the RFI module, you are able to check mark if there is a schedule
or cost impact

You will enter details of the issue in the “Details”
section.

Next to “Details” you will note “Activities”, “Attributes”
and “Drawings” which are similar to the RFI module. Link drawings if desired.
You may also attach files at the top of the page if desired.

Upon completion, save your work. You will note that there is
no “Contact” to send the issue to, although you are able to convert it to a RFI
by clicking the “CONVERT TO RFI” at the top. You also have the option to close
it, convert it to a change request or print it. To delete, simply click the
trash can at the top

A screenshot of a computer

AI-generated content may be incorrect.

 

 



 

Drawing
Logs

The next hyperlink is “Drawing Logs”.  This will open
all drawings for all projects. You can again sort by ascending/descending
project, or best practice is to enter the project number in the field at the
top.

A screenshot of a computer

AI-generated content may be incorrect.

Note that the information and success in this module is
highly dependent upon a user taking the time to sort, upload and correctly
label each print. In a perfect world, this is something the office staff will
take care of on behalf of the PM. The new record entry page looks like this:

A screenshot of a computer

AI-generated content may be incorrect.

Required fields are “Drawing Number”, “Title”, “Project” and
“Discipline”. 

To view the drawing, click from the File Name under
“Drawings” tab. You can also find it in the “files” at the top of the page

Note that we are able to export drawings (which will export
to a zip file) or create revisions to drawings by clicking “Create Revision”

A screenshot of a computer

AI-generated content may be incorrect.

You will also note that in each module there are 3 dots to
the right of the toolbar actions. Clicking those dots in the drawing logs
brings up short cuts to “Create RF”, “Export Drawings”, “Create Revision”,
“Create Project Issue” and “Email”

A screenshot of a computer

AI-generated content may be incorrect.

To activate any of these actions, click the blue hyperlink.



 

Daily
Field Report

Daily Field Report is the next hyperlink. Clicking the
hyperlink brings you to the landing page. Similar to the other modules, the
home view defaults to “All Records” with the option to look at “My Daily Field
Reports”

A screenshot of a computer

AI-generated content may be incorrect.

To create a new record, click the + sign.  Enter the
project  number first, then you will be prompted to enter the Project
Manager.

A screenshot of a computer

AI-generated content may be incorrect.

Once you enter the project number & manager, you have a
number of options available to enter data. The first one you see is “Labor Time
and Activities”.  Since we do not track time in Acumatica, we track
through WorkForce Go, do not use this section. You will note that even if you
try to add time here, only your name shows up and you cannot add additional
employees.

The next is “Progress Worksheets”.  This one ties back
to Inventory ID’s so again, do not use this section at this time.

The third section is “Change Requests”. You are able to
refer back to change requests here, but you cannot initiate them here. To refer
back to a created change request, click the + and you must select the reference
number from the available options

The next section is “Change Orders” and behaves just like
Change Requests.

Next is Subcontractors. In order for vendors to appear in
this list, a PO must first be created. If Devin has not created a PO, this
section cannot be used appropriately. If you choose to use this section to
track subs on your job site, first make sure the PO exists (you can tell by
clicking the + sign to create a new record). A list of all vendors linked to
the project will appear.

A screenshot of a computer

AI-generated content may be incorrect.

 

 

 

 

 

 

Select the vendor, then the next required field is the
“Project Task”. If you’re tracking subs, the project task is “S” for
Subcontractor.

A screenshot of a computer

AI-generated content may be incorrect.

You are then able to enter the number of workers, time
arrived and time departed. The “Working Hours” and “Working Hours Total” will
calculate based on your entries.

A screenshot of a computer

AI-generated content may be incorrect.

The next tabs are “Project Issues” & “Photo Logs” which
are again similar to Change Requests/Change Orders where a record must first be
created in order to reference it through Daily Field Report.

Notes is next, and this is where you will primarily live in
Daily Field Reports. To create a new record, click the + and enter a
description/summary. There is a character limit here so do not enter details of
the day here, only a summary. You will then need to save your work. After
saving, you will want to enter details for the day by clicking the piece of
paper next to the paperclip on the left side of the screen. This will bring up
a text box where you can type unlimited characters. You will note that you are
also able to attach files here by clicking the paper clip.

A screenshot of a computer

AI-generated content may be incorrect.

After you’ve entered your note, you can tell it is there
because the piece of paper will now be yellow. This also applies across all
modules in Acumatica

A screenshot of a computer

AI-generated content may be incorrect.

Next to notes is Equipment. This is something we hope to
roll out in the future. You can log hours for equipment such as boring machine,
trencher etc. here. The equipment must first be set up, which is something
admin users must do. If the equipment is listed and you want to use this
feature, it is available for you to do so. You must select the equipment and
project task, from there you can enter Setup Time, Run Time and Suspended Time.
Once you save the data, the system will create an Equipment Time Card.

A screenshot of a computer

AI-generated content may be incorrect.

This would be used if we ever get to the point where we bill
for the use of equipment on an hourly basis. This is not something we do at
this time, equipment is figured in to the estimator’s pricing.

After Equipment is Weather, this is self explanatory and
available for use if you find it helpful.

Next to Weather is Visitors which may be helpful. Start by
clicking the + sign and choose from the available Visitor Types. You must enter
the visitor’s name, arrival & departed times and the reason for visit. You
can also enter the areas visited and add a brief description. You also have the
notes option here if you want to enter more detailed information, as well as
the paperclip to attach a file.

A screenshot of a computer

AI-generated content may be incorrect.

After Visitors is Approvals, there is nothing to do here.

In the above screen shot, Approvals appears to be the last
option, but you will see two arrows pointing to the right set in dark gray.
Across all modules in Acumatica, this signifies additional tabs.

A screenshot of a computer

AI-generated content may be incorrect.

Clicking this tab brings up all remaining/unseen tabs. The
only one left in this module is “History” and there is nothing to do here.



 

Photo
Logs

Photo logs is finally a platform to store pictures that link
to the project! Photo logs view differently on an ipad/mobile device vs a
laptop/desktop.  On a laptop/desktop computer, you’re able to view a photo
preview if it was set up to be the main photo (selecting a main photo is
not required). Choosing a main photo would be useful for organizing photos
within a certain telecom room, for instance. The main photo could be a picture
of the telecom room # with the detailed pictures added inside the photo log.

A computer screen shot of a computer

AI-generated content may be incorrect.

To add a new photo log, click the + at the top of the
screen. Or to view/edit an existing photo log, click the blue hyperlink under
“Photo Log ID”.  Note that you can search photos by project, and you can
also filter photos by any of the available columns.

When creating a new photo log, you must enter the project #
then save your work.

A screenshot of a computer

AI-generated content may be incorrect.

 Once you  have saved your work, navigate to
“Photos”. Adding photos from a laptop/desktop computer is easy. You can drag
and drop them or click to upload

A screenshot of a computer

AI-generated content may be incorrect.

Once you have uploaded your photos, enter a description at
the top of the page for an overall description of this photo log, and it is
best practice to enter a description for each photo, which will help with
organization and searching in the future. Lastly, if you want to make a “main
photo” for the photo log, check the box to the right of that photo

A screenshot of a computer

AI-generated content may be incorrect.

If you are using the web version on your mobile device or
ipad, add photos by clicking “Drag files here or click to upload” and you will
be prompted to choose from your “photo library”, “take photo” or “choose
files”  where you can upload photos straight from your device. From your
mobile device, a thumbnail view of the photo may or may not be viewable. Try
turning your device sideways/landscape and the image may appear to the right.
The images do seem to be easily viewable from a laptop/desktop so we assume
this feature will depend on the user’s screen size.

A screenshot of a computer

AI-generated content may be incorrect.

Clicking on the Photo ID from a desktop or laptop opens a
new tab with the photo and description. If you are on a mobile device, click on
the Photo ID. If nothing happens, you need to allow pop-ups on the device. To
enable pop-ups, follow the instructions below:

Open the Settings app on your iPhone or iPad.

Scroll down and tap on Safari under the "Apps"
section.

Find the Block Pop-ups option.

Toggle the switch off (it should turn gray) to allow
pop-ups.

Once you have allowed pop-ups, you should now be able to
click the Photo ID where you may get a prompt reading “This site is attempting
to open a pop-up window”. Click “Allow” and the device will open a new tab with
the photo.

 



 

Submittals

The final module is submittals. There will not be much to do
here for the time being.



 

 

Additional
Useful Information

Projects

The next sections will help you with general information
about your projects.

The first place to navigate to is in “Projects”

A screenshot of a computer

AI-generated content may be incorrect.

We suggest starring your most used / favorite modules, this
will help with finding them in the future and will also be placed in the
“Favorites” tab for you

A screenshot of a computer

AI-generated content may be incorrect.

There are a LOT of actions available in projects but you
will only primarily only be using a few. The main us under “Profiles” and is
labeled “Projects”. This is where all projects live, both past and present

A screenshot of a computer

AI-generated content may be incorrect.

Once you click on the Projects hyperlink, you will see “All
Records”. Note that by default you can also view “Completed Projects”.

A screenshot of a computer

AI-generated content may be incorrect.

You can use any search and/or filter here for any column.
The General Inquiry that Rick created here will show a lot of information. At a
glance you can see the original bid amount, change order amount, revised bid
amount and total project cost to date, project manager, sales manager as well
as various other information.

Once you locate the project you want and click the
hyperlink, you will be taken to the main project screen. The information in
this module is viewable only, you will note that you cannot add or modify any
information.

There is a lot of data in this module, but you will mainly
be able to look at the file attachments where you should be able to find a copy
of the bid, CO’s, possible materials lists etc. You can find these documents by
clicking the “Files” on the top right of the screen.

 

A screenshot of a computer

AI-generated content may be incorrect.

Another location for valuable information is under the “Cost
Budget” tab. This should give a list of items that Devin has ordered, with
quantities and pricing. You will want to edit your column views in this module
as there are a LOT of options that get quite overwhelming.

Here’s an overview of the different columns that are
probably most needed and a brief description of each. If not listed, it may be
best to hide from your view:

Original Budgeted Quantity: This is the quantity the bidder
has come up with in their initial materials list. This must be entered manually
at project start-up and will not always be available/entered

UOM: Unit of measure

Unit Rate: This is the cost the bidder has in their
BOM

Original Budgeted Amount: This is the budgeted cost
dollar amount (budgeted quantity * unit rate) that the bidder came up with

Actual Amount: This is the actual/invoiced dollar amount to
date

Original Committed Quantity: This is the quantity that was
ordered

Committed Invoiced Quantity: This is the quantity that has
been invoiced and most likely received, or at least has been shipped

Committed Open Quantity: This is the quantity that has not
yet been invoiced, probably not yet shipped

Committed Invoiced Amount: This is dollar amount invoiced to
date

Committed Open Amount: This is the dollar amount that has
not yet been invoiced

You will find that clicking on the blue hyperlink of the
Inventory ID’s is not helpful as it just takes you to the inventory id profile

A screenshot of a computer

AI-generated content may be incorrect.

The next useful tab is under “Commitments”.  This will
take you to PO’s that have been created for the project.

A screenshot of a computer

AI-generated content may be incorrect.

Clicking on the hyperlink of the “Order Nbr” is helpful as
it will open a new tab and take you right to the PO. You can view the all items
that were ordered on that PO, the part number, description, quantity ordered,
quantity billed etc. There are again several available columns for view in this
section, I’d suggest changing the view to something similar to:

Inventory ID

Line Description

UOM

Order Qty

Unit Cost

Ext. Cost

Billed Qty

Unbilled Qty

Billed Amount

Unbilled Amount

Those items should be sufficient for your needs but feel
free to add additional items if you find them helpful

A screenshot of a computer

AI-generated content may be incorrect.

The “Invoices” tab is what we have invoiced to the customer.
This is probably not useful to you, but the info is there.

Another potential useful tab is “Change Orders”. Currently
only change orders that have been approved are entered here, pending CO’s will not
be entered at this time. Clicking on the hyperlink for the CO Reference Nbr
will open a new tab where you can view the revenue lines of the CO and a copy
will be attached to the files.

A screenshot of a computer

AI-generated content may be incorrect.

The final potentially useful piece of info is “Addresses”
which can usually be found by clicking the two arrows to the right which
reveals additional tabs

A screenshot of a computer

AI-generated content may be incorrect.

This is where the project address can be found, but *should*
also be located on the bid



 

Budget
Details

The next section that will have useful information is
located under “Inquiries” and is called “Budget Details”. 

The Budget Details landing page will take you to All
Records. For this module, navigate over to “Active Labor Budget Summary”

A screenshot of a computer

AI-generated content may be incorrect.

This is a General Inquiry that Rick has created for tracking
labor hours. To find a specific project, search the project in either the top
search box or the one at the top right (it is generally easier to use the one
on the right)

A screenshot of a computer

AI-generated content may be incorrect.

Once you’ve entered your project number, it is suggested
that you adjust your view to the following:

Original Budgeted Quantity – this is the quantity of labor
hours that were bid for the project and is a manual entry

Actual Quantity – this is the quantity of labor hours used
to date after payroll has been posted

Percentage – this is the percentage of labor hours used. The
system is set so once a percentage reaches 80%, it is flagged and turns red.

Original Budgeted Amount – this is the original dollar
amount budgeted for labor

Revised Budgeted Amount – this is the revised dollar amount
budgeted for labor

Actual Amount – this is the dollar amount used to date

A screenshot of a computer

AI-generated content may be incorrect.

Note that this number is not synced up with WFG time sheets
until after payroll has been processed and the transaction has been posted into
Acumatica. Typically this will happen on Wednesday mornings. If you have
temp / non-payroll employees, their time is entered when the invoice from the
placement agency is entered.

It is possible that when you enter your project number you
will see two lines. The original budgeted quantity will only be on one line but
Actual Quantity will be on two. To get the total hours used to date, you must
add these two numbers together.  This is something that we discovered a
few months ago and has to do with how temp agency invoices are entered. We have
since changed our processes so all labor hours drop in on the same line, but
there are lingering projects out there.

A screenshot of a computer

AI-generated content may be incorrect.

 

 



 

Project
Review by Period by Task

The next section that will have useful information is located
under “Inquiries” and is called “Project Review by Period by Task”

A screenshot of a computer

AI-generated content may be incorrect.

Clicking on this hyperlink will take you to a blank page. To
get the data, you must first select a “As of Period” at the top of the page.
Select the most recent month/year

A screenshot of a computer

AI-generated content may be incorrect.

The default will again list all projects, both active and
complete. To locate your project, search it in the tool bar at the top right

A screenshot of a computer

AI-generated content may be incorrect.

This General Inquiry that Rick created will give you a
breakdown of revenue and expenses to date, by task. Here is a quick guide to
the “Task ID”:

3 = Other

4 = Mileage

E = Equipment / lift rental

F = Freight

L = Labor

M = Material

S = Subcontractor

This tool summarizes our revenue to date (what we have
invoiced) and our expenses to date by task. At the bottom you will find a
summary of each.

A screenshot of a computer

AI-generated content may be incorrect.

 



 

Purchases

Navigating to the Purchases module will take you to
PO’s.  Under “Transactions, click on “Purchase Orders

A screenshot of a computer

AI-generated content may be incorrect.

If you’re looking for PO’s for a specific project, enter the
project in the search bar at the top right

A screenshot of a computer

AI-generated content may be incorrect.

All PO’s will show up here. As mentioned earlier, you can
also locate these in “Projects” under “Commitments”

Just as with the Projects module, the information here is
informational only and should never be edited or deleted.