Accounts Payable Invoice Import Method

Unfortunately, the current AP invoice Import method is not effective when inputting an invoice with a large number of GL Line Items (200 or 300). If there is any way that you can change the Import format for invoices to have the distributions on multiple rows going Down the Excel spreadsheet instead of all the Line Items going across one row, the AP Invoice Import will be much more effective and easier.

  • Guest
  • Jul 1 2020
  • Needs review
Payables
  • Attach files
  • Guest commented
    October 19, 2022 13:20

    We are running into the same issue when trying to upload data from Amazon. This would be super helpful. Right now it takes more time to reformat the data to fit the spreadsheet than it does to cut and paste directly into FE NXT. The spreadsheet needs to be set up with the distribution lines on multiple rows, not across one row. Also, there appears to be only once place to put a description on the spreadsheet, but each distribution needs its own description.

    Attachments Open full size

Related ideas