5 Replies Latest reply on Jan 2, 2009 11:22 AM by 656069

    Printed Purchase order Report

    656069
      Hi all

      i need to customize Printed purchase order report(Lanadsacp)

      i need to add supplier item number to printed purchase order report

      where(group) i need to add item number i think it is g_lines right?

      item number is sengment1 from tml_system_items_b is it correct?

      ple reply it is urgent

      ashok
        • 1. Re: Printed Purchase order Report
          628428
          Ashok
          I think that is already a standard functionality (showing supplier item number). If it is not there g_lines is group but you do not have to go to mtl_system_items_b. It is within po_lines_all. It is either vendor_item_number or supplier_item_number. You can check it.

          Thanks
          Nagamohan
          • 2. Re: Printed Purchase order Report
            656069
            Thank you Nagamohan,

            i checked supplier item number is vendor_product_num in po_lines_all table is it right?

            yes it is standard functunality of purchase report.

            they siply create a ticket as add supplier item number to Printed purchase orde report
            how can i achieve this advice
            otherewise i need to ask any information from onsite?

            plz advice me

            ashok.
            • 3. Re: Printed Purchase order Report
              628428
              Ashok,
              Try to get a sample and understand the concern from your users. See if that is already customized to not show the supplier item number (as far as I remember I don't think there are any conditions in the standard report that qulify the printing of the supplier item number, it should print as long as it is entered in the supplier item number field in the PO lines). So see where your users are entering this in PO lines.

              Yes it is vendor_product_num in PO lines table.

              Thanks
              Nagamohan
              • 4. Re: Printed Purchase order Report
                656069
                thanks ngamohan,

                I added fileld to lauout model but but

                some part of text is going to netx page in the output,

                if that supplier item is null then space is coming in the lauout

                can adivice plz

                ashok.
                • 5. Re: Printed Purchase order Report
                  656069
                  thank you for ur all help