Total Value

[Benjamin Baptista]

I made Invoice and in that invoice I using a portal to show all credit that Agent should pay during a periode.

How can I get total of payment ?

[aaa]

Create Field in invoice file Total_Payment=Sum(Portal_Relation::Payments)

[Benjamin Baptista]

Thank for your kind reply....... it had work good..

But there is another question..... how can I set all record that show in portal as one invoice number...

Thank for your kind..

Cheers

[aaa]

In invoice file Create field Const=1.

Such field create and in related file.

Then create relation from invoice to items by this fields:Constant=Constant.

Create your needing portal in invoice

[Benjamin Baptista]

Sorry if I make whirl..... but it's all work now.

may I ask you other question ?

[aaa]

Certainly! Ask!

[Benjamin Baptista]

In invoice file Create field Const=1 ----> did u mean this is Constant ?

I have finished make invoice with portal but when I go to next invoice I found that One of Agent that have more than one payment shown as many as the payment .... could you explain what is going wrong with my invoice ?

May I sent my FM file to you so you can figure it out ?

Thank for your previous reply....

[aaa]

I wanted to ask you that you send your file. Attach it here. But i will come here on Mondey. And may i can not answer you this two day.

[Benjamin Baptista]

I have found the problem, I think it's because I import agent name (kepada) at Inv.fp6 to Invoice.fp6.

I do import file so I dont'n have to make a new record.

Without import everything fine but the problem is how can I search in portal,

example I want to search agent name (field name --> kepada) and also range of date which is in portal row (field name --> dive date).

I need your suggestion.....

Herewith I also attach my file...

Thank for your kind

Benjamin

[Benjamin Baptista]

uuppss.. sorry I forgot attach fm file.... here they are

Inv.zip

[aaa]

Such?

123.zip

[Benjamin Baptista]

How can I be that stupid not give you the password.....

the password for inv.fp5 is Admin

[aaa]

I understanded that Admin.

You look to attachment. Have you question yet?