Open Forum

Expand all | Collapse all

Table Link

  • 1.  Table Link

    GOLD CONTRIBUTOR
    Posted 6 days ago
    I'm trying to create a Smart List view linking the slbAccountTrx view with the PM30200 / PM2000 / PM1000 tables. I specifically need the field PORDNMBR field from the PM tables.

    The slbAccountTrx view contains the following table:
    • POP10110
    • dbo.slbAccountTrx_Work
      • GL10001
      • GL10000
      • GL00100
    • dbo.slbAccountTrx_Open
      • GL20000
      • GL00100
    • dbo.slbAccountTrx_Hist
      • GL30000
      • GL00100
    • GL00100
    • MC40200
    • GL10000
    • GL10001
    • GL30000

    As always, any help or guidance is appreciated.

    Thanks.

    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Table Link

    SILVER CONTRIBUTOR
    Posted 6 days ago
    Jon,

    You should be ale to link on:
    GL.ORCTRNUM = PM.VCHRNMBR and =GL.ORTRXTYP = PM.DOCTYPE

    ------------------------------
    Aref Karam
    Data Consultant
    LTI Information Technology
    Ann Arbor MI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Table Link

    TOP CONTRIBUTOR
    Posted 5 days ago
    Jon,

    Not exactly sure what you are trying to build out, but if it helps, we have a template for SmartList Builder and/or Excel Report Builder that pulls together the GL and PM data.  We have a Summary and Detail one depending on how you post to GL.  They are built to give you a list of your Payables transactions with their corresponding posted GL Transaction.

    You can find the templates if you are interested here:  https://www.eonesolutions.com/smartlist-builder/downloads/#templates.  Under the Purchasing series is where you will find the PM Distributions with GL Summary and PM Distributions with GL Detail lists.  You can download them there and import of depending on your GP version, you can import them in the SLB import window by selecting the Web tab.  If you need more on importing xml files into SmartList Builder, you can find it in the manual here:  https://www.eonesolutions.com/Manuals/SmartList-Builder/SmartList%20Builder/toc377551035.php.



    ------------------------------
    Nicole Albertson
    Product Manager
    eOne Solutions
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role