Hey everyone!
I have an issue with an Export Scenario. I am trying to Export Sales Orders to Salesforce, and it’s so close to working but I am still struggling with the the Details of the Order.
I currently have a Source Restrction to limit the export to just one order while I’m testing.
This one order, has six products on the details. When I Prepare the export however, Acumatica is showing a row for each Detail row. On this order with six products, I can see six prepared rows.
The issue is that Salesforce is thinking I’m trying to update just that field, and it’s only displaying the details for the very last row (the last one sent to SFDC)
Is there anyway to concatenate all the all the details on one row for export?
Attached is my Scenario.
I’d really appreciate any help with this, I’ve been stuck on this a few weeks.