Thank you for the advice. As you previously assumed, I ran into problems when determining the level (0, 1, 2) with my previous model. I followed your advice and split into 3 tables.
However I'm not sure how to add suppliers (my vendors I buy from), surcharges and prices to all 3 levels. Do I simply connect by adding ArtNum, CompNum and SubComNum to tArtSup, tArtSur and tPrice?
I'm not finished with change reasons / dates...
Zelur90
Last Activity: Oct 18 '20, 01:18 PM
Joined: Sep 23 '20
Location:
-
Think of the following situation. You need to negotiate prices with a supplier who provides you with articles (they are my level 2). The following scenarios are possible:
- he gives you a discount for a specific article
- he gives you a discount for a group of articles
- he gives you a global discount (unlikely, so let's ignore that here. I never experienced this ever.)
So in that moment you will want to...Leave a comment:
-
I was hoping to have all level 0, level 1 and level 2 in tArticle and via tBOM define their relationships to each other.
If each entry has their assigned supplier, surcharges and price, I'd be able to calculate the purchase price. The surcharge on my level 0 would then give me the sales price.
I'm not sure if that works.
What I'm also unsure about is how to catch changes, e.g. give a reason for change. Add a field...Leave a comment:
-
Dear twinnyfo,
Thank you! I have attached the picture to my OP and apologise.
Your latter assumption is what I'm going for, I'm afraid. Let me describe a basic calculation.
...Code:Level 2 A: Basic price 5 USD + VAT - Specific rebate only for A - VAT refund = 4.5 USD Level 2 B: Basic price 5 USD + VAT - Specific rebate only for B
Leave a comment:
-
Price simulation
I have level 0 products (finished product), level 1 products (component) and level 2 products (sub-component).
My subcomponents have all the price calculations, which are inherited by the component and then the finished product.
At the end, based on the finished product group, I want to add a % margin. This becomes then my sales price.
That's my calculation. Then (in a temp table?) I want to have a full...Last edited by twinnyfo; Sep 23 '20, 11:28 PM.
No activity results to display
Leave a comment: