I’m trying to build a scenario that takes fields on an object from Salesforce, and creates an invoice within quickbooks.
My object is an invoice, and my fields are setup as follows
ILI Product code : Hosting and Maintenance|Paid Marketing Management|Monthly Marketing Services|Advanced Telecoms Line Rental
ILI Unit Price : 75|500|1500|100
ILI Quantity : 1|1|1|1
I can add more if necessary.
I’ve already tried using 3 Iterators to split the lines and then Array aggregator for the quickbooks invoice, but it seems that the array aggregator can only read from one iterator to populate the invoice with data.
You can use an aggregator for each iterator and then use the merge function so that it’s like
That said getting a detailed and clear answer does require a little more effort, so my recommendation is try post as much screenshots of
a) overview of your scenario setup
b) the input area of the module you are having trouble with
c) the output area of the module you are getting data from and want sent to Quickbooks
Thank you for coming back to me.
So the overall top down view is that a Salesforce object (invoice) is created, send the fields I mentioned before, run through the iterators, then the array aggregator sets them up into the correct format for QB.
The last part of the puzzle is the formatting of the Quickbooks Invoice Arrau Aggregator
So Make requires me to Select a Source Module (this means I’m going to need to combine the other Iterators in to a single source module)
Then select Target Structure type = lines (see screenshot below)
A little embarrassing but that took me way longer to figure out and might not be the most efficient solution but it should work. When you do that split function on the description code, is it processing the blanks correctly?
This will work properly only if it recognizes the same amount of items for each parameter.
So what you’ll do is remove the Price Iterator and the Iterator after that.