Customise standard sales confirmation report

(0) Share

Report

Posted on by AXDynamics365

Hi,

I need to add a custom field in the sales confirmation report.

I found many reference but those are not working for my case,

If you have any idea or reference let me know.

thanks and regards,

Aathil Ameen P

I have the same question (0)

All responses (13)

Answers (3)

Verified answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Aatthil,

You need to create new report design - Extend the temp table and add the new fields - Write OnInsertingEvent handler for temp table to populate values to the custom field.

Can you tell us what issue you got when doing the above steps?

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report

First duplicate menuitem giving your new controller class.

Add the same code in controller like standard but call your new report because extension is not possible for report. We need to duplicate the standard report

Once duplicated change the name, add your new field (prior add that in the temp table extension). For writing code to populate you can do a coc on process report or can use oninserting event handler of that table.

Deploy reports and do a build sync.

Was this reply helpful? Yes No
Verified answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi, Please check this article and let us know in which step you are facing issue.

nuxulu.com/.../

Was this reply helpful? Yes No
AXDynamics365 58 on at

Like (0)

Report

" Cannot edit a record in Show confirmation (SalesConfirmHeaderTmp). The operation cannot be completed, since the record was not selected for update. Remember TTSBEGIN/TTSCOMMIT as well as the FORUPDATE clause. "

getting this error while generating report

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (1)

Report

Maybe you missed to add forUpdate keyword in the select statement.

Thanks,

Girish S.

Was this reply helpful? Yes No
AXDynamics365 58 on at

Like (0)

Report

class AatSalesConfirmController_Form_Handler

{

/// <summary>

/// post handler for the process report

/// method in Sales confirm dp class

/// </summary>

/// <param name="args"></param>

[PostHandlerFor(classStr(SalesConfirmDP), methodStr(SalesConfirmDP, processReport))]

public static void SalesConfirmDP_Post_processReport(XppPrePostArgs args)

{

SalesConfirmDP dpInstance = args.getThis() as SalesConfirmDP;

SalesConfirmHeaderTmp salesConfirmHeaderTmp = dpInstance.getSalesConfirmHeaderTmp();

SalesTable salesTable;

ttsbegin;

while select forUpdate salesConfirmHeaderTmp

{

select * from salesConfirmHeaderTmp

where salesConfirmHeaderTmp.CustomerAccount == salesTable.CustomerAccount;

salesConfirmHeaderTmp.CustomerAccount = salesTable.CustomerAccount;

salesConfirmHeaderTmp.update();

}

ttscommit;

}

}

code for your reference

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Why do you need one more select statement inside the while statement.

While select statement is enough for your scenario. No need of select statement inside while select.

Thanks,

Girish S.

Was this reply helpful? Yes No
AXDynamics365 58 on at

Like (0)

Report

Thanks bro it worked and report generated.

but I didn't get my values " salesConfirmHeaderTmp.CustomerAccount = salesTable.CustomerAccount; "

this is what i saw from an reference but i dont know why it doesnt came for me

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

You decalred SalesTable buffer but where will you get cust account?

Thanks,

Girish S.

Was this reply helpful? Yes No
AXDynamics365 58 on at

Like (0)

Report

customer account is mu custom field

those values are come from SalesOder form , in that sales order form I used this customer Account where its data source is salesTable thats why i mapped like this "salesConfirmHeaderTmp.CustomerAccount = salesTable.CustomerAccount"

but i dont know how i get that field value

if you have any idea let me know

Thanks in advance Girish S

Was this reply helpful? Yes No