Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2005
    Posts
    6

    Unanswered: PO report print amount help

    Hi Guru's

    I just want to print PO's that are greater then Amount $2500
    Printed Purchase Order Report(Portrait)
    POXPRPOP
    As we have lots of po for small amounts any help

    Thanks In advance

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I hope your question will be better understood by someone else, because I don't know what "PO" means. However, let me try: if you want to display PO's (whatever they are) whose Amount is greater than 2500, why don't you simply add this condition into the WHERE clase of the report query? Such as

    SELECT ...
    FROM ...
    WHERE amount > :parameter_amount
    AND ...

    I'd recommend use of a parameter instead of a hard-coded amount (WHERE amount > 2500) as you'd, perhaps, want to display data depending on different amount value.

    If this doesn't help, I hope you'll hear a better advice soon.

  3. #3
    Join Date
    Nov 2005
    Posts
    6

    po is Purchase order

    Hi
    Po is Purchase Order in oracle purchsing:the report name is
    Printed Purchase Order Report(Portrait)
    POXPRPOP
    I just want to print PO's that are greater then $2500

  4. #4
    Join Date
    Jan 2004
    Posts
    492
    You have to understand that not many Oracle developers here work with Oracle Apps - and even less are familiar with the actual report.

    Post some of the code and we can help
    Oracle OCPI (Certified Practicing Idiot)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •