For example, we can reformat this to be on a single row where the line items in each column are listed in a single cell using commas in between, like this: Since we generate this ourselves from our own system, we can reformat Purchase Order and related line items any which way is required in order for Zapier to do its thing. We then want to be able to push this purchase order out to the Vendor via email using a manual trigger. We want to get all of this order information automatically into Quickbooks Online using Zapier including line item details. Our internal ordering system generates a new Google Sheet for each new Purchase Order. Here is an example Purchase Order in Google Sheets to explain what we are starting with: Many thanks in advance for ideas / solutions here! ![]() ![]() At the same time, we create a purchase order in Quickbooks with the same multiple items (only difference really is price is at our cost and not a customer sales price). In our typical workflow, we send an invoice to our customers that includes many items - each with a model, description, price/ea, and price/total. ![]() We are attempting to integrate our Google Spreadsheet and Airtable databases with Quickbooks Online. Zapier seems to have line item support for many types of events, such as - Invoices, Sales Receipts, Bill, Estimates, Find Products, etc - but NO LINE ITEM SUPPORT for Purchase Orders or Credit Memos.Īm I missing something? I’m currently testing this on a Zapier free plan, is this available on a paid plan? If not, is there any way to accomplish this? Workaround? Quickbooks Online / Zapier - Line Item Support Events Hello! I can’t seem to find “line item support” with the Quickbooks Online integration for creating Purchase Orders and Credit Memos? See table below with Quickbooks / Zapier event integration details when trying to create a new Zap:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |