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

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

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.

Nobody want to help me??? :(

Finally i did it...