Total of amount in P43214

[lisachew]

Good day!

Refering to the attachment, what I want to ask now is, can I total up the Amount Received into a column based on same Supplier Remark?

Eg:
Supplier Remark | Amount Received | Total Amount Received (column add)
5542
5542.......................92.83.....................390.4
5542.......................33.92.....................390.4
5542........................5.76.....................390.4
5542......................257.89.....................390.4

Can I do it and is there any example in the reference book that I can refer too? Can anyone help to guide me as in customizing the application I am not quite familiar.

THank you very much


Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2

 

[lisachew]

sorry this will be the attachment


Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2

 

[lisachew]

attachment

Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2

 

[pcaenaro]

Lisa,

It seems that the attachment is not going through... not to
the List nor to the forum.

Anyway, the cutomization you are looking for seems a little
bit difficult: i don't think the total amount by Supplier
Remark will be stored anywhere, so you will have to
calculate it in the program.

to do that you will have to do something like:
(In the Grid Record is Fetched Event)

Select from F43121 where PRVRMK=GC Supplier Remark
While SV File IO Status = CO SUCCESS
F43121.FetchNext
Extended Cost ==> VA Amount received
VA Total Received = VA Total Received + VA Amount
Received
End While

I am sure you get the picture...
Now, you will have to store the last "Supplier Remark" (or
use PC Supplier Remark) to reset Total Received when the
Supplier remark changes.
You can also do the calculation only once when the RMK
changes, to avoid doing this 10 time if you have 10 line
with the same remark...

I hope this helps you.

Cheers

Philippe



One World B7333 SP16 AS400