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 Icons | Description |
---|---|
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 Icons | Description |
---|---|
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. |
Fields | Description |
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:
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 | Error rendering macro 'excerpt-include' : No link could be created for 'Def - Charges (GA)'. Database Field: ERPx_CPCharge.ChargeItem |
Charge Account | Identifies the GL Account used to record the Charge. |
Delivered Weight | Error rendering macro 'excerpt-include' : No link could be created for 'Def - Total Weight (GA)'. Database Field: ERPx_CPTicketItem.TotalWeight |
Item Amount | Error rendering macro 'excerpt-include' : No link could be created for 'Def - Ext Amount (GA)'. 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]. 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. .
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]. Database Field: ERPx_CPTicketItem.UnpaidWeight |
UOM | Identifies the UOM associated with the Charge's 'Rate'. This is a non-editable field 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 Icons | Description |
---|---|
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. |
Fields | Description |
Accrual | 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. |
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:
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)'. Database Field: ERPx_CPTicketItem.TotalWeight |
Expense Account | |
Item Amount | Error rendering macro 'excerpt-include' : No link could be created for 'Def - Ext Amount (GA)'. 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]. 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. .
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]. Database Field: ERPx_CPTicketItem.UnpaidWeight |
UOM | Identifies the UOM associated with the Accrual's 'Rate'. This is a non-editable field 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 |