Created Journal Transaction Import, with the following data:
Not all the transactions got the error, only a few, i have recreated the transaction on the journal transaction screen and journal transaction was on balance with no issues. Also, i have removed the Module, added, and check for the Commit on several of the selections, but cant import all of the transactinos, only some worked.
Do you see anything wrong with my import scenario? Thank you so much in advance.
Best answer by Laura03
Hello Martin,
I expect the issue is with batch numbering.
Are the GL’s numbered automatically?
If so, we populate the “Batch Numb” column in Excel with a placeholder. I find GL imports work best if the First batch number is higher than all existing batch numbers that are already in Acumatica for the same Branch. Acumatica will then use the placeholder to determine where one batch ends and the next begins, and will look to Numbering Sequence to know how to give the entries appropriate batch numbers.
HTH
Laura
+15Hi
Please share the XML report and Sample Mapping data sheet here
Hola
+15Hi
Hoowever I tested below xml and sharing with you. Please compare or modified beloe xml report as needed and check
+19Hello Martin,
I expect the issue is with batch numbering.
Are the GL’s numbered automatically?
If so, we populate the “Batch Numb” column in Excel with a placeholder. I find GL imports work best if the First batch number is higher than all existing batch numbers that are already in Acumatica for the same Branch. Acumatica will then use the placeholder to determine where one batch ends and the next begins, and will look to Numbering Sequence to know how to give the entries appropriate batch numbers.
HTH
Laura
+3When I get strange reasons for data not importing, I add an action in the import scenario to put on hold before save, as if its out of balance, it will still save it.
Then you can try work out what went wrong by looking at the batch created, but possibly a branch issue or debits / credits not matching / period closed
Team, thank you so much for your responses. I shot myself in the foot with this one, batches already existed in Acumatica, and the system would tried to update the old batches that I was using as Batch Reference. Thank you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.