cancel
Showing results for 
Search instead for 
Did you mean: 
daniel60
Level 1

Does anyone know if you can (and how) create a PO from uploading a .csv or .iif file in QB online?

The .iif file comes from Sanmar.
4 Comments 4
Nick_M
QuickBooks Team

Does anyone know if you can (and how) create a PO from uploading a .csv or .iif file in QB online?

Hi daniel60. 

 

Thanks for dropping by the Community, I'm happy to provide some feedback on creating Purchase Orders. Unfortunately, you cannot import Purchase Orders into QuickBooks Online. If you have QBO Advanced, you can import invoices in a batch of up to 100, however they don't allow Purchase Orders. Thank you for bringing this to our attention, when customers have great ideas like this, we use this as a perfect opportunity to reach out to our product engineering team to see if we can add to the product in a future update. This is a prime example of that, and I'm going to reach out to them directly to see about adding this soon. You can check the QuickBooks Blogspot to see future updates and what changes are made. 

 

If you have any other questions, feel free to post here night or day. Thank you and have a nice afternoon. 

Fiat Lux - ASIA
Level 15

Does anyone know if you can (and how) create a PO from uploading a .csv or .iif file in QB online?

@daniel60 

What kind of transaction type do you need to import into your QBO? What is Sanmar? Have you explore TPImporter?

https:// transactionpro.grsm.io/qbo

 

daniel60
Level 1

Does anyone know if you can (and how) create a PO from uploading a .csv or .iif file in QB online?

@Fiat Lux - ASIA I'm trying to upload detailed Purchase Orders with products and costs so they match inventory and credit card charges. Sanmar is a major apparel supplier that I was hoping someone in the community would have experience with. 

Fiat Lux - ASIA
Level 15

Does anyone know if you can (and how) create a PO from uploading a .csv or .iif file in QB online?

You prepare the Purchase Order data with the following template

RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermPOStatusShipMethodNameClassAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples 15/05/202015/05/2020 OpenUPS 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50.25           
101 Staples 15/05/202015/05/2020 OpenUPS 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office FurnitueNew Chairs300.18           
185 Green's Taxi Service 15/05/2020 Net 30Closed  1 Main Street   San DiegoCA12345    Transportation 125.13           

 

then utilize the importer tool as I mentioned earlier.

Need to get in touch?

Contact us