PJC Adjustments Screen
This is an internal number that the program assigns to identify the sequence in which all adjustment transactions are entered.
Enter a description for the transaction.
This field indicates whether optional fields are assigned to the currently selected document or transaction. If any optional fields are set up for automatic insertion, this field is selected when you add a new document/transaction.
To view or edit optional fields for the current document/transaction on the Optional Fields screen, click the Zoom button beside the field.
If you assign the same optional fields as you use for adjustments in Inventory Control, and you use the setting (on the PJC Optional Fields screen) to send optional fields to Inventory Control, optional field information is sent to Inventory Control when you post adjustments to material usage or material return transactions.
Enter a reference for the transaction.
Transactions can have the following statuses:
- New. When you are entering a new transaction, accept this default status.
- Entered. When you add a transaction, its status changes from New to Entered.
- Approved. When you finish entering information for a transaction, you can change its status to Approved, indicating that it can be posted.
- Posted. When you post a transaction, its status changes to Posted.
Enter the date when you are processing the transaction. (The session date is used by default, but you can change it.)
Note: Depending on the Default Posting Date setting on the Transactions tab of the PJC Options screen, the date in this field may be used as the default posting date.
This field displays the year and period that contains the posting date. The posting date is set by default as either the session date or the transaction date, depending on the Default Posting Date setting on the Transactions tab of the PJC Options screen.
You can change the default posting date using the Posting Date Override screen, which you open by clicking the button beside the Year/Period field.
Note: If you consolidate G/L transactions by Account and Fiscal Period or by Account, Fiscal Period, and Source, the posting date for consolidated entries is the last date of the fiscal period.
Adjustment Details
Select Adjustment or Transfer in this field.
- Select Adjustment to adjust the A/R item number, the unit of measure and the unit cost (for "non-material" transactions), the quantity, extended cost, and billing rate for a posted transaction.
- Select Transfer to transfer a transaction to the correct contract, project, or category, if the original transaction was posted incorrectly.
The A/R item number from the original transaction is displayed only for time and materials projects and fixed price projects that use the accrual-basis or billings and costs accounting method.
You can change the item number only for adjustments, not for transfers.
If the detail is for a time and materials project or for a fixed price project that uses an item invoice type, enter the unit of measure that is specified for the item in Accounts Receivable.
For cost plus projects or for fixed price projects that use a summary invoice type, you can use the field to enter any additional information.
You can accept or change the unit of measure only for adjustments, not for transfers.
This field appears in multicurrency ledgers.
For time and materials projects and for fixed price projects that use an item invoice type, this field displays the customer currency for the billing amount.
For time and materials projects and fixed price projects that use an item invoice type, the program displays the billing rate from the original transaction. You can change the billing rate only for adjustments, not for transfers. For all other project types, the field is blank.
This field displays the billing type for the original transaction.
You cannot change the billing type for transfers.
You can change the billing type for adjustments if the project and category are billable, but only for:
- Time and materials projects.
- Fixed price projects that use the accrual-basis or billings and costs accounting method.
Enter, or select, the category you are adjusting, or from which you are transferring.
For Transfer adjustment types, the field is named Original Category.
Enter or select the contract for which you are entering the adjustment or from which you are transferring.
For Transfer adjustment types, the field is named Original Contract.
This field displays the cost class for the Adjust To Category you specified.
This field displays the customer number.
Enter or select the document number of the posted timecard, equipment, or charge transaction for the specified contract, project, category, and resource.
Note: You cannot enter a transaction that originated in Accounts Payable or a transaction that has been billed in Accounts Receivable.
The program displays Timecard, Equipment, Material Usage, Material Return, Cost, or Charge, depending on the type of document you selected in the previous field.
If you are adjusting a timecard detail for a non-labor category, the employee number from the original timecard appears in this field. You cannot change this field.
This field appears if you are adjusting a timecard detail for employee earnings.
The program displays the earnings code that was used on the timecard, but you can change the code in the Revised column, if necessary.
If you are adjusting a timecard detail for a non-labor category, the program displays the expense code that was used on the timecard in the Original column.
You can change the expense code in the Revised column, if necessary.
For time and materials projects and fixed price projects that use a billings and costs or accrual-basis accounting method, the program displays the extended billing amount from the original transaction.
If you change the billing rate or the quantity, the program recalculates the extended billing amount.
In multicurrency ledgers, the program displays the billing amount in the customer currency.
The program displays the extended cost amount from the original transaction, plus or minus any posted adjustments.
For an adjustment, the program calculates and displays a new extended cost if you change the quantity or if the unit cost is different from the original transaction.
You can change the extended cost for an adjustment to an equipment usage, material usage, material return, or timecard transaction. The program will then recalculate the unit cost based on the extended cost you enter.
If the original transaction was a charge, the field is blank and you cannot change it.
You cannot change the field if you are transferring the transaction.
Adjustments to material usage and material return transactions are also posted as adjustments in Inventory Control.
For items using the FIFO or LIFO costing method, Inventory Control keeps track of the order in which units arrive at a location by storing each item's receipt date, receipt number, quantity, and extended cost in individual "buckets."
For inventory items that use the FIFO or LIFO costing method, you need to specify how adjust the cost of the items in Inventory Control. You can choose:
- Offset Bucket. Adjust only the offset bucket. (An offset bucket is used if you shipped more items than there were in stock at an inventory location. Offset buckets contain a quantity and a cost, but do not contain a date or receipt number).
- Specific Bucket. Select a specific receipt that contains the cost and quantity information for the transaction. Each bucket (apart from the offset bucket) is associated with a receipt number.
- Prorate. Prorate the adjustment across all buckets (including the offset bucket) for the item at the location. The number of units and the amount of cost prorated to each bucket is based on the quantity in each bucket.
If you are adjusting a material usage or material return transaction, and you selected Specific Bucket as the bucket type for an item that uses a LIFO or FIFO costing method, select the document number that was used to enter the item into inventory.
This field displays the transaction date used in the transaction you are adjusting or transferring. You cannot change it.
This field displays the location used for the original transaction, if you are adjusting or transferring a material usage or material return transaction. You cannot change it.
The program displays the unit of measure used for the item in Inventory Control. You cannot change it.
The program calculates the labor amount for the adjustment based on quantity you enter and the unit cost.
Note: The percentage or amount could be different on the contract, project, and category to which you transfer a transaction.
This field displays the labor rate or percentage used for the project category in the original and the revised columns.
Line numbers are assigned automatically, and you cannot change them.
You use line numbers to identify details you have entered.
Enter or select the project you are adjusting or from which you are transferring. You must have assigned the project to the specified contract, and the project must be open or on hold.
For Transfer adjustment types, the field is named Original Project.
If you use optional fields, you can review and edit optional fields by clicking the Optional Fields column heading. (If you are using the detail screen, click the Zoom button beside the Optional Fields option.)
If an optional field is required, you cannot save the transaction unless the field has a default value, or until you fill in the field yourself.
To add optional fields that were not automatically inserted, press the Insert key to add a new line to the table, and then use the Finder to select an optional field.
Optional fields must be assigned to transactions using the PJC Optional Fields screen before you can add them to individual transactions. For more information, see PJC Optional Fields Screen.
For material usage and material return adjustments, if you assign the same optional fields as you use for adjustments in Inventory Control, and you use the setting (on the PJC Optional Fields screen) to send optional fields to Inventory Control, optional field information is sent to Inventory Control when you post the adjustments.
For other (non-material) adjustments, if you assign the same optional fields as you use for an affected account's transaction details, and you specified in the setup record that data for the optional field will be sent to the General Ledger account, optional field information is sent to General Ledger when you post the adjustments.
If you are transferring a timecard detail that used a non-labor category, the program displays the employee number from the original timecard in this field.
The program calculates the overhead amount for the adjustment based on the quantity you entered and the unit cost.
Note: The percentage or amount may be different on the contract, project, and category to which you are transferring a transaction.
This field displays the overhead rate or percentage used for the project category in the original and the revised columns.
The program displays the original quantity entered on the transaction plus or minus any posted adjustments. You can change the quantity only for adjustments, not for transfers.
Note: For charge transactions, the quantity is set to one, and you cannot change it.
On a standard project, enter or select the resource you are adjusting or from which you are transferring. On a basic project, you can enter a resource, or leave the field blank.
For Transfer adjustment types, the field is named Original Resource.
If you are transferring a cost, enter or select the category to which to transfer the transaction.
If you are transferring a cost, specify the contract number to which to transfer the transaction. Note that the contract you enter must be open or on hold.
If you are transferring a timecard detail for a non-labor category, enter the employee number for the correct employee in this field, or use the Finder to select the employee.
If you are transferring a cost, enter or select the project to which to transfer the transaction. Note that:
- The project must be open or on hold.
- You cannot transfer to or from a time and materials project from or to any other project type. You can transfer between fixed price and cost plus projects, however.
If you are transferring a cost for a standard project, enter the resource to be adjusted. For a basic project, you can enter a resource or leave the field blank.
The program calculates this amount. It is the sum of the extended cost plus labor amount plus the overhead amount.
This field displays the transaction date for the transaction you are adjusting or transferring.
The program displays the unit cost from the original transaction plus or minus any posted adjustments.
If you are adjusting an equipment usage, material usage, material return, cost, or timecard transaction, you can accept or change the unit cost.
You cannot change the unit cost for transfers or for adjustments to charge transactions.
Overview
Use the PJC Adjustments screen to adjust or transfer timecard, equipment usage, material usage, material return, cost, or charge transactions that you have posted in Project and Job Costing. You can:
- Adjust the A/R item number, unit of measure, unit cost, quantity, extended cost, and billing rate.
- Transfer a transaction to the correct contract, project, or category, if the original transaction was posted incorrectly.
To adjust transactions originating in another Sage 300 program, use that program. For example, to adjust a transaction that you have invoiced in Accounts Receivable, use the A/R Adjustment Entry screen.
To adjust amounts originating in Purchase Orders, you must adjust the purchase order, receipt, or return in the Purchase Orders program.
- To transfer a transaction between projects or categories, both the contract and project must be open or on hold.
- You cannot adjust or transfer items that use serial numbers or lot numbers.
- You can transfer a transaction from a time and materials project only to:
- Another time and materials project
- A fixed price project that uses an item invoice type. (You specify the invoice type when setting up fixed price projects that use the accrual-basis or billings and costs accounting method.)
- You can transfer a transaction from a cost plus project to another cost plus project or to a fixed price project that uses the project percentage complete or completed project accounting method.
- You can transfer a transaction from a fixed price project that uses the project percentage complete or completed project accounting method to a fixed price project that uses either of these accounting methods, or to a cost plus project.
- You can transfer a transaction from a fixed price project that uses the billings and costs or accrual-basis accounting method to a fixed price project that uses either of these accounting methods. However, both projects involved in the transfer must use the same invoice type (item or summary).
- You can adjust or transfer a timecard for a payroll employee only if you have not yet updated Payroll. If you have sent the timecard to US or Canadian Payroll, you must adjust the timecard in Payroll.