Import Scenario - Sort Data before processing

Hi ​@nsmith51 ,

If you use a manual numbering sequence for the invoice reference number then the invoice lines can be in any order.  With auto numbering, the details lines will need to be grouped.  I believe the sort was removed in 2024 R1 to avoid the false impression that sorting the data on the import screen will define the import order.  You should be able to sort the rows within the data source (e.g. in Excel or the Generic Inquiry).  

Hope this helps!

Laura 

Hi ​@nsmith51 

Please check this thread as well, this could be useful.

Regards,

​@lauraj46 ​@vkumar  Thanks a lot for providing the responses.

Client won’t sort the data in the Source file (Excel Sheet), he will receive that file from 3rd party system and uploads file into the Acumatica.

​@vkumar  I checked with Parallel Processing as suggested but it seems it is not working. 

Is there any simple customization that can be done to sort the data automatically.

Hi ​@vkumar ,

Here’s one approach that you could take:

1.  With a customization, define a custom Acumatica DAC. 

2. Create an import scenario to import the Excel file to the custom DAC

3. Create a GI based on the custom DAC.  You can sort data in the GI.

4. Change the data provider for your current import scenario to use the GI that you created in step 3.

Hope this helps!

Laura