How do I get all of the records to get in a single journal batch?

Question

As of now, here is a test:My goal is to import three GL transaction records in a single batch. I have been working on this scenario for over two days and several iterations. As of now, the scenario imports the records and creates 2 batches from 3 records. I am attaching the latest version of the import scenario and the sample data. As of now, the source for this data is a SQL Server table, but for simplification, I have exported it to an Excel file (attached). The amount fields in the table are defined a money columns.You may notice a lot of hard-coding because I had to hardcode several field values to understand what is going on.I am working on Acumatica 2025 R1Build 25.101.0153.7

KrunalDoshi · Accepted Answer

Hi ​@abhijit,You need to set the Module first and Action Cancel before you set the Batch Number. Also, batch number should be same for all the transactions. So, for instance, I have set JEId in your case. I have included below screenshots for your reference.Hope this resolves your issue.Import ScenarioImported Journal Transaction

nasir · Answer

​@abhijitit is possible to import all three GL records into a single batch in Acumatica 2025 R1, but only if your import scenario is structured so Acumatica createsone batch headerand then addsall three lines to that same batch; if the scenario is creating two batches, it usually means the header is being inserted more than once, the line grouping is breaking, or the scenario is using separate debit/credit passes instead of one continuous journal entry flow. In practice, the fix is to use a single Batch/GL transaction header with one key reference for the group, keepHold Batches on Entryenabled, make sure line numbering is left to the system, and ensure each source row maps to the same batch group so Acumatica doesn’t start a second batch mid-import.

Sign up

Social Login

Login to the community

Social Login