Adjustments Field List

Sage ERP Accpac Project and Job Costing 6.0

Adjustments Field List

This is an internal number that the program assigns to identify the sequence in which all adjustment transactions are entered.

Enter a description reference for the adjustment using up to 60 characters.

This field appears if you use Sage ERP Accpac Transaction Analysis and Optional Field Creator.

It indicates whether adjustment optional fields have been assigned to the selected transaction.

Click the Zoom button beside the field to open a separate Optional Fields form where you can view or edit the optional fields assigned to the transaction.

If you set up any adjustment optional fields for automatic insertion, they are assigned to any new adjustments you add, along with the default values specified in 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 adjustments.

If you assign the same optional fields as you use for adjustments in Inventory Control and you selected the option to pass optional fields to Inventory Control, the information will be passed to Inventory Control when you post adjustments to material usage or material return transactions.

Enter a reference for the adjustment using up to 60 characters.

This field lets you select one of two statuses for a transaction:

  • New. If you are entering a new transaction, accept this default status.

  • Approved. When you have finished entering information for the transaction, you can change the status to Approved, indicating that it can be posted.

After you add a new transaction (by clicking the Add button), the program changes the status to Entered. You can change the status from Entered to Approved if you want to indicate that the transaction is ready for posting.

The program assigns Posted status once you post the transaction.

Select the transaction date to which to post the transaction.

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

Project and Job Costing uses the transaction/document date or the session date as the default posting date, depending on your choice for the Default Posting Date option on the PJC Options form.

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.

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 program displays the A/R item number from the original transaction 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.

You can accept or change the unit of measure only for adjustments, not for transfers.

You must enter a unit of measure for time and materials projects and fixed price projects that use an item invoice type. The Finder shows the unit of measure assigned to the item in Accounts Receivable.

For cost plus or fixed price projects that use a summary invoice type, you can use the field to enter any additional information.

This field appears in multicurrency ledgers.

For time and materials projects and fixed price projects that use an item invoice type, the program 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.

The billing type for the original transaction appears in this field.

You cannot change the billing type for transfers.

You can change the billing type for adjustments for time and materials projects and for fixed price projects that use the accrual-basis or billings and costs accounting method, if the project and category are billable.

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 shows the cost class for the Adjust To Category you specified.

The program 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 that 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, to 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, to 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, to have the program 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.

The program displays the transaction date used in the transaction you are adjusting or transferring. You cannot change it.

The program 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 that the percentage or amount could be different on the contract, project, and category to which you transfer a transaction.

The program displays the labor rate or percentage used for the project category in the original and the revised columns.

The program assigns a unique line number to identify the detail.

Accept the line number displayed, or click the New button to start a new detail.

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 Sage ERP Accpac Transaction Analysis and Optional Field Creator, the Optional Field column on the detail entry grid and the Optional Fields indicator on the Detail Adjustments form indicate whether adjustment detail optional fields have been assigned to a selected adjustment detail.

To open a separate Optional Fields form that lets you view or edit the optional fields assigned to a detail:

  • On the detail entry grid, either double-click the field for a selected detail, or select the detail, and then press Shift+F9 on your keyboard.

  • On the Adjustment Details form, click the Zoom button beside the Optional Fields check box.

If any adjustment detail optional fields are set up for automatic insertion, they appear for new details, 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 adjustment details.

If you assign the same optional fields to material usage or material return adjustment details as you use for adjustments in Inventory Control — and you chose the optional field setting to pass information to Inventory Control — the entries will be passed to Inventory Control with the adjustment details.

In turn, Inventory Control will pass the entries to any General Ledger accounts selected in the optional field Settings, if the optional fields used in the Inventory Control adjustment match the transaction details optional fields assigned to the General Ledger account.

For other (non-material) adjustments, if you assign the same optional fields to a detail as you use for an affected account's transaction details — and you specified in the setup record that data for this optional field will pass to the General Ledger account — the entries will be passed with the transaction detail to General Ledger.

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 that the percentage or amount may be different on the contract, project, and category to which you are transferring a transaction.

The program 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 that 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.

The program displays the transaction date used in 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.