End of payment cycle selection program (RBO140) is a generic program to select records for the following end of payment cycle processing. The payment cycle processing options and the programs for these options are set in control file TMSRB/RBO140.
Contents
Re-calculate actual rebate (RBO100)
Menu : Other Modules > Rebate & Commissions > Rebate Payments > RB Recalculate Actual Rebate
Calculates the actual rebate earned at the end of rebate cycle rather than the estimated amount. If a rebate definition is changed or the rebate percentage of targets has changed this process must be run to re-calculate all rebates earned. Note: If you include or exclude customers or products you cannot run this process, you must do a rebuild.
Adjust for lost payments (RBO130)
Menu : Other Modules > Rebate & Commissions > Rebate Payments > RB Calculate & Adjust Payments
Rebates may be estimated daily, then adjusted for the actual rebate at the end of the cycle. This option allows you to adjust the payments.
Close-out journal creation (RBO120)
Menu : Other Modules > Rebate & Commissions > Accruals Posting to GL > RB Close-Out Journal Creation.
This option provides the facility to automatically create reversal journal for any outstanding accrual provision amount that has to be written off. It will only select those rebates whereby numbers of month expiry is greater or equal to the nominated months of retention periods.
Re-build rebates (RBO190)
Menu : Other Modules > Rebate & Commissions > Utilities > RB Rebuild Selected Rebates.
This option will clear a selected rebate cycle and rebuild. If customers or products are included or excluded from a rebate definition then you must run this process to rebuild all masterfiles. The process keeps a record of payments made and if a difference is found, the difference is carried to the next cycle.
Hold overdue accounts (RBO130)
Menu : Other Modules > Rebate & Commissions > Rebate Payments > Hold Overdue RB Accounts
The option is run against the next period after the last payment cycle closed (as on the rebate definition master
file). It checks whether rebate can be paid to each customer by comparing:
- actual return rate against customer’s return profile
- payment pattern against customer’s payment profile
- hold flag in customer’s payment profile
Re-calculate estimate rebate (RBO100)
Menu : Other Modules > Rebate & Commissions > Accruals Posting to GL > RB Recalculate Estimate Rebate
Rebates may be estimated daily, then adjusted for the actual rebate at the end of the cycle, or determined once as an actual rebate earned at end of cycle. This option allows you calculate the daily rebate estimates.
