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

Notifications

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) / Showing Value in Repor...
Microsoft Dynamics AX (Archived)

Showing Value in Report from new my created table

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

Dear Experts,

I am facing an issue for last 6 or 7 months, the issue is :

When we are generating Certificate of Analysis(COA) Report all Vendors' name are showing against any PO(and we are taking Batch numbers) till here ok.

But when we are generating this report taking those batches Opening Balance(Those  Materials which were there in warehouse, before of Ax implementation). So its vendors name are not showing(showing blank). The Reason these Opening Balance vendors names are not inserted.Further, we are not making Po against these old data (opening balance company rules).I want to show these vendors name in blank place. Whenever, the user take these opening balance batches. Please share your ideas  thanks and advance.

Best 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... 301,020 Super User 2025 Season 2 on at

    Hi Shabir,

    Is this the same question as you posted earlier? community.dynamics.com/.../305814

    If so, please update your original post instead of duplicating questions.

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

    Thanks for your reply André Arnaud de Calavon,

    in that case that was purchparmline table made by our vendors(and i resolved that  manually fill the names in the table),but here is another issue with that report.The issue is that if there are some batches against which vendors is not showing. Further, here are manually creating Quality Orders not for PO. So will there  be the solution.if again you are not getting my point, i will give you more detail.

    Thanks and Regards,

    Shabir Ahmad

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

    Hi Shabir,

    Thanks for the explanation. Your question was familiar, so I thought it could be still the same question. However, it is a similar issue.

    If I do understand you correctly, the data on the COA report is always related to batches. If there is no purchase order, the batch number indeed has no reference due to e.g. opening balances. Would it be a solution for you to add a field on the Batch table with the vendor name? Fill this based on data from your legacy system and the data in the purchparmline. Then you are able to change the report to look at the vendor name related to the batch. It is a short thought; you also have to find a way to fill this field when you create new batches.

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

    André Arnaud de Calavon,

    Very good idea of adding field to Batch table. i add field to batch table of vendor name, but batch numbers are taking name of vendors from Purchparmline table all of against PO, what will be the condition if i manually put vendors names for batch number which will be taken by report server and show on blank place in the report.For example Batch number abc123 is taking name from purchparmline table and how these my manually vendors name in batch table will be taken(for example xyz456 is blank and i add vendor name in batch table in front of bacth number )there is any idea or code please suggestion.

    Thanks and Regards,

    Shabir Ahmad

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

    Hi Shabir,

    If there is a process where the batch number will be auto generated from a PO, the vendor name can be populated directly. Otherwise, you need to find out if the vendor name can be completed during the PO posting process. Current available records should be updated with a script to copy them from the purchparmline and/or convert from your older system.

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

    André Arnaud de Calavon,

    Thanks for your reply, The process of generated Batch Number is Manually, when we are receiving PO and generating GRN, while that time we enter Batch number as well as vendor Name as well. But these  vendors names are not entered, but  batch numbers for these old materials was already there and inserted to the system. More, The vendors name(new vendors and against PO) are from Purchparmline. what about these vendors name which are not inserted. I know i am taking your time and reminding you these point again but this is my issue.As you mentioned in above comments to make venors name column in batch table i did same.Now my idea is:

    if(inventtestCertOfAnaylsistmp.manufacture==" ")

    {

    then show the that condition, means take the data from batch table batchtable.batch Id ==  batchtable.vendorName((vendors name)which i will put  manually )

    }

    I need your help this kind of query.Again thanks in advance

    Thanks and Regards,

    Shabir Ahmad

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

    André Arnaud de Calavon,

    Not only the opening balance vendors are showing blank as well as, we are creating new batches number that are also showing blank.

    Thanks and Regards,

    Shabir Ahmad

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

    Hi Shabir,

    Your idea with the condition is a solution. Then the system can first try to find a vendor name from the purchparmline and you can use the vendor name on the batch as fallback.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans