We are running MS Dynamics GP 2018 on MS Windows 2016 server (virtual). Users connect to this server via a Citrix application server (also virtual Windows 2016 server) using a GP Dynamics client installation on the Citrix server.
We have Dynamics set up to save EFT files to a network share. The file(s) created are named using the checkbook name + date (yyy+mm+dd) + a sequentially incremented number (-0001). In this case, dd=settlement day.
The problem we are experiencing is that if a user creates a second file with the same settlement date (on the same day), the file does not increment to the next number (i.e. -0002) and it overwrites the first file with -0001. This also happens if a different user creates and EFT file from the same checkbook on the same day.
From my understanding, Dynamics 'looks' to see if the file already exists, and if it does, it's supposed to increment the file by 1 (i.e., -0001 exists, new file should be -0002).
Oddly, sometimes it does increment the file and other times it does not, it just overwrites it.
Any helpful suggestions for a fix, and explanation as to why this might be happening, and/or a possible workaround would be greatly appreciated.
Thanks!