how to sum quantity for same item on a purchase order?

billwa

hi,everybody:

i have a question is that how to sum quantity for same item no. on a purchase order. it should likes this:

Document No. Item No. Quantity Received Qty Total Received Qty Date

PO0001 Mt00001 100 90 98 11-09-07
PO0001 Mt00001 -5 -5 -5 11-09-08
PO0001 Mt00001 5 5 5 11-09-09
PO0001 Mt00001 8 8 8 11-09-10

any helps ,thanks in advance.

billwa

mohana_cse06

You need it in report?

billwa

mohana_cse06 wrote:

You need it in report?

no, i just want to do that in form. thanks for your quick reply.

mohana_cse06

May be you need at bottom of the form like journals?

Check Journals forms for example..

billwa

mohana_cse06 wrote:

May be you need at bottom of the form like journals?

Check Journals forms for example..

first ,i prefer to calculate the total without button, just calculate quantity when i open the form.
how can i achieve that? thanks

mohana_cse06

billwa wrote:

mohana_cse06 wrote:

May be you need at bottom of the form like journals?

Check Journals forms for example..

first ,i prefer to calculate the total without button, just calculate quantity when i open the form.
how can i achieve that? thanks

I suggested the same..Look at balance and total balance fields in General Journal form..