Open Forum

Expand all | Collapse all

Payables WORK with AA

  • 1.  Payables WORK with AA

    SILVER CONTRIBUTOR
    Posted Nov 20, 2019 12:23 PM
    Edited by Curtis Cruz Nov 20, 2019 02:51 PM
    Does anyone have a SQL View for Payables transactions in WORK status that joins to AA tables.

    I'm trying to create a view for users to review their Payables batches in SmartList that includes AA transactions.

    The AA tables I'm finding difficult to join.

    ------------------------------
    Curtis Cruz
    Database Administrator
    Apex Healthcare Partners LLC
    Montebello NY
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Payables WORK with AA

    GOLD CONTRIBUTOR
    Posted Nov 20, 2019 01:22 PM
    Hi Curtis,
    Since you want to publish it to Smartlist, it will be a view and in order to create the view, we may need to know your data in AAG00400.
    You can send it to me and I can send you the view.

    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Payables WORK with AA

    SILVER CONTRIBUTOR
    Posted Nov 20, 2019 02:56 PM
      |   view attached
    Hi Gerald,

    thanks so much for your assistance with this.

    I've attached an image of the results of table and as well pasted into excel.

    I really appreciate any assistance. I'd like to join the AA data to the PM10000 along with PM10100 distribtion table to give users ability to review their batches to double check AA etc....


    ------------------------------
    Curtis Cruz
    Database Administrator
    Apex Healthcare Partners LLC
    Montebello NY
    ------------------------------

    Attachment(s)

    xlsx
    AAG00400.xlsx   9K 1 version
    Conference-GPUG_200x200


  • 4.  RE: Payables WORK with AA

    GOLD CONTRIBUTOR
    Posted Nov 21, 2019 09:55 AM
    HI,
    I am having issues in uploading and attaching the query.  if you want you can email me gbuenafe@btptek.com


    Gerald


    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Payables WORK with AA

    GOLD CONTRIBUTOR
    Posted Nov 21, 2019 03:50 PM
    Curtis,
    hope the query is good :)

    Gerald

    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: Payables WORK with AA

    SILVER CONTRIBUTOR
    Posted Nov 21, 2019 04:47 PM
    ​Thanks to Gerald Buenafe of BTP Technologies, LLC, he was able to work with me to deliver a view of Payables transactions in WORK with associated AA transactions if applicable.

    I'd like to thank you personally Gerald for your prompt responses and assistance.


    ------------------------------
    Curtis Cruz
    Database Administrator
    Apex Healthcare Partners LLC
    Montebello NY
    ------------------------------

    Conference-GPUG_200x200


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