customize standard InventAging report

(1) Share

Report

Posted on by M_R

123

Hi there, here I am going to add three columns in the InventAging report as vendor code, vendor name and vendor group.

But I am unable to fetch the required values here through these code.

Can you please help me out?

All responses (10)

Answers (0)

Sort by

Martin Dráb 240,902 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please tell us what you mean by "I am unable to fetch the required values here through these code". What did you find when you debugged your code?
M_R 123 on at

Like (0)

Report
Copy link

Link copied!

found this while debugging
Martin Dráb 240,902 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Why not? Are you saying that you know how to run code in debugger but otherwise you have no idea how to use it, such as how to see whether your code got called and whether variables have the expected values?
Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @M_R,

Do you mean that the values for the custom fields weren't filled correctly? Can you provide more details about the issue?
M_R 123 on at

Like (0)

Report
Copy link

Link copied!

I am going to add three columns in the InventAging report as vendor code, vendor name and vendor group.

But not getting the values of vendor code, vendor name and vendor group through this code

[ExtensionOf(classstr(InventAgingDP))]
final class ABCInventAgingDP_Extension
{
public void processReport()
{
next processReport();

InventAgingTmp inventAgingTmpabc = this.getinventoryAgingTmp();

ttsbegin;
while select forupdate inventAgingTmpabc

InventTable inventTable = InventTable::find(inventAgingTmpabc.ItemId);
inventAgingTmpabc.AccountNum =inventTable.PrimaryVendorId;
inventAgingTmpabc.PackagingGroupId = inventTable.PackagingGroupId;

//VendTable vendTable;
VendTable vendTable = VendTable::find(inventTable.PrimaryVendorId);
inventAgingTmpabc.Name = vendTable.name();
inventAgingTmpabc.VendGroup =vendTable.VendGroup;

inventAgingTmpabc.update();

//if (InventTable)
//{
//inventAgingTmpabc.AccountNum = inventTable.PrimaryVendorId;

//VendTable = VendTable::find(inventAgingTmpabc.AccountNum);
//if (VendTable)
//{
//inventAgingTmpabc.Name = vendTable.name();
//inventAgingTmpabc.VendGroup = vendTable.VendGroup;
//}

//inventAgingTmpabc.PackagingGroupId = InventTable::find(inventAgingTmpabc.ItemId).PackagingGroupId;

}
    ttscommit;

}

}
Martin Dráb 240,902 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You really need to use the debugger to find out where your code fails. Please tell us if you don't know how to do it; we can help you.

Start by putting a breakpoint at the line with insert() and check if the fields are populated as expected. If not, look at the other variables. For example, maybe you already failed to find the VendTable record, or maybe even the InventTable record. When you know which values are wrong, continue your debugging to find out why. If you can't resolve the problem on your own, share all the information you collected with us.

As you see, just trying to guess what's wrong is not a good approach. You made no progress with that, so maybe you should start taking our advice seriously.
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Your code seems okay but to say if it is working, as everyone suggested, you need to debug it. You need to understand if extension is getting triggered, then check what values the code is returning like let's say the vendor group or name. Then you can have some more idea and understand exact issue.
M_R 123 on at

Like (0)

Report
Copy link

Link copied!

while debugging it is showing the values, but when we print the report it is showing blank as no values are coming.
Martin Dráb 240,902 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

A problem isolation is still your main problem. That a reports shows no data may be caused by the report itself, not the data. Test the report with hard-coded values (e.g. added in insert() to verify that it can ever show values of your custom fields. If not, you need to fix the report, not the data provider.

By the way, I think you should put your code to an extension of InventAgingReportLines.findOrCreate(). It's the most logical place and performance will be much better (because you won't need to process all lines again).
Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi M_R,

Is the issue resolved? Did you try Martin's suggestion " Test it with hard coded values?"