Wholesale Discounts/Rebates

 

Back Office >Accounts > Account Records > Wholesale Discounts

 

Description

 

This menu item is used to manage and configure Wholesale Discounts/Rebates associated with selected Accounts for Back Office Invoicing.

 

To Be Considered

 

  1. Advanced Host Integration registration is required for access to this feature.
  2. Note : Wholesale Discounts are ONLY applied when sales are made via Invoicing. They DO NOT apply to sales made via a SwiftPOS Touch terminal.

 


Wholesale Discounts

 

 

This screen is accessed from here.

 

Search Filters

 

  • The filters at the top of the screen can be used to limit the number of rows displayed in the grid. By default the screen will show Accounts with valid Active From / To dates and a non-zero Account Balance or a Credit Limit. To show all Accounts select the Show All checkbox. The filters include the following types:

    • Check Boxes - The filter fields of this type are: Show Disabled and All.
    • Date Range From/To -  The filter fields of this type are: Period and From/To Dates.
    • Search Screens - The filter fields of this type are: Product.


 

Grid

 

The grid displays the: Product, Enabled, Contract Start Date, Contract End Date, Discount, Value, Rebate, Value and Supplier. Note : To edit an entry in the grid, double click a row. Rows displayed in the grid can be sorted by toggle selecting the column headings.

 

Footer

 

  • New - Select to open the New Wholesale Discount screen add a Wholesale Discount/Rebate.
  • Copy - Select from the drop down list one of the following copy options to copy Wholesale Discounts to another Account. The following prompt will be displayed:
     
  • All to Multiple - Select to open the Copy Wholesale Discounts to Multiple Accounts screen to copy ALL listed Wholesale Discounts to multiple Accounts.
  • Selected to Multiple - Select to open the Copy Wholesale Discounts to Multiple Accounts screen to copy ONLY SELECTED Wholesale Discounts to multiple Accounts.

 

  • All - Select to open the Copy Wholesale Discounts screen to copy ALL listed Wholesale Discounts to one Account.
  • Selected - Select to open the Copy Wholesale Discounts screen to copy ONLY SELECTED Wholesale Discounts to one Account.

 

  • Edit - Select open the Edit Wholesale Discount screen to edit the current selected (highlighted) row, OR select from the drop down list one of the following options:
     
  • Delete - Select to confirm the deletion of the current selected (highlighted) row, OR select from the drop down list one of the following options:
     
    • All - Select confirm the deletion of all Wholesale Discounts listed.
    • Selected - Select to confirm the deletion of only the selected (checkbox selected in first column) Wholesale Discounts.
       
  • Reports - Select from the drop down  list one of the following:
     
  • Add Products Wizard  - Select to open the Add Products Wizard to add multiple Products to which a Wholesale Discount and/or Rebate will be applied.
  • Tools - Select from the drop down list one of the following:
     
  • Import (Update) - Select to search for a CSV file to import. Using this option Wholesale Discounts imported will result in either being added (for new Discounts) or updating existing Wholesale Discounts. The following confirmation prompt will be displayed once the import file has been selected.
     

 

  • Import (Replace) - Select to search for a CSV file to import. Using this option Wholesale Discounts imported will result in all existing Discounts being deleted for the selected Account and the imported Discounts replacing the deleted ones. The following confirmation prompt will be displayed once the import file has been selected.
     

 

For file format information ...

 

  • Close - Select to exit.

 


New/Edit Wholesale Discount

 

 

This screen is accessed from here and here.

 

  • Product - Displays/Select the Product to which the Wholesale Discount/Rebate is applied.
  • Enabled - Select to ensure the Discount/Rebate is enabled.
  • Contract Start/End Dates - Displays/Set the Contract Start/End dates.
  • Discount - Select from the following option:
     
    • Percent - Select to set the Discount in the form of a Percentage.
    • $ Value - Select to set the Discount in the form of a value.
    • Fixed Price - Select to set the Discount in the form of a fixed price.
    • None - Select to ensure not Rebate is applied.
       
  • Rebate - Select from the following option:
     
    • Percent - Select to set the Rebate in the form of a Percentage.
    • $ Value - Select to set the Rebate in the form of a value.
    • None - Select to ensure not Rebate is applied.

 

  • Rebate Description - Displays/Enter a Description for the Rebate.  Note : When exporting using the SupplierRebateExport report the Rebate Description will be exported in the DISC column.
  • Supplier - Select to ensure a Supplier is assigned to the new/existing Wholesale Discount.

 

Footer

 

  • Ok - Select to save changes and exit.
  • Cancel - Select to exit without saving changes.

 


Edit All/Selected Wholesale Discounts

 

 

This screen is accessed from here.

 

  • Enabled - Select to edit the Enabled status of all the selected Wholesale Discounts to either set them as Enabled or not.
  • Contract Start/End Dates - Select to edit the Contract Start/End Dates of all the selected Wholesale Discounts to set them to a new Start/End date.
  • Discount - Select to edit the Discount applied to all the selected Wholesale Discounts by changing one the following options:
     
    • Percent - Select to set the Discount in the form of a Percentage.
    • $ Value - Select to set the Discount in the form of a value.
    • Fixed Price - Select to set the Discount in the form of a fixed price.
    • None - Select to ensure not Rebate is applied.
       
  • Rebate - Select to edit the Rebate applied to all the selected Wholesale Discounts by changing one of the following options:
     
    • Percent - Select to set the Rebate in the form of a Percentage.
    • $ Value - Select to set the Rebate in the form of a value.
    • None - Select to ensure not Rebate is applied.

 

  • Rebate Description - Displays/Enter a Description for the Rebate.  Note : When exporting using the SupplierRebateExport report the Rebate Description will be exported in the DISC column.
  • Supplier - Select to ensure a Supplier is assigned to all the selected Wholesale Discounts by selecting a Supplier.
     

Footer

 

  • Ok - Select to apply the changes all the selected Wholesale Discounts and exit.
  • Cancel - Select to exit without applying the changes.

 


Add Products Wizard

 

 

This screen is accessed from here.

 

Filters

 

  • Family - Select to open the Search Families screen to select a Family, to return the Products associated with that Family.
  • Sub-Range - Select to open the Search Metcash Sub-Ranges screen to select a Sub-Range, to return the Products associated with that Sub-Range.
  • Supplier - Select to open the Search Suppliers screen to select a Supplier, to return the Products associated with that Supplier.

 

Discount/Rebate Settings

 

  • Enabled - Select to ensure the Wholesale Discount is enabled.
  • Contract Start/End Dates - Displays/Set the Contract Start/End dates.
  • Discount - Select from the following option:
     
    • Percent - Select to set the Discount in the form of a Percentage.
    • $ Value - Select to set the Discount in the form of a value.
    • Fixed Price - Select to set the Discount in the form of a fixed price.
    • None - Select to ensure not Rebate is applied.
       
  • Rebate - Select from the following option:
     
    • Percent - Select to set the Rebate in the form of a Percentage.
    • $ Value - Select to set the Rebate in the form of a value.
    • None - Select to ensure not Rebate is applied.

 

  • Rebate Description - Displays/Enter a Description for the Rebate.  Note : When exporting using the SupplierRebateExport report the Rebate Description will be exported in the DISC column.
  • Update Existing - Select to ensure that Products selected by this wizard, and that already have a Wholesale Discount applied, are updated to ensure the settings configured above are also applied to them

 

Footer

 

  • Ok - Select to save changes and exit.
  • Cancel - Select to exit without saving changes.

 


Operation

 

Once Products related to Wholesale Discounts/Rebates have been configured for an Account, and those Products are added to a sale that includes the Account in question, the sell Price will reflect the Discount/Rebate applicable given the Contract period has not expired. Note : Wholesale Discounts are ONLY applied when sales are made via Invoicing. They DO NOT apply to sales made via a SwiftPOS Touch terminal.

 


Import File Structure

 

Field

Type

Notes

ProductCode

Nvarchar(13)

SwiftPOS Product Code

FromDate

DateTime

DD/MM/YYYY HH:mm

ToDate

DateTime

DD/MM/YYYY HH:mm

DiscountType

Int

0 = No Discount

1 = % Discount

2 = $ Discount

3 = Fixed Price of Product

DiscountValue

money

2 decimal places no $ sign

DiscountPercent

float

2 decimal places no $ sign

DiscountPrice

money

2 decimal places no $ sign

RebateType

Int

0 = No Rebate

1 = % Rebate

2 = Fixed $ Rebate

RebateValue

money

2 decimal places no $ sign

RebatePercent

float

2 decimal places no $ sign

SupplierID

Nvarchar(10)

SwiftPOS SupplierID

PriceLevelA

Int

SwiftPOS Price Level ID

PriceA

money

2 decimal places no $ sign

PriceLevelB

Int

SwiftPOS Price Level ID

PriceB

money

2 decimal places no $ sign

FamilyID

Int

SwiftPOS Family ID

 

Example:

 

ProductCode,FromDate,ToDate,DiscountType,DiscountValue,DiscountPercent,DiscountPrice,RebateType,RebateValue,RebatePercent,SupplierID,PriceLevelA,PriceA,PriceLelelB,PriceB,FamilyID
583464,30/07/2021 06:00,06/08/2021 06:00,1,0.0000,3.0000,0.0000,0,0.0000,0.0000,ALM,1,0.0000,2,0.0000,1
584444,30/07/2021 06:00,06/08/2021 06:00,1,0.0000,3.0000,0.0000,0,0.0000,0.0000,ALM,1,12.1500,2,10.9500,1
597081,30/07/2021 06:00,06/08/2021 06:00,1,0.0000,3.0000,0.0000,0,0.0000,0.0000,ALM,1,0.0000,2,0.0000,1

 


Related Topics

 

  1. Accounts
  2. Customer/Members
  3. Global Preferences - Member Settings
  4. POS Configuration Index - Account/Customer/Member Configuration
  5. POS Operation Index - Account/Customer/Member Features
  6. Reports - SupplierRebateExport