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 / Microsoft Dynamics AX (Archived) / Manufacturer Field is ...
Microsoft Dynamics AX (Archived)

Manufacturer Field is not showing on Report

(0) ShareShare
ReportReport
Posted on by Shabir Ahmad 3,124

COA-Error.pngCOA-Blank-Field.png

Dear Experts,

I am new to Reporting area, i want to show a field of (Manufacturer) on Certificate of Analysis Report, The Field is Manufacturer of PurchParmLine table. I tried but in vain, i wrote the above code in InventTestCertOfAnalysisDP in inserttotmptable method image please help. Thanks in advance.

Show me step by step 

My code is here :

select firstOnly1 inventTrans where inventTrans.inventDimId == inventTestCertOfAnalysisTable.InventDimId
&& (inventTrans.StatusReceipt == StatusReceipt::Purchased
|| inventTrans.StatusReceipt == StatusReceipt::Received);
inventTestCertOfAnalysisTmp.mod3Manufacturer = PurchLine::findInventTransId(inventTrans.InventTransOrigin().InventTransId).purchTable().vendorName();

THanks and Regards,

Shabir Ahmad

*This post is locked for comments

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

    Hi Shabir,

    In your coding, you try to retrieve an InventTrans record based on InventDimId. The InventDimId is not unique and can be used on many other transactions. Having a link on the InventTransId is a better option.  

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,124 on at

    Dear  André Arnaud de Calavon,

    Please tell me, what kind of code should i write ?? because i am new to reports.

    Thanks and Regards,

    Shabir Ahmad

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

    Hi Shabir,

    You can try to link the InventRefTransId in the InventTestCertOfAnalysisTable on the InventTransId field on the InventTrans table. Not sure about the outcome, as I'm not familiar with the database model in the area of these certificates.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,124 on at

    Dear André Arnaud de Calavon,

    The table name is PurchParmLine in which the field Manufacturer is exist, that i want to show on Certificate of analysis.

    Thanks and Regards,

    Shabir Ahmad

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

    Hi Shabir,

    In the standard application there is no Manufacturer field on the PurchParmLine. So, you probably have some customizations here. Above mentioned coding is assuming that the manufacturer is the vendor name of the vendor used on the PO. As said above, I'm not familiar with the data model used for the COA. I tried to help you on the part where you used the InventDimId instead of the InventTransId to find the related inventory transaction.

    The PurchParmLine does have a field InventTransId. So, probably you can directly try to link the InventTestCertOfAnalysisTable.InventRefTransId with PurchParmLine.InventTransId or PurchLine.InventTransId. Note that there might be multiple records in the PurchParmLine because of e.g. Confirmation, Receipt list, Invoice. In that case, the PurchLine is a better choice. Possibly you can use something like:

    inventTestCertOfAnalysisTmp.mod3Manufacturer = PurchLine::findInventTransId(InventTestCertOfAnalysisTable.InventRefTransId).purchTable().vendorName();


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 April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans