Sage 100

 View Only

  • 1.  Multi-Company Report for Unposted AP Invoices

    Posted 06-16-2022 11:59
    Is anyone aware of a tool that can generate a report of unposted invoices across multiple companies?

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------


  • 2.  RE: Multi-Company Report for Unposted AP Invoices

    Posted 06-17-2022 09:55
    You could do this with Crystal Reports, You would just need to setup a silent ODBC connection for each company code in Sage 100 first.  then I would create a main crystal report with a subreport specific to each company code and the data source in each subreport would use the appropriate ODBC connection.

    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 3.  RE: Multi-Company Report for Unposted AP Invoices

    Posted 06-17-2022 11:31
    Use GL_CompanyActiveBatch, SY_Activation and SY_Company files in the Crystal report - you won't need separate ODBC connections.   




    ------------------------------
    Moira Goggin
    Chismet Consulting Corp.
    ------------------------------

    Original Message


Related Content