Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / D365FO on premise impo...
Finance forum

D365FO on premise import of purchase order lines using DMF

(0) ShareShare
ReportReport
Posted on by NaveenKumar S 3,354

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?

Categories:
Data Integration
Implementation Lifecycle
On-prem Implementation
Go-Live
Financial Management
  • NaveenKumar S Profile Picture
    NaveenKumar S 3,354 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,014 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... 291,642 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,354 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,308 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,354 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... 291,642 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.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans