Line Break data in Import Scenario - Everything Else https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/ Acumatica User Group Forums en-US Wed, 14 Oct 2026 10:13:56 +0000 wpForo 60 RE: Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-4565 Fri, 28 Jun 2019 14:31:29 +0000
Posted by: Ahmed

I'm guessing you already tried <br> ?

Because in reports that's what you have to use for line breaks.

We've also seen success using a <br > inside automation steps to prefill tasks with required data on multiple lines.

]]> Everything Else Ryan Brown @xByte Hosting https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-4565 RE: Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-4558 Thu, 27 Jun 2019 06:06:40 +0000 I think it could potentially have something to do with the specific input field that data is being imported into. I had to add an additional note to the Stock Item's Note field and managed to get the text to be added onto a new line. My mission was to add additional text to any existing text that was already present in the note field but as a new line.

I used the concat & '\r\n' approach.

Import Scenario:

Sample Result:

PS. Tested this on 2019R1 so a fix could have been added as well?

]]> Everything Else Christiaan Raubenheimer https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-4558 RE: Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1974 Thu, 07 Jun 2018 15:36:29 +0000 I'm guessing you already tried <br> ?

Because in reports that's what you have to use for line breaks.

]]> Everything Else AhmedBahar https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1974 RE: Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1851 Wed, 23 May 2018 15:19:45 +0000 I tried with a formula in Excel and didn't have any luck getting the line-breaks to function as desired either.

Might be a good post for the more technical forums.  I'm sure there has to be a way.  Maybe even create a case with Acumatica?

]]> Everything Else MikeLupro https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1851 RE: Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1845 Wed, 23 May 2018 03:55:35 +0000 I tried this:

 

But I also didn't have any luck. It imported like this:

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1845 RE: Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1841 Tue, 22 May 2018 13:07:12 +0000 The tasks screen, I am using the new Business Events feature of 2018 to automate the creation of tasks via an import script.

 

]]> Everything Else nickheuer https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1841 RE: Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1836 Tue, 22 May 2018 12:20:53 +0000 What specific screen and field are you trying to import this into?

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1836 RE: Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1834 Mon, 21 May 2018 18:23:38 +0000 Tried both of those and it did not work, may not be possible in an import scenario

]]> Everything Else nickheuer https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1834 RE: Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1828 Sat, 19 May 2018 04:21:40 +0000 A non-programmer "wonder if this would work" response:

In Excel you can do an Alt-Enter and get the cell to break 

ABC alt-enter
DEF

Wondering if you could enter Jack B Quick alt One Jack Place altcharacters "Jackson, MS 13456"

and get

Jack B Quick
One Jack Place
Jackson, MS 13456 in the cell.

Don't have time to test/fuss with this - just a thought.   A post I found suggested this :

=A1 & CHAR(10) & A2 & CHAR(10) & A3

The CHAR(10) inserts a line feed character, which is the same as is done by Excel when you press Alt+Enter.

]]> Everything Else MikeLupro https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1828 Line Break data in Import Scenario https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1827 Fri, 18 May 2018 23:33:40 +0000 Is it possible to add a line break to a formula used in an import scenario:

Need to format an address display for the large summary area of the task screen and want the address to look like an actual address

John Smith

1 Fake Street

Fakeville, CA 90210

]]> Everything Else nickheuer https://www.augforums.com/forums/everything-else/line-break-data-in-import-scenario/#post-1827