Forum Discussion
SamCole
Qrew Cadet
Manny,
Thank you for this, its very appreciated.. it worked perfectly except for one thing. In the Quickbooks channel's "Lines (list)" section, I can't figure out where to map a "line item cost" field to the "Rate" field in Quickbooks. It has a field to map "Amounts" for the total for the line item, but nothing i've tried will send anything to the Rate field. It sends Quantity, Name, SKU, and Description (and even Amount) perfectly for each Child record in a given Parent record, but nothing for the actual Rate. So as it is, it creates the invoice and all of the line items, and each one has a name, description, quantity, and total, but the Rate field is left blank. Have you come across this issue?
------------------------------
Sam Cole
------------------------------
Thank you for this, its very appreciated.. it worked perfectly except for one thing. In the Quickbooks channel's "Lines (list)" section, I can't figure out where to map a "line item cost" field to the "Rate" field in Quickbooks. It has a field to map "Amounts" for the total for the line item, but nothing i've tried will send anything to the Rate field. It sends Quantity, Name, SKU, and Description (and even Amount) perfectly for each Child record in a given Parent record, but nothing for the actual Rate. So as it is, it creates the invoice and all of the line items, and each one has a name, description, quantity, and total, but the Rate field is left blank. Have you come across this issue?
------------------------------
Sam Cole
------------------------------
MannyHernandez
4 years agoQrew Trainee
Sam,
I did have the same issue. Unfortunately no luck with making the native fields work. Seems like those filelds are missing in the pipelines.
I did have a workaround that I am using for now until they fix it. I made a formula text field where I combine the rate and amt beneath the description. See attached photos. Not the best fix - but it will do for now.
------------------------------
Manny Hernandez
------------------------------
I did have the same issue. Unfortunately no luck with making the native fields work. Seems like those filelds are missing in the pipelines.
I did have a workaround that I am using for now until they fix it. I made a formula text field where I combine the rate and amt beneath the description. See attached photos. Not the best fix - but it will do for now.
------------------------------
Manny Hernandez
------------------------------
- SamCole4 years agoQrew CadetThanks Manny. I've also opened a support case and given them all the info. Hopefully they'll get it corrected soon
------------------------------
Sam Cole
------------------------------- JessicaFeauto4 years agoQrew MemberHey Sam,
Any update on them adding Rate to the Pipeline for Quickbooks? This is a really ridiculous thing to not be able to do.
------------------------------
Jessica Feauto
------------------------------- JosephMahon9 months agoQrew Member
I know this is an old post but I am running into an issue. When I follow this, it is creating sequential invoices. It finds the first record and creates an invoice. Then it finds the second record and creates another invoice with both line items, then the third. So if it finds 10 records, it creates 10 invoices.
------------------------------
Joseph Mahon
------------------------------