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!

Invoice is not generating in Order Mnagement

Discussion in 'Oracle Apps Technical' started by sambhaji, Oct 23, 2013.

  1. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi i am doing o2c cycle technical-functional way, i reached till pick ship confirmed. I ran autyo invoice master and import programs it ran successfully but in output it is showing like,

    errors:invalid warehouse id(207)
    unable to derive gl date for your transactions. please ensure your transaction is in gl period which have defined.

    Regards
    Sambhaji
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi check gl periods are opened or not?
     
  3. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi Jagadekara,
    Gl periods are open ...
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Where did you cheked the gl periods?
     
  5. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi,
    general ledger >> setup >> open & close

    Regards
    Sambhaji
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi while Releasing sales order in Shipping > Release Sales Order > Release Sales Orders
    In the Inventory Tab change the Warehouse or delete the warehouse and try it...

    Hope this will help you...
     
  7. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    HI,
    I tried it still it is not coming

    Regards
    sambhaji
     
  8. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi ,

    Check the Inventory period is open or not for that inventory organization...

    Inventory Responsibility ---> Account Close Cycle Inventory Accounting --> Inventory Accounting Periods

    For more information Check the attached screenshot.

    Regards
    Sambasiva Reddy.K
     

    Attached Files:

    Ecor likes this.
  9. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi All,
    From net i found that this issue is coming because gl_date column in ra_interface_lines_all is blank. So for testing i updated that date with sysdate and then ran auto invoice program .

    Then auto invoice got generated.

    so my question is how gl_date get into ra_interface_lines_all and how it is affecting
    auto invoice generation???
     
    Ecor likes this.
  10. Ecor

    Ecor Active Member

    Messages:
    20
    Likes Received:
    3
    Trophy Points:
    90
    Good document samba