Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Error importing Sales order via AIF

(0) ShareShare
ReportReport
Posted on by 593

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 593 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 593 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 593 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 593 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 593 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans