Table Filter

(0) Share

Report

Posted on by Mosaheb

952

We want to create a new CUE in order to have the list of customer with Credit Limit Exceeded, ie customers where Balance (LCY) is greater than Credit Limit (LCY).

In the Table 9054 (Finance Cue) added a new field 'Cust - Credit Limit Exceeded' which is a flowfield.

However, how we can filter the Customer Table with only the records where Balance (LCY) > Credit Limit (LCY)

NAV 2015 with SQL 2014

*This post is locked for comments

All responses (2)

Answers (1)

Suggested answer

aavio 895 on at

Like (1)

Report

RE: Table Filter

Can you refer "Partially Shipped" cue in Page 9060

using query object you may be able to achieve it.
Verified answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Table Filter

This can be done in different way .

Suggestion would be make Cust - Credit Limit Exceeded data type as Boolean and make it true when credit limit exceeded

Then you can show the count of customer on cue table by using that Boolean table . and after that whenever user drill down it it will show the customer list where credit limit exceeded.