Can anybody think of a way round my issue.

We stock inventory and sell in each.
We price in 100metres.

At the moment our item is set up in metres and priced in 100metres, although you can enter a dimension when raising a sales order, it does not allow you to view stock by length (only metres of item) and we can't use shop floor control because we need to know what length to manufacture.

My first attempt was to use PCF and one of the features would be 'Length', this worked great until pricing, somehow I need a conversion between each and metres. I have tried changing the pricing to each but if you see in the example below I would end up being hung by finance for losing money.

148 each x 2.6metres - £99.00 100metres = £380.95
148 each x 2.6metres - £2.57 each = £380.36

I tried amending the system to incorportate 4 decimal places into price but then got complaints for users and had to convert back to 2.

We don't want to set up an item for each length as this can differ with every order, we want to be able to view the stock of the length and be able to use SFC.

Has anybody got any suggestions?:confused:

Hi,

Indeed, you need a conversion factor between your inventory unit and every other unit you are using (like meter, 100meter, ...) in your generic item.
Have you considered using generic price lists ?

I'm using the generic price list to convert the price from 100m to each but as my example shows this gives me the issue with the decimal places.

Am I missing something about generic price lists?

Hello,

I've never used generic prices, however I have an idea...
To avoid the issue with decimal places, you can round the price for each using the function "round" in a constraint:

price = round(price_for_each_not_rounded;2;2)

where the 1st "2" is the number of decimal places, and the 2nd "2" is the rule for rounding (0 -> lower; 1 -> std; 2 -> upper).

Using this function, the exact price for each 2.6metres item (£2.574) will be rounded at £2.58!
=> 148 each x 2.6metres - £2.58 each = £381.84

Hope this help...

Sylvain

Thanks for the advice, but that's my issue I don't want it to round up to 2 decimal places as this gives me a price issue I need it to use the 4.

Thanks for reply though ;)