Walkthrough: Quarter discount percentage on minimum sales amount
Each quarter, the Selangorian Pub (20000) can get a 2% Net discount on our own beers. But the sales of these beers during that period should be at least 1,000. Verify the setup for such a discount. You can use it as an example to implement it yourself:
Select the Search icon
, enter Sales and Purchase Condition Rules, and then choose the related link.Select Rule No. 25 and choose the Edit action.
In the Calculation Code the Q_NET_DISC code is selected. We use this code for our quarterly net percentage discounts.
- The Calculation Period for this code is Quarter. This means that the condition is calculated on all transactions in one quarter.
The Description (General FastTab) makes clear what the discount is about. It is shown on the order and can be printed on the invoice.
The rule has the Certified Status. Which means that it will be used in transactions that meet the criteria for the rule. Rules with other statuses will never be used in transactions.
On the Customer/Vendor (Source) FastTab we defined that this discount will be given to customer 20000 (Source Type and Source No.) and based on transactions with that customer (Based on Source is Member).
On the Item FastTab, we explained for which products the discount is applicable: all items that belong to the Classification Item OB. Use the Lookup button to view this classification.
On the Others FastTab, we added an additional criterium for the rule. It is only applicable on sales lines with a Reason Code that belongs to the SALES group. In our example, we did not set this reason code by ourselves. It was automatically inserted from the Aptean Beverage Foundation Management.
On the Rates FastTab:
- 1,000 is entered in the Minimum Amount field
- the 2.00 is set in the Rate Unit (Net%) field
At quarter-end, we will be settle this bonus with a sales credit memo that is created in the Periodic Settlement Journal. If you execute the next exercise, you can later use it in the settlement journal.
Exercise Quarter Discount
- Change your Work Date to February 1st 2024 in My Settings.
- Select the Search icon , enter Sales Orders, and then choose the related link.
- Select New to create a new entry.
- In the Customer field, enter the name Selangorian (20000).
- Fill in lines:
Item Quantity 1010 40 1280 6 1510 40 - Choose the Post (Ship and Invoice) action.
- Confirm the message for a related call entry if it pops-up.
- Change your Work Date to March 1st 2024 in My Settings.
- Select the Search icon , enter Sales Orders, and then choose the related link.
- Select New to create a new entry.
- In the Customer field, enter the name Selangorian (20000).
- Fill in lines:
Item Quantity 1010 40 1280 6 1510 40 - Choose the Post (Ship and Invoice) action.