Sage 100

 View Only
Back to discussions
Expand all | Collapse all

In SAGE 100 STD v2017 PU#3 is there a way to add t

  • 1.  In SAGE 100 STD v2017 PU#3 is there a way to add t

    Posted 01-12-2018 05:01
    In SAGE 100 STD v2017 PU#3 is there a way to add the ""Purchases"" field from the AP_VendorPurchasesHistory table, where the total for all periods and FiscalYear=2017 to the ALE Lookup AP_Vendor AP Vendor Master List. I'm trying to export a simple vendor list to Excel that contains 2017 YTD Purchases for each vendor. Should I be looking at BIE? VI? Crystal?


  • 2.  RE: In SAGE 100 STD v2017 PU#3 is there a way to add t

    Posted 01-12-2018 05:36
      |   view attached
    Like this?

    Attachment(s)

    rpt
    VendPurchases.rpt   49 KB 1 version


  • 3.  RE: In SAGE 100 STD v2017 PU#3 is there a way to add t

    Posted 01-12-2018 05:45
    Thanks @MarkKotyla I need to add a few more fields (cells) like Address1, Address2, City, State, Zip, Phone etc. from the AP_Vendor table, but this will get me started.


Related Content