Reopen Projects Worksheet Field List

Sage ERP Accpac Project and Job Costing 6.0

Reopen Projects Worksheet Field List

 

 

This column shows the accounting methods used by the projects that appear on the worksheet.

 

This column shows the contract for which you are reopening projects. (This is the contract you specified when you created the worksheet.)

 

The program displays the description you entered for the selected worksheet on the Create Reopen Projects Worksheet form.

You can edit the description for the worksheet, if you want.

 

The program assigns a sequential line number to each project on the worksheet. You cannot change it.

 

The Optional Field column on the worksheet grid indicates whether reopen projects optional fields have been assigned to a project you are reopening.

To view or edit the optional fields assigned to a detail, double-click the field, or select the project on the grid and then press Shift+F9 on your keyboard. If any reopen projects 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 reopen project entries.

If you assign to worksheet details same optional fields that are used for transactions for the account in General Ledger, and if the optional field is set up to pass information to the General Ledger accounts, the optional field values will be passed with the transactions to General Ledger.

 

Initially, the Project column shows the range of projects selected for reopening on the Create Reopen Projects Worksheet form when the worksheet was created.

To delete any project in the range, simply select the project on the grid, then press the Delete key on your keyboard. When you delete a detail line, the program also deletes any general ledger entries, and the status of the project will not be changed when you post the worksheet.

 

The Project Type column shows the project type for each project that appears on the worksheet.

Reversing entries may be required to reopen a particular project, depending on the project type and the accounting method it uses.

 

The program displays the date and the fiscal year and period you specified on the Create Reopen Projects Worksheet form.

 

The worksheet number is assigned when you create the worksheet.

  • Use the navigation buttons or the Finder beside the worksheet number field to display the worksheet you want to view, edit, or post.

  • To create a new worksheet, click the New () button beside the Worksheet Number field. The Create Reopen Projects Worksheet form opens, letting you specify the contract projects to reopen.

  • To delete a worksheet, display the worksheet, then click the Delete button on the worksheet form.

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

 

GL Entry Details

This field shows the description specified in General Ledger for the account.

 

This field shows the accounting method for the project specified in the worksheet detail.

 

This field appears only in a multicurrency system.

For the billings and sales accounts, amounts are posted in both customer and functional currency, while amounts are posted to the work in progress and cost of goods sold accounts in functional currency, only.

 

This field shows the amount that will be debited (in functional currency, in a multicurrency system) to the sales and work in progress accounts for the worksheet detail.

If the customer currency is different from your functional currency, amounts are posted to the billings and sales accounts in both customer (source) and your functional currency.

Amounts are posted to the work in progress and cost of goods sold accounts in functional currency. (The amounts in the "source" column are the same, for these accounts.)

 

This field shows the amount that will be credited (in functional currency, in a multicurrency system) to the billings and cost of goods sold accounts for each worksheet detail.

If the customer currency is different from your functional currency, amounts are posted to the billings and sales accounts in both customer (source) and your functional currency.

Amounts are posted to the work in progress and cost of goods sold accounts in functional currency, only.

 

This field shows the rate used in the entry to recognize revenue when the account was originally closed.

 

This field shows the rate date used to determine the exchange rate for the entry to recognize revenue when the account was originally closed.

 

This field shows the rate type used to determine the exchange rate for the entry to recognize revenue when the account was originally closed.

 

This column appears only in a multicurrency system.

It shows the amounts that will be credited, in source currency, to the billings and costs of goods sold accounts.

If the customer currency is different from your functional currency, amounts are posted to the billings and sales accounts in both customer (source) and your functional currency.

Amounts are posted to the work in progress and cost of goods sold accounts in functional currency. (The amounts in the "source" column are the same, for these accounts.)

 

This column appears only in a multicurrency system.

It shows the amounts that will be debited, in source currency, to the work in progress and sales accounts.

If the customer currency is different from your functional currency, amounts are posted to the billings and sales accounts in both customer (source) and your functional currency.

Amounts are posted to the work in progress and cost of goods sold accounts in functional currency. (The amounts in the "source" column are the same for these accounts.)