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

Question

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.

Sandra Smith · Accepted 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. 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.

socasue · Answer

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

Sage 100

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

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING