PO Spend History

Sort:
You are not authorized to post a reply.
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member

    I need to run a report to pull in several fields for PO spend. I am familiar with running some reports, but I'm not sure of all the tables these fields are in and not sure how to link them to get all of the data needed.

     

    If anyone has an example or a Crystal report already built they would be willing to share, I would greatly appreciate it!

    Im not able to attach an example because for some reason, Lawson guru is not allowing me to do so.

    JonA
    Veteran Member
    Posts: 1162
    Veteran Member
      It depends on what fields you need. Can you list them?
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      lars
      Veteran Member
      Posts: 54
      Veteran Member

        Is there a standard Lawson report that can be run showing spend per vendor number?

         

        Bev Edwards
        Veteran Member
        Posts: 366
        Veteran Member

          There are several Jon, but willing to do without the fields that do not exist in Lawson.

          Location Code, 

          Loc Description,

          Cost Center (or Dept),

          Dept Name,

          Invoice #,

          Invoice Line #,

          PO#,

          PO Description,

          PO Line #,

           PO Line Item Unit price,

          PO Line Item Qty,

          UOM,

          PO Line Item Total price,

          PO Issue Date,

          Purchase Date,

          Vendor #/Name, Part #,

          Part Descr,

          Manuf Name, 

          Manuf #, Vendor Name,

          Item #,

          Item Description,

          GL Acct #,

          GL Acct Description,

          Contract name,

          Payment #,

          Invoice amt,

          Invoice Gross amt,

          Invoice Disc amt,

          Invoice Net amt,

           Invoice date,

          Posted Date,

           Invoice Header,

          Invoice Line Description

          JonA
          Veteran Member
          Posts: 1162
          Veteran Member
            lars, AP270 will give you what you've paid to vendors. It doesn't break it out by department or account detail.
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            lars
            Veteran Member
            Posts: 54
            Veteran Member
              thank you
              Bev Edwards
              Veteran Member
              Posts: 366
              Veteran Member

                Hey Jon,

                 I just found out that another person had also been asked for that data and the report has been run and sent. No need to spend any time with this. I already wasted enough non knowing someone else had already completed it.

                 

                Thanks anyway!

                 

                Bev

                JonA
                Veteran Member
                Posts: 1162
                Veteran Member

                  Don't you love that?  We get that all the time in Purchasing. Someone calls for information and leaves the same message on three different buyers' voicemail.  They all run around trying to get the information not realizing they're doing the same work!

                  Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                  Bev Edwards
                  Veteran Member
                  Posts: 366
                  Veteran Member

                    Nothing worse than wasting my time at year end inventory prep. I'm trying to use my nice words. Failing miserably,....

                     

                    Thanks Jon! Sorry for the time you spent too but always grateful when you respond!!

                    You are not authorized to post a reply.