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

1,646

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:

Business Central

All responses (3)

Answers (0)

Inkey Solutions 1,646 on at

Like (0)

Report

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

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?
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

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

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.
Suggested answer

Mohana Yadav 59,077 Super User 2024 Season 2 on at

Like (0)

Report

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

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