Solved

Import by Scenario 'CustomerID' cannot be empty

  • 13 June 2023
  • 4 replies
  • 153 views
L
Rank

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.

icon

Best answer by llittle 13 June 2023, 16:29

View original
2 Attachments

4 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

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*.
L
Rank

Hi @kandybeatty49 ,

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

1 Attachment
L
Rank

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

Thanks!

Chris Hackett
Rank
Userlevel 7
Badge

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*.

Reply


Terms & ConditionsCookie settings
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