VI import to AP Invoice Header using Expense Distribution Tables with automatic lines being created

SOLVED

We're trying to import AP invoices using Expense Distribution Tables.  When entering an AP invoice manually, the lines auto-populate, but using VI there is just an error (with the same input).

No L fields (because the goal is to let the lines be auto-populated).

The Header data is accepted, but the import fails because it's out of balance.  Is this strategy possible (i.e. are the Expense Distribution Table automatic lines programmed using UI objects)?

Parents Reply
  • 0 in reply to Mike Peck

    If each Vendor is already assigned an Expense Distribution Table Code then no it does not have to be in the import file.  

    Assigning a default Expense Distribution Table Code to a Vendor was just added as a feature a couple of years ago.  If your current version of Sage 100 does not have that feature the table code will have to be imported.

Children