Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Error importing Sales order via AIF

(0) ShareShare
ReportReport
Posted on by 619

Hi

I try to import a salesorder via AIF inbound port. In the data policy of the port the field Salestype is activated and the xml has the tag in it but during import I get an error on the queue (damn its german) Datenquelle 'SalesType' ist nicht in Abfrage 'AxdSalesOrder' enthalten.

but..the field is available in Port, the fied is in the query and I can find it in AOT in the class

Any ideas

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Error importing Sales order via AIF

    Hi CRSW, that is correct.

  • CRSW Profile Picture
    CRSW 619 on at
    RE: Error importing Sales order via AIF

    in this case I first have to setup the outgoing stuff our system

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Error importing Sales order via AIF

    Could you try to export a sales order via AIF, just to see if it works, whether this field can be included and how the value displays in the XML file?

  • CRSW Profile Picture
    CRSW 619 on at
    RE: Error importing Sales order via AIF

    Did that already, same result

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Error importing Sales order via AIF

    Can you try passing the enum element name instead of the value? For SalesType, try passing Journal instead of 0.

  • CRSW Profile Picture
    CRSW 619 on at
    RE: Error importing Sales order via AIF

    No. as I said when I create the order over AIF I get the error that the SalesType field is not in the query AxdSalesTable (which is a wrong information...it is there)

    Order creation over AIF import is failing.

    If I remove the tag than an import is possible but it creates the order with a salestype setup in the customer parameters (not possible becaue only the orders for a specific customer should be created as journal

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Error importing Sales order via AIF

    Ok. But you were able to create the order without any errors. Correct? Please do let us know how you are inserting the records.

  • CRSW Profile Picture
    CRSW 619 on at
    RE: Error importing Sales order via AIF

    When I do remove the mapping AX will create the orders as SalesOrder (as set in the CustParameters)

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Error importing Sales order via AIF

    Can you remove this mapping and try? It will be 0 by default while importing/. Correct?

    How are you importing the records by the way? Do you have any code for the import?

  • CRSW Profile Picture
    CRSW 619 on at
    RE: Error importing Sales order via AIF

    I pass just a 0 to create an order as journal

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans