I have a over 200 vendors that I want to blank out the Acct field. When I import it the Vendor codes with a blank column, it says, "Invalid data '' for field called 'Inv Distribution Acct' of record 1." When I set the default for Inv Distribution Acct to blank, it says the same error. How can I blank these out? AP 8.1C (110729)

Susan:
That problem was solved with Payables 8.1D. That new version is being released this week.

Thanks Bruce, I guess I'll have to wait. We have a new person starting in Payables in a couple of weeks (when I get back from my Caribbean cruise ) and I want to clean this up before they start.

Hi Susan,

Adagio Payables 8.1D was released today. Your announcement e-mail should arrive shortly (if it hasn't already).

I installed 8.1D but it still does not work.

Susan:
Are you importing both the Acct and the Dept? Are there only 3 columns: Vendor, Acct and Dept? I tested that way and it worked (on a very small sample size).

I had only 2 columns, vendor and acct (since we don't use dept). When I added the dept column.. problem solved. Thanks Bruce!!!!