Open Forum

Expand all | Collapse all

Payables WORK with AA

  • 1.  Payables WORK with AA

    SILVER CONTRIBUTOR
    Posted 19 days ago
    Edited by Curtis Cruz 19 days ago
    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 19 days ago
    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 19 days ago
      |   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 19 days ago
    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 18 days ago
    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 18 days ago
    ​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