Skip to main content

Set Up a Project's Cost Codes

Limit a project to its own list of cost codes or phase codes, so people can only pick codes that belong to that job. Covers project-specific codes.

Written by Gabby Gutman

Give a project its own list of cost codes, and phase codes if your company uses them. Once a project has a list, people working on it can only pick codes from that list.

Before you start

  • An Admin must turn on Project Specific Cost Codes in Company Settings, on the Cost Codes tab. For phase codes, Independent Phase Codes and Project Specific Phase Codes must both be on as well.

  • Cost codes are available on some plans. Check with your account team.

  • You need to be able to edit the project's settings. The Admin and Purchaser roles can by default. Your role also needs permission to manage materials, or you see the list but not the buttons.

  • The codes must already exist in your Material Database. Nothing on this screen creates a code.

How the list works

  • A project with no list shows All cost codes available. It can use every code except restricted ones.

  • A project with a list shows Limited to and the number of codes. Only those codes can be used on it.

  • A restricted code carries a lock icon in the Material Database. Only the projects listed on that code can use it.

Steps

  1. Open Projects in the top navigation bar.

  2. Click the gear icon on the project. Its tooltip reads Edit project settings.

  3. Find Allowed cost codes in the Cost codes section.

  4. Click Limit to specific cost codes, or Edit list if the project already has one.

  5. Tick the codes this project can use. Search by code, description or tag to find them.

  6. Click Selected to check only the codes you ticked.

  7. Click Save with the count, for example Save 12 cost codes.

  8. If a warning opens, read it, then confirm or click Go back.

  9. Click Save Changes at the top of the page.

Upload a list instead of ticking

The drawer has an Upload row. Drop a file on it, or click it to choose one.

  • CSV, XLSX and XLS files work, up to 2 MB or 10,000 rows.

  • Each row needs the SubBase ID or the code itself. Point at the info icon next to Upload to see the columns your company needs.

  • The file replaces the codes already ticked. The drawer says so: This will overwrite the selected cost codes.

  • Codes in the file that are not in your active list are shown under Not in your active catalog, nothing is created: and skipped.

  • Remove file clears the file card. The codes it ticked stay ticked.

Set up a project from the Material Database

You can do the same from the code list, one project at a time. Material Database is only in your menu if your role can edit the material database.

  1. Click your name in the top navigation bar, then Material Database.

  2. Open the Cost Code tab.

  3. Click Set up a project's codes.

  4. Pick the project under Choose a project.

  5. Tick the codes or upload a file, then click Save with the count.

This saves straight away, with no Save Changes step. SubBase confirms with a message such as Saved 12 cost codes, followed by the project name.

Phase codes

If your company uses project-specific phase codes, the section also has Allowed phase codes and is titled Cost and phase codes. It works the same way: click Limit to specific phase codes, tick the codes, save the drawer, then click Save Changes. From the Material Database, use Set up a project's phase codes on the Phase Code tab.

What happens next

On this project, the cost code pickers only offer codes on the list. That covers orders, RFQs, material requests, inventory requests, commitments and invoices. If someone tries to save a line with a code the project does not allow, SubBase stops the save with a message that starts Cost code filtering is enabled. Codes already saved on documents stay as they are.

What removing codes or allowing all does

  • Removing a code from the list stops it being picked on this project. Orders and other documents that already use it keep it. Adding it back makes it available again.

  • If a code you removed has already been used on this project, a warning lists where before anything is saved. Go back keeps the list as it was. Confirm and remove goes ahead.

  • Giving a list to a project that allowed every code shows a warning that the project allows every cost code today. Confirm and limit makes every code not on the list unavailable on that project.

  • Allow all deletes the project's list, and the project can use every unrestricted code again. SubBase does not keep the old list. To get it back, pick or upload it again.

  • If every code on the list has been archived, the status reads Limited to archived cost codes and no code can be used. Click Allow all or pick active codes.

Restrict one code to certain projects

To keep one code off every project except a few, open the code in the Material Database, switch on Restrict to specific projects and pick the Projects. The other codes on those projects do not change. The code then shows a lock icon with the tooltip Restricted: only the projects listed here can use this cost code.

Notes and limits

  • In a project's settings, the drawer's Save only fills in the form. Nothing is stored until you click Save Changes.

  • From the Material Database, the drawer saves as soon as you click Save.

  • By default, only an Admin can change the settings on the Cost Codes tab in Company Settings.

Best practices

  • Click Save Changes after the drawer closes. If you leave the page first, the list you picked is lost.

  • Change a project's list from the project, not from a code's Projects field. That field notes that Listing a project limits it to its listed codes. A project that allowed every code drops to that one code.

  • Build an upload from your downloaded cost code list and delete the rows you do not need. A file without the columns your company needs is refused with a message that it is missing a column this company needs.

  • To change a few codes, use Edit list rather than Allow all. Allow all deletes the list, and you rebuild it by hand.

If this doesn't work

Start a chat from the Messenger in the bottom-left of this page, or email [email protected]. Include the order or project number and what you expected to happen.

Related

Did this answer your question?