We have a client on 4.5 that uses Item Pricing by Total Quantity, based on Item Category. They are taking on a new product line, however, that they want to implement discounts by line item based on the total PRICE of the items on the order within that product line, instead of on quantity ordered. They want the discount to be applied to each line item AS a line item, and to post to a different G/L account than the normal Discount account that they use for other product lines. I can't figure a way to do this other than to use a Misc Charge Code to apply the discounts per line item, which would require the salesperson to first calculate the total dollars ordered within the PL, and then calculate the discount per line item.
I looked at a couple DSD enhancements (SO Pricing by Product Line/Customer and SO Line Discount Posting to General Ledger), but these enhancements also base the discounts on quantity rather than dollars.
Has anyone else had this type of request from a client and found a way to make it work?