Open Forum

AP Voucher & Adjustment Entry Transaction Import (SNotes)

  • 1.  AP Voucher & Adjustment Entry Transaction Import (SNotes)

    Posted 10-26-2018 01:14 PM
    ​We would like to start using Transaction Import to import data into the AP Voucher & Adjustment Entry screen (03.010.00).  I was able to import all the data I needed except for notes (when you click the yellow post-it note icon located in the bottom left of the screen and add notes related to the line item).  I believe the field is called "SNotes" but I don't see this field listed on the Control File that generates for screen # 03-010.00.  Does anyone know how to add this to the Control File or just how to get notes to import?  Thanks so much for your help!




    ------------------------------
    Corrie Kumbalek
    Accounting Assistant
    KBA, Inc.
    Bellevue WA
    ------------------------------


  • 2.  RE: AP Voucher & Adjustment Entry Transaction Import (SNotes)

    Posted 10-27-2018 07:03 AM
      |   view attached
    Review this attachment, it contains instructions on how to add the SNote table to your TI Control Macro, along with a sample .ctl file.

    The file is also downloadable from this URL:
    https://mbs.microsoft.com/downloads/customer/TK112407_tinotesv5.zip

    ------------------------------
    Mark Ehleben
    President
    QBI Consulting, LLC
    Warminster PA
    ------------------------------

    Attachment(s)

    zip
    TK112407_tinotesv5.zip   3K 1 version


  • 3.  RE: AP Voucher & Adjustment Entry Transaction Import (SNotes)

    Posted 11-02-2018 11:31 AM
    Thank you for your response & attachment Mark!  Unfortunately, this example looks like it's for a different screen so I'm still not totally sure where to add some of these scripts into my Control Macro.  Also, I'm just very unfamiliar with the format and it's a little intimidating.  Appreciate the help though!  If anyone has an example of a Macro that includes SNotes for the  AP Voucher & Adjustment Entry screen (03.010.00), that would be super helpful!  Thanks so much!

    ------------------------------
    Corrie Kumbalek
    Accounting Assistant
    KBA, Inc.
    Bellevue WA
    ------------------------------