-1

I'm new in scriptin and just start to learn that.

I need a script that will do next:

Script must enter sum value in my new field in POLINE. I have sql code for what I want:

select sum(linecost) from poline group by itemnum.

So every time when I create new PO, in new field must enter sum value of linecost of one item. so if I use some item few times in different PO I need to check sum of linecost is used for this item.

Thank you very much

F Rowe
  • 2,042
  • 1
  • 11
  • 12
newinscripting
  • 3
  • 2

1 Answers1

1

I suggest finding and taking introductory online tutorials or classes in both Java and Python. Then, you can look up Maximo V7.6.0.9 JavaDoc and study psdi.server.MXServer and psdi.mbo.Mbo.

Preacher
  • 2,127
  • 1
  • 11
  • 25
  • Thank You for your suggestion. I already started taking tutorials. I just ask this because I need this in my work, and only solution that I see is scripting. – newinscripting Jun 10 '20 at 06:08
  • StackOverflow is for programmers to help each other solve programming problems. What you have is a business requirement, not a programming problem. Your question got downvoted (by someone else) because it feels like you're asking us to do your job of satisfying the requirement instead of telling us what you have tried and the problem you are running into. Read [ask], as @William suggested on your question, and provide a [example] and we would love to upvote your question and provide helpful answers. – Preacher Jun 10 '20 at 18:05
  • Thank You very much for Your comment. I'm going to that. – newinscripting Jun 12 '20 at 10:24