Categories List Fields

Sage ERP Accpac Project and Job Costing 6.0

Categories List Fields

If you use retainage accounting in Accounts Payable, this field contains the retainage percentage that will be used when paying invoices that include the selected category.

The program displays as the default the retainage percentage specified in the vendor record or the project category, depending on your selection for the Default Retainage From field.

If you use retainage accounting in Accounts Payable, this field contains the retention period that will be used when paying invoices that include the selected category.

The program displays as the default the retainage percentage and retention period specified in the vendor record or the project category, depending on your selection for the Default Retainage From field.

This field displays the accumulated total amount of posted cost transactions.

This field displays the accumulated total quantity based on posted cost transactions.

This field displays the codes for the categories you have added to the selected project.

The Category field also lets you assign a category to a project that has an Estimate status.

To assign a category

  1. Press the Insert key to start a new line.

  2. Use the Finder in the Category field to choose the code for the category you want to add to the project.

  3. If you are using a separate Categories form (you didn't display the form using the tree), click Close to close the Categories form.

  4. Click Save to save the changes to the contract.

The program displays the total committed quantities from purchase orders posted for the category in Sage ERP Accpac Purchase Orders.

The program increases the committed quantity when you post purchase orders and returns in Sage ERP Accpac Purchase Orders, and decreases the quantity when you post receipts.

Project and Job Costing is also updated when you change a quantity on a purchase order

When you post a job-related receipt, Purchase Orders reverses the committed quantity in Project and Job Costing, and updates the actual quantity for the received amounts. It also records any additional quantities you post with receipts.

The program displays the total committed costs (purchase orders) posted for the category in Sage ERP Accpac Purchase Orders.

The program increases the amount of committed costs when you post purchase orders and returns in Sage ERP Accpac Purchase Orders, and decreases the amount when you post receipts.

Project and Job Costing is also updated when you change any of the following amounts on a purchase order:

  • Change in quantity.

  • Change in cost.

  • Adding new detail lines.

  • Deleting a detail line or a purchase order.

  • Change in exchange rate.

  • Change in tax rates.

When you post a job-related receipt, Purchase Orders reverses the commitments in Project and Job Costing, and updates the actual costs for the received amounts. It also records any additional costs you post with receipts.

This field displays the cost type for the selected category.

This field shows the current estimated cost for the category.

The program uses the cost plus percentage for calculating billings and revenue for cost plus projects.

The cost plus percentage for the project appears as the default for the category for fixed price and cost plus projects.

As long as a project has an Estimate status, you can enter a different percentage. When you enter resource estimates for the project, the program calculates and displays the amount of revenue the category will generate using the new cost plus percentage.

On a basic project, you can enter the revenue amount you require and let the program calculate the cost plus percentage for the category.

This field shows the current estimated quantity for the category.

This field determines whether Accounts Payable will use the retainage options specified for the vendor in Accounts Payable, or for the project category on the contract. You can choose Category or Vendor.

This field displays the description for the selected category.

When you assign a category to a project, the program displays the default labor percentage from the category record.

While the project has an Estimate status, you can change the labor percentage for the category.

When you assign a category to a project, the program displays the default labor rate from the category record.

While the project has an Estimate status, you can change the labor rate for the category.

When you add a category, the program displays the labor type from the category record as the default.

While the project has an Estimate status, you can change the labor type for the selected project category. You can choose:

  • None

  • Flat Rate Per Labor Hour/Unit

  • Percentage of Labor Cost

The program assigns a sequential line number to each category you assign to a project. You cannot change it.

This column appears only if you use Sage ERP Accpac Transaction Analysis and Optional Field Creator.

If you set any category optional fields for automatic insertion for a particular category, the field is selected for that category.

To view the assigned optional fields, select the category on the grid, then click the Optional Fields column header or press the Shift + F9 keys.

You edit or delete any automatically inserted optional fields on the Optional Fields tab of the Category Maintenance form, and you can add different optional fields that you have defined for categories.

Optional field entries from the category setup record appear as defaults when you add a new category to a project. If an automatically assigned optional field is not used in the category setup record, the default entry from the optional field record appears. You can accept or change the default entries.

This field shows the cost originally estimated for the category.

On basic projects, you can edit the amount while the project has an Estimate status.

On standard projects, the field shows the total cost from all project resource to which the category is assigned.

This field appears for fixed price and cost plus projects.

When you assign a category to a project, the program displays the cost plus percentage for the project as the default. While the project has Estimate status, you can change the cost plus percentage for an individual category.

This field displays the original labor amount calculated for the estimate based on the quantity and labor percentage or the flat rate you entered.

This field displays the original overhead amount calculated for the estimate based on the quantity and overhead percentage or the flat rate you entered.

This field shows the quantity originally estimated for the category.

On basic projects, you can edit the quantity while the project has an Estimate status.

On standard projects, the field shows the total quantity from all project resource to which the category is assigned.

This field shows the revenue originally estimated for the category, in your functional currency.

This field shows the revenue originally estimated for the category, in the customer (source) currency.

When you assign a category to a project, the program displays the default overhead percentage from the category record.

While the project has an Estimate status, you can change the overhead percentage for the category.

When you assign a category to a project, the program displays the default overhead rate from the category record.

While the project has an Estimate status, you can change the overhead rate for the category.

When you add a category, the program displays the overhead type from the category record as the default.

While the project has an Estimate status, you can change the overhead type for the selected project category. You can choose:

  • None

  • Flat Rate Per Unit

  • Percentage of Cost

This field displays the Accounts Payable outstanding retainage amount for the project category.

The field is updated automatically when you post, in Accounts Payable, an original invoice, credit note, debit note, or adjustment that includes retainage for these project types and accounting methods. It is also updated when you post a retainage invoice, credit note, or debit note to clear outstanding retainage payable. You cannot edit the field.

The amount is displayed in the functional currency.

This field displays the outstanding receivable retainage amount for the project category. The field appears only for the following project types and accounting methods:

  • Time and materials projects.

  • Cost plus projects that use the billings and costs, category percentage complete, or accrual-basis accounting method.

  • Fixed price projects that use a billings and costs or accrual-basis accounting method.

The field is updated automatically when you post, in Accounts Receivable, an original invoice, credit note, debit note, or adjustment that includes retainage for these project types and accounting methods. It is also updated when you post a retainage invoice, credit note, or debit note to clear outstanding retainage receivable. You cannot edit the field.

The amount is displayed in the source (customer) currency.

The program displays the estimated revenue calculated for the selected category.

If you use multicurrency accounting, note that the revenue amount is displayed in the customer currency.

The program displays the total cost calculated for the category based on the quantity and extended cost.

If you use multicurrency accounting, note that the cost amount is displayed in your functional currency.