>Yes I have outlined my concept and if the tables I propose are okay or do they require any changes from your experiences.
In general, it looks OK.
Like you, I also use fields of type "Currency" for quantities - but make sure that you won't need more than 4 decimals. Otherwise, you may want to use type "Double". In computations with Currency, all results are converted to Currency - which may give you some rounding errors. This can be avoided using mton() in strategic places.
Isn't the invoice related to a sales order? I have the impression you are missing a FK to the related sales order, in the invoice header.
Otherwise - just ask again if you have specific design questions, which you are not sure how best to solve.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
