Question

Import Scenarios - Order in which lines imported

  • 22 December 2021
  • 7 replies
  • 118 views

Userlevel 1
Badge

Hi everyone,

 

I feel like this probably has an easy answer but I cannot find it anywhere. I have looked through the screens and the help files. 

Our customer is importing GL transactions through the GL file. This last one they sent failed. We realized it is because, on the import file, the transactions are not ordered by the transaction ID anymore. When the import scenario goes to import, it fails because it is only seeing part of the transaction (since the other part is farther down in the file). 

Is there any way to set in the import scenario that when the file is prepared, it rearranges the order of lines by the transaction ID number assigned to it?


7 replies

Userlevel 7
Badge

Hi @rebeckamckinney53 were you able to figure this out? Thanks!

Userlevel 1
Badge

@vkumar 

It will be a regular import. 

Userlevel 7
Badge +8

Hi @rebeckamckinney53 

One need to sort content on source file in this case. With regards to your requirement, Is this a one time import in your case (initial balance?) or regular import based on any standard file received from another system? (file updated using synchronization?).

Regards,

Userlevel 1
Badge

@vkumar 

The other lines are farther down in the file. If I sort the file before importing then it will work. 

How do I sort the lines on a per ‘Batch’ basis? I don’t see where to do that. 

Userlevel 7
Badge +8

Hi @rebeckamckinney53 

You can sort the lines on per ‘Batch’ basis. I guess the Transaction ID on above screenshot represents one single batch? I dont see the credit entries for the batch on the list. 

You can find a sample GL transaction import scenario on our demo instance. I am attaching the import scenario and the excel file from our Demo tenant. 

 

Regards,

Userlevel 1
Badge

@vkumar 

That isn’t the problem. I pasted the image of the file below. When I prepare the import, this is the order the files come in as. As you can see, Transaction ID 1 is not balanced. The other half of the transaction is farther down in the file. 

When I upload it to import scenarios and prepare, this is the order is loads them in.

Those first 4 lines fail. 

Is there any way to default the order within Acumatica so that they load in the order of Transaction ID? I was able to change the order in the file itself beforehand and upload it, so this is really the only issue. The client wants to be able to import it with as little modification beforehand as possible. 

Userlevel 7
Badge +8

Hi @rebeckamckinney53 

If all transactions are imported into ‘one’ single GL batch, then, it should allow you save the lines in ‘Hold’ mode. 

Send us your import scenario and source file. 

 

You may enable ‘Hold batches on entry’ option on GL preferences, and then try import the GL batch. Check if that works. One has to release the batch from hold later. 

Regards,

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved