PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/15/2015 6:51 AM by  JonA
GLTRANS attributes
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Sherry Shimek
Private
Private
Advanced Member
(94 points)
Advanced Member
Posts:42


Send Message:

--
05/11/2015 2:11 PM

    We have 3 source codes that post to the General Ledger with GLTRN object attribute values.  One has one attribute; this is easy.  The other two use the maximum three attributes.  Is there a way to run a GLTRANS query with all three attributes without triplicating the records? (Using OTM set at 3 we can get all three attributes in the query but it provides the actual records once for each attribute. This results in triplicate data if the transaction had all three attributes for that system code.)

    I have tried using the Category tables in the query, but haven't found a way to get all three mx values in the results.

    I am working to get this information using ODBC queries but would prefer this in MS Addins that our users can duplicate.

    Thanks,

    Sherrill Shimek

    CHI Connect Financial Systems

    Catholic Health Initiatives

     

    Sherry Shimek Catholic Health Initiatives Englewood CO
    JonA
    Private
    Private
    Veteran Member
    (2949 points)
    Veteran Member
    Posts:1037


    Send Message:

    --
    05/15/2015 6:51 AM
    I'm not very familiar with attributes but it's been my experience with Addins and ODBC queries that if Table1 is linked to Table2 via common fields and there are multiple record matches in Table2, the output will result in duplicate records out of Table1- one for every match in Table2. I've not found any way around this.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.