Walkthrough: Allocate a fixed amount discount

Article01/25/20243 min read

It is not exceptional that trading companies in the beverage industry receive a lumpsum bonus from a supplier at for instance year-end. This bonus has impact on your margin and you might want to allocate it as (negative) costs to sales transactions with the products involved. Aptean Beverage Sales-Purchase Conditions can support this by setting up a condition rule for it. This rule can be created:

  • Prior to the period to which the bonus relates
  • When we settle the bonus, the entries where we allocate the bonus to already exist.
  • Afterwards, when the amount of the bonus is known
  • When we settle the bonus, the entries where we allocate the bonus to do not exist yet. We have to create them before the settlement. See Walkthrough: Create Condition Ledger Entries from history

We receive such a year-end bonus from the Mortimor Brewery. This year, the amount is 1.000.

  1. Select the Search icon alt text, enter Sales and Purchase Condition Rules, and then choose the related link.

  2. Select Rule No. 64 and choose the Edit action.

  3. In the Calculation Code field on the General FastTab, the Y_NET_DISC code is selected. We use this code for our yearly net percentage bonuses.

    • The Calculation Period for this code is Year. This means that the condition is calculated on all transactions in one year.

  4. The Description (General FastTab) makes clear what the discount is about. It is shown on the order and can be printed on the invoice.

  5. 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.

  6. On the Customer/Vendor (Source) FastTab we defined that we will get this discount from Vendor 82000 and is based on transactions with customers that are part of the ONPREM classification.

  7. On the Item FastTab, we explained for which products the discount is applicable: all items that belong to the Classification Item PBMORT. Use the Lookup button the view this classification.

  8. 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.

  9. In the Rates FastTab, the 1.00 is set in the Rate Unit (Net%) field.

Note

In this example we have set the rate to 1.00%. Since it is a lumpsum, we don’t exactly know what the percentage should be. But in our example we estimate it will be about 1% of the total sales. By setting this percentage, we can for instance create accruals on the shipments that we post.

We received the credit memo with the bonus from Mortimor. Now we can use the Periodic Settlement Journal to create a credit memo in the system, including the allocation to the sales transactions.

  1. Select the Search icon alt text, enter Condition Periodic Settlement Journal, and then choose the related link.
  2. Choose the Suggest Settlement Lines action.
  3. On the Suggest Periodic Journal Lines page, fill in Ending Date December 31st 2022, Starting Date January 1st 2022 and select Rule No. 64 and then choose the OK button.
  4. In the Journal Line that is created for the rule, fill in 1,000.00 in the Unit Price field.
  5. Choose the Create Settlement Document(s) action and then choose the OK button.
  6. Select the Search icon alt text, enter Purchase Credit Memos, and then choose the related link.
  7. Open the Credit Memo that was created for Mortimor Brewery and verify the document.
  8. Enter a Vendor Cr. Memo No. and choose the Post action.
  9. Verify the Posted Credit Memo.