Material Returns Field List

Sage ERP Accpac Project and Job Costing 6.0

Material Returns 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 return 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 return transaction you need.

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

It indicates whether material returns 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 you set up any material returns optional fields 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 returns.

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 return 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 Returns/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 return. (Normally, you would enter the A/R Item number used on the material usage transaction that transferred the item to the project.)

Enter the unit of measure from Accounts Receivable to be used on the invoice for this material return.

This field, together with the Extended Billing Amount field, is used only for time and materials projects and fixed price projects that use an item invoice type.

You can use this field to enter the rate at which to credit the customer for this cost in the Billing Rate field. The program calculates the amount to bill the customer for the charge.

Alternatively, you can enter the amount to credit the customer for the charge. The program then calculates the billing rate for you, based on the extended billing amount and the quantity you entered.

Depending on the project type and accounting method, 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. Make sure you use the same billing type that was used to transfer the material to the project in the original material usage transaction.

You cannot change the billing type for fixed price projects that use a summary invoice type or for cost plus projects.

Select the category to credit for the return of the material.

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

Select the contract to credit for the return of material to inventory.

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

(For other accounting methods, the program displays the work in progress account from the project or the category, rather than the cost of sales account.)

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

This field, together with the Billing Rate field, is used only for time and materials projects and fixed price projects that use an item invoice type.

You can use this field to enter the amount to credit the customer for the return. The program then calculates the billing rate for you, based on the extended billing amount and the quantity you entered.

Alternatively, you can enter the billing rate in the Billing Rate field, then let the program calculate the amount credit bill the customer for the return of material.

When you tab out of the Unit Cost field, the program displays the extended cost it calculates for the quantity and unit cost you entered. If you enter a different extended cost and tab out of the field, the program recalculates the unit cost for you.

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 for transferring the item back to inventory (for example, Each). 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 to which you want to return the item.

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 crediting for the return of the material.

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 Returns/Taxes form indicate whether material return detail optional fields have been assigned to a selected material returns 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 Returns/Taxes form, click the Zoom button beside the Optional Fields check box.

If any material return detail optional fields are set up 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 return details.

If you assign the same optional fields to the material return 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.

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

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

The program displays the tax authorities and descriptions from the customer record. You cannot change them.

These fields appear only for time and materials projects and 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.

The program displays as the default unit cost the most recent unit cost used for the item in Inventory Control. Enter the unit cost you used to transfer the item to the project. (To check the unit cost, display transactions for the contract, project, category, and resource in Transaction History.)

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.)