PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 6/25/2015 6:55 PM by  Bev Edwards
PO Spend History
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Bev Edwards
Infor Supply Chain Consultant
Surety Systems
Veteran Member
(717 points)
Veteran Member
Posts:363


Send Message:

--
6/25/2015 11:40 AM

    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
    Private
    Private
    Veteran Member
    (3449 points)
    Veteran Member
    Posts:1147


    Send Message:

    --
    6/25/2015 4:37 PM
    It depends on what fields you need. Can you list them?
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    lars
    Buyer II
    DuPage County Government
    Veteran Member
    (126 points)
    Veteran Member
    Posts:54


    Send Message:

    --
    6/25/2015 5:08 PM

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

     

    Bev Edwards
    Infor Supply Chain Consultant
    Surety Systems
    Veteran Member
    (717 points)
    Veteran Member
    Posts:363


    Send Message:

    --
    6/25/2015 5:09 PM

    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
    Private
    Private
    Veteran Member
    (3449 points)
    Veteran Member
    Posts:1147


    Send Message:

    --
    6/25/2015 5:14 PM
    lars, AP270 will give you what you've paid to vendors. It doesn't break it out by department or account detail.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    lars
    Buyer II
    DuPage County Government
    Veteran Member
    (126 points)
    Veteran Member
    Posts:54


    Send Message:

    --
    6/25/2015 5:17 PM
    thank you
    Bev Edwards
    Infor Supply Chain Consultant
    Surety Systems
    Veteran Member
    (717 points)
    Veteran Member
    Posts:363


    Send Message:

    --
    6/25/2015 5:23 PM

    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
    Private
    Private
    Veteran Member
    (3449 points)
    Veteran Member
    Posts:1147


    Send Message:

    --
    6/25/2015 5:29 PM

    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    Bev Edwards
    Infor Supply Chain Consultant
    Surety Systems
    Veteran Member
    (717 points)
    Veteran Member
    Posts:363


    Send Message:

    --
    6/25/2015 6:55 PM

    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.