cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Super Contributor **

Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

I downloaded the IIF Import Kit. I want to know the difference between 2 "!VEND" line in "BILL Payment (Write Check Against AP).iif"?

Solved
Best answer 11-05-2018

Accepted Solutions
Community Manager

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

@BenTam, Hello. I'm actually wondering that as well. I want to be certain we're looking at the same thing. One !VEND has a line under it with Refnum 1 whereas the other !VEND has a line under it with Refnum 25. It almost looks like a duplicate except for some subtle changes. Let me know and I'll see what I can find out. Thanks, ~B
Established Community Backer ***

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

You only need one Header declaration, to add multiple Vendor Names under this. You can see this by Exporting from any Sample file, or even your own. File menu > Utilities, Export, Lists, Vendor list. Then, open it using Excel.

 

One row for !VEND simply defines which data is in which sequence for the fields

 

Each actual name and info is the VEND line, one per line.

 

To learn, it helps to Export and look.

13 Comments
Moderator

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

Hi there, BenTam.

Welcome to the Community. I'm here to provide some insight about the difference between the 2 !VEND lines on your bill payment.

!VEND indicates the transactions and information of your vendors, these details are usually found when you double click their name. While the VEND line indicates the name of the vendor that owns the !VEND details.

To know more about this process, please refer to this article: https://community.intuit.com/articles/1501233.

 

I'm just a post away if you have any questions about these concern or with QuickBooks. Take care.

 

 

 

 

Super Contributor **

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

Hi Betty, thanks for your reply. However I wonder your have answered my question. My question is why there is 2 !VEND header lines. What's the difference between these 2 header lines.

Moderator

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

Hi there, BenTam.

Thanks for your quick response.

I've tried replicating this on my end using the .IIf import kit found on the link that I've provided and it's working fine. I'd suggest downloading the file again using the .IIF kit. Once done and the still issue persists, I'd recommend giving our Technical Team a call so they can better isolate this matter. They have the necessary tools to work with you to find out what exactly may be causing this issue.

To reach them:

  1. In your browser, navigate to https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose QuickBooks Desktop.
  3. In the Contact Us page, click the issue or topic.
  4. Click the Green Phone button to see the support number.

Please let me know if you have further questions. I'll be around to help. Have a great weekend.

Community Manager

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

@BenTam, Hello. I'm actually wondering that as well. I want to be certain we're looking at the same thing. One !VEND has a line under it with Refnum 1 whereas the other !VEND has a line under it with Refnum 25. It almost looks like a duplicate except for some subtle changes. Let me know and I'll see what I can find out. Thanks, ~B
Super Contributor **

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

Hi Brandon.  Yes, we are looking at the same thing.

Established Community Backer ***

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

There are a lot of minor mistakes in the import kit. For instance, open the VEND help file and the info tab shows it is CUST for Customers & Jobs.

Community Manager

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

@BenTam,

 

I've imported that very example into QB 2018 and it imported without issue. I also removed the first two lines and it imported that modified iif template into a new file and it also imported without issue. I could not see any difference between the two transactions.

 

I tried this same test in QB 2019 and it noticed the duplicate Vendor name and did not import.

 

As I understand it, the !VEND header is only necessary to add a new Vendor Name into QuickBooks and the iif transaction. If the names already exist in QuickBooks, you would not need any of the !VEND headers. Yet, since more than one name can be added from the template, my only guess is that the original template author placed both identical headers as a means to enter multiple names.

 

I am working with our developers to see how we can improve those templates or messaging to avoid any confusion as I was also perplexed by that specific template example.

 

Thanks for bringing it to our attention. ~B

 

Established Community Backer ***

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

You only need one Header declaration, to add multiple Vendor Names under this. You can see this by Exporting from any Sample file, or even your own. File menu > Utilities, Export, Lists, Vendor list. Then, open it using Excel.

 

One row for !VEND simply defines which data is in which sequence for the fields

 

Each actual name and info is the VEND line, one per line.

 

To learn, it helps to Export and look.

Super Contributor **

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

Hi qbteachmt and Brandon

 

Thanks for your information. It really helps me a lot!

Established Member

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

Hello BettyJaneB,

 

I keep getting this error when I try to import Full Bill Payment: "You cannot import a blank transaction, Fill in the appropriate fields and try again." Do you have any idea how to fix this error?

 

Thank you!

Established Member

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

Hello,

 

I keep getting this error when I try to import bill payments using IIF. "You cannot import a blank transaction, Fill in the appropriate fields and try again."

 

Any suggestions on how to fix this?

 

Thank you!

QuickBooks Team

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

Hi there, rlnacct.

 

If you're using QuickBooks 2019, you can review the error message and fill in the appropriate fields before importing the bill payments again.

 

Here's how:

 

  1. Click Review now.
  2. Look for ERROR to see what the problem with the file is.
  3. Correct the errors and Save. If asked if you want to keep the file type, select Yes.
  4. Close the File not imported window.
  5. Import the new, corrected .IIF file.

For more details about the improved IIF import in QuickBooks 2019, you can check out this article: https://quickbooks.intuit.com/community/Help-Articles/Improved-IIF-Import-in-QuickBooks-2019/m-p/203....

 

If you're using other QuickBooks version, try importing the transactions again. Then, ensure the bill payments field are filled out correctly (as stated in the error message).

 

You can check the Export or import Intuit Interchange Format (.IIF) files for the steps and details.

 

I've got an article to learn more about IIF files: IIF Overview: import kit, sample files, and headers.

 

Please reply to this thread if you have more questions with importing IIF files in QuickBooks.

Super Contributor **

Re: Why "BILL Payment (Write Check Against AP).iif" has 2 "!VEND" header

Dear RCV. Thanks for your reply!