Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
AFSMark
September 23, 2020
Solved

When importing check using IIF File what is the Column Header on the SPL Line for Inventory Site

  • September 23, 2020
  • 11 replies
  • 67 views

Our third party vendor needs to find out what the Column Header on the SPL line is for the Inventory Site for use in importing into our QB Enterprise v19.0.  Intuit only helps by giving me a link to a kit that does not contain the information that they need.  Anyone have any help on this?

Best answer by BigRedConsulting

Unfortunately there is no Inventory Site field included in the IIF file format.  Intuit added the Site concept a decade ago, but hasn't updated the IIF file format to include it.

11 replies

JasroV
JasroV
Level 8
September 23, 2020

Thanks for sharing the details with us, @AFSMark.


I appreciate you for checking our Intuit Interchange Format (IIF) import kit for QuickBooks Desktop (QBDT). 

 

I’d like to get this sorted out and get you back in working order. However, it’ll require me to look into your account which I’m unable to do.

 

To get around this, I recommend checking with our Support team. There, they can securely check your account and can guide you further on what column header to use on the SPL Line for your Inventory Site.

 

To reach out to them, you can follow these steps below.

  1. In your QBDT software, go to the Help menu.
  2. Select QuickBooks Desktop Help.
  3. Click Contact Us.
  4. Enter a brief discussion if your issue and select Let’s talk.
  5. Then choose your preferred way to connect with us.

You can also refer to this article for more details: Contact QuickBooks Desktop support.

 

I’m also adding these articles that you can read to learn more about importing IIF in QBDT:

In case you have other concerns or queries, you’re always welcome to leave a reply. I’ll be around to help you. Take care and keep safe.

AFSMarkAuthor
September 23, 2020

Thank you for responding!!! I have already tried the support route and they basically told me that they don't offer this type of assistance with IIF File Import/Export and he forwarded me a link to a kit which didn't help the programmer of our third party software.  As such, I tried this route next to see if anyone might be able to help us.  It seems like just a little thing to get.  Any other thoughts?

    Fiat Lux - ASIA
    Fiat Lux - ASIA
    Level 14
    September 23, 2020

    @AFSMark 

    Explore a 3rd party migration tool as another option. You may create a scheduler to export/import data automatically if required.

    https:// transactionpro.grsm.io/qbd

     

    AFSMarkAuthor
    September 23, 2020

    Thank you for your response!  I had already tried the QB support route and they basically said they don't help along the lines of IIF File Import/Export and he sent me a link to a kit that evidently did not help our third party programmer in getting the specific information he needed that I mentioned in my original post.  It seems like this shouldn't be a huge thing to ask of Intuit and I must admit my opinion has always been very good but I sure didn't like this response.  Any other thoughts or recommendations?

      BigRedConsulting
      BigRedConsultingAnswer
      Level 15
      September 23, 2020

      Unfortunately there is no Inventory Site field included in the IIF file format.  Intuit added the Site concept a decade ago, but hasn't updated the IIF file format to include it.

      Thinkgreen
      August 15, 2024

      I am also looking to import Inventory Site into an invoice IIF file.  I don't understand how Intuit can't support importing their defined data.  I can import the IIF successfully as is, but the customer needs the Inventory Site data available in their invoice.  They can't expect to be able to import thousands of invoices, and then go back and manually update one simple field that should be available to import along with all the other SPL fields that are supported.  

       

      Is there a way to mass update that field after the fact?  Is there an ETA as to when Intuit will support importing a field that they added to their invoice template.

      CamelleTModerator
      Moderator
      August 15, 2024

      Thank you for highlighting your queries, ThinkGreen.  I appreciate the opportunity to address them thoroughly. To ensure that you have a clear understanding and all the information you need, I will go through each of your concerns below. 

       

      In QuickBooks Desktop (QBDT), the data you can import via IIF are only those specified in the Import Kit.

       

      For more details, please refer to this article: IIF Overview: import kit, sample files, and headers.

       

      Regarding the supportability of importing a field added to the invoice template, no timeframe has been provided yet. In the meantime, I suggest sending your feedback about this, including the option to bulk update the inventory site field. Here's how: 

       

      1. Go to the Help menu.
      2. Select the Send Feedback Online option, then Product Suggestion.



      3. Type your feature recommendation in the space provided.



      4. Hit the Send Feedback button.

       

      We look forward to incorporating your insights into our ongoing efforts to enhance our product. These are carefully analyzed to ensure our updates align with your needs. If you have questions about managing IIF files or other tasks in QBDT, comment below. The Community space is here round the clock to assist. 

      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement