Working with 6-Project Management > 6-5 Cost Codes > Importing cost divisions

Importing cost divisions

If you have a cost division list from another source, you can import it. Arrange the data in the following order: Division# and Description. Then save the file using a comma delimited (*.cma), tab delimited (*.tab), or comma-quote (*.qte) format. You can also copy and paste from a spreadsheet using the clipboard (Ctrl+C, Ctrl+V).

Important!

You must import cost codes separately and after you have imported cost divisions.

Cost Division is a required entry. You cannot save data in the 6-5 Cost Codes window without inserting cost divisions.

To import cost divisions:

1 Open 6-5 Cost Codes.
2 In the Division column, click in a cell.
3 Right-click the cell, then click Display Detail/Add Record.
4 The Cost Divisions window appears.
5 On the File menu, point to Open, and select the type of file you want to import.
6 Select the file you want to import, then click Open.
7 Sage 100 Contractor imports the cost divisions file into the Cost Divisions window.
8 Save the Cost Divisions window.
9 In 6-5 Cost Codes, click in a cell in the Division column, then click the drop-down arrow.
10 The Cost Divisions window appears.
11 Double-click the cost division you want to insert into the 6-5 Cost Codes window.
12 Click Save.

Links to more information...