Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / D365FO on premise impo...
Finance forum
Answered

D365FO on premise import of purchase order lines using DMF

Posted on by 3,313

Hello, 

I'm using purchase order headers v2 and purchase order lines v2 for importing purchase orders, i have created to seperated projects one for header and other for lines, i'm able to import header but while importing lines i get this error

Results. Field 'Reservation type' must be filled in.
Results. Field 'Document number' must be filled in.
Results. Field 'Reservation title' must be filled in.
Results. Field 'End date' must be filled in.
Results. validateWrite failed on data source 'BudgetReservationHeader_PSN (BudgetReservationHeader_PSN)'

have anyone faced this? how to resolve this?

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,313 on at
    RE: D365FO on premise import of purchase order lines using DMF

    Hello Mattguo, 

    It works if I remove the mapping for the two fields that you said, thanks

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,012 on at
    RE: D365FO on premise import of purchase order lines using DMF

    additionally could suppress validation on update and create at entity level to test

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,142 Super User 2024 Season 2 on at
    RE: D365FO on premise import of purchase order lines using DMF

    Hi Naveen,

    Try to remove all columns which don't have any value. DMF and the Excel add-in are working a bit different.

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,313 on at
    RE: D365FO on premise import of purchase order lines using DMF

    Hello Andre, 

    however i used the same entity and tried using excel addin and it is working correctly, im able to import line, but not happening using DMF

  • Verified answer
    MATTGUO Profile Picture
    MATTGUO 22,298 on at
    RE: D365FO on premise import of purchase order lines using DMF

    Hi Naveen,

    Cancel the mapping of field BUDGETRESERVATIONDOCUMENTNUMBER and BUDGETRESERVATIONLINENUMBER.

    Please refer to this post: community.dynamics.com/.../using-the-vendor-invoice-entities-fails-for-import

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,313 on at
    RE: D365FO on premise import of purchase order lines using DMF

    Hello Andre, 

    All the fields in 'Purchase order lines V2' entity, but here the fields are not appearing.

    PURCHASEORDERNUMBER
    LINENUMBER
    ACCOUNTINGDISTRIBUTIONTEMPLATENAME
    ALLOWEDOVERDELIVERYPERCENTAGE
    ALLOWEDUNDERDELIVERYPERCENTAGE
    BARCODE
    BARCODESETUPID
    BOMID
    BUDGETRESERVATIONDOCUMENTNUMBER
    BUDGETRESERVATIONLINENUMBER
    CATCHWEIGHTUNITSYMBOL
    CONFIRMEDDELIVERYDATE
    CONFIRMEDSHIPPINGDATE
    CUSTOMERREFERENCE
    CUSTOMERREQUISITIONNUMBER
    DEFAULTLEDGERDIMENSIONDISPLAYVALUE
    DELIVERYADDRESSCITY
    DELIVERYADDRESSCOUNTRYREGIONID
    DELIVERYADDRESSCOUNTRYREGIONISOCODE
    DELIVERYADDRESSCOUNTYID
    DELIVERYADDRESSDESCRIPTION
    DELIVERYADDRESSDISTRICTNAME
    DELIVERYADDRESSDUNSNUMBER
    DELIVERYADDRESSLATITUDE
    DELIVERYADDRESSLOCATIONID
    DELIVERYADDRESSLONGITUDE
    DELIVERYADDRESSNAME
    DELIVERYADDRESSPOSTBOX
    DELIVERYADDRESSSTATEID
    DELIVERYADDRESSSTREET
    DELIVERYADDRESSSTREETNUMBER
    DELIVERYADDRESSTIMEZONE
    DELIVERYADDRESSZIPCODE
    DELIVERYBUILDINGCOMPLIMENT
    EXTERNALITEMNUMBER
    FIXEDASSETGROUPID
    FIXEDASSETNUMBER
    FIXEDASSETTRANSACTIONTYPE
    FIXEDASSETVALUEMODELID
    FIXEDPRICECHARGES
    FORMATTEDDELVERYADDRESS
    INTRASTATCOMMODITYCODE
    ISDELIVERYADDRESSORDERSPECIFIC
    ISDELIVERYADDRESSPRIVATE
    ISLINESTOPPED
    ISNEWFIXEDASSET
    ISPARTIALDELIVERYPREVENTED
    ISPROJECTPAYWHENPAID
    ITEMBATCHNUMBER
    ITEMNUMBER
    LINEAMOUNT
    LINEDESCRIPTION
    LINEDISCOUNTAMOUNT
    LINEDISCOUNTPERCENTAGE
    MAINACCOUNTIDDISPLAYVALUE
    MULTILINEDISCOUNTAMOUNT
    MULTILINEDISCOUNTPERCENTAGE
    ORDEREDCATCHWEIGHTQUANTITY
    ORDEREDINVENTORYSTATUSID
    ORDEREDPURCHASEQUANTITY
    PROCUREMENTPRODUCTCATEGORYNAME
    PRODUCTCOLORID
    PRODUCTCONFIGURATIONID
    PRODUCTSIZEID
    PRODUCTSTYLEID
    PROJECTACTIVITYNUMBER
    PROJECTCATEGORYID
    PROJECTID
    PROJECTLINEPROPERTYID
    PROJECTSALESCURRENCYCODE
    PROJECTSALESPRICE
    PROJECTSALESUNITSYMBOL
    PROJECTTAXGROUPCODE
    PROJECTTAXITEMGROUPCODE
    PROJECTWORKERPERSONNELNUMBER
    PURCHASEORDERLINECREATIONMETHOD
    PURCHASEORDERLINESTATUS
    PURCHASEPRICE
    PURCHASEPRICEQUANTITY
    PURCHASEREBATEVENDORGROUPID
    PURCHASEUNITSYMBOL
    RECEIVINGSITEID
    RECEIVINGWAREHOUSEID
    REQUESTEDDELIVERYDATE
    REQUESTEDSHIPPINGDATE
    REQUESTERPERSONNELNUMBER
    RETAILPRODUCTVARIANTNUMBER
    ROUTEID
    SALESTAXGROUPCODE
    SALESTAXITEMGROUPCODE
    SKIPCREATEAUTOCHARGES
    TAX1099GVENDORSTATEID
    UNITWEIGHT
    VENDORINVOICEMATCHINGPOLICY
    WILLPRODUCTRECEIVINGCROSSDOCKPRODUCTS
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,142 Super User 2024 Season 2 on at
    RE: D365FO on premise import of purchase order lines using DMF

    Hi Naveen,

    Can you indicate what columns you have used in your source document? If you did include these fields with blank values, try to remove these fields from the source file.

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,142 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,979 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans