Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Charges (GA)'.

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Accrual - GA'.
 

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.04.22 and newer

Page Header 

Toolbar IconsDescription
Excel Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 
Help Opens the online WIKI help page for the current page. 
Save Saves the changes made to the record. 
Save & Close Saves your changes and closes the page.

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 IconsDescription
Column Filter Show / Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Group By Show / Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
Amount

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

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Charge Amount (GA)'.

Calculated On

Identifies the values used for determining Ticket Charges. It can be set to one of the following values:

  • % Gross $: The Charge is calculated by multiplying the ticket items extended amount by the Charge 'Rate'.
  • Delivered Weight: The Charge is calculated by multiplying the ticket items 'Total Weight' by the Charge 'Rate'. 
  • Paid Weight: The Charge is calculated by multiplying the ticket items 'Total Weight' by the Charge 'Rate' for only line items with a non-zero 'Amount'.
  • Unpaid Weight: The Charge is calculated by multiplying the ticket items 'Total Weight' by the Charge 'Rate' for only line items with a zero 'Amount'.
  • $ Fixed AmountThe Charge is calculated as a fixed $ Amount.

 The weight-based calculation methods do not do UOM conversions.

 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 

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

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Charges (GA)'.
 This is a non-editable field.

Database Field: ERPx_CPCharge.ChargeItem

Charge 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].

The GL Account that is used to record a Charge against a Grower Ticket. The offset is recorded against the Grower Payable/Receivable GL Account.

Delivered Weight

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Total Weight (GA)'.
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.TotalWeight

Item Amount

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Ext Amount (GA)'.
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.GrossAmount

Paid Weight

'Paid Weight' describes the weight that was included in the 'Net Weight' that is being paid for or deducted (items with a non-zero price). [Delivered Weight] - [Unpaid Weight] = [Paid Weight].
 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. 

Identifies the tax rate used for calculating the Grower Accounting Ticket Charges.

Database Fields: ERPx_CPCharge.Rate, ERPx_CPChargeItem.Rate

Settle Method

Identifies how the Charge Program is Settled. This is a non-editable field that defaults from the 'Settle 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 AccrualThe Charge is included with the journal entry created by the Ticket.

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 field.

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

Unpaid Weight

The 'Unpaid Weight' describes the weight that was included in the 'Delivered Weight' that is not being paid for (items with a price of 0.00). This most often represents dockage/waste material that is being sorted out. [Delivered Weight] - [Unpaid Weight] = [Paid Weight].
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.UnpaidWeight

UOM

Identifies the UOM associated with the Charge's 'Rate'. This is a non-editable field that defaults from the 'Rate UOM' property assigned on the Charge Record View for the associated Charge program.

A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.

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

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 IconsDescription
Column Filter Show / Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Group By Show / Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
Accrual

Charge program IDs are the unique identifier for Charge programs. This is a non-editable field that defaults from the 'Accrual ID' property assigned on the Accrual Record View for the associated Accrual program.

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Accrual - GA'.

Database Field: ERPx_CPAccrual.AccrualItem

Accrual Account

The GL Account that is Credited to record the liability (e.g., Accrued Taxes) when a Charge or Accrual is assigned to a transaction.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

Amount

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

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Accrual Amount (GA)'.

Calculated On

Identifies the values used for determining Ticket Charges. It can be set to one of the following values:

  • % Gross $: The Charge is calculated by multiplying the ticket items extended amount by the Charge 'Rate'.
  • Delivered Weight: The Charge is calculated by multiplying the ticket items 'Total Weight' by the Charge 'Rate'. 
  • Paid Weight: The Charge is calculated by multiplying the ticket items 'Total Weight' by the Charge 'Rate' for only line items with a non-zero 'Amount'.
  • Unpaid Weight: The Charge is calculated by multiplying the ticket items 'Total Weight' by the Charge 'Rate' for only line items with a zero 'Amount'.
  • $ Fixed AmountThe Charge is calculated as a fixed $ Amount.

 The weight-based calculation methods do not do UOM conversions.

 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 Weight

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Total Weight (GA)'.
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.TotalWeight

Expense Account

The GL Account that is Debited to record the expense when an Accrual is assigned to a transaction. 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

Item Amount

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Ext Amount (GA)'.
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.GrossAmount

Paid Weight

'Paid Weight' describes the weight that was included in the 'Net Weight' that is being paid for or deducted (items with a non-zero price). [Delivered Weight] - [Unpaid Weight] = [Paid Weight].
 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. 

Identifies the tax rate used for calculating the Grower Accounting Ticket Accrual.

Database Fields: ERPx_CPAccrual.Rate, ERPx_CPAccrualItem.Rate

Settle Method

Identifies how the Accrual Program is Settled. This is a non-editable field that defaults from the 'Settle 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 AccrualThe Charge is included with the journal entry created by the Ticket.

Database Field: ERPx_CPAccrual.AccrualSettleMethodSK

Ticket Item

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

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

Unpaid Weight

The 'Unpaid Weight' describes the weight that was included in the 'Delivered Weight' that is not being paid for (items with a price of 0.00). This most often represents dockage/waste material that is being sorted out. [Delivered Weight] - [Unpaid Weight] = [Paid Weight].
 This is a non-editable field.

Database Field: ERPx_CPTicketItem.UnpaidWeight

UOM

Identifies the UOM associated with the Accrual's 'Rate'. This is a non-editable field that defaults from the 'Rate UOM' property assigned on the Accrual Record View for the associated Accrual program.

A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.

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

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details


  • No labels