Charges & Accruals Record View
- Emma Greenwood
- Tom Williams
A Charge represents something that will be deducted (most often) from a Grower Ticket. Charges are most commonly used to deduct (pass along) fees associated with harvesting, hauling, and damaged / down-grade product.
A Grower Accounting Accrual is used to automate the recording expenses incurred as part of a Ticket. These are most often used to accrue for taxes, harvesting, or hauling expenses that will be paid by the company.
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
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 |
| Calculated On | Identifies the values used for determining Ticket Charges. It can be set to one of the following values:
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'. A calculated field that summarizes the Charges being applied to a Ticket Item. The detail Charges can be viewed on the Charges & Accruals page. A 'Charge Amt.' can only be changed by either changing the 'Rate' for a Charge (on the Charges & Accruals page) or by changing something that impacts the 'Delivered Wt.' and/or 'Gross Amt.' of a Ticket Item. |
| Charge ID | A Charge represents something that will be deducted (most often) from a Grower Ticket. Charges are most commonly used to deduct (pass along) fees associated with harvesting, hauling, and damaged / down-grade product. Database Field: ERPx_CPCharge.ChargeItem |
| Charge GL Account | Identifies the GL Account used to record the Charge. |
| Delivered Wt. | A calculated field that identifies the delivered weight of the Ticket Item. This is calculated as: [Ticket Header Net Weight] * ([Ticket Items Sample] / [Ticket Header Sample Size]). This can only be edited by changing either the Ticket Item's 'Sample' or one of the Ticket Header Properties that impact the Ticket's Net Weight or Ticket's Sample Size. Database Field: ERPx_CPTicketItem.TotalWeight |
| Gross Amt. | A calculated field that Identifies the extended amount of the Ticket Item. This is calculated as: ([Delivered Wt.] * [Price]) and can only be changed by editing the Price or changing one of the other properties that impact 'Delivered Wt.'. Database Field: ERPx_CPTicketItem.GrossAmount |
| Item | Identifies the Item, displayed as Item ID: Item Description. 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. | '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. The number of decimals allowed is dependent upon the value set in the 'Decimal Places Charge Rate' preference. Identifies the tax rate used for calculating the Grower Accounting Ticket Charges. Database Fields: ERPx_CPCharge.Rate, ERPx_CPChargeItem.Rate |
| Settlement Method | Identifies how the Charge Program is Settled. .
Database Field: ERPx_CPCharge.ChargeSettleMethodSK |
| Unpaid Wt. | 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 |
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 ID | A Grower Accounting Accrual is used to automate the recording expenses incurred as part of a Ticket. These are most often used to accrue for taxes, harvesting, or hauling expenses that will be paid by the company. Database Field: ERPx_CPAccrual.AccrualItem |
| Accrual GL 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. |
| Accrual Amt. | Displays the total Accrual amount for the line item. This is calculated based on the 'Rate' and 'Calculated On'. A calculated field that summarizes the Accruals being applied to a Ticket Item. The detail Accruals can be viewed on the Charges & Accruals page. An 'Accrual Amount' can only be changed by either changing the 'Rate' for an Accrual (on the Charges & Accruals page) or by changing something that impacts the 'Delivered Wt.' and/or 'Gross Amt.' of a Ticket Item. |
| Calculated On | Identifies the values used for determining Ticket Charges. It can be set to one of the following values:
Database Field: ERPx_CPAccrual.AccrualCalcMethodSK |
| Delivered Wt. | A calculated field that identifies the delivered weight of the Ticket Item. This is calculated as: [Ticket Header Net Weight] * ([Ticket Items Sample] / [Ticket Header Sample Size]). This can only be edited by changing either the Ticket Item's 'Sample' or one of the Ticket Header Properties that impact the Ticket's Net Weight or Ticket's Sample Size. Database Field: ERPx_CPTicketItem.TotalWeight |
| Expense GL Account | |
| Gross Amt. | A calculated field that Identifies the extended amount of the Ticket Item. This is calculated as: ([Delivered Wt.] * [Price]) and can only be changed by editing the Price or changing one of the other properties that impact 'Delivered Wt.'. Database Field: ERPx_CPTicketItem.GrossAmount |
| Item | Identifies the Item, displayed as Item ID: Item Description. 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. | '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. The number of decimals allowed is dependent upon the value set in the 'Decimal Places Accrual Rate' preference. Identifies the tax rate used for calculating the Grower Accounting Ticket Accrual. Database Fields: ERPx_CPAccrual.Rate, ERPx_CPAccrualItem.Rate |
| Settlement Method | Identifies how the Accrual Program is Settled. .
Database Field: ERPx_CPAccrual.AccrualSettleMethodSK |
| Unpaid Wt. | 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 |