
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 respuestas