Andrew:

How to you get pricing to 6 decimal places when the progarm will only store 2 decimals (the number based upon currency code)?

If you are refering to fooling the system by changing the stock by each/price by each to stock by hundreds/price by hundreds this would work if I could get the fractional quantity to three decimal places, which I can't.

Trying another approach;

lumber is sold @ $128/1000 feet (which is the standard for lumber).

If I stock by foot my price is $0.128 (not doable due to the fact that I can only store prices to 2 decimal places).

If I stock by 1000 feet and then sell 5 feet I need a fractional quantity of .005 (also not doable due to the fact that I cannot use a fractional quantity with more than 2 decimal places).

I could stock by 100 foot units and make it work but this would likely be confusing to the users whole are use to thinking in terms to 1000 feet.

Any other suggestions would be greatly appreciated.