Create Billing Worksheet Field list

Sage ERP Accpac Project and Job Costing 6.0

Create Billing Worksheet Field list

 

This option lets you create invoices by:

  • Customer— This option generates one invoice (of each invoice type, as necessary) that includes all billable amounts for each customer. The invoice can include different contracts and projects for the customer.   

  • Contract— This option generates a separate invoice for each contract.

  • Project— This option generates a separate invoice for each project.

 

The program uses a cutoff date to determine which costs and charges to include, and to determine completion percentages for the project or category (depending on the accounting method used).

 

Enter a description for the invoice batch.

 

Enter or select the date to be used on the invoice.

 

Select this option to create invoices for customers whose accounts are on hold.

 

Select this option to include invoice details for contracts that are on hold.

 

Select this option to create invoices for customers whose accounts are inactive.

 

This option is available only if you are creating a worksheet with item details (for time and materials projects).

If you select the option, the program includes on the billing worksheet non-billable transactions that were posted to billable categories (for basic projects) and billable resource categories (for standard projects).

You can review and, if necessary, change the billing type for these transactions on the billing worksheet before posting the worksheet. Project and Job Costing sends only billable transactions to Accounts Receivable.

 

Select this option to include invoice details for projects that are on hold.

 

This option is available only if you are creating a worksheet with item details.

Select this option to include invoice details for transactions that are on hold.

 

Select this option to include details for fixed price projects whose fixed price amount is zero.

 

Select the type of invoice batch you want to generate.

  • Select Item to create invoices for time and materials projects and for fixed price projects that use an Item invoice type.

  • Select Summary to create invoices for all other project types.

  • Select Both to create both types of invoices (for all project types).

 

If you use retainage accounting in Accounts Receivable and you have a multicurrency system, you use the Retainage Exchange Rate field to specify the method the program will use to determine the exchange rate for the retainage document when you process the outstanding retainage.

Project and Job Costing displays the option you set in Accounts Receivable, but you can change it. You can select:

  • Use Original Document Exchange Rate, to use the same rate as used for original documents (the transactions for which you are now billing).

  • Use Current Exchange Rate, to use the rate in effect when you process the retainage document for the outstanding retainage.

The option you select appears as the default for each invoice you create from the worksheet, but you can change it for particular invoices in Accounts Receivable.

 

Specify up to four selection criteria to further define the range of invoices to create. You can specify a range of account sets, customer numbers, project types, contracts, projects, and categories.

 

If you chose Transaction Date, this field appears to let you specify the cutoff transaction date.

 

If you chose Year/Period in the Cutoff By field, this field appears, letting you select the cutoff year and period.

 

The program displays the year and period to which the worksheet entries will be posted.

The year and period corresponds to 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.