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!

Create an AP invoice through a Purchase Order

Discussion in 'Oracle SCM & Manufacturing' started by tomloera, Feb 29, 2012.

  1. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hello Friends;

    I have the following operation to see if I can support

    We are currently generating purchase orders for two hundred lines of which are receiving partially.

    I want to generate an invoice based on the partial received, but when the I associated the invoice with the purchase order and show the two hundred lines and I have to look one by one they received

    There will be some way to show only the lines received?

    Thanks a lot
    Tomloera
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Tomolera,

    This is intended functionality. It is meant to be checked for each receipt before it becomes an invoice else the match option would have been different. Only the lines received will be shown if the following conditions are met;
    The Invoice match option is set to receipt.
    WHen you are about to match select RECEIPT as the option in the pop list before clicking the match button and this should take you to find receipts to match window.
    Then you enter the appropriate criteria and pull up receipts which includes receipts which have a match option set to PO but you will not be able to match them here..

    So the real trick is in the criteria you enter here to pull up the receipts.

    It is advisable to work within the realms of standard functionality rather than customize. Give it a go and let us know if it makes sense.
    Ramji
     
  3. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hello Ramji;

    Question, When you do the receive generated some consecutive number?

    You can help me with some screenshot of where I need make the match of the lines received for create the invoice

    You can?
    Regards
    Tomloera
     
  4. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Tomloera,

    Yes I will send you the steps. Shall prepare it for you. Before that Can you upload the Supplier, Supplier Site and PO match screens of a Po you have entered. I will then replicate that scenario for you.
    cheers
    Ramji
     
  5. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hello Ramji;

    Tomorrow I prepare the document with the testing of the flow of the Creation of the PO and the receipt for create the invoice

    Regards
    Tomloera
     
  6. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Ramji;

    Question, How I can upload the document in this post?

    Regards
    Tomloera
     
  7. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Yes pls.
    thanks
    Ramji
     
  8. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Ramji;

    Goos Morning, How I can send the document of my process?
    Regards
    Tomas
     
  9. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    This is the document of the process

    Regards
    Tomloera
     
  10. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Tomoloera,

    Thanks. I will get back to you. You can edit .
    cheers
    Ramji
     
  11. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Tomoloera,

    I have seen your process doc. Here are the checks
    After Creating the PO what is the Match option on the Shipment? Is it set to Receipt. Please confirm.
    In R12 the match option defaults in the following order and can be overridden at any level > Payables System Setup ->Supplier -> Supplier Site -> Purchase Order Shipment.
    So check the Supplier site as what is set there defaults on the PO shipment. (in the more tab in PO shipment Invoice match field)
    Once you have confirmed both the above
    Enter the invoice
    and before you click match chose the receipt option from the pop list , then you can pull up the lines based on the receipt number and match.
    Please check and let me know.
    and redo a new PO and steps make sure you chose receipt before clicking the match button and update
    cheers
    Ramji
     
  12. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Ramji;

    I performed the cycle of the test entire to generate the purchase order, receipt and invoice generation based on the reception and everything was satisfactory.

    I have only two questions to try to improve the process:

    When making the receipt of materials in which time is assign the receive number?

    Is it possible to assign the default Tax Code Classification in the supplier or item for prevent the capture when creating the invoice?

    Regards
    Tomloera
     
  13. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Tomas,

    The Receipt number will be there at from the point when you receive goods against Purchase order.

    As for tax it is possible to prevent capture when creating the invoice. Unless you specify the applicable tax the system wont calculate it. In R12 the tax is very versatile. You can exempt an item from tax. Similarly you can exclude tax for a supplier.
    cheers
    Ramji
     
    tomloera likes this.
  14. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Dear Ramji;

    Truly thank you for your help to improve the process we have actually.

    If anything I can help please tell me

    Regards
    Tomloera
     
  15. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Tomas,

    Pleasure is equally mine. Dont embarass me! Anything let me know anytime.
    Best Regards,
    Ramji