Salesforce Quote Line Item required minium 1 quantity.
As we already added a condition that if Quantity is not presetn in invoice line item then we use 1 as quantity in Quote Line Item.
But in some cases user put 0 in Invoice Line Item in QB, so how can we check quantity is 0 and if its 0 then convert it to 1.
See attached screen shot formula that we are using for quantity.
Best Answer
A
Adam Goh
said
over 5 years ago
Hi Catherine,
Yes that will be possible. What you'll be looking for is to have indented condition On the first true statement (after ?) You can have the second condition. The second condition you may use [Quantity] == '0' ? [Quantity] : 1 It should look similar to this screenshot
This can be read as: "If JobID is present, check if JobID is equals to 4748. If yes, use 'statement is true', or 'statement is false1' if otherwise. If the jobID is not present use 'statement is false2'.
Cheers,
Adam Goh
Customer Success Team
Email : success@workato.com
Phone : +1 844 469 6752
Answer
Adam Goh
said
over 5 years ago
Hi Catherine,
Yes that will be possible. What you'll be looking for is to have indented condition On the first true statement (after ?) You can have the second condition. The second condition you may use [Quantity] == '0' ? [Quantity] : 1 It should look similar to this screenshot
This can be read as: "If JobID is present, check if JobID is equals to 4748. If yes, use 'statement is true', or 'statement is false1' if otherwise. If the jobID is not present use 'statement is false2'.
Catherine Meyrat
How To Convert 0 Quantity To 1
Hi Catherine,
Yes that will be possible. What you'll be looking for is to have indented condition On the first true statement (after ?) You can have the second condition. The second condition you may use [Quantity] == '0' ? [Quantity] : 1
It should look similar to this screenshot
This can be read as: "If JobID is present, check if JobID is equals to 4748. If yes, use 'statement is true', or 'statement is false1' if otherwise. If the jobID is not present use 'statement is false2'.
Cheers,
Adam Goh
Customer Success Team
Email : success@workato.com
Phone : +1 844 469 6752
Adam Goh
Hi Catherine,
Yes that will be possible. What you'll be looking for is to have indented condition On the first true statement (after ?) You can have the second condition. The second condition you may use [Quantity] == '0' ? [Quantity] : 1
It should look similar to this screenshot
This can be read as: "If JobID is present, check if JobID is equals to 4748. If yes, use 'statement is true', or 'statement is false1' if otherwise. If the jobID is not present use 'statement is false2'.
Cheers,
Adam Goh
Customer Success Team
Email : success@workato.com
Phone : +1 844 469 6752