Skip to Content
author's profile photo
Former Member

purchase items report for sales orders - very important

Hi Folks,

Could you please guide me on how to create a report of "items purchased" for a particular "sales order". if i am able to include various fields of items purchased, like....quantity, item description, vendor name, item price, etc., it will be very useful.

This report is required for a client, who assembles machines in a "make to order" scenario, and most of the BOM child items are "purchase items".

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • author's profile photo
    Former Member
    Posted on Sep 20, 2007 at 08:28 AM

    Does the client buy all the items required in a particular SO or does he purchase only the items that are not sufficiently available in his warehouses.

    The report can easily be created if the above question is answered

    Gyanesh

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 20, 2007 at 03:09 PM

    Hello Krishna,

    Few things to note:

    Is the PO created from the SO. Is YES, then you could use the base document ref at the POR1 table.

    OR

    Are the BOM components defined with a default vendor in the Item Master and if YES are the components always purchased from the same vendor.

    I am trying to see how to establish the relationship of the items between the PO and SO.

    Please give me the details and I could guide you further

    Thanks

    Suda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Suda,

      The BOM components are having various vendors........therefore the difficulty in linking the Sales Order to the Purchase order.

      Please advise.

  • author's profile photo
    Former Member
    Posted on Sep 21, 2007 at 06:54 AM

    Krishna,

    You forgot to answer my question,

    Is the PO created from the SO. Is YES, then you could use the base document ref at the POR1 table.

    If NO to above, then the solution I can think of would be to create a User defined field on the document row level called SONumber / SONO and enter the SO number at the PO lines.

    This way you have the link of the Sales Order to the PO of Item.

    Otherwise if you are using batches you could get this easily by querying the OIBT and IBT1 tables.

    Let me know

    Suda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You can create an UDF in PO. In that UDF you can assign the pending SO's.

      When you are creating PO's you can link the SO to that PO.

      Based on this, reports can be generated

  • author's profile photo
    Former Member
    Posted on Sep 22, 2007 at 01:50 AM

    How do you create a purchase order from a sales order?

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 22, 2007 at 06:17 PM

    In the recent message you are talking about Production Order. Is this a seperate requirement?

    If you talking about Production Order then Production Orders have a link to Sales Order.

    If you still talking about Purchase Orders then UDF at the document row level on the PO will be the way to go.

    Good luck

    Suda

    Add comment
    10|10000 characters needed characters exceeded