1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Prepayment Isuue

Discussion in 'Oracle Financials' started by sambhaji, Dec 30, 2013.

  1. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi All,

    I have a prepayment issue in which ap_payments_all has record having invoice_id same as ap_invoices_all,
    but rec in ap_payments_all is showing gl_set_of_books_id=1004 and in ap_invoices_all showing 1001 show while doing report i am retriving data by giving parameter set_of_book_id , so if i give 1001 as par. then prepayment data from ap_payments_all is not getting.

    so my que. is why prepayment has diff set_of_books_id and invoces has diff. prepayment !!

    note:: prepayment is coming from cash box


    Regards
    Sambhaji
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Sambhaji you are using 11i or R12?
     
  3. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi Jagadekara ,
    11i

    Regards
    Sambhaji
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Check both org_id s same or not?
     
  5. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Yes

    Regards
    Sambhaji
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Moved to the correct forum.
     
  7. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi did yo got answer for this?
     
  8. Nidhi25

    Nidhi25 Forum Genius

    Messages:
    81
    Likes Received:
    9
    Trophy Points:
    835
    Analyze the issue from front end. Find Set of books corresponding to 1001 & 1004 & query the required prepayment/invoice data in forms, then compare & analyze.