Custom quotation workflow

(0) Share

Report

Posted on by faiz7049

2,238

Hi experts,

I created custom sales quotation workflow based on total discount percentage criteria.

Now we have requirement to check first Net amount then total discount percentage. I found a method in Salesquotationtable totalInvoiceAmountMST(). but I do not know how to apply.

I created a field (Net Amount) in Salesquotationtable and based on Net Amount I configure workflow but where I can get amount in Net Amount using totalInvoiceAmountMST().

Please help me.

If need more details let me know.

regards,

Faiz

All responses (10)

Answers (1)

Verified answer

faiz7049 2,238 on at

Like (0)

Report
RE: Custom quotation workflow

Hi André Arnaud de Calavon,

I have been updated paramenters in method parmTotalInvoiceAmountMST() and classDeclaration definition as given. Workflow now working perfectly and error disappeared.

classDeclaration

class SalesQuotationApprDocument extends WorkflowDocument { SalesQuotationTable salesQuotationTable; AmountMST amountMST; }

parmTotalInvoiceAmountMST

public AmountMST parmTotalInvoiceAmountMST(CompanyId _companyId,tableId _tableId, RecId _recId ) { select salesQuotationTable where salesQuotationTable.RecId ==_recId; { amountMST = salesQuotationTable.totalInvoiceAmountMST(); } return amountMST; }

Thanks,

Faiz
André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

RE: Custom quotation workflow

Hi Faiz,

This is weird. You are able to select and configure the fields in the workflow, but you still get the runtime error.
faiz7049 2,238 on at

Like (0)

Report

RE: Custom quotation workflow

Hi André Arnaud de Calavon,

Yes, this is development environment . I have checked CIL status looks fine.

Regards,

Faiz
André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

RE: Custom quotation workflow

Hi faiz,

Anyhow, I think it is related to the CIL build. Is this the development environment or was the coding already moved to another environment? Can you check the latest CIL status?
faiz7049 2,238 on at

Like (0)

Report

RE: Custom quotation workflow

Hi André Arnaud de Calavon ,

In WF , I am checking total discount in % and total amount.
André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

RE: Custom quotation workflow

Hi Faiz,

I'm not able to check your environment. How did you use this calculated field in the workflow configuration? Can you share a screenshot of the WF configuration?
faiz7049 2,238 on at

Like (0)

Report

RE: Custom quotation workflow

Hi André Arnaud de Calavon,

Yes I complied and restarted AOS but still getting same error.

Please help me.

Regards,

Faiz
André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

RE: Custom quotation workflow

Hi Faiz,

Did you compile the objects? Is the CIL created correctly or did the build give some errors? If you have multiple AOS machines, try to restart them all (if the CIL is correctly built).
faiz7049 2,238 on at

Like (0)

Report
RE: Custom quotation workflow

Thank you André Arnaud de Calavon, I added a method to calculate total Invoice Amount as given below
public AmountMST parmTotalInvoiceAmountMST(tableId _tableId, RecId _recId ) { SalesQuotationTable salesQuotationTable; ; select salesQuotationTable where salesQuotationTable.RecId ==_recId; return salesQuotationTable.totalInvoiceAmountMST(); }

under class SalesQuotationApprdocument.

When I run workflow I am getting error as given below.

Please help me
Suggested answer

André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

RE: Custom quotation workflow

Hi Faiz,

You can create calculated fields in the workflow document class. There are examples on the purchase order workflow where e.g. a delta amount is calculated to be used as condition in the workflow configuration.