Workflow balance due lcy control

(0) Share

Report

Posted on by Community Member

Hello!

When I send a sales order to request to approval Workflow need to control if the balance due lcy(customer) is >0, does anyone know how i can do this?

Thank u

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Chris Dsilva 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Yes, you can add it in the On Conditions for the sales order workflow.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

How can I add that? With codeunit?

Thank u

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Are you using a BC workflow or a PowerAutomate workflow?

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

BC workflow

Was this reply helpful? Yes No
Suggested answer

Chris Dsilva 40 on at

Like
a
(0)

Report
Copy link

Link copied!

On your search bar in BC, type workflows, edit the sales order workflow , disable it if enabled, add the condition on the first line and enable the workflow

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

How does it know that the balance due lcy is >0 beacuse balance due lcy is a calc field in customer table not in sales header

Was this reply helpful? Yes No
Suggested answer

Chris Dsilva 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

It will be better you create an extension and write your code to first get the calcifield balance and then write a condition to send for approval only if the condition is satisfied else pop up a error.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

I have done this... but the client wants to see the procedures in workflow as the credit limit

Was this reply helpful? Yes No