United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
AZEmbroiderer
Level 3
posted
‎February 20, 2020 10:47 AM
last updated ‎February 20, 2020 10:47 AM

Inventory / PO's

Hello All -

When I import an IFF file and it populates into Purchase Orders, I can edit the item so all of the info imports correctly when I select the PO to match the Bill I am entering.  Make sense??

 

Ex:

My PO columns

MPN   Sub Item   Style #    Description   Size    Qty    Unit Price    Customer    Date   Total 

                                 xxx          xxx                             xx          xx                                                  xx

The x's are the rows that have the basic info from the IFF.  I have to fill in the rest and edit the x's to match my inventory SKU's etc.  This way when I am entering the Bill and the window comes that there are PO's that match that vendor, I can select the correct PO and it populates in with all of the info.

 

So my question is, 

When I have done all of this, why isn't it populating with all of the edits etc. into the Add/Edit Multilple Entries?  When I open that window, I have to re-enter everything.

 

My other question re: the PO.  There are Ship To and and Ship From (I edited this a little) boxes.  The Ship From which is the second box has the drop down so that I can select the location needed.

There is no drop down for the Ship To - why?  That box is automatically populated with my Vendors address.  I'm not shipping to my Vendor.  If I change the info, that info automatically changes in the Vendors info in the Vendor Center.  REALLY need to have a drop down for this box also. 

Once I am done with the PO and am saving, an Address Change window will pop up asking if I want make the change permanent for all future transactions.  I do not.  So rather than having a drop down like the other box, I am continually having to type in the info.  I use a lot of the same people to ship to, so the drop down would be nice.

 

Thanks for your answers!

 

Reply Join the conversation
2 Comments 2
Kristine Mae
Moderator
Moderator
‎February 20, 2020 12:19 PM

Inventory / PO's

I'll help you get this sorted out, AZEmbroiderer.

 

Let's go over to your questions at a time.

 

Regarding your first concern. once you make some changes to the IIF file and import it, all information will be added to the software. In your case, this unexpected behavior can be caused by corrupted data. Let's run the Verify/Rebuild utility to detect the data damage.

 

Here's how:

  1. Click File.
  2. Go to Utilities, then choose Verify Data.
  3. If QuickBooks detected no problems, there's no further action needed. If you receive a message, "Your data has lost integrity", the file is damaged. Just continue to Rebuild Data to correct the problem.
  4. When you Rebuild Data, you'll receive a message to back up your company file, just click OK. The utility starts as soon as the back up is finished.
  5. Click OK when you get the message "Rebuild has completed".
  6. Run Verify Data again to check for remaining data damage.

When you import another IIF file, everything should be imported. 

 

On your second question, the PO's Ship To address is the company's address. That's the reason why there's no drop-down arrow. Although, it's showing the vendor address on your end. The Verify/Rebuild tool can also help us fix this unusual behavior. 

 

Once you're done running the utility, check the PO again. The company address should show in the Shit To field.

 

I'll also add some references about IIF file to better guide you:

You can keep us updated after trying the recommended step. We're just around to help you. 

Reply Join the conversation
AZEmbroiderer
Level 3
‎February 24, 2020 11:42 AM

Inventory / PO's

Hi Kristine,

I've done the Rebuild/Verify so many times it's crazy.

I saved the IFF file from my vendor as an Excel file.  Unbelievable amount of extra work to edit columns, delete columns, edit items that it takes me longer to do that than what I am doing now.

I've decided to give up.  Some things are just not going to work for what I do on an everyday basis.

 

I have so many different vendor and customer addresses to work with for both dropdowns.

"the PO's Ship To address is the company's address. That's the reason why there's no drop-down arrow."   I would have to go back into the Vender Center every time I used a different address and change it back to the Vendors mailing address.  Wasted time for me to have to keep doing this.

 

I know now that copy/paste is my only option. 

I did go thru the instructions, read the links, and tried.  It's good that these answers don't go anywhere and I can always refer back to them.

Thank you so much for the answer. 

Reply Join the conversation
Featured
The Answer Room: 60 Second Video FAQs - QuickBooks Solopreneur
Welcome back to another round of 60 Second FAQs. QuickBooks Solopreneur was...
Read more
Quick Start with a Product Expert: Moving from Desktop to Online
Hi Community! Today our expert Mike Santos is sharing his top 3 tips on how...
Read more
Spring Cleaning Your Business!
Are you ready to Spring clean your business?! Join Emma and Sofia to learn ...
Read more

Need to get in touch?

Contact us