Automate

 View Only

  • 1.  Query - AP Transactions

    Posted 12-09-2021 11:00
    Hello everyone,
    Wondering if anyone has built a query to extract AP transactions.
    thanks

    ------------------------------
    Frank Simms | Controller
    Equinox Gold Corp | 9289193752
    ------------------------------


  • 2.  RE: Query - AP Transactions

    Posted 12-09-2021 12:25
    Hey Frank -

    Does the query template available in our template library cover your needs? https://community.winshuttle.com/sap-module-templates/viewdocument/extract-accounting-document-header?CommunityKey=8a12989f-fefe-4b81-8147-4bbb11af6820&tab=librarydocuments 

    Thanks!

    ------------------------------
    Jennifer Hwang | Senior Solutions Engineer
    Winshuttle North America
    ------------------------------

    Original Message


  • 3.  RE: Query - AP Transactions

    Posted 12-09-2021 12:54

    Hello Jennifer,

    Not really. Looking more for AP transactions that would list out invoices, vendors, PO's etc.

    Thanks,

    Frank

     




    Original Message


  • 4.  RE: Query - AP Transactions

    Employee
    Posted 12-10-2021 10:58
    Hi Frank,

    The PO query  template Jennifer pointed you to works in ECC and S4.

    Here are tables for an Invoice to get you started - again works in ECC and S4.  BSIK is OPEN invoices and BSAK is CLOSED invoices.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 5.  RE: Query - AP Transactions

    Posted 12-09-2021 12:54

    We are also using S4/HANA

     




    Original Message