5,124
*This post is locked for comments
Hi All, because I couldn't perform calc on a flowfield, I created a global function that does the calculation and returns the result as decimal. But then I compared the result with Outstanding Amount and they are equal. So I ended up using the Outstanding Amount after all.
Hi mbr,
You cannot use flowfield to make a calculation on some fields.
My suggestion is a function return decimal on Sales Header.
Hi
You are not able to create flow field with multiple fields, you need to create a function in the sales line to update the field in the sales header
Regards
Rajasekhar.Y
Hi,
Using the above formula, I don't think that you can create a FlowField in the Sales Header using the data from "Sales Line". If your requirement is to display it on the Page, you may very well use a variable, calculate it and display it on the page.
As mentioned before, you can create a flowfield in the "Sales Header" based on the "Outstanding Amount" from "Sales Line".
Best Regards,
MMV
Oh! You mean there's an outstanding amt field in sales line equivalent to formula =(quantity - quantity shipped) * unit cost? If so, let me take a looksy at the sales line tAble again.
Moving forward, can u create a flowfield for above formula????
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (