Skip to main content
Solved

Unable to import into customer Mail settings tab

  • September 30, 2020
  • 2 replies
  • 397 views

I imported the contacts - I now want to on the mail settings screens assign the contacts to the customer in mail setting - I created an import to do so but it gives me an error saying object need to be GUI has anyone had any success creating an import scenario to assign contacts to the Mailing IDs  ( want to assign contacts to mail receipients for Invoice form

Best answer by vkumar

Hi George, 

The error is due to the format in which the ‘Mailing ID’ is saved at database level. Here is what you can do find various Mailing ID values stored in database :

  • Create an export scenario to export CustomerID, mailing ID from Customer screen
  • You will see the value stored for each mailing ID in database
  • for example ‘a70caa8e-2691-46c9-beb7-bb7626f51b4b’ this is the value for ‘INVOICE’ mailing ID
  • If you replace the Mailing ID for ‘INVOICE’ on your import scenario, it does work. 

Hope this helps. 

 

Regards,

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

2 replies

Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 521 replies
  • October 3, 2020

Hello George,

Could you please advise the Acumatica ERP version, how your import scenario mapping currently looks, and which exact error you’re getting?

When importing lines for the record, make sure you use <LineNbr>=-1 formula in lines. There is also might be a matter of incorrect key field used. For more information, please refer to the I100 course.


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • Answer
  • October 5, 2020

Hi George, 

The error is due to the format in which the ‘Mailing ID’ is saved at database level. Here is what you can do find various Mailing ID values stored in database :

  • Create an export scenario to export CustomerID, mailing ID from Customer screen
  • You will see the value stored for each mailing ID in database
  • for example ‘a70caa8e-2691-46c9-beb7-bb7626f51b4b’ this is the value for ‘INVOICE’ mailing ID
  • If you replace the Mailing ID for ‘INVOICE’ on your import scenario, it does work. 

Hope this helps. 

 

Regards,


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