Sage 100

We have a customer that wants to change their pricing structure in Sage 100. Currently they have all of their customers paying one price but then allow some items to be discounted on the invoice. Thus, they have to sub-total of all items at full price, then the discount subtracted at the bottom of the invoice. What they would like to do is show the discounts on the individual items on each line of the invoice. This will allow then to post the discounts to the individual item(s) Sales Accounts and show their customers which items are being discounted. I know that we can do this with Price Codes assigned to Product Lines and various price levels (different customers get different discount percentages). The invoice will have to be customized to create a column and total for the discount amounts. Does anyone have any caveats or possible pointers on creating and changing the price schedules?

I don't think the discount amounts are going to post anywhere, or did you mean just that the discounted price per line will post to the line sales account?

Yes, @BethBowers , the discounted price per line posting to the sales account. Right now they go back and make a journal entry to split the discounts between product divisions because the discount posts to only one account.

I suppose one could do something like this with scripting. Sell the first line at full price, then the script creates the discount line and assigns the same sales account to it??