Component and Price List

[Jochen Suehlo]

I try to put out a component and price list for single parts of a part of furniture.
I use something like this in the Properties Script:

COMPONENT "101.999.333", e1, "pieces",1,"frame wing"

The listing gives me something like this:
1 | 11,000 | pieces | 101.999.333 | frame wing

But what I want is something like this (the adittional information of pricing):
1 | 11,000 | pieces | 101.999.333 | frame wing | 101.50 | EUR

Because of the limited number of variables in the COMPONENT command I can either get the number of the parts OR the prices of the parts.

Is there a way to get both?

[Anonymous]

Try using the + sign to add information between the commas. It adds info to that one output column but you might be able to make it list the way you want.


COMPONENT "101.999.333", e1, "pieces",1,"frame wing"+ "101.50 EUR"


Keep in mind I'm a "Wiz Wannabe"!!! You may have to experiment a little to make it work.

[Jochen Suehlo]

Thank You for that tip, but it does not work, because the price is now a string.
If I have e.g. 10 tables with together 10 frame wings, the listing would write:
1 | 10,000 | pieces | 101.999.333 | frame wing 101.50 | EUR
instead of
1 | 11,000 | pieces | 101.999.333 | frame wing | 1015.00 | EUR
which is right.
The problem ist, that I do not want to list the price for 1 part, but for all parts.

[Fabrizio Diodati]

Dear Joachim,

I totally agree with you and any time I take part to a GS discussion about this I always complain about this missing issue.

In your case, if you have to list "single" part, there can be a workaround:

simply use as component udm "Euro" and as individual quantity the individual price.

The number of pieces is always displayed in the list (and in any case you could display the reference quantity).

This works, of course only with individual pieces, in any other, common, case it doesn't help enough...

If you need more detailed information, write me privately...

Friendly
Fabrizio