Dear Folks,
I am stuck in a problem , I have the following tables :
1.composite,
2. stock
3.unit cost
In composite table, columns are parentsku, childsku and ratio.
In stock table , coumns are sku , WH , FBA , intransit and PO
In Unit cost ,columns are sku and unit cost
composite table:
parentsku childsku ratio
A b 1
A c 1
A d 1
X z 1
In above table parent sku A have multiple childs(b c d) and X has one.
In stock table , parent and child sku's wh and fba intransit po value are listed and they are different like as:
stock table:
SKU Warehouse FBA On Purchase In Transit
A 22 3 4 5
b 10 6 0 0
c 11 7 0 0
d 12 8 0 0
I want to make a straight table where I want to show the sku , unitcost , wh
In Sku , both parent and child sku will be listed.
In Wh, if parent sku is there in sku column, then its connected childsku's warehouse will be picked and divided by ratio(if parent has only one child).and if child sku is there then its original warehouse will be shown. if parent sku have multiple childs then its childsku's warehouse with minimum value will be picked up.
in unitcost column, if parent sku is there in sku column then its connected child sku unit cost will be picked and multiply by ratio.and if child sku is there then its original unit cost will be shown.
please let me know how to achieve this..
Regards,
Farhan
