Gathering info for Vendors

I am new to Crystal Reports and I am trying to figure out how to put some vendor information into my report. I have their number, name, address in it and now I need how much they have purchased. I used InvoiceAmt and even NetInvoiceAmt in the report but where it should be millions one particular vendor, it shows a negative $5000 (I have a parameter field covering the date range in the report also).  So I either have the wrong information, I am pulling it from the wrong place, or I'm pulling partial information.  Any thoughts or suggestions? Thanks in advance. 

  • 0

    What tables are you using?

    How are they linked?

    Any selection criteria other than the date range?

  • 0 in reply to Helium

    No, there is no other selection criteria. That's part of the problem, the fact that I don't have any tables in the report. Not familiar with tables and linking the data to the table. I have played around with it quite a bit trying to learn as I go, but it is not easy. I realize that I may be asking an impossible question seeing how that I am a novice at Crystal Reports so I understand if responses/replies may not answer my question.

  • 0 in reply to [email protected]

    Ever thought of taking some classes or calling your reseller. I would say that not having any tables in the report could be a source of your problem.

  • 0 in reply to BigLouie

    Yeah, taking classes is in the works.  Just thought I could get this figured out first.  

    And yes, I do have tables in the report (still learning lingo) but linking it to the data I need is throwing me off.  Maybe I need a parameter field or something. I come from a design background and through my eyes, this whole program is poorly designed and confusing. But this is program is widely used so I'm probably in the minority. Just trying to get the total dollar amount our vendors has purchased from us, but the data is incorrect. Thanks for your assistance everyone.

  • 0 in reply to [email protected]

    Any reason why the following canned reports might not work?

    A/P

      Vendor Purchase Analysis

      Vendor Purchase History by Period

      Monthly Purchase Report

    P/O

     Purchase History Report

    Business Insights Explorer

      Vendor History Purchases

    If none of those work, try the Business Insights Reporter - it helps you create crystal reports and has various views that prelink tables, thus helping to insulate you from understanding which tables to pick and link..    Look at the Vendor History views.  

  • 0 in reply to TomTarget

    They do technically work, but I am looking to make an all inclusive report with all my vendors, addresses, phone numbers, and total purchases.  I'll try out the BIS and see if that will help.  Thanks.