Skip to main content
Solved

SO Import line items from excel sheet to user field

  • February 8, 2023
  • 8 replies
  • 146 views

Forum|alt.badge.img

I have created a user defined field (Customer Line Number) on SO301000 to the Details > Grid: Transactions for my company. This field is working as expected, however I am unable to map an excel upload to the grid to that user defined field

Is there a way to enable import mapping to a user defined field? See picture for more details.

2022 R2 Build 22.209.0029

 

Best answer by rmillerKimball

Hi @Chris Hackett

Mostly? I was unable to find the solution I was hoping for, but the solution that ended up working is importing a new sales order with an Import Scenario using information from this post: 

Thanks for checking in!

 

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

8 replies

Yuriy Zaletskyy
Jr Varsity I
Forum|alt.badge.img+3

Is it UDF, based on attribute, or it is DAC extension?


Forum|alt.badge.img

Hi @Yuriy Zaletskyy, thank you for your response. 

I’m pretty new to Acumatica customizations so not entirely sure, but I believe it is just a UDF.

Does this screenshot help? 

 


Yuriy Zaletskyy
Jr Varsity I
Forum|alt.badge.img+3

Hi, not it’s not UDF, it’s classic DAC Extension. Try please to type of name of the field in import scenario, just type there UsrCustLineNbr.


Forum|alt.badge.img

Good idea, unfortunately same result. When I enter in any value there it doesn’t save it if it is not matching anything in the drop-down.

Just to be clear, I’m using the file upload to import into the details of a sales order. Maybe this would work better if I made an import scenario?

 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2757 replies
  • March 20, 2023

Hi @rmillerKimball  were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Varsity I
  • 41 replies
  • Answer
  • March 20, 2023

Hi @Chris Hackett

Mostly? I was unable to find the solution I was hoping for, but the solution that ended up working is importing a new sales order with an Import Scenario using information from this post: 

Thanks for checking in!

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2757 replies
  • March 20, 2023

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


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 561 replies
  • March 20, 2023

@rmillerKimball unfortunately, you will not be able to upload the UDF data using the load records from file option.  alternatively, you can create a import scenario.  on your import scenario, you will select the summary section and specify the UDF name (which is the attribute ID)

hope this helps


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