Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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,024

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Vendors Names' are not showing for some of the batches

    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.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Vendors Names' are not showing for some of the batches

    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

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Vendors Names' are not showing for some of the batches

    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,024 on at
    RE: Vendors Names' are not showing for some of the batches

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Vendors Names' are not showing for some of the batches

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans