Small and medium business | Business Central, N...

Create Customer Only When "Order" &"Guest" combination on sales quote page action using XMLPort

(0) Share

Report

Posted on by Inkey Solutions

2,100

Hi Community,

I have a client's requirement which is as follows:

While Importing CSV Files using XMLPort, we're not creating customers directly into the System(Customer Table), we're creating customers in the customer table only when /Document Type/ is /Order/ & /Sell-to Customer No/ is /Guest/ in Sales Quote Page using AL Code. For that, I have created XMLPort which is shown in the below Image.

When I'm trying to import my CSV File it Shows following Error

This is the data that I want to import

For Example When I import this file if /Document Type/ is /Order/ & /Sell-to Customer No/ is /Guest/ then Customer /ABC/ & /XYZ/ Should be added into Customer Table.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

As per the error, do you have 77777 customer in your database?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

You can not create the customer in that trigger on the XML port.

Try using the OnAfterInsertRecord trigger instead.

In the OnPreXmlPort trigger your file is not read yet.

Was this reply helpful? Yes No
Inkey Solutions 2,100 on at

Like (0)

Report

Hi @Inge M. Bruvik ,@Mohana Yadav

Thank You for your Reply.

@Mohana Yadav, No I don't have 77777 customer in the database.

@Inge M. Bruvik, I have tried "OnAfterInsertRecord" trigger but it shows the following error. Do you have any other solution?

Was this reply helpful? Yes No