Custom quotation workflow

(0) Share

Report

Posted on by faiz7049

2,382

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

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

André Arnaud de Cal... 301,049 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
faiz7049 2,382 on at

Like (0)

Report
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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,049 Super User 2025 Season 2 on at

Like (0)

Report

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).

Was this reply helpful? Yes No
faiz7049 2,382 on at

Like (0)

Report

Hi André Arnaud de Calavon,

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

Please help me.

Regards,

Faiz

Was this reply helpful? Yes No
André Arnaud de Cal... 301,049 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
faiz7049 2,382 on at

Like (0)

Report

Hi André Arnaud de Calavon ,

In WF , I am checking total discount in % and total amount.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,049 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
faiz7049 2,382 on at

Like (0)

Report

Hi André Arnaud de Calavon,

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

Regards,

Faiz

Was this reply helpful? Yes No
André Arnaud de Cal... 301,049 Super User 2025 Season 2 on at

Like (0)

Report

Hi Faiz,

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

Was this reply helpful? Yes No
Verified answer

faiz7049 2,382 on at

Like (0)

Report
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

Was this reply helpful? Yes No