Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey friends
i have a problem showing the the inventory qtyf rom another field which is linked (BOM).
Basically i have 3 tables
1. Inventory figures by Item
2. item relations (Multilevel BOM)
3. Item data ( item informations such type and so on....)
Now i would like to show the stock of an subassambly by expression. Tried planty of things, but somehow i just dont get it done. how should the expression look like?
i have attached a sample .qvw which is reflecting my RL data
Would be great if somebody could help
Many thanks and rgs
Rob
What are you expecting to see?
lets say if i select item 1, i would like to see the qty of all oils
sku | type | qty | sub qty (oil) |
1 | finished | 10 | 39 |
thansk
May be this:
Sum(TOTAL {<[SKU NO], TYPE = {'Oil'}>}QTY) * Avg(1)
it should just show the figures from
3 | , | Oil |
4 | , | Oil |
5 | , | Oil |
I should be able to add the dim sub if required
result should be
Item | Type | Sub qty (type oil) |
1 | finished | 12 |
1 | finished | 13 |
1 | finished | 14 |
thanks
I am not sure I understand the logic behind this? Would you be able to explain what you are trying to do?
sure!
Lets say i have an SKU NO 1, which is build of components (SUB) 3 and 4. Now i would like to display by expresion the Sub stock quantities from the SKU NO. The link which Sub belongs to which item is done in the relation table.
like sum({<Item = {'sub from the relation table'} , Type = {'Oil'}>} QTY)
Result should be
Dim | Dim | Expression (qty from sub oil) |
SKU NO | SUB | QTY |
1 | 3 | 12 |
1 | 4 | 13 |
1 | 5 | 14 |
the expression should also work if Dim SUB is removed
Dim | Expression (qty from sub oil) |
SKU NO | QTY |
1 | 39 |
Thanks Sunny
Your exp should work.
Hi, can you eventually add the expression to the sample .qvw attached? Would be great, as i couldnt get it work ...
Thanks Varsha
I'm using personal edition.