Transaction Edit Preference

NetSuite provides a preference so you can choose whether to use the details from the latest version of agreement details or from the applicable agreement details relative to the transaction date.

To use this preference, go to Setup > Company > General Preferences. Under the Custom Preferences subtab, check or clear the box for Always Use the Latest Version of Agreement Details for Rebate Recalculation. This box is cleared by default.

If you check the box, the system applies the latest version of the agreement details to the sales transactions. If you clear the box, the system uses the rebate from the applicable agreement details that are created on or before the transaction date.

Important:

When you check or clear the Always Use the Latest Version of Agreement Details for Rebate Recalculation box during transaction creation, then change the setting again before editing transactions, rebates are recalculated based on the current setting.

The following timelines show examples of how this preference works:

Example #1:

Date	Activity
3/1/2023	A rebate agreement with a 10% rebate was created.
This is version #1 of the agreement details record.
3/6/2023	A sales transaction was created with the following details: Quantity: 1, Price: $100
The item on the transaction will have $10 rebate according to the existing rebate agreement.
3/10/2023	The rebate on the agreement was changed from 10% to 15%.
This change triggers the creation of a version #2 of the agreement details record.
3/11/2023	The sales transaction was modified to increase the item quantity from 1 to 3 bringing the total amount to $300.
If the Always Use the Latest Version of Agreement Details for Rebate Recalculation box is checked, the system uses version #2 of the agreement details with a 15% rebate and applies it to the line item. If the box is cleared, the system uses version #1 of the agreement details with a 10% rebate. Additionally, if you modify the item units in the transaction, the system recalculates the rebate and applies the best deal according to your preference.

Date

Activity

3/1/2023

A rebate agreement with a 10% rebate was created.

This is version #1 of the agreement details record.

3/6/2023

A sales transaction was created with the following details: Quantity: 1, Price: $100

The item on the transaction will have $10 rebate according to the existing rebate agreement.

3/10/2023

The rebate on the agreement was changed from 10% to 15%.

This change triggers the creation of a version #2 of the agreement details record.

3/11/2023

The sales transaction was modified to increase the item quantity from 1 to 3 bringing the total amount to $300.

If the Always Use the Latest Version of Agreement Details for Rebate Recalculation box is checked, the system uses version #2 of the agreement details with a 15% rebate and applies it to the line item.

If the box is cleared, the system uses version #1 of the agreement details with a 10% rebate.

Additionally, if you modify the item units in the transaction, the system recalculates the rebate and applies the best deal according to your preference.

Example #2

Date	Activity
3/1/2023	A rebate agreement with a 10% rebate was created.
This is version #1 of the agreement details record.
3/6/2023	A sales transaction was created with the following details: Quantity: 1, Price: $100
The item on the transaction will have a $10 rebate according to the existing rebate agreement.
3/10/2023	The rebate on the agreement was marked as Expired.
This change triggers the creation of a version #2 of the agreement details record.
3/11/2023	The sales transaction was modified to increase the item quantity to 3.
If the Always Use the Latest Version of Agreement Details for Rebate Recalculation box is checked, the expired rebate agreement is no longer applicable, and rebates applied to the items are removed. If the box is cleared, version #1 of the agreement details will be used and a $30 rebate will be applied to the item.

Date

Activity

3/1/2023

A rebate agreement with a 10% rebate was created.

This is version #1 of the agreement details record.

3/6/2023

A sales transaction was created with the following details: Quantity: 1, Price: $100

The item on the transaction will have a $10 rebate according to the existing rebate agreement.

3/10/2023

The rebate on the agreement was marked as Expired.

This change triggers the creation of a version #2 of the agreement details record.

3/11/2023

The sales transaction was modified to increase the item quantity to 3.

If the Always Use the Latest Version of Agreement Details for Rebate Recalculation box is checked, the expired rebate agreement is no longer applicable, and rebates applied to the items are removed.

If the box is cleared, version #1 of the agreement details will be used and a $30 rebate will be applied to the item.

General Notices