Tiered Pricing

I have a request to set up tiered pricing (easy enough) but I want to enter one quantity and have JDE split up the lines into the appropriate tiers and add them to the sales detail so they will print on the invoice. Has anyone had any experience with this kind of request?

Example

1. Enter  quantity of 500 widgets

Required results on sales order detail;

Line 1 - 50 @ $1ea = $50

line 2 - 100@ $25ea = $2500

line 3 - 350@ $15ea = $5250

thx

We are using JDE 9.2