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) / Vendors Names' are...
Microsoft Dynamics AX (Archived)

Vendors Names' are not showing for some of the batches

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

7673.Quality1.png6330.Quality2.png

Dear Experts,

We are generating COA(Certificate of Analysis) Reports on the basis of Batches.Please check the above screenshot and  Process first switch to (Inventory Management Module)Click on Dimensions->Batches and then new window of batches will be opened in that batches form go to on the top bar -> Inquiries->Quality Order. Now new Quality Order form is appeared and we enter the data.Now, what is the issue basically, our vendor miss to enter vendors' Name to enter to the system of Opening Balance(The old inventory with us before Dynamics ax implementation in warehouse).Now,our warehouse is entering vendors' name for the PO and then that vendors' name is showing on COA(Certificate of Analysis). But what about that miss Vendors' name of opening balance. where to enter that old inventory vendors' name so the COA(Certificate of Analysis) will show it in place of blank. Help!

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... 304,508 Super User 2026 Season 1 on at

    Hi Shabir,

    I do assume your COA report is a customization? Do you know which exact field is used for retrieving the vendor name? This is not mentioned in your question. If you know which table and field, you can possibly create or have your partner create a script to complete the data.

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

    purchparmline.png

    André Arnaud de Calavon,

    Thanks for your reply, The table name is PurchParmLine, where all vendors' names are saved in mod3Manufacturer field. I know that table(PurchParmLine) and mod3Manufacturer field is customization.Furthermore, The batches are already there but vendors are not entered. Now, if we select that batches and start generating report for that opening Balances the vendor field will be blank for COA. please check the table.Now, i am thinking, should i make another field for this purpose or some thing else??

    Thanks and Regards,

    Shabir Ahmad

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,508 Super User 2026 Season 1 on at

    Hi Shabir,

    It is not a good design to take data from the PurchParmLine for reports like this. This table can be cleaned; then also the data is lost. If the records from your screenshot are related to the batches with missing vendor names, you can fill them using a script. For longer term, I would recommend to pass the data to transaction tables which cannot be deleted; like inventory transactions or posted vendor invoices/receipt lists.

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

    André Arnaud de Calavon,

    I respect of your view, but this is done by our vendor not by me and this table is being used somewhere else in reporting other things as well. So what do you think on the current system.I mean to say that if want to show the data from this table of missing Manufacturers or Vendors name what will be the idea?? Should i use this mod3Manufacturer field for report or create a new field and retrieve vendors' name for COA(Certificate of Anlaysis).

    Thanks and Regards,

    Shabir Ahmad

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

    Hi Shabir,

    As mentioned above, you can try to fill this field using e.g. a script. You can also ask help from your vendor as they probably have the overview how it was customized and intended in their view.

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans