Sales Discounts Based on Certain Customers

I am working with Kinetic Cloud. We currently have the GL Account for Sales Discounts assigned at the Product Group GL Code. We would like to add a second GL Account for Sales Discounts that is used for a select group of customers. For example:

Scenario 1:
Majority of customers will receive a 10% discount on select items for a limited time. That discount is applied at the sales order level. When the order is shipped and invoiced, the discount is recorded in account 7605 along with a segment for the product code based on the Product Group GL Code

Scenario 2:
We want the discount to go to a different GL account if the Customer falls into a different category – perhaps customer class or even at the customer level.

Does anyone have any ideas on how to handle this? I can use a separate GL Code for a customer (which is the “AR Account”), but it won’t assign the dynamic product code segment in the GL like I have via the Product Group GL Codes.

Any suggestions would be appreciated.

@nanvdand This should be simple with a custom posting rule. They are not hard to do just have to understand the process. Two possible places both in AR Invoice

  1. there is a function Determine Discount Account. While functions are called from everywhere they also don’t have the nice custom code separate area where you only have to add your extra needs.

  2. There are three Post Discount Amount rules for parts, contracts and calls. you probably only need to make the part one custom.

Epicor determines Temp Account from the function
image

something like this should work. I don’t know about dynamic segments. We don’t use them.

turn on PE logging and check the manually review all transactions and you can run an edit list and check where it be sent.

The one pain is that you have to activate the rule to test, so I made it from A G last week before I got a set finished.

3 Likes

Thanks Greg. I will take a look at this. I really appreciate your help.

1 Like