[jmns]

Całościowa lista artykułów
DIN A3 Format poprzeczny
1 Kolumna
19 Wierszy

Thank you for this form pwisniewski!

Tried this and among others one thing is fine (actually, two): Grand Total and Carry over sum. I noticed that there is no Total purchase price so I inserted this in column Total price so you can for each element see price and at the bottom of form Grand total sum.

Pity this still don't show price for cables (length x Purchase price)...

Has anybody solution for this?

Greetings,

jmns

[LeBmo]

If I understand you correctly I see the problem but I do not know how to solve it.
If you see FOTO#1 In standard F02_005 I have 3 cables 10 meters each one (3x10=30m), price 8 PLN/m and 3 switches 15 PLN/piece.
"Suma całkowita" (bottom of the page - I am sorry I do not have English version of Eplan) I have 69 PLN.
Why?
Because Eplan calculate it as follow:
(3cabels x 8PLN)+(3switches x 15PLN)= 69PLN
Eplan calculate 3cables, not 30meters!

On FOTO#2 is the different between calculate meters and pieces.
In "Cena łączna" I add meters_price/pieces_price so I think that we should use these information to "Suma całkowita" but I do not know how to prepare It. I do not know how to do something like "OR".

FOTO#1:
   

FOTO#2:
   

[pwisniewski]

Hi jimns

PS I Assumed that you have in database the price from article correct assigned

in this case you must modified the form to use "length" in case that you have for example cable instead quantity (in one form this is difficult to perform but not impossible)

if you do this then you can use some calculation to count the total price

I suggest to use 2 forms to do this, it will be simpler

---

If I understand you correctly I see the problem but I do not know how to solve it.
If you see FOTO#1 In standard F02_005 I have 3 cables 10 meters each one (3x10=30m), price 8 PLN/m and 3 switches 15 PLN/piece.
"Suma całkowita" (bottom of the page - I am sorry I do not have English version of Eplan) I have 69 PLN.
Why?
Because Eplan calculate it as follow:
(3cabels x 8PLN)+(3switches x 15PLN)= 69PLN
Eplan calculate 3cables, not 30meters!

eplan calculate this correct but you think/use it wrong

its so simple but also very complicated

first this form its for "quantitative" articles - not for "in length"
if you wont to use this in "length" articles you must modified the form to include the "length" in quantity

[LeBmo]

eplan calculate this correct but you think/use it wrong

I know, I did something wrong, but I did not know how to do it correct.

OK I found something but I see pwisniewski gave us some hint.

In Article tab, for cable use quantity "0", because we do not want quantity but length. FOTOBazy artykułów Helukabel:
   

I did some modifications in "Cena łączna" column. FOTOMakra artykułów ABB:
   

And modifications in "Suma calkowita". FOTORelpol:
   

At the end what I got. FOTOWago:
   

[pwisniewski]

...
In Article tab, for cable use quantity "0", because we do not want quantity but length. FOTOBazy artykułów Helukabel:

don`t trow away the quantity (you may think that this its not used - not true)
you should multiply the length by quantity then the result its correct

why ?

because quantity show how many "pieces" of cable witch this length its used
example :
if you have incoming supply witch multiple cable like this 3x(3x120mm2) - one piece 100m
then if your don`t include the quantity
you will become only 100m but it should be 300m from cable 3x120mm2 in this example

and second taking into account the quantity you can filter out all articles that have "0" quantity and don't show it
that give you some capabilities to hide certain articles in forms and use templates that you have in database in this articles