x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 3 replies
  • Answers 2 answers
  • Subscribers 17 subscribers
  • Views 1062 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
Dominic Bell

How to get transaction values for the nominal ledger in ODBC Sage 200 connection.

SUGGESTED
Posted By

Hi,

i'm new to using sage 200 and have been given access to our ODBC connection to review some of the reporting tables available to us. I'd like to create a connection that allows me to pull nominal transactions but while the table "NLPostedNominalTran" holds every transaction, it does not give any financial values for some reason?

please can someone help me with what other table i may need to join in to get this information?

thanks

Dom

Parents
  • 0
    SUGGESTED

    Hi Dominic,

    As Geoff says, you would be better using the Excel integration. We have reports in there that are purpose built to update whenever they're refreshed and can be modified by updating the schema for the report. 

    Your Business Partner may have more information on this for you or may be able to provide this functionality for you.

    We do not have an up to date document detailing the Sage 200 database, but the vast majority of this has not changed it was last published.

Reply
  • 0
    SUGGESTED

    Hi Dominic,

    As Geoff says, you would be better using the Excel integration. We have reports in there that are purpose built to update whenever they're refreshed and can be modified by updating the schema for the report. 

    Your Business Partner may have more information on this for you or may be able to provide this functionality for you.

    We do not have an up to date document detailing the Sage 200 database, but the vast majority of this has not changed it was last published.

Children

*Community Hub is the new name for Sage City