About Common Features of PJC Transactions Screens
This topic introduces some common elements shared by all Project and Job Costing transaction screens—once you know how to enter transactions using one screen, the operation of other transaction screens will seem very familiar.
Note: For transaction details, the fields that appear and which ones you can edit depend on the contract and project type used in the detail.
Common Fields
All transaction screens 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 methods.
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 screen, except for the Charges screen, 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 screen, you enter a payroll expense account to credit. The account specified for the project category is used as the default. (Sage 300 Payroll debits the account when you post the timecard in that program.)
- Employee Expense Account. On the detail Timecard - Expense screen, 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 screen. 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 screen. 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 screen 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 screen 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 screens except in Material Usage and Material Returns screens. 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 screen or from the Post Transactions screen.
- 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 screen), 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 screen, 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.
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/Taxes screens
You can view and enter transaction details on the detail table that appears in each transaction entry screen, or you can use a separate detail entry screen that you open by clicking the Edit Details button on the transaction screen. Entering details on the Detail/Taxes screens provides the following advantages over the detail entry table on the transaction screen:
- You can view all the information for a single detail at once.
-
For time and materials projects and for fixed price projects that use an item invoice type, you can view and enter information for taxes that apply to the customer. This information is in a table, which includes the following fields:
- Tax Authority. The tax authority code and description comes from the tax group for the customer or for the contract (if you changed the tax group for the contract). You cannot change it.
- Tax Class. By default, the tax class code and description is set as follows (but you can change it):
- If one or more tax authorities are assigned to the item in Accounts Receivable, the tax class from the A/R item record is used.
- If no tax authorities are assigned to the item in Accounts Receivable, the customer tax class for the inventory item is used.
- If the item does not use a customer tax class, the default tax class of 1 is used.
- Tax Included. By default, this status is set as follows (but you can change it if the tax authority permits):
- If one or more tax authorities are assigned to the item in Accounts Receivable, the Tax Included status from the A/R item record is used.
- If no tax authorities are assigned to the item in Accounts Receivable, the Tax Included status is set to No.