web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Error Message: Field &...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Error Message: Field 'Reference' must be filled in

(0) ShareShare
ReportReport
Posted on by donnazoee 10

Hi all,

Using Dynamics 365 for about a year right now. Would like to learn more, so figuring out more options to .

I'm trying to use the Excel Add-In to place a Purchase Order. I have managed to make a new Purchase Order using via Design > Add Table > Purchase Order Headers V2

I have to add the lines which I would like to add via Purchase Order Lines V2. However, I get the error message: 

Error Publishing Details: 1 error(s) were encountered while publishing. 0 change(s) were successfully published.

Error Publishing Row Details: A row created in data set PurchaseOrderLinesV2 was not published. Error message: 'Write failed for table row of type 'PurchPurchaseOrderLineV2Entity'. Infolog: Warning: Field 'Reference' must be filled in.; Warning: validateWrite failed on data source 'EPCPurchLine (EPCPurchLine)'.'

I cannot find the 'Reference' Field? I was unable to find a step by step plan, so I might have missed something. 

And is it necessary to see all the existing lines in Dynamics 365? I prefer to see only the lines I am creating.

Many thanks in advance!

Donna

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

    Hi Donna,

    The EPCPurchLine table is not a standard table. Can you verify if you have a customization or ISV/partner solution? You can then ask the partner for guidance. It could be a bug in the data entity extension.

  • donnazoee Profile Picture
    donnazoee 10 on at

    Hi André,

    Thank you for your response. I forgot to mention: Epc is related to my company; it is also used as 'Site'. I believe our system is partly customized. Does this mean I have to ask the partner for guidance? Or can I do something with the Reference Field?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

    Hi Donna,

    I think (but not sure) it is a reference field to the purchase order line in the EPCPurchLine table. You can check it with your partner.

  • donnazoee Profile Picture
    donnazoee 10 on at

    I will contact them in the next couple of days! And will share what it was if they can help me. Thanks!

  • Lars Blaaberg Profile Picture
    Lars Blaaberg 10 on at

    Does the EPCPurchLine table have a RecId based foreign key field that references PurchLine?

    If the RecId based field is associated with the RefRecid EDT, then that might the field, since the Label on RefRecId is 'Reference'.

  • donnazoee Profile Picture
    donnazoee 10 on at

    Sorry but I'm not sure if the table has a RecId based foreign key field that references PurchLine. Am I able to check that myself or do I have to contact my IT colleagues?  

  • Lars Blaaberg Profile Picture
    Lars Blaaberg 10 on at

    You will most likely have to contact your IT colleagues/Partner. My response is essentially the same as the one André gave you, but with a bit more detail about what your colleagues need to look for.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 296

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 234 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 145 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans