Rebates EOD/EOM processing

Rebates End of Day/Month processing can be run by individual company (i.e. if the company does not belong to a region) or by region.

The following  processes are run as part of EOD:

  • Accumulate sales history (RBO090A)identifies and records the sales transactions that are eligible for rebate
  • Rebates sales history build (RBO006A)  – builds rebates accrued/earned into the Sales History file.
  • Calculate total rebate (RBO100A) –  calculates the estimated rebate earned for End of Day.
  • Load customer balances (RBO110) updates rebate customer balance file with sales and rebate earned and accumulated accruals.

The following  processes are run as part of EOM:

  • Calculate total rebate (RBO100A) –  calculates the actual rebate earned for End of Month.
  • Load customer balances (RBO110) – updates rebate customer balance file with sales and rebate earned and accumulated accruals.
  • Updates customer balances (RBO002OE)– for any customers where balance brought forward is not zero and there is no sales for current rebate cycle period.
  • Rebates sales history build (RBO006A) – builds rebates accrued/earned into the Sales History file. 
  • Create close-out journals (RBO120A) –  to clear any provision amounts that needs to be written off.
  • Purge rebate (RBP000B) – purges rebates with no outstanding amounts.

Process EOD/EOM 

  1. In the menu, expand Other Modules > Rebate & Commissions > Utilities > End of Period menu and double-click
    1. RB End of Day Process for EOD processing. RBO000 Rebate End of Day Processing panel appears.
    2. RB End of Month Process for EOM processing. RBO001 Rebate End of Month Processing panel appears.
Field Description
Company / Region

Company – Company to run EOD/EOM process for, as defined in control file TMSDS/CONO. The company must exist in this database for the EOD/EOM process to run and must not belong to a region.

Region – This is the region for the group of companies as defined in control file ********/EOP-GRP. If this field is populated then EOD/EOM process  will be run by the this region for all the companies within the region. 

Note If the company is setup to belong to a region then the EOD/EOM for that company can only be run by region.
Current period  Current open period will default for the EOD/EOM process.
  1. Enter the required details and click OK.