Sage 100

 View Only

  • 1.  Add Company Code to Sage Intelligence Consolidating table using Connector

    Posted 02-25-2019 09:30
    We are consolidating multiple companies and would like to add the company code to identify which company the record is derived.  This has to be something I am missing.  I believe I remember this as part of my training but do not recall how to do.

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------


  • 2.  RE: Add Company Code to Sage Intelligence Consolidating table using Connector

    Posted 02-25-2019 09:52
    Edited by Nancy Hanson 02-25-2019 09:52
    Go to the Connector/Container, right click on a table, add Expression/Data Field.  It may ask you which table.  Once you get to the list of fields, find Company Code, check the box to add it.  You may need/want to add it to multiple tables.

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------



  • 3.  RE: Add Company Code to Sage Intelligence Consolidating table using Connector

    Posted 02-25-2019 09:56
    We are querying AR Tables, not GL.  There does not appear to be a Company Code field in AR_Transaction or AR_Customer.

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------

    Original Message


  • 4.  RE: Add Company Code to Sage Intelligence Consolidating table using Connector

    Posted 02-25-2019 10:01
    Can you bring in SY_Company (may not be correct table) like you would in Crystal and join it?

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------

    Original Message


  • 5.  RE: Add Company Code to Sage Intelligence Consolidating table using Connector

    Posted 02-25-2019 10:16
    Looks like we have to start with AR_Options.

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------

    Original Message


  • 6.  RE: Add Company Code to Sage Intelligence Consolidating table using Connector

    Posted 02-25-2019 20:53
    1. Connector
    2. MAS 90 4.0 ODBC Driver
    3. Sage MAS Consolidation
    4. New
    5. SQL Join Type
    6. Source Container (Join) would like similar to the following:

    ((("AR_Customer"
    INNER JOIN "AR_OpenInvoice"
    ON "AR_OpenInvoice"."ARDivisionNo" = "AR_Customer"."ARDivisionNo" and
    "AR_OpenInvoice"."CustomerNo" = "AR_Customer"."CustomerNo")
    LEFT JOIN "AR_Options" ON "AR_Options"."CompanyCode" = "AR_Options"."CompanyCode")
    LEFT JOIN "SY_Company" ON "AR_Options"."CompanyCode" = "SY_Company"."CompanyCode")

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


Related Content