Material Usage Field List

Sage ERP Accpac Project and Job Costing 6.0

Material Usage Field List

Enter a description of the use of the material using up to 60 characters.

When you enter a new transaction, the program displays ***NEW*** in this field. Accept this entry to let Project and Job Costing assign the next number for material usage transactions (specified on the Options form) when you add the transaction.

To view an existing transaction, use the navigation buttons next to the field to display the number for the material usage transaction you need.

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

It indicates whether material usage optional fields have been assigned to the selected transaction.

Click the Zoom button beside the field to open a separate Optional Fields form where you can view or edit the optional fields assigned to the transaction.

If any material usage optional fields are set up for automatic insertion, they are assigned to any new material return transactions you add, along with the default values specified in optional field setup records.

You can edit or delete the optional fields that appear, and you can add different optional fields that are defined for material usage.

If you assign to the detail the same optional fields use for Inventory Control shipment transactions — and you chose the optional field setting to pass optional fields to Inventory Control — the optional field entry will be passed to Inventory Control when you post the transaction.

Enter a reference for this material usage transaction using up to 60 characters.

This field lets you select one of two statuses for a transaction:

  • New. If you are entering a new transaction, accept this default status.

  • Approved. When you have finished entering information for the transaction, you can change the status to Approved, indicating that it can be posted.

After you add a new transaction (by clicking the Add button), the program changes the status to Entered. You can change the status from Entered to Approved if you want to indicate that the transaction is ready for posting.

The program assigns Posted status once you post the transaction.

The program calculates and displays the sum of the detail billable amounts for the transaction in this field. You cannot change it.

Note:This figure is a hash total. In a multicurrency system, detail amounts are not converted to any one currency. Therefore, the total may consist of mixed currencies.

The program calculates and displays the sum of the detail costs for the transaction in this field. You cannot change it.

The program calculates and displays the sum of the detail quantities for the transaction in this field. (The figure is a hash total.) You cannot change it.

Select the date that you are processing the transaction.

Depending on the selection for the Default Posting Date option (on the PJC Options form), the transaction date may be used as the posting date for the transaction.

The program displays the year and period that contains the date to which the transaction will be posted.

Project and Job Costing uses the transaction/document date or the session date as the default posting date, depending on your choice for the Default Posting Date option on the PJC Options form.

If you want to change the posting date, click the Zoom () button beside the Year/Period field to open the Posting Date Override form, and then change the posting date as required.

Note: If you consolidate G/L transactions by Account And Fiscal Period or by Account, Fiscal Period And Source, the posting date for consolidated entries is the last date of the fiscal period.

Detail Material Usage/Taxes

If the detail is for a time and materials project or a fixed price project that uses an item invoice type, enter the A/R Item number to be shown on the invoice for this cost.

If the detail is for a time and materials project or a fixed price project that uses an item invoice type, enter the unit of measure specified for the item in Accounts Receivable.

The unit of measure is used on the invoice for the material.

This field is used only for time and materials projects and for some fixed price projects. You can use it to specify the rate at which to bill for each allocated unit of measure.

Project and job Costing uses the allocated quantity and the billing rate to calculate the extended billing amount for the detail, and displays the amount in the customer's currency.

Alternatively, you can enter the amount to bill in the Extended Billing Amount field. The program then calculates the billing rate for you based on the extended billing amount and the allocated quantity.

If you specify a different unit of measure, Project and Job Costing recalculates the billing rate and extended billing amount using the conversion factor for the material item.

Depending on the project type and accounting method for the selected project, the program displays the billing type from the project category (on a basic project), or the resource category (on a standard project).

For time and materials projects and for fixed price projects that use a billings and costs or accrual-basis accounting method, if the category or resource category is billable, you can change the billing type to non-billable or no charge.

You cannot change the billing type for fixed price or cost plus projects.

Select the category you are charging for the use of the material.

You can enter a comment for each detail using up to 250 characters.

Select the contract you are charging for the use of the material.

The program displays the cost of sales account specified for the category for projects that use the accrual-basis accounting method.

(For other accounting methods, the program displays the work in progress account from the project or the category.)

You can change the account for any project that uses the accrual basis accounting method.

This field is used only for time and materials projects and some fixed price projects. (In multicurrency ledgers, the amount is shown in the customer's currency.)

You can use this field to enter the amount to bill the customer for this cost. The program recalculates the billing rate for the quantity and unit of measure you entered.

Alternatively, if you enter a rate in the Billing Rate field the program calculates the extended billing amount.

If you specify a different unit of measure, Project and Job Costing recalculates the billing rate and extended billing amount using the conversion factor for the material item.

You can enter an extended cost only for items that have a User Specified costing method in Inventory Control.

For all other costing methods, the extended cost is calculated during day end processing.

The program displays the inventory account assigned to the item in Inventory Control.

Enter or select the Inventory Control number used to identify the item. (Note that the Finder displays only items assigned as material to the project.)

Enter or select the unit of measure to use in transferring the item to the project (for example, Each or Box). You can enter or select only units of measure used for the item in Inventory Control.

The program assigns a unique line number to identify the detail.

Accept the line number displayed, or click the New button to start a new detail.

Enter the Inventory Control location from which you want to transfer the item.

If you use Sage ERP Accpac Transaction Analysis and Optional Field Creator, the Optional Field column on the detail entry grid and the Optional Fields indicator on the Detail Material Usage/Taxes form indicate whether material usage detail optional fields have been assigned to a selected material usage detail.

To open a separate Optional Fields form that lets you view or edit the optional fields assigned to a detail:

  • On the detail entry grid, either double-click the field for a selected detail, or select the detail, and then press Shift+F9 on your keyboard.

  • On the Detail Material Usage/Taxes form, click the Zoom button beside the Optional Fields check box.

If any material usage detail optional fields are set for automatic insertion, they appear for new details, along with the default values specified in the optional field setup records.

You can edit or delete the optional fields that appear, and you can add different optional fields that are defined for material usage details.

If you assign the same optional fields to the material usage details as you use for shipment details in Inventory Control — and you specified in the setup record that data for this optional field will pass to Inventory Control — the entries will be passed with the details to Inventory Control.

This field appears if the selected project uses a price list for the default billing rate. (You can specify a price list for projects that use an item invoice type.)

The program displays the price list specified for the project as the default, but you can change the price list for the transaction.

To use a different price list, type the code for the price list in this field, or use the Finder to select it.

Select the project you are charging for the use of the material.

Enter the number of units (specified by the unit of measure you specify next - for example, Hours) of material you are charging on this detail.

These fields appear only for time and materials projects and for fixed price projects that use an item invoice type.

The program displays the tax authorities and descriptions for the tax group used in the customer record or for the contract, if you changed the tax group for the contract. You cannot change the tax authorities for the transaction.

These fields appear only for time and materials projects and for fixed price projects that use an item invoice type.

You can change the tax class that appears as the default. The program displays the:

  • Tax class from the A/R Item record, if tax authorities are assigned to the item.

  • Customer tax class for the inventory item, if no tax authorities are assigned to the A/R item.

  • Default tax class (1), if the item does not use a customer tax class.

If tax authorities are assigned to the item used in this detail, the program displays the Tax Included status from the A/R Item record.

If no authorities are assigned to the item, the default is No. You can change the tax-included status, if the tax authority permits.

You can enter a unit cost only for items that have a User Specified costing method in Inventory Control.

For all other costing methods, the unit cost is calculated during day end processing.

Depending on the project type and the accounting method, the program displays the work in progress account from the contract project or the category.

The program displays the work in progress account specified for the:

  • Project, for fixed price projects and for cost plus projects using the completed project, total cost percentage complete, or labor hours percentage complete accounting methods.

  • Category, for cost plus projects that use the category percentage complete or billings and costs accounting methods, and for time and materials projects that use the completed project and billing and costs accounting methods.

You can change the account only for projects that use an item invoice type.

(For projects that use the accrual-basis accounting method, this field is named Cost Of Sales Account, and the cost of sales account specified for the category appears.)