have you tried sage line 50 financial controller? has more functions including stock control
Without more details its hard to know exactly why Sage doesn t fit the bill for you but if it is something that is too complex for Sage then a customised database or spreadsheet (or combination of the two) may be the be the best option.