Skip to main content
Solved

Help with Exporting Sales Order Details

  • 14 December 2023
  • 3 replies
  • 80 views

gorazem
Varsity I
Forum|alt.badge.img

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. 

 

One order, six rows. One for each Detail Row.

 

Best answer by gorazem

Just wanted to provide an update. 

I was able to solve this buy creating a View, in which I used an aggregate function to combine the Line Items into one column (String_agg and STUFF should work depending on your SQL version) 

I than generated a new DAC off that View, and used it in a GI with the Salesforce Provider. 

The only downside to be aware of, is I don’t think the GI will respect the “sync type” set on the Export Scenario. 

View original
Did this topic help you find an answer to your question?

3 replies

gorazem
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 39 replies
  • Answer
  • January 30, 2024

Just wanted to provide an update. 

I was able to solve this buy creating a View, in which I used an aggregate function to combine the Line Items into one column (String_agg and STUFF should work depending on your SQL version) 

I than generated a new DAC off that View, and used it in a GI with the Salesforce Provider. 

The only downside to be aware of, is I don’t think the GI will respect the “sync type” set on the Export Scenario. 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2525 replies
  • January 30, 2024

Thank you for sharing your solution with the community @gorazem and great to meet you at Summit!


gorazem
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 39 replies
  • January 30, 2024
Chris Hackett wrote:

Thank you for sharing your solution with the community @gorazem and great to meet you at Summit!

Thanks Chris! It was good to finally meet you in person!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings