Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Def - Charges (GA)Program Type - GA Charges
Def - Charges (GA)Program Type - GA Charges
nopaneltrue

Insert excerpt
Def - Accrual Program Type - GA Accrual
Def - Accrual Program Type - GA Accrual
nopaneltrue
 T 

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

Software Version: 2022.0407.2201 and newer

Table of Contents
typeflat

Page Header 

Toolbar IconsDescription
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
Save
Insert excerpt
Save - RV Header 3.0
Save - RV Header 3.0
nopaneltrue
Save & Close
Insert excerpt
Save & Close - RV Header 3.0
Save & Close - RV Header 3.0
nopaneltrue

Page Details


Charges Tab

This tab displays 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. 

ExcelAmount

Displays the unit of measure upon which the Charge amount is calculated. This is a a non-editable textbox that is required. It defaults from the 'Rate UOM' property on the Properties tab of the associated Charge Record View. This field is never editable.

Database Field: ERPx_IMUOM.UOMID, ERPx_CPCharge.UOMSK, ERPx_CPChargeItem.UOMSK, ERPx_CPTicketItem.UOMSK

Toolbar IconsDescription
Column Filter Show / Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Group By Show / Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Quick Column Filter
Insert excerpt
Excel - LV
Quick Column Filter
Quick Column Filter
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0
Excel - LV
- Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Calculated On

Insert excerpt
Def - Calculated On - Ticket Charges
Def - Calculated On - Ticket Charges
nopaneltrue
 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 the 'Calculated On method'

Calculated On

Insert excerpt
Def - Charge Amt. (GA)
Def - Charge Amt. (GA)
nopaneltrue

Charge ID

Insert excerpt
Def -
Calculated On
Program ID -
Ticket
Charges
Def -
Calculated On
Program ID -
Ticket
Charges
nopaneltrue
 This is a non-editable
textbox field that is required. It defaults from the 'Calculation OnCharge ID' property assigned on the 'Properties' tab of the associated Charge Record View for the item assigned to the associated Charge program. This field is never editable

Insert excerpt
Def - Program Type - GA Charges
Def - Program Type - GA Charges
nopaneltrue
 This is a non-editable field.

Database Field: ERPx_CPCharge.ChargeCalcMethodSKChargeItem

Charge Charge GL Account

Identifies the

Charge ID for the associated item

GL Account used to record the ChargeThis is a non-editable

textbox

field that

is required.  It

defaults from the 'Charge

ID

Account' property assigned on the

Properties tab of the associated Charge Record View. 

Charge Record View for the associated Charge program, displayed as [GL Account ID] - [GL Account Description].

Insert excerpt
Def - GL Account - Charge - GA
Def - GL Account - Charge - GA
nopaneltrue

Delivered Wt.

Insert excerpt
Def - Charges Delivered Wt. (GA)
Def - Charges Delivered Wt. (GA)
nopaneltrue
 This is a non-editable field.

Database Field: ERPx_CPCharge.ChargeItem

Delivered Weight

CPTicketItem.TotalWeight

Gross Amt.

Insert excerpt
Def - Gross Amt. (GA)
Def - Gross Amt. (GA)
nopaneltrue
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.GrossAmount

Paid Weight

Database Field: ERPx_CPTicketItem.TotalWeight

Item Amount

GrossAmount

Item

Insert excerpt
Item ID & Item Description
Item ID & Item Description
nopaneltrue
 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.

Insert excerpt
Def - Paid Weight
Def - Paid Weight
nopaneltrue
 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

Insert excerpt
Charge Rate - GA
Charge Rate - GA
nopaneltrue

Database Fields: ERPx_CPCharge.Rate, ERPx_CPChargeItem.Rate

Settle Settlement Method

Database Field: ERPx_CPCharge.ChargeSettleMethodSK

Ticket Item

Displays the Item ID and Description of the item associated with the corresponding Charge.  This is a non-editable textbox that is required.  

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

Unpaid Weight

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.

Insert excerpt
Def - Unpaid Weight
Def - Unpaid Weight
nopaneltrue
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.UnpaidWeight

UOM
Insert excerpt
Def - UOMDef - UOM
nopaneltrue

Accruals Tab

This tab displays 

...

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. 

Database Field: ERPx_CPAccrual.AccrualSettleMethodSK

Toolbar IconsDescription
Column Filter Show / Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Group By Show / Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Accrual Identifies the Accrual ID for the associated item.  This is a non-editable textbox that is required.  It ID

Insert excerpt
Def - Program ID - Charges
Def - Program ID - Charges
nopaneltrue
 This is a non-editable field that defaults from the 'Accrual ID' property assigned on the Accrual Record View for the associated Accrual program.

Insert excerpt
Def - Program Type - GA Accrual
Def - Program Type - GA Accrual
nopaneltrue

Database Field: ERPx_CPAccrual.AccrualItem

Accrual GL Account

Insert excerpt
Def - GL Account - Accrual
Def - GL Account - Accrual
nopaneltrue
This is a non-editable field that defaults from the 'Accrual

ID

Account' property assigned on the

Properties tab of

Accrual Record View for the associated Accrual

Record View. 

program displayed as [GL Account ID] - [GL Account Description].

Database Field: ERPx_CPAccrual.

AccrualItem

CRAccountSK

AmountAccrual Amt.

Displays the total Accrual amount for the line item.

  This

This is calculated based on the 'Rate' and

the

'Calculated On

method.  

'. 

Insert excerpt
Def - Accrual Amt. (GA)
Def - Accrual Amt. (GA)
nopaneltrue

Calculated On

Insert excerpt
Def - Calculated On - Ticket Charges
Def - Calculated On - Ticket Charges
nopaneltrue
 This is a non-editable

textbox

field that

is required. It

defaults from the 'Calculation On' property assigned on the

'Properties' tab of the associated

Accrual Record View for the

item assigned to the

associated Accrual program.

This field is never editable.

Database Field: ERPx_CPAccrual.AccrualCalcMethodSK

Delivered WeightWt.

Insert excerpt
Def - Delivered Wt. (GA)
Def - Delivered Wt. (GA)
nopaneltrue
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.TotalWeight

Item Amount

Database Field: ERPx_CPTicketItem.GrossAmount

Paid WeightExpense GL Account

Insert excerpt
Def - GL Account - Expense
Def - GL Account - Expense
nopaneltrue
 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_

CPTicketItem.PaidWeight
Rate

Identifies the Charge rate for the corresponding item.  This is a numeric textbox that is required.

Database Fields: ERPx_CPAccrual.Rate, ERPx_CPAccrualItem.Rate

Settle MethodTicket ItemDisplays the Item ID and Description of the item

CPAccrual.DRAccountSK

Gross Amt.

Insert excerpt
Def - Gross Amt. (GA)
Def - Gross Amt. (GA)
nopaneltrue
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.GrossAmount

Item

Insert excerpt
Item ID & Item Description
Item ID & Item Description
nopaneltrue
 This is the Ticket Item associated with the corresponding Accrual.   This is a non-editable textbox that is requiredfield.  

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

Unpaid WeightPaid Wt.

Insert excerpt
Def - Paid Weight
Def - Paid Weight
nopaneltrue
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.UnpaidWeightPaidWeight

UOMDisplays the unit of measure upon which the Accrual amount is calculated. This is a a non-editable textbox that is required. It defaults from the 'Rate UOM' property on the Properties tab of the associated Accrual Record View. This field is never editableRate

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. 

Insert excerpt
Accrual Rate - GA
Accrual Rate - GA
nopaneltrue

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.

Insert excerpt
Def -
UOM
Unpaid Weight
Def -
UOM
Unpaid Weight
nopaneltrue
 This is a non-editable field.

Database Field: ERPx_IMUOM.UOMID, ERPx_CPAccrual.UOMSK, ERPx_CPAccrualItem.UOMSK, ERPx_CPTicketItem.UOMSK ERPx_CPTicketItem.UnpaidWeight

Related Topics



Expand
titlePage Definitions

Page Definitions



Expand
titleTechnical Details

Technical Details