Skip to main content

Notifications

Announcements

No record found.

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

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Showing Value in Report from new my created table

    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.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Showing Value in Report from new my created table

    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

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Showing Value in Report from new my created table

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Showing Value in Report from new my created table

    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,024 on at
    RE: Showing Value in Report from new my created table

    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... 291,253 Super User 2024 Season 2 on at
    RE: Showing Value in Report from new my created table

    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,024 on at
    RE: Showing Value in Report from new my created table

    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... 291,253 Super User 2024 Season 2 on at
    RE: Showing Value in Report from new my created table

    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.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans