invoice with already populated portal

[atarabotto]

Any customers of mine (restaurant or hotels) use ever the same product, so i'd like to populate invoice portal with only that customer product.

I create a Customer price list, where i save product and prices of each customer.

 

Example:

Customer: John's

Product: white napkin 0,30 €, blue tablecoath 2,00€

 

Customer: Hotel Milano

Products: white sheet 1,00 €, white pillowcase 0,50 €, white towel  1,00€

 

Naturally any product is a record

 

I also created a related Value list for product

 

i already have the script, the problem is that in every portal column i see the whole product

 

white sheet

pillowcase

white towel

--------------

white sheet

pillowcase

white towel

 

and not

 

white sheet

--------------

pillowcase

-------------

white towel

 

i attach file.

 

Thanks

 

DDT Lavanderia.fmp12.zip

[mr_vodka]

When you create records in the invoice line portal, you should be looking up the prices from the related customer price list table

[atarabotto]

Thank you for your answer, can you help me with an example? So it's difficult 4 me understand what u're saying.

 

Thanks again.

[atarabotto]

Nobody want to help me??? :(

[atarabotto]

Finally i did it...