FE NXT import to add new AP invoice records

Has anyone tried it yet? I compared the “initial template" to one of our existing import records in database view which allows multiple account distribution.

f42f62a3b524bfa612db623f69268df4-huge-ap

The template looks like it could only support one record. I understand it could still be a work in progress.

Thanks in advance.

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Ferdie Alayon
    the current invoice import can import multiple invoices but there are large differences in the current one. The vendor has to have a default distribution, so you don't actually define your accounts / projects at all on it. 2nd it currently doesn't copy down the 1099 information. Meaning if any vendor is a 1099 vendor you'd have to go back and manually update those invoices. With that said, in the May 2nd PUB for FENXT, they said they are bringing forward all the DB view import templates. With that in mind I'd not worry about the current iteration of the invoice import. The function they are bringing forward will mean you'll use your same template for DB view in webview once they develop it.

  • @Kevin Brazell thanks for your reply. I'm hoping they do bring forward all DB view import templates. I love how we could import Attributes (NXT Custom Fields) with the AP invoice record. Also, default distribution won't work in this case. The import file has specific accounts and projects defined already.

  • @Kevin Brazell thank you for this clarity. We were alarmed by the loss of all the options for invoice import in web vs. database. We use this often and the web's reliance on vendor defaults doesn't work for us in terms of grant or expense payments. We pay the same vendor through multiple expense/grant accounts. There seems to be a trend of losing a lot of detailed information in multiple modules in the transition so far, which is seems to be keeping people in database. We would love for web to be as robust as database!

  • @Kevin Brazell having the 1099 information missing is a BIG deal, we import hundreds of records every month and the majority are 1099 vendors. also most of the vendors have multiple distributions, so that means a lot of manual adjustments on each import.

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Michelle Nielsen
    I agree. Essentially I don't use the new method for this reason and use the DB view import for invoices until they migrate that process to webview.

  • @Michelle Nielsen Which is unacceptable. We have multiple cost centers, grants, etc that would each be a unique import.

  • @Kevin Brazell:
    they said they are bringing forward all the DB view import templates.

    I'm excited to see the templates are now available.

    I'm just not sure if it's fully functional.

    19f46ecdf68697f8ad715676451aa49c-huge-ca
  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Ferdie Alayon
    I've seen import in many databases since Thanksgiving. I've only tried the JE import but it worked. If you see Import in your drop down for a module , technically it should be enabled. If you're getting an error I'd double check the file patch as the file path is different vs DB view, and if not working contact support to troubleshoot.

  • @Kevin Brazell
    I tried import templates for JE and AP invoices in NXT, creating a new and editing an existing template. I encountered the same file path error so that's encouraging, maybe it's one simple fix. Thanks!

  • @Ferdie Alayon
    Where are you able to obtain the templates?

  • @Chris Uzun
    I created them myself and each one depends on number of invoice account distribution lines I'm importing. Here's the knowledgebase article Import Invoices but I find the database view version more detailed.

  • @Kevin Brazell
    Happy Friday, Kevin! Quick question, where is this box in NXT? It used to be in Tools -> Options. Thanks!

    c7d63715d4ca8e61c1d84ddab9195527-huge-ca
  • @Chris Uzun YES! All of them!

    42d835271bf6cf3b2dfb1f079ff48e6a-huge-ca


Categories