Hi Community,
I just can’t get the upload feature work properly in the Weekly Crew Time Entry.
When it reads the upload file all fields are ok except date and time, I did numerous tests changing the format of these fields but still Acumatica can’t process it and so I have to manually enter them which is time wasting.
Are any of you successfully using this feature? Can you share a working upload file so I can test and try to figure out where my setup is wrong?
Thanks in advanced,
Abel
Best answer by DavidEichner
I was able to import the file you sent after updating the employee and removing the Project references. It might be a bug in the version/build you are on. I would start a support case with Acumatica to verify and perhaps see if they have fixed it in a more recent build of 2021R1 or if you would need to update to more recent version/build.
Also, you might try not importing Project data to see if the issue is with Project Accounting.
Best,
David Eichner, CPA
+14Hi Abel,
What version of Acumatica are you running on? I was able to import the attached file into the sales demo company. Often times, it helps to manually enter a record first and then export to Excel so you can see the way the Excel columns should be configured.
Best,
David Eichner, CPA
Hi David,
Thanks, sorry I should have included more detail here:
Acumatica release 2021 R1
Error message attached
I did the exercise export to excel and then upload, same problem. Also tried with your example and that didn’t work either. I am suspecting some other kind of setup issue, hope the error message gives a glimpse here.
+14I am on 2022R2 latest build. If you’d like me to try importing with your file, you can either email it to me at deichner@kensium.com or attach the Excel file to this thread.
Best,
David Eichner, CPA
+14I was able to import the file you sent after updating the employee and removing the Project references. It might be a bug in the version/build you are on. I would start a support case with Acumatica to verify and perhaps see if they have fixed it in a more recent build of 2021R1 or if you would need to update to more recent version/build.
Also, you might try not importing Project data to see if the issue is with Project Accounting.
Best,
David Eichner, CPA
+14Here’s a copy of the test file I used without Project data
That makes sense, even the error message seemed to be claiming about other things than date&time.
Very much appreciated David, thanks for your kind support.
Have a joyful 2023.
Hi,
For those interested on the topic this error was solved after upgrade to 2022R2.
Cheers,
Abel
Thank you for providing this update to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
