Using the Transaction Forms

Sage ERP Accpac Project and Job Costing 6.0

Using the Transaction Forms

This topic introduces some common elements shared by all Project and Job Costing transaction forms — once you know how to enter transactions using one form, the operation of other transaction forms will seem very familiar.

All transaction forms have the following fields in common:

The A/R Item Number is used on item invoices. Item invoices are used in billing for time and materials projects and, if you choose, for fixed price projects that use the accrual-basis or billings and costs accounting method.

Accounts Receivable requires an A/R item number for these types of invoices.

On standard projects, the item number specified for the resource appears as the default. On basic projects (which do not track resources), the item number specified for the category appears as the default.

You can edit this field only for details for time and materials projects and fixed price projects that use an item invoice type. For cost plus and other fixed price projects, this field is blank and you cannot enter an item number.

This field appears for time and materials projects and for fixed price projects that use the billings and costs or accrual-basis accounting methods. The program multiplies the amount you enter in this field by the quantity to calculate the extended billing amount.

If you use multicurrency, you enter the billing rate in your customer's currency.

For time and materials projects, and for fixed price projects that use the accrual-basis or billings and costs accounting methods, the program displays the billing type for the category (on a basic project) or resource category (on a standard project) as the default.

You can edit the Billing Type field only if the category or resource category is billable.

The program displays the amount calculated for the billing rate and quantity you entered.

If you use multicurrency, the program displays the extended billing amount in your customer's currency.

If you change the extended billing amount, the program adjusts the billing rate accordingly.

The program calculates the extended cost using the unit cost and quantity you entered. If you edit the extended cost amount, the program recalculates the unit cost based on the new extended cost.

If you use multicurrency, the program displays the extended cost in your functional currency.

Each transaction form, except for the Charges form, displays the expense account, work in progress or cost of sales account, and the overhead accounts that will be affected when you post the transactions in General Ledger:

Payroll Account. On the detail Timecard - Time form, you enter a payroll expense account to credit. The account specified for the project category is used as the default. (Sage ERP Accpac Payroll debits the account when you post the timecard in that program.)

Employee Expense Account. On the detail Timecard - Expense form, you enter the account to credit for an expense (such as transportation, hotel, or meals) for which you are reimbursing an employee. The program uses the account specified for the project category as the default.

Equipment Account.The program displays the equipment account specified for the project category on the Equipment Usage form. This is the account you credit when you transfer the costs of equipment that you own to a project. Normally, you would use some kind of contra equipment account.

Inventory Control Account. This field appears in the Material Usage form. The program displays the account specified for the item in Inventory Control, and you cannot change it.

Work In Progress Account/Cost Of Sales Account. The program displays default accounts, as follows:

  • For all fixed price projects and for cost plus projects using completed project, total cost percentage complete, or labor hours percentage complete, the work in progress account is set by the project, and you cannot change it.

  • For cost plus projects using category percentage complete, the work in progress account is set by the category, and you cannot change it.

  • For cost plus projects using the billings and costs accounting method, the work in progress account is set by the category, and you cannot change it.

  • For cost plus projects using the accrual-basis accounting method, the cost of sales account is set by the category, and you cannot change it.

  • For time and materials projects using the completed project or billings and costs accounting method, the program displays the default work in progress account for the category. You can change the work in progress account.

  • For time and materials projects using the accrual-basis accounting method, the program displays the default cost of sales account from the category. You can change the cost of sales account.

The Charges form includes none of the general ledger accounts mentioned above. The only accounts affected by charges are the billings and revenue accounts specified for the project. (The Charges form lets you charge projects for services or fees. Charge transactions do not involve a cost to you, so there are no costs or expenses to transfer to projects.)

You can enter up to 5 decimals for the quantity in all transaction forms except in Material Usage and Material Returns forms. In material usage and material returns transactions, you can use the number of decimals permitted in your Inventory Control system.

A transaction can have one of the following statuses:

  • New status is used as the default status.

  • Approved status indicates that a transaction is ready for posting. You can post a transaction either from the source transaction form or from the Post Transactions form.

  • Ready For Approval status lets employees who enter their own timecards indicate that their timecard is ready for approval and posting. This status is available only for timecards.

You use this field to enter or select the date on which you are processing a transaction. The program displays the session date as the default, but you can change it.

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

Depending on your selection for the Default Posting Date option (in the PJC Options form), either the session date or the document/transaction date may be used for the posting date.

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.

The program updates the Year/Period field to correspond with the posting date.

The unit cost specified for the category (for basic projects) or for the resource (for standard projects) appears as the default unit cost.

On standard projects, the unit of measure from the resource appears as the default; on basic projects, the unit of measure from the project category appears.

The fields that appear and which ones you can edit depend on the contract and project type used in the detail

When entering transactions in Project and Job Costing, you can enter details on the detail entry grid provided with all transaction forms, or you can enter them on a separate detail entry form that you open by clicking the Detail/Tax button on any transaction form. The detail entry forms include additional fields for changing accounts and tax information.

Multicurrency

In multicurrency systems, you do not enter currency or exchange rate information with transactions. Instead, you enter amounts in your functional currency, and Project and Job Costing uses the current exchange rate at the time of billing. If no current rate exists for that date, the program uses 1.0000000 as the default rate.

Detail/Tax forms

The transaction forms also let you open Detail/Tax forms where you can view existing details or enter new details for the transaction. Entering details on the Detail/Tax forms provides two advantages over the detail entry grid on the transaction form:

  • You can view all the information for a single detail at once.

  • In addition to the detail fields that appear on the main transaction form, the form also displays tax fields for time and materials projects, as follows:

  • Tax Authority and Description. The program displays the tax authority and description from the customer record.

  • Tax Class and Description. The program displays the tax class from the A/R item record.

If no tax authorities are assigned to the A/R item, the customer tax class is used, if there is a corresponding item tax class for the tax authority (in Tax Services). If there is no matching tax class in Tax Services, the tax class "1" is used.

You can change the tax class for the detail.

  • Tax Included. If tax authorities are assigned to the item, the Tax Included status from the A/R item record is used as the default for this field. Otherwise, No is the default. You can change the tax-included status for the detail, if the tax authority permits it.