how CustQuotationJour is linked with SalesQuotationTable? in AX 2012 r3

(0) Share

Report

Posted on by @rp@n

Hi all,

can you please let me know how CustQuotationJour is linked with SalesQuotationTable? I have not get proper matching in the QuotationID field in both tables.

Kindly let me know the exact relation between both tables,

Please give me more shed on this.

Thnaks!

I have the same question (0)

All responses (18)

Answers (1)

Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report
Copy link

Link copied!

Hi @rp@n,

You need to use CustQuotationSalesLink table to get a link between these tables.

Check method CustQuotationJour.salesQuotationTable and how it's designed

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Sergei,

i have created a report for Sales Quotation

in Controller class --

PreRunModifyContract() --

public void prePromptModifyContract()

{

GDJ_JPN_SalesQuotationContract contract;

// Set contract based on caller

contract = this.parmReportContract().parmRdpContract() as GDJ_JPN_SalesQuotationContract;

custQuotationSalesLink = this.parmArgs().record() as CustQuotationSalesLink;

contract.parmQuotationId(custQuotationSalesLink.quotationId);

contract.parmCustAccount(custQuotationSalesLink.invoiceAccount);

}

DP -- process report method

[SysEntryPointAttribute(false)]

public void processReport()

{

GDJ_JPN_SalesQuotationContract contract;

contract = this.parmDataContract() as GDJ_JPN_SalesQuotationContract;

quotationId = contract.parmQuotationId();

custAccount = contract.parmCustAccount();

info(quotationId);

}

Note - info is return BLANK

Report

i want to get Quotation id = QT-0000002 in my query.

Kindly suggest me what to do?

Was this reply helpful? Yes No
Martin Dráb 238,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You're again forgetting about the debugger. Your first step should be checking what's going on in your, not immediately asking others, who can't do that. You're in a much better position to check the problem.

I would place a breakpoint at the line with contract.parmQuotationId(custQuotationSalesLink.quotationId) (by the way, if you didn't forget to use "Insert code", I could have referred to the line number). I think it's likely that custQuotationSalesLink is empty.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Martin

i debugged that, and the quotationid is showing blank. So, i am asking what else i need to do?

i saw, in custQuotationSalesLink table, there is present the QuotationId, whch i am looking for

Was this reply helpful? Yes No
udaY-ch 5,173 on at

Like (0)

Report
Copy link

Link copied!

Hi

Does your dp class decorated with contract class attribute?

I mean in the class declaration.

Uday

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

yes,

[SRSReportParameterAttribute(classStr(GDJ_JPN_SalesQuotationContract))]

class GDJ_JPN_SalesQuotationDP extends SrsReportDataProviderPreProcessTempDB

{

}

processReport method

[SysEntryPointAttribute(false)]

public void processReport()

{

GDJ_JPN_SalesQuotationContract contract;

contract = this.parmDataContract() as GDJ_JPN_SalesQuotationContract;

quotationId = contract.parmQuotationId();

custAccount = contract.parmCustAccount();

info(quotationId);

}

Was this reply helpful? Yes No
Martin Dráb 238,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Could you be a bit more precise, please? I'm confused, because you said you debugged that and then didn't gave me the answer.

Do you mean that custQuotationSalesLink in prePromptModifyContract() doesn't contain any value in QuotationId field? If so, it's clear that we can ignore the rest of code, because the problem is already here.

But it's not exactly what I suggested. Not only that the QuotationId is empty - I suspect that the whole record is empty. Either this.parmArgs().record() returns no record at all, or its type is not CustQuotationSalesLink. Now please go to the debugger again and check what I said. And then try to think by yourself what could be wrong and how you can test it.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

No, its in my class

GDJ_JPN_SalesQuotationController >> prePromptModifyContract method

Was this reply helpful? Yes No
udaY-ch 5,173 on at

Like (0)

Report
Copy link

Link copied!

You should write your code in prerunmodifycontract and not in prepromptmodifycontract

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

why prerunmodifycontract ??

Was this reply helpful? Yes No