An Accrual is used to automate a journal entry, as part of a transaction, for recording revenues or expenses incurred. These are most often used to accrue for taxes as part of sales, purchasing, and/or Fishermen/Grower Tickets. They are also used to accrue for delivered freight expense on sales transactions and/or royalties incurred as part of a sales or grower ticket.The purpose of this page is to add, edit, remove, and activate/inactive these records.
Software Version: 2022.02.25 and newer
Page Header
| Toolbar Icons | Description |
|---|---|
| Delete |
WARNING: Records cannot be recovered once they are deleted! |
| Help |  Opens the online WIKI help page for the current page. |
| New |  Opens a new blank record for data entry. |
| Save |  Saves the changes made to the record. |
| Save & Close |  Saves your changes and closes the page. |
| Fields | Description |
| Accrual | Identifies the short description and unique identifier for Tax, Premium, Charge, Accrual and Sales Program. This is editable by editing either the Accrual ID property on the Properties tab. Database Field: ERPx_CPAccrual.AccrualItem |
Properties Tab
| Toolbar Icons | Description |
|---|---|
| Excel |
|
| 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. |
| Fields | Description |
| Properties | Identifies the Property that is being set up. |
| Value | A text box or lookup to set the value of the property. Property values are always editable and can be changed at any time, unless otherwise specified. |
| Group: Configuration | |
| Accrual ID | Identifies the short description and unique identifier for Tax, Premium, Charge, Accrual and Sales Program. This is a text box that is required. It defaults to blank for new records. If not assigned, the message "Accrual ID is required." will be displayed on Save. This value must be unique. If not, the message "Duplicate Accrual ID's are not allowed." will be displayed on Save. This field is always editable and must be <= 25 characters. Database Field: ERPx_CPAccrual.AccrualItem |
| Start Date | Identifies the date the Program starts. Tickets with a 'Landed Date' on or after the Landed Date Start date will be evaluated for the Program. This is a date picker that is required. If missing, the message "Start Date is required." will be displayed on Save. This defaults as blank on new records and is always editable. Database Field: ERPx_CPAccrual.StartDate |
| End Date | Identifies the date the Program ends. Tickets with a 'Landed Date' on or before the Landed Date End date will be evaluated for the Program. This is a date picker that is not required. This defaults as blank and is always editable. A blank value assumes the Tax never ends, but if a date is entered it must be >= the 'Start Date' field. Else the message "End Date must be on or after the Start Date." will be displayed on Save. Database Field: ERPx_CPAccrual.EndDate |
| Inactive | Database Field: ERPx_CPAccrual.IsInactive |
| Group: Assign Rules By | |
| Assign Rules By | Specifies how Accruals are assigned to tickets. This is a multi-select lookup where at least one selection is required. If missing, the message "Assign Rules By is required." will be displayed on Save. This field defaults as blank and is always editable. When one or more values are selected, on Save, additional tabs for each of the selected items will be added to the record view. The Assign Rules By field determines the criteria used to calculate Fish Ticket taxes and premiums for a given Program. One or more of the following values may be selected:
This lookup contains all the values in the CPAssignRulesBy Enumeration Class. Database Field: ERPx_CPAccrual.AssignRulesByCSVEN |
| Assign Rate By | Specifies where the Accrual Rate comes from. This is a single-select standard lookup that is required. It defaults to "???" and is always editable. If it is changed from "???", it must match one of the values in the 'Assign Rules By' Property. If not, the message "Assign Rate By must be assigned by one of the Assign Rules By values." will be displayed on Save. The Assign Rate By field determines where the 'Rate' on a Fish Ticket Tax or Premium is specified, for a given program. The selection must match one of the values assigned in the 'Assign Rules By' property. The potential values include:
This lookup contains all the values in the CPAssignRateBy Enumeration Class. Database Field: ERPx_CPAccrual.AssignRateByEN |
| Settlement Method | This lookup contains all the values in the CPSettleMethod Enumeration Class. Database Field: ERPx_CPAccrual.AccrualSettleMethodSK |
| Calculated On | Identifies the value used, for each applicable ticket line, for calculating Ticket Accruals. This is a single-select standard lookup that is required. If missing, the message "Calculated On is required." will be displayed on Save. It defaults to blank and is always editable. Identifies the values used for determining Ticket Accruals. It can be set to one of the following values:
This lookup contains all the values in the CPAccrualCalcMethod Enumeration Class. Database Field: ERPx_CPAccrual.AccrualCalcMethodSK |
| Default Rate | Identifies the 'Rate' (Tax Amount or Premium Amount) of a Fish Ticket Tax or Premium Program. This rate is used for all Programs with an 'Assign Rate By' property set to "Global". This is also the default rate assigned to all lines on the additional tabs when the 'Assign Rate By' is set to anything other than Global. This is a text box that is required. If missing, the message "Rate is required." will be displayed on Save. It defaults to "0.000000" and is always editable. If the tax is configured to be an expense for the company and the fisherman, the default rate is automatically divided. If this causes the rate to be more than 6 decimals, then the company rate is rounded up and the fisherman rate is rounded down.
Database Field: ERPx_CPAccrual.Rate |
| Rate UOM | Database Field: ERPx_CPAccrual.UOMSK |
| Group: Accounting | |
| Expense Account | Identifies the GL Account that is Debited to record the expense side of the Fish Ticket Tax Program paid by the Company. This is a single-select standard lookup that is required if "Company" is selected in the 'Expense For' property. If missing, the message "Company Expense Account is required." will be displayed on Save. This defaults as blank and is always editable. The lookup contains a list of all the 'Active' GL Accounts. Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.DRAccountSK |
| Accrual Account | Identifies the GL Account that is Credited, to record the liability, for a Fish Ticket Tax. This is a single-select standard lookup that is required. If missing, the message "Tax Liability GL Account is required." will be displayed on Save. This defaults as blank and is always editable. The lookup contains a list of all the 'Active' GL Accounts. Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.CRAccountSK |
| AP Vendor | Identifies the name of the Vendor assigned to the transaction or master file. This is set in the Vendor Record View. This is a single-select standard lookup that is not required. It defaults to blank and is always editable. This lookup contains a list of all the 'Active' Fishermen, Tenders, Fishermen & Tenders and Vendors. Database Fields: ERPx_APVendor.VendorName, ERPx_CPAccrual.VendorSK |
This does not convert to the UOM specified.Crops Tab
This tab will only be visible if "Crops" is selected in the 'Assign Rules By' property.
| Toolbar Icons | Description |
|---|---|
| Excel |
|
| Delete |  Deletes the selected line(s) from the transaction. When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This icon is only enabled for transactions with a Status of 'New'. |
| New | Opens a new blank record for data entry. |
| 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. |
| Fields | Description |
| Checkbox | Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete. |
| Crop | Identifies the Chill Type that the Tax Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Tax Program is created, all Chill Types are assigned. If you want only specific Chill Types to apply to the Tax Program, click the ‘New’ icon and manually add the Chill Type(s) that you wish to apply. This field defaults as blank and is editable. This lookup contains a list of all the 'Active' records in the Crops Master List. Database Fields: ERPx_CPCrop.Crop, ERPx_CPAccrualCrop.CropSK |
| Rate | Identifies the tax rate used for calculating the portion of the tax payable by the fisherman. This is a text box that is not required. This field is only enabled when "Chill Type" is selected as the 'Assign Rate By' value and "Fisherman" is selected as the 'Expense For' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. If the tax is configured to be an expense for a Company and a Fisherman, then the default rate is divided between the company and the fisherman and the company rate is rounding up and the fisherman rate is rounding down. E.g. a default rate 1.654321 would default the company rate to 0.827161 and the fisherman rate to 0.827160. Database Fields: ERPx_CPAccrual.Rate ERPx_CPAccrualCrop.Rate |
Items Tab
This tab will only be visible if "Items" is selected in the 'Assign Rules By' property.
| Toolbar Icons | Description |
|---|---|
| Excel |
|
| Delete | Deletes the selected line(s) from the transaction. When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This icon is only enabled for transactions with a Status of 'New'. |
| New | Opens a new blank record for data entry. |
| 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. |
| Fields | Description |
| Checkbox | Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete. |
| Item | Database Fields: ERPx_CPItem.ItemDescription, ERPx_CPAccrualItem.ItemSK |
| Rate | Identifies the tax rate used for calculating the portion of the tax payable by the fisherman. This is a text box that is not required. This field is only enabled when "Fishermen" is selected as the 'Assign Rate By' value and "Fisherman" is selected as the 'Expense For' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. If the tax is configured to be an expense for a Company and a Fisherman, then the default rate is divided between the company and the fisherman and the company rate is rounding up and the fisherman rate is rounding down. E.g. a default rate 1.654321 would default the company rate to 0.827161 and the fisherman rate to 0.827160. Database Fields: ERPx_CPAccrual.Rate, ERPx_CPAccrualItem.Rate |