Billing Worksheet Field List

Sage ERP Accpac Project and Job Costing 6.0

Billing Worksheet Field List

 

This field lets you change the A/R account for the invoice that is generated for the billing worksheet detail in Accounts Receivable.

Project and Job Costing uses the A/R account set specified for each project as the default on new worksheets, but you can change the account set for individual worksheet details.

 

The program displays the customer currency for each invoice included on the worksheet.

 

The program displays the customer number for each invoice included on the worksheet.

 

The program displays the customer name for each invoice included on the worksheet.

 

The program displays the description you entered for the worksheet when you generated it using the Create Billing Worksheet form, but you can change it.

 

The program displays the document amount for each invoice included on the worksheet.

 

The program displays the document date you specified when you created the worksheet using the Create Billing Worksheet form.

 

The program displays the exchange rate to be used on each invoice included on the worksheet, using as the default the exchange information you specified for the project in the contract record.

You can change the exchange rate to be used for an invoice, if necessary.

 

The program displays the invoice type you specified when you created the billing worksheet. The invoice type can be Summary, Item, or Both.

 

The program automatically assigns a line number to each invoice it includes on the billing worksheet. You cannot change the line number.

 

This field indicates that billing optional fields have been assigned to a selected billing worksheet.

Click the Zoom button beside the field to view or edit the assigned optional fields. If you set up any billing optional fields for automatic insertion, they appear on the form that opens, 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 billings.

If you assign the same optional fields to the worksheet as you use for invoices in Accounts Receivable, and you selected the optional field settings to pass optional field information to Accounts Receivable, the entries will be used for the invoice in Accounts Receivable.

 

The program displays the rate date to be used on each invoice included on the worksheet, using as the default the exchange information you specified for the project in the contract record.

You can change the exchange rate to be used for an invoice, if you want.

 

The program displays the rate type to be used on each invoice included on the worksheet, using as the default the exchange information you specified for the project in the contract record.

You can change the rate type to be used for an invoice, if you want.

 

The program fills in the tax group specified for the project on the Contract Maintenance form. If no tax group is specified for the project, the tax group used in the customer record appears.

Project and Job Costing creates a separate line for each tax group used in a contract, ensuring that a separate invoice is generated for each tax group in a contract billing.

If the tax group for the project uses a different currency than the customer's currency, the program fills in the tax reporting information to be used to convert amounts to the tax reporting currency on the Accounts Receivable invoices.

 

Project and Job Costing fills in these tax reporting fields if the currency for the tax group specified for the project is different from the customer’s currency.

The Tax Reporting Currency is the currency used by the specified tax group for the entry. The Tax Reporting Rate Type, Tax Reporting Rate Date, and Tax Reporting Exchange Rate are used to convert invoice amounts from the customer's currency to the tax reporting currency.

 

When you generate a worksheet using the Create Billing Worksheet form, the program assigns a unique number to identify the worksheet.

You use the Worksheet Number field to select the worksheet that you want to view or edit.

 

The program displays the year and period to which the worksheet entries will be posted, and are determined by the posting date used for the billing worksheet.

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.

Details

For time and materials projects and fixed price projects that use an item invoice type, the program displays the A/R item number used on the original transaction detail. You cannot change it.

 

For time and materials projects and fixed price projects that use an item invoice type, the program displays the A/R unit of measure used for the original transaction detail. You cannot change it.

 

The program displays the description for the account used for the original transaction detail. You cannot change it.

 

The program displays the accounting method for the project used on the invoice detail. You cannot change it.

 

The program displays the billing type for the detail.

For a time and materials project, if the project, category, and (on standard contracts) resource are all billable and you included non-billable transactions when you created the worksheet, you can change a non-billable transaction to billable on the worksheet.

Otherwise, you cannot change the billing type.

 

Information that is included with an invoice detail depends on the project type and the accounting method. The category is included for:

  • Time and materials projects.

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

  • Fixed price projects that use the billings and costs or accrual-basis accounting methods.

 

The program displays the comment used with the original transaction detail. You can change it for the invoice detail, if you want.

 

The program displays the code for the contract used on the original transaction detail. You cannot change it.

 

The program displays the customer number for the invoice. You cannot change it.

 

The program displays the description for the category used on the original transaction detail. You cannot change it.

 

For item invoices, these fields show you the type and the document number for the underlying transaction for which you are billing.

The Module field shows the source of the transaction.

The program calculates the extended amount in functional currency for customers who use your functional currency.

 

In a multicurrency system, the program calculates the extended amount in source currency for customers who use a currency that is different from your functional currency.

 

The program displays the billings account specified for the project. You cannot change it.

 

For item invoices, this field shows you the source ledger for the underlying transaction.

The Document Number and Document Type fields help complete the audit trail.

 

The Optional Field column on the detail grid indicates whether billing detail optional fields have been assigned to a selected billing detail.

To view or edit the optional fields assigned to a detail, double-click the field for a selected detail, or select the detail, and then press Shift+F9 on your keyboard. If any billing detail optional fields are set up for automatic insertion, they appear on the Optional Fields form that opens, 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 billing details.

If you assign the same optional fields to worksheet details as you use for invoice details in Accounts Receivable, and you selected the optional field settings to pass optional field information to Accounts Receivable, the entries will be used for invoice details in Accounts Receivable.

 

For cost plus and fixed price projects that use a percentage complete accounting method, the program calculates the percentage complete but you can change it for a particular invoice.

 

This field identifies the project that is being billed.

 

The program displays the type of project used for the detail.

 

For time and materials projects and fixed price projects that use an item invoice type, the program displays the quantity used in the original transaction detail, but you can change the quantity billed for a particular detail.

The quantity is used in calculating the extended amount for the invoice detail.

 

Information that is included with a detail depends on the project type and the accounting method.

The resource is included for time and materials projects and for standard, fixed price projects.

 

The program displays the retainage percentage you specified for the contract project as the default, but you can change the retainage percentage for each billing detail.

When you post the worksheet, Project and Job Costing sends to Accounts Receivable invoices that include the retainage percentage for each detail.

Accounts Receivable calculates the retainage amount using the retainage percentage specified in Project and Job Costing, the detail amount, and your selection for the Base Retainage Amount On option (Document Total After Taxes or Document Total Before Taxes).

 

The program displays the retention period you specified for the contract and project as the default, but you can change the retention period for each billing detail.

When you post the worksheet, Project and Job Costing sends to Accounts Receivable invoices that include the retention period for each detail.

 

For time and materials projects and for fixed price projects that use an item invoice type, you can set this field to On Hold, if you do not want to bill for a particular transaction at this time.

 

For time and materials projects, the program displays the date for the original transaction you are now billing.

 

For time and materials projects and billings and costs projects that use an item invoice type, the program displays the unit price used in the original transaction detail, but you can change the quantity billed for a particular invoice detail.

The quantity is used in calculating the extended amount for the invoice detail.