Skip to main content
Jamila Joshi ha fatto una domanda in #Data Management
How do i create a formula to add up the total amounts on multiple invoices raised against one Purchase order.

 

Example:

 

I have PO1 of amount 25000

 

An invoice IN1 is raised for PO1 amounting to 5000

 

another invoice IN2 is raised for PO1 amounting to 12000

 

and another invoice IN3 is raised for PO1 amounting to 10000

 

How can i have a field that will give me the summation of invoice amounts till that date and the balance left against a particular PO?

 

Other than formula fields do i have to specify some relationship between the objects PO and Invoice?
2 risposte
  1. 23 feb 2011, 10:38
    Thanks a million ...This should work....I will certainly try