By using this website, you agree to our Terms of Use (click here)
For your line that is Active, have you tried using <Line Number> in the Field / Action Name column instead of Line Nbr.?
Hi @timrodman,
Did @josemar-garcia-mba ever come back to you saying they had fixed the Import? I'm struggling with the same problem and tried what you suggested, but there isn't a line number for the screen I'm using.
Regards
Nick Savage-Mady
@timrodman That's a bugger. I will have to look through Acumatica Training guides and videos to hope that I find a something. I will not be defeated 😝
I have figured it out, so I had to post this for syntax purposes and for future head-banging.
The trick to this screen, as mentioned before, is the ID (CABankTrans.TransID) field. This is the Primary for the table, but a few rules on how to use it for updates.
- It is has to be included as the first field for Details
- Untick Commit
I found this whilst re-reading Troubleshooting Performance in Import and Export Scenarios in the help. There is a section about what commit is used for and how to speed up scenarios. In short because it is a field that can't be updated, it doesn't need to be committed, only used for a look-up when updating. By default it is ticked, so I trusted the system on that front. Once unticked, hey presto!!
Glad I stayed committed to the finding the answer 