About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Not able to create QuickBooks Purchase Order line items in Salesforce.

  • 16 February 2024
  • 4 replies
  • 26 views
S

I have created a zap which takes ‘Purchase Order’ data and creates a record in Salesforce custom object ‘Orders’. SO when I create a record for ‘Purchase Order’ line items the record data are coming as one record. E.g. If there are 3 line Item records with field ‘amount’. The amount is coming for 3 records as “120,234,45”. The data is coming as one record and when I create a record in Salesforce using Zapier the ‘Amount’ is showing as ‘12023445’.

You can see in the above image what the values are coming as.

So my question can anybody help me with creating line items related to custom Order object?

I have multiple fields with the same combined data like Quantity, Description,Payment Type etc.

P.S. I want to make it dynamic because not every time the number of line items related to an Order will be same.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Sam09 

For us to have more context, post screenshots with how your Zap steps are outlined and configured.

Some Zap steps support line items.

For others, the Looping app can be used to handle line items: https://zapier.com/apps/looping/help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S

I am adding a screenshot of the zap:

Step 4 :  I create Order records.

Step 5 : I find the order record to add to the 6th to connect the line items.

Step 6 : I am creating Order Line Item records.

but I am facing issue that records are coming as 1(combined) record. as mentioned above in the original question. I want to separate the data coming and create multiple line item records related to the order records.

S

I have created a zap which takes ‘Purchase Order’ data and creates a record in Salesforce custom object ‘Orders’. SO when I create a record for ‘Purchase Order’ line items the record data are coming as one record. E.g. If there are 3 line Item records with field ‘amount’. The amount is coming for 3 records as “120,234,45”. The data is coming as one record and when I create a record in Salesforce using Zapier the ‘Amount’ is showing as ‘12023445’.

You can see in the above image what the values are coming as.

So my question can anybody help me with creating line items related to custom Order object?

I have multiple fields with the same combined data like Quantity, Description,Payment Type etc.

P.S. I want to make it dynamic because not every time the number of line items related to an Order will be same.

I am adding a screenshot of the zap:

Step 4 :  I create Order records.

Step 5 : I find the order record to add to the 6th to connect the line items.

Step 6 : I am creating Order Line Item records.

but I am facing issue that records are coming as 1(combined) record. as mentioned above in the original question. I want to separate the data coming and create multiple line item records related to the order records.

Troy Tessalone
Userlevel 7
Badge +14

@Sam09 

We would need to see screenshots with how each Zap step is configured to have full context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions