How Stock Rebates work

Understanding Stock Rebates.

Introduction

Adding Rebates to a Stock Item

Rebate Definitions

Create Rebate Validation Spreadsheet

Introduction

Rebates on the prices for Stock Items can be added manually, or imported when you import new or updated Stock Items from a file.

Return to Top of Page

Adding Rebates to a Stock Item

To read about importing Stock Items with rebate figures, refer to Import Stock Items.

To manually add a rebate to a Stock Item:

• Go to Stock > Stock Details.
• Search for and select the Stock Item you want to edit.
• Click View and edit rebates in the bottom right of the screen.

In the Edit rebates screen:

• Product rebate percent: Enter the % for Product rebate. This is used to calculate the Average Cost.
• Unqualified rebate percent: Enter the % for this rebate. This is used in reporting only.
• Qualified rebate percent: Enter the % for this rebate. This is used in reporting only.
• Marketing rebate percent: Enter the % for this rebate. This is used in reporting only.
• Points rebate percent: Enter the % for this rebate. This is used in reporting only.

Return to Top of Page

Rebate Definitions

• Product rebate percent: This is used to calculate the Stock Branch Average Cost, which then flows through to calculate the Margin which is used in Sales Order Approval and used for end-of-month stock valuations.

• Unqualified rebate percent: This rebate is used in the Payables report Create Rebate Validation Spreadsheet.

• Qualified rebate percent: This rebate is used in the Payables report Create Rebate Validation Spreadsheet.

• Marketing rebate percent: This rebate is used in the Payables report Create Rebate Validation Spreadsheet.

• Points rebate percent: This rebate is used in the Payables report Create Rebate Validation Spreadsheet.

The last four rebate fields are used only for reporting. The Create Rebate Validation Spreadsheet shows these calculated figures, which you can then use to do any further calculations that you may require.

Return to Top of Page

Create Rebate Validation Spreadsheet

This report creates a spreadsheet that shows the calculated values for all the rebate fields for your Stock Items.

• Go to Payables > Create Rebate Validation Spreadsheet.
• Supplier: Select a Supplier, or leave blank for all Suppliers.
• Branch: Select a Branch, or leave blank for all Branches.
• Start date: Enter the Start date for the report.
• End date: Enter the End date for the report.
• Click Create Rebate Validation Spreadsheet.

This exports the report.

Return to Top of Page

Last updated: 15 February 2023