Skip to main content
Answer

user defiend fields using import scenario in Invoice and memo fields

  • August 26, 2022
  • 4 replies
  • 598 views

I have defined user defined fields (User defined Field Tab) on Invoice and Memo screen and  How can I import the data in the using import scenario

Best answer by DConcannon

Hi @muralir  Look for them under the ‘...Summary’ Target Object. They should automatically show there. The images show a user defined field within Customer Locations created for Legacy Customer ID

 

Customer Locations
Location Summary - Target Object

 

4 replies

DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • Answer
  • August 26, 2022

Hi @muralir  Look for them under the ‘...Summary’ Target Object. They should automatically show there. The images show a user defined field within Customer Locations created for Legacy Customer ID

 

Customer Locations
Location Summary - Target Object

 


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • August 26, 2022

Hello, To add to what Dan said, I did a quick test with an attribute/udf called “AR Invoice Type”.  The Description for the Attribute is the field I had to use in my Excel. (Not the Value ID for the attribute).

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @muralir 

UDF fields can be imported when Invoice in Balanced Status only, if you want to update or Import UDF fields then you need work on Workflow changes in Invoice and Memos screen,

Share XML import scenario. I will review and assist you.

 

Thanks


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • September 4, 2022

Hi @muralir  Look for them under the ‘...Summary’ Target Object. They should automatically show there. The images show a user defined field within Customer Locations created for Legacy Customer ID

 

Customer Locations
Location Summary - Target Object

 

To add to what @DConcannon  said, any screen with a UDF can be imported using a scenario. You use the Summary and then map according to the UDF. We have done this for the customer record but the same can be done for Invoices: