Open Forum

Expand all | Collapse all

VENDOR STATEMENTS IN EXCEL

  • 1.  VENDOR STATEMENTS IN EXCEL

    Posted Oct 04, 2019 03:40 AM
    Hi, we have started to receive Vendor/ Supplier Statements in Excel as opposed to paper/ PDF.

    Looking for suggestions on how we can set up templates in excel to reconcile our Nav data against the Statement

    Regards

    ------------------------------
    KEVIN BREEN
    MULHOLLAND CONTRACTS LTD
    WEST CALDER SCOTLAND
    ------------------------------


  • 2.  RE: VENDOR STATEMENTS IN EXCEL

    TOP CONTRIBUTOR
    Posted Oct 04, 2019 12:53 PM
    Hi Kevin,

    You can accomplish this via Jet Reports. If you have the vendor statements in excel, you can pull/query NAV data directly from Excel.

    ------------------------------
    Kristoffer Ruyeras
    Solutions Architect
    Tigunia
    Seattle, WA
    ------------------------------



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