Finance | Project Operations, Human Resources, ...

Syntax (formula help)

(0) Share

Report

Posted on by DT-08051425-0

Good morning,

I am trying to figure out how to tell my QUANTITY column and/or my REMAINING BALANCE column (Reported As Finished is the system terminology) to report when an order has packed, but not complete (i.e 62 is the order but 2 did not pack). I'd prefer to set it up as a tile on my dashboard, but may have to use the alert to email route (I don't see a real option for setting that up either.). I appreciate any help I can get! Thanks!

All responses (2)

Answers (0)

DT-08051425-0 9 on at

Like (0)

Report

Syntax (formula help)

I think I'm close with this, but it's displaying all the NULL values instead of the NON NULL values

ProdTable.RemainInventPhysical IS NOT NULL AND ProdTable.RemainInventPhysical<ProdTable.QtySched

In my picture, I don't want to see the green line item because the remaining balance is null.

Thank you!
Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

Syntax (formula help)

Hi,

You can refer to this official document, hope to help you: Modify a workspace with a tile, list, and data cache - Finance & Operations | Dynamics 365 | Microsoft Learn. In this tutorial, you will create a new tile and include it in the summary section of a workspace, build a new list for a workspace, and create a data cache for the list in the workspace.

Best regards,

Kevin