cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

How do I close the open purchase order in bulk via QBO?

 
1 Comment
Highlighted
Level 13

How do I close the open purchase order in bulk via QBO?

Utilize the trial period of this 3rd party tool

https://transactionpro.grsm.io/qbo

 

Export your PO data with "open" status out to XLS, change "open" to "closed" in "PO status" field, then reimport back the file into your QBO account. Make sure to set the app to "overwrite" the data to avoid any duplication.

 

The template should be like this

RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermPOStatusShipMethodNameClassAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples 15/05/202015/05/2020 OpenUPS 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25.1           
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           

Need to get in touch?

Contact us