Wildcard for username with file attachments for Attachment Type Maintenance

Recently switched to Office 365 and Azure AD and have gone serverless at our office. Which is great.

One thing I didn’t think of is that, even though we’re using Epicor Cloud the file attachments are stored locally.

Since all the users have a OneDrive specifc to them, I was thinking I could map a sharepoint folder with all the Epicor file attachments.

Previously they had them all on a mapped drive every user had to the server.

Examples:
(Previously)
S:/Epicor/Attachments

(what I’d like to do)
C:\Users%USERNAME%\OneDrive\Epicor\Attachments\

Problem is, Epicor doesn’t like %USERNAME% as an option. And since every user has a different username, well that won’t work. Unless someone else has a solution to a wildcard for a username in a directory structure for Epicor.

Otherwise I’ll have to come up with something else.

Create one AAD user and use it for all attachments? use the name instead of %UserName%. Use SharePoint attachment type.

Also, what about Azure Files? may be it can be used as replacement for file shares?

Seems like that would work but it would require logging into every machine with said new user and I don’t believe it will sync data to onedrive when the user isn’t logged in, so that would be a nonstarter.

I thought you would use it in attachments system, so file be uploaded by the client, not syncronizing data automatically.

I don’t know any better but if I attach the file from my client PC and then I try to access it from another PC, wouldn’t that not work?

I assumed the files are still stored locally. Not actually uploaded to Epicor. Or are they uploaded to Epicor servers?

I don’t know as I haven’t had to deal with this side of Epicor yet.