Setting Up Custom Segments for Rebate Transactions
If your company is using custom segments, you can specify or apply them on rebate transactions and journal entries. Then, applied custom segments, besides rebate agreements and Classifications (Class, Department, and Locations), will be used in grouping rebate items in accruals and settlements.
If you want to apply or use custom segments in your rebate transactions and journal entries, ensure that you already set up the Rebate Agreement, preferences, and then the custom segment preferences, before creating transactions with rebates.
The Custom Segment Preferences page allows you to view and specify custom segment values for rebate transaction records. The page displays all custom segments already defined in the system that are applied to Sales, Purchases, Journal Entries, or related item entities.
A script, RM MR Update Custom Segment MR, which runs during off-hours, automatically creates preference records with the applicable custom segments. These records are then displayed on the Custom Segment Preferences page, along with any default values. If a custom segment has no a default value, its field will be blank.
You can update the default values or specify values in blank fields. Custom segment values on the page can then be used for grouping rebate items in accruals and settlements.
Custom segments of the type Multiple Select, and those that are inactive or locked, are not supported in rebate transactions and journal entries; these custom segments will not be displayed on the Custom Segment Preferences page
To set up and use custom segments for rebate transactions:
-
Go to Rebate Management > Preferences > Custom Segment Preferences, and on the Custom Segment Preferences List page, click New Custom Segment Preferences. You can only create one Custom Segment Preferences page.
Note:If you create a custom segment preference manually, custom segments will not be displayed by default until script, RM MR Update Custom Segment, scheduled to run nightly, is triggered. The administrator can manually run the script outside its schedule to instantly populate the custom segment fields on the Custom Segment Preferences page.
-
(Optional) On the Custom Segment Preferences page, specify, select, change, or retain the values of the custom segment fields.
Note:If you change a custom segment value on the Custom Segment Preferences page, this will not change the default value of the source Custom Segment record. Conversely, if you edit a Custom Segment record, the changes will not be reflected on the corresponding custom segment on the Custom Segment Preferences page.
-
Check or leave clear the Set Custom Segment of rebate transactions with values from source transactions box.
-
Check the box if you want custom segment values on rebate transactions to inherit custom segment values from their source transactions.
-
Leave the box clear if you want rebate transactions to use custom segment values specified on the Custom Segment Preferences page.
By default, the preference or box is clear.
-
-
Click Save.
To better understand how custom segment preference works, consider the following example.
If your account has 2 custom segments defined with the following default values:
-
CS1 = val1
-
CS2 = val2
; these custom segment values are set on the preference record.
Then, consider the following 2 transactions are created with different values for custom segments CS1 and CS2:
-
transaction#1:
-
CS1 = val3
-
CS2 = val4
-
-
transaction#2:
-
CS1 = val5
-
CS2 = val4
-
Case 1:
The preference or box is not checked or cleared.
Result:
When rebate transactions are created for the 2 transactions, the custom segment values on the rebate transactions will be taken from the Custom Segment Preferences page or preference record, not from the source transactions.
Rebate Transaction |
Class |
Location |
Department |
CS1 |
CS2 |
---|---|---|---|---|---|
RT#1 (from transaction#1) |
C1 |
L1 |
x |
val1 |
val2 |
RT#2 (from transaction#2) |
C1 |
L1 |
x |
val1 |
val2 |
Number of groups when accrual is generated = 1
Number of groups when settlement is generated=1
Case 2:
The preference or box is checked.
Result:
When rebate transactions are created for the 2 transactions, the custom segment values on the rebate transactions will be taken from their source transactions.
Rebate Transaction |
Class |
Location |
Department |
CS1 |
CS2 |
---|---|---|---|---|---|
RT#1 (from transaction#1) |
C1 |
L1 |
x |
val3 |
val4 |
RT#2 (from transaction#2) |
C1 |
L1 |
x |
val5 |
val4 |
Number of groups when accrual is generated = 2
Number of groups when settlement is generated=1