Vanco Import Error

Contributions, Faith Promises

Moderators: Moderators, Tech Support

Post Reply
beas
Posts: 121
Joined: Mon Nov 17, 2003 11:29 pm
Location: Neighborhood Church (A/G), Albany, OR
Contact:

Vanco Import Error

Post by beas »

Since I installed the current MR yesterday, when I try to look at what is ready to import from Vanco, I get an error: "Transit Access Account is not used in Fund __, with a fund number (e.g. 02). I have never had this error show up. I looked at the import setup which has 1130-000 as the transit access account. It has worked fine forever and again, I've never seen this error. Anyone else having this problem?
Bill Beasley
Secretary-Treasurer
Neighborhood Church
Albany, Oregon
User since ~1988

beas
Posts: 121
Joined: Mon Nov 17, 2003 11:29 pm
Location: Neighborhood Church (A/G), Albany, OR
Contact:

Re: Vanco Import Error

Post by beas »

Checking back on the MR info from yesterday, I see there was something dealing with with Vanco import.
Bill Beasley
Secretary-Treasurer
Neighborhood Church
Albany, Oregon
User since ~1988

NeilZ
Posts: 10326
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Vanco Import Error

Post by NeilZ »

beas wrote:
Wed Oct 16, 2024 5:31 pm
Checking back on the MR info from yesterday, I see there was something dealing with with Vanco import.
Do you have the transit access account setup for Fund 02?
Neil Zampella

Using PC+ since 1999.

beas
Posts: 121
Joined: Mon Nov 17, 2003 11:29 pm
Location: Neighborhood Church (A/G), Albany, OR
Contact:

Re: Vanco Import Error

Post by beas »

I didn't up until yesterday and the latest MR. I only had it set up for Fund 1 and it has been working forever. I am just guessing here, but PC must have been looking for the 1130-000 account line and using the first one it found. And that worked just fine.

It appears that now it requires an 1130-000 in each fund that has imported funds. I don't know if that was an intended change. I'm going to add the 1130 account to each of my funds and see if that works.

UPDATE: Added the 1130 to all funds. Then it wanted the expense account in every fund. I did that as well and now I can see the imports. Again, yesterday before the MR it was doing the import just fine. Now it requires these account lines in each fund.

Would have been nice if PC had given a little more detail on what actually changed. Here's what we received:

Import from Vanco - Account validation issues on setup

Oh, well, I'll work with it. First time I've run into this kind of thing. Been using PC+ since 1988.
Bill Beasley
Secretary-Treasurer
Neighborhood Church
Albany, Oregon
User since ~1988

Zorak
Tech Support
Tech Support
Posts: 3078
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Vanco Import Error

Post by Zorak »

PowerChurch was previously enforcing that the Transit Asset and Fees Expense accounts were set up in the Accounting Fund that the Debit (Bank) account was in on all Contribution Funds. We found in one particular user's case, where they had Contribution Funds with accounts assigned out of balance (meaning Debit to Fund 01 and Credit to Fund 02, for example), that we were creating a transaction referencing accounts that don't exist in Fund Accounting. That is easily avoidable by properly validating the accounts that you create for Vanco import are used in all the Accounting Funds that you have in use in Contributions.

We thought that is what it was doing all along, but for some reason didn't see the use case of people purposefully assigning CO Funds in an OOB fashion.

beas
Posts: 121
Joined: Mon Nov 17, 2003 11:29 pm
Location: Neighborhood Church (A/G), Albany, OR
Contact:

Re: Vanco Import Error

Post by beas »

Thanks, Zorak. Kind of what I figured.
Bill Beasley
Secretary-Treasurer
Neighborhood Church
Albany, Oregon
User since ~1988

Post Reply