web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Lars Blaaberg Profile Picture
    Lars Blaaberg 10 on at
    RE: Error Message: Field 'Reference' must be filled in

    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.

  • donnazoee Profile Picture
    donnazoee 10 on at
    RE: Error Message: Field 'Reference' must be filled in

    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
    RE: Error Message: Field 'Reference' must be filled in

    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
    RE: Error Message: Field 'Reference' must be filled in

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,421 Super User 2025 Season 2 on at
    RE: Error Message: Field 'Reference' must be filled in

    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
    RE: Error Message: Field 'Reference' must be filled in

    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?

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,421 Super User 2025 Season 2 on at
    RE: Error Message: Field 'Reference' must be filled in

    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.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 189 Super User 2025 Season 2

#2
Yng Lih Profile Picture

Yng Lih 134

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 116

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans