/
Charges & Accruals Record View

Charges & Accruals Record View

Jul 06, 2022

 

The purpose of this page is to display the details for all Charges and Accruals calculated for a Ticket. Users can also update the Rate used to calculate the Accrual/Charge amount.

Software Version: 2022.07.01 and newer

[ 1 Page Header  ] [ 2 Charges Tab ] [ 3 Accruals Tab ] [ 3.1 Related Topics ] [ 3.1.1 Page Definitions ] [ 3.1.2 Technical Details ]

Page Header 

Toolbar Icons

Description

Toolbar Icons

Description

Excel

Help

Save

Save & Close

Charges Tab

This tab displays the Charge details that have been calculated for each applicable Ticket item. Charges are auto calculated based on the Charge programs configured. The 'Rate' is the only editable field in the grid. 

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show / Hide

Group By Show / Hide

Quick Column Filter

Saved Layouts

Fields

Description

Calculated On

 This is a non-editable field that defaults from the 'Calculation On' property assigned on the Charge Record View for the associated Charge program.

Database Field: ERPx_CPCharge.ChargeCalcMethodSK

Charge Amt.

Displays the total Charge amount for the line item. This is calculated based on the 'Rate' and 'Calculated On'. 

Charge ID

 This is a non-editable field that defaults from the 'Charge ID' property assigned on the Charge Record View for the associated Charge program.

 This is a non-editable field.

Database Field: ERPx_CPCharge.ChargeItem

Charge GL Account

Identifies the GL Account used to record the Charge. This is a non-editable field that defaults from the 'Charge Account' property assigned on the Charge Record View for the associated Charge program, displayed as [GL Account ID] - [GL Account Description].

Delivered Wt.

 This is a non-editable field.

Database Field: ERPx_CPTicketItem.TotalWeight

Gross Amt.

 This is a non-editable field.

Database Field: ERPx_CPTicketItem.GrossAmount

Item

 This is the Ticket Item associated with the corresponding Charge. This is a non-editable field.

Database Fields: ERPx_CPItem.ItemID - ItemDescription, ERPx_CPTicketItem.ItemSK

Paid Wt.

 This is a non-editable field.

Database Field: ERPx_CPTicketItem.PaidWeight

Rate

Identifies the Charge rate for the corresponding item.  This is a numeric textbox that is required and is editable for Tickets that are not Approved or Posted. The number of decimals allowed is dependent upon the value set in the 'Decimal Places Charge Rate' preference. 

Database Fields: ERPx_CPCharge.Rate, ERPx_CPChargeItem.Rate

Settlement Method

Identifies how the Charge Program is Settled. This is a non-editable field that defaults from the 'Settlement Method' property assigned on the Charge Record View for the associated Charge program.

  • AP Invoice: The Charge is created via a separate AP Invoice that posts directly to AP when the Ticket is posted.

  • GL Accrual: The Charge is included with the journal entry created by the Ticket.

Database Field: ERPx_CPCharge.ChargeSettleMethodSK

Unpaid Wt.

 This is a non-editable field.

Database Field: ERPx_CPTicketItem.UnpaidWeight

Accruals Tab

This tab displays the Accrual details that have been calculated for each applicable Ticket item. Accruals are auto calculated based on the Accrual programs configured. The 'Rate' is the only editable field in the grid. 

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show / Hide

Group By Show / Hide

Quick Column Filter

Saved Layouts

Fields

Description

Accrual ID

 This is a non-editable field that defaults from the 'Accrual ID' property assigned on the Accrual Record View for the associated Accrual program.

Database Field: ERPx_CPAccrual.AccrualItem

Accrual GL Account

This is a non-editable field that defaults from the 'Accrual Account' property assigned on the Accrual Record View for the associated Accrual program displayed as [GL Account ID] - [GL Account Description].

Database Field: ERPx_CPAccrual.CRAccountSK

Accrual Amt.

Displays the total Accrual amount for the line item. This is calculated based on the 'Rate' and 'Calculated On'. 

Calculated On

 This is a non-editable field that defaults from the 'Calculation On' property assigned on the Accrual Record View for the associated Accrual program.

Database Field: ERPx_CPAccrual.AccrualCalcMethodSK

Delivered Wt.

 This is a non-editable field.

Database Field: ERPx_CPTicketItem.TotalWeight

Expense GL Account

 This is a non-editable field that defaults from the 'Expense Account' property assigned on the Accrual Record View for the associated Accrual program displayed as [GL Account ID] - [GL Account Description].

Database Field: ERPx_CPAccrual.DRAccountSK

Gross Amt.

 This is a non-editable field.

Database Field: ERPx_CPTicketItem.GrossAmount

Item

 This is the Ticket Item associated with the corresponding Accrual. This is a non-editable field.

Database Fields: ERPx_CPItem.ItemID - ItemDescription, ERPx_CPTicketItem.ItemSK

Paid Wt.

 This is a non-editable field.

Database Field: ERPx_CPTicketItem.PaidWeight

Rate

Identifies the Accrual rate for the corresponding item. This is a numeric textbox that is required and is editable for Tickets that are not Approved or Posted.  The number of decimals allowed is dependent upon the value set in the 'Decimal Places Accrual Rate' preference. 

Database Fields: ERPx_CPAccrual.Rate, ERPx_CPAccrualItem.Rate

Settlement Method

Identifies how the Accrual Program is Settled. This is a non-editable field that defaults from the 'Settlement Method' property assigned on the Accrual Record View for the associated Accrual program.

  • AP Invoice: The Charge is created via a separate AP Invoice that posts directly to AP when the Ticket is posted.

  • GL Accrual: The Charge is included with the journal entry created by the Ticket.

Database Field: ERPx_CPAccrual.AccrualSettleMethodSK

Unpaid Wt.

 This is a non-editable field.

Database Field: ERPx_CPTicketItem.UnpaidWeight