Announcements
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?
Hello Mattguo,
It works if I remove the mapping for the two fields that you said, thanks
additionally could suppress validation on update and create at entity level to test
Hi Naveen,
Try to remove all columns which don't have any value. DMF and the Excel add-in are working a bit different.
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
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
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 |
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,142 Super User 2024 Season 2
Martin Dráb 227,979 Super User 2024 Season 2
nmaenpaa 101,148