Is there a way to pull data from a specific source code, like AP or AR?

SOLVED

We are looking for a way to separate our YE AJE's.  It was suggested to us to use a source code named AJ.    We'd like to create a set of financials that shows the unadjusted trial balance, then the AJE's, and then the final balances.

So, my question is if intelligence will allow for me to pull data from a specific source code.

Thanks.

  • 0

    I don't have an answer with specific steps for you as i don't do too much with Sage Intelligence but if you are using any source that contains the detail/transaction data, it should include the SourceJournal field which you could filter on.

  • 0 in reply to David Speck

    I've tried looking around for "SourceJournal" and I do not see it.  I must not be looking in the right place. 

  • 0 in reply to L Energy

    If you don't have the Connector license that allows you to define sources then you are stuck using the out-of-box data sources and i don't know if any of those will allow you to include and filter on the SourceJournal.

    You may need to either tinker around or wait until someone else can give you a better answer.

  • +1
    verified answer

    Hi,

    David is correct in saying that you will most likely need the Connector module which enables you to connect to tables within 100 and other ODBC database tables.  Then you can add an expression from those tables either in the form of a field or combining fields using an Excel or SQL formula.  If you do not have the connector module then you can work with your Sage Partner to look for the field/fields you need.  

    When you say that you looked around and could not find the SourceJournal field where were you looking? Within 100 tables or Sage Intelligence reports? If you were looking in 100 tables and could not find it then maybe someone can offer information beyond what I know for how to find that field or data.  Maybe it would result from a formula of some kind.  Maybe that is the original question.  Slight smile  Maybe submit the question to another 100 group. Once you learn the field/fields you need you work with the Connector to find the field or build it as a formula.  

    I hope this helps. 

    Thank you, 

    Sandra. 

  • 0 in reply to Sandra Smith

    Thanks for the response.  I may try to look at this myself, but  I think this is over my head as a relative newbie.  I'll probably have to contact my sage partner for help.

    Again, I appreciate the reply.

  • 0 in reply to L Energy
    SUGGESTED

    Hi, In order to get more familiar with the tables we do have Anytime Learning topics available (Program and Data Files: Business Framework  File Structure would be a place to start).  We offer a very comprehensive series of courses for Sage Intelligence Reporting starting with a recorded Anytime Learning Beginner course and then going on to Instructor led courses.  Please go to www.sageu.com/sage100 to see all of our courses

  • 0 in reply to socasue

    Thanks for the tip.  I'll check out the courses.