Skip to main content
Solved

Data is absent error on Sales Order Line upload


Forum|alt.badge.img

Wondering if anyone else encountered the error “Data is absent” during the Sales Order Line upload function? 2022R2

The client provided an excel workbook, and I added an upload tab as the first tab in the workbook for the upload data.

If I copy that upload data to an empty new workbook, it will upload, so I know my data is clean.

What settings on the excel workbook might be causing this error?  I have verified that the sheet and workbook is not protected. What else could it be? 

 

Any idea would be appreciated.  We have not seen this error before.

 

Best answer by GBower

I found this thread via search after spending 30 minutes trying to fix the same issue.  While the above suggestions didn’t solve my issue, they did get me started down the path to a simple solution.  Hopefully, the following helps somebody in a similar position: 

Change from the standard Excel view to the “Show Formulas” view (“Formula” ribbon / “Show Formulas” button). 

I was absolutely positive there were no formulas on my upload sheet, but three were buried in data.  One was a manual edit to fix a rounding error (x+.01) and the others were my total at the bottom of the dr./cr. columns.

I suggest switching views and manually confirming there are no formulas.

View original
Did this topic help you find an answer to your question?

7 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16

HI @TShoaff 

Have you tried exporting the actual grid from the Sales Order Details and putting the data on that then uploading?


Forum|alt.badge.img
  • Author
  • Freshman II
  • 22 replies
  • June 16, 2023

Thanks Kandy for your reply.

Yes we have tried exporting the grid.  Support has suggested it is related to formatting or formulas.  It is a complicated workbook and I would prefer to keep the import sheet there for audit purposes, but it may not be possible.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 22 replies
  • June 16, 2023

 

The only method I found that works is to save the sheet as a CSV (comma delimited), it doesn’t save all the sheets in the workbook, however it is more efficient that copying to another workbook.


Forum|alt.badge.img+1
  • Jr Varsity III
  • 66 replies
  • June 30, 2023

This sounds like the original excel spreadsheet has formula, lookups, etc.  When you copy to a new workbook are you just copying the data (as text)?  The upload will read the exact contents of the cell so if a formula exists, it will not recognize it.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 22 replies
  • July 3, 2023

Yes, the workbook the client uses has several sheets.  We are copying data from one sheet, to the front sheet for upload as Text/  Formulas on the other sheets must be interfering with the upload process in Acumatica.  


  • Freshman II
  • 1 reply
  • Answer
  • July 6, 2023

I found this thread via search after spending 30 minutes trying to fix the same issue.  While the above suggestions didn’t solve my issue, they did get me started down the path to a simple solution.  Hopefully, the following helps somebody in a similar position: 

Change from the standard Excel view to the “Show Formulas” view (“Formula” ribbon / “Show Formulas” button). 

I was absolutely positive there were no formulas on my upload sheet, but three were buried in data.  One was a manual edit to fix a rounding error (x+.01) and the others were my total at the bottom of the dr./cr. columns.

I suggest switching views and manually confirming there are no formulas.


Forum|alt.badge.img
  • Jr Varsity II
  • 39 replies
  • December 19, 2023

I found the “Data is Absent” error as well.  In my case there was a series of blank lines after my initial data set.  Then, about 100 lines down there was a TOTAL line in the middle of the worksheet (well after my last upload record). 

The solution was to delete all blank rows after my last data record to the bottom of the worksheet and that fixed the problem.  Vexing but I made a note now so I won’t soon forget this small detail when creating an upload file.  Kind regards, Mike Lupro


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings