Skip to main content
Answer

Uploading Sales Price Worksheet - Does not see first row of EXCEL data for column mapping

  • July 8, 2024
  • 3 replies
  • 55 views
L
Captain II
Forum|alt.badge.img+5

Hello,

The column name shown in the image above is row 2 in the EXCEL file.  Row 1 is the column headers.  I have copied and pasted values into a new spreadsheet etc. trying to get past this.  Seems to be an EXCEL thing but I cannot find how to get past this.

Best answer by ltussing03

Kandy, thanks for the response.  I discovered they had blank rows in the data.  Made it get wonky.  I cleaned up the blank rows and it works fine.

Thanks!

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Kandy Beatty

    3 replies

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

    Hi @ltussing03 

    Can you share the excel?

    Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    L
    L
    Captain II
    Forum|alt.badge.img+5
    • ltussing03
    • Author
    • Captain II
    • Answer
    • July 8, 2024

    Kandy, thanks for the response.  I discovered they had blank rows in the data.  Made it get wonky.  I cleaned up the blank rows and it works fine.

    Thanks!

    If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Kandy Beatty
    Chris Hackett
    Kandy Beatty
    Captain II
    Forum|alt.badge.img+17

    Kandy, thanks for the response.  I discovered they had blank rows in the data.  Made it get wonky.  I cleaned up the blank rows and it works fine.

    Thanks!

    Glad you got it Larry! 

    Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved