Skip to main content
Answer

Import by Scenario 'CustomerID' cannot be empty

  • June 13, 2023
  • 4 replies
  • 391 views
L
Freshman II

Hi, I am trying to import open sales order data by using the Import by Scenario in Acumatica. I am getting the error “‘CustomerID’ cannot be empty”.

The CustomerID field has the Customer ID numbers, it is the column highlighted in red on the attachment.

Does anyone know what may be causing this error? It is not triggering the error for a few orders listed in the second screenshot.

Best answer by llittle

This issue has been resolved. A reference line for the customer ID needed to be added to the Import TC Fields.

Thanks!

2 Attachments
Kandy Beatty

4 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Kandy Beatty
  • Captain II
  • June 13, 2023

HI @llittle 

Can you share the XML of the import scenario?

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
Freshman II
  • llittle
  • Author
  • Freshman II
  • June 13, 2023

Hi @kandybeatty49 ,

Yes, I attached the xlsx file I am trying to import.

1 Attachments
L
Freshman II
  • llittle
  • Author
  • Freshman II
  • Answer
  • June 13, 2023

This issue has been resolved. A reference line for the customer ID needed to be added to the Import TC Fields.

Thanks!

Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • June 13, 2023

Thank you for sharing your solution with the community @llittle !

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
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