Skip to main content
Solved

Funds Transfer Import Scenario *The system failed to commit the Transfer row.

  • February 20, 2025
  • 9 replies
  • 74 views

Forum|alt.badge.img

Good day,

Attached is what I thought would be a simple import for Funds Transfer data.  

Any ideas where I have issue.  I am not sure if it my file or the scenario.

Any suggestions.

I appreciate your assistance.

Evan

Best answer by vkumar

Hi ​@grillevan 

Please try this scenario. I have made few changes. This worked on my demo. 

Regards,

 

 

View original
Did this topic help you find an answer to your question?

9 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

@grillevan I am able to import the data by disabling the below field.

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 46 replies
  • February 21, 2025

@Manikanta Dhulipudi   Still not working.  See screenshot.  I would like the record to not be on hold and have it be Balanced on import.  Any other suggestions?

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 46 replies
  • February 22, 2025

@Manikanta Dhulipudi   Still not working.  I have been playing with the commit checkbox.  I ran a full run to see if any record imported.  See screenshot. Now I stumped.  It is CA setting issue? I don’t think so.  Any suggestions

Anyone one else?  Management is looking for this to import Funds transfer next week; it is a manual process right now.

Thank you.

Evan

 


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • February 24, 2025

Hi ​@grillevan 

Can you check if the source and destination Cash accounts have ‘Restrict visibility with Branch’ enabled? If yes, do try uncheck and run the import.

Also, check if there are any restriction groups set to access the GL account linked to the Cash account. 

Try do transfer transaction from UI, using the details from the Import scenario to ensure, the logged on user has required permission to access the Cash accounts and create the transaction. 

Hope this helps,

Regards,


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 46 replies
  • February 24, 2025

@vkumar Thank you. It is strange.  The one that works  highlighted below.  I entered them manually.  No issues.  I also unchecked the Restricted box.  Still same results.  One is CASHASSET and one the NOTEPAY class.  I don’t know what I am missing. 

 

TransfeNbr Descr OutAccountID OutDate OutExtRefNbr CuryTransOut InAccountID InDate InExtRefNbr CuryTranIn
000001 ZBA Transfer 10170 1/14/2025 ZBA Transfer 24294.12 24000 1/14/2025 ZBA Transfer 24294.12
000001 ZBA Transfer 10170 1/14/2025 ZBA Transfer 24294.12 24000 1/14/2025 ZBA Transfer 24294.12
000002 ZBA Transfer 24000 1/22/2025 ZBA Transfer 23901.17 10170 1/22/2025 ZBA Transfer 23901.17
000002 ZBA Transfer 24000 1/22/2025 ZBA Transfer 23901.17 10170 1/22/2025 ZBA Transfer 23901.17
000003 ZBA Transfer 10170 1/31/2025 ZBA Transfer 222852.81 24000 1/31/2025 ZBA Transfer 222852.81
000003 ZBA Transfer 10170 1/31/2025 ZBA Transfer 222852.81 24000 1/31/2025 ZBA Transfer 222852.81
000004 ZBA Transfer 10170 1/30/2025 ZBA Transfer 162591.14 24000 1/30/2025 ZBA Transfer 162591.14
000004 ZBA Transfer 10170 1/30/2025 ZBA Transfer 162591.14 24000 1/30/2025 ZBA Transfer 162591.14

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 46 replies
  • February 24, 2025

@vkumar  We don’t use restrictive groups.  I am also the Administrator so I should not have issues with access.


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • Answer
  • February 25, 2025

Hi ​@grillevan 

Please try this scenario. I have made few changes. This worked on my demo. 

Regards,

 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 46 replies
  • February 25, 2025

@vkumar  Thank you very much.  It is getting frustrating that this simple import is struggling.  I get the same results.  One record.  The remaining fail.  I am in my test system as well.  Sometimes, ACM does throw some errors.  There is not error database that would at least me to find out.  I tried changing the commit buttons as well.  I am using 2023R2; could this be the issue?  

Anyone other ideas?  Acumatica support is not available unless I contact my VAR.  

I do appreciate your assistance.  Accounting does multiple transactions a week; they could really use this import to work.  I did promise it as well.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 46 replies
  • February 25, 2025

It as the data that was causing the issue.  After the VAR looked at it, worked.  We didn’t need two lines for each transaction. 

@vkumar

@Manikanta Dhulipudi 

Thank you for your time.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings