Skip to main content
Solved

Weekly Crew Time Entry Upload: date/time format

  • Jan 19, 2023 2:34 PM UTC
  • 10 replies
  • 310 views
  • Translate All

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

View original

10 replies

DavidEichner
Captain II
Forum|alt.badge.img+14

Hi 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

Translate

  • Author
  • Freshman I
  • Jan 19, 2023 3:51 PM UTC

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.

Translate

  • Author
  • Freshman I
  • Jan 19, 2023 4:04 PM UTC

..and this is how it looks after pressing OK to the error message

Translate

DavidEichner
Captain II
Forum|alt.badge.img+14

I 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

Translate

  • Author
  • Freshman I
  • Jan 19, 2023 4:41 PM UTC

File attached here.

 

Thanks David.

Translate

DavidEichner
Captain II
Forum|alt.badge.img+14
  • Captain II
  • Answer
  • Jan 19, 2023 5:23 PM UTC

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

Translate

DavidEichner
Captain II
Forum|alt.badge.img+14

Here’s a copy of the test file I used without Project data

Translate

  • Author
  • Freshman I
  • Jan 19, 2023 5:27 PM UTC

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.

Translate

  • Author
  • Freshman I
  • Feb 13, 2023 6:27 PM UTC

Hi,

 

For those interested on the topic this error was solved after upgrade to 2022R2.

 

Cheers,

Abel

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Feb 13, 2023 10:33 PM UTC

Thank you for providing this update to the community @abelp !

Translate