Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Compare one NAV field against another field

This feature is supported with Dynamics NAV connectors, only

Overview

If you want to compare the value in one field to the value in another field in the same record, you can use a "Calculated Field" within your Jet Reports formula.

Examples

You need a list of sales invoice numbers where the "Bill-to Customer No." is equal to the "Sell-to Customer No."

=NL("Rows","Sales Invoice Header","No.","No.","=IF(NF(,""Bill-to Customer No."")=NF(,""Sell-to Customer No.""),NF(,""No.""))")

List all [Vendor Ledger Entry] records where the "Remaining Amt. (LCY)" is different than the "Amount (LCY)"

=NL("Rows","Vendor Ledger Entry",,"Remaining Amt. (LCY)","=""<>""&nf(,""Amount (LCY)"")")

Published:

Compare one NAV field against another field

This feature is supported with Dynamics NAV connectors, only

Overview

If you want to compare the value in one field to the value in another field in the same record, you can use a "Calculated Field" within your Jet Reports formula.

Examples

You need a list of sales invoice numbers where the "Bill-to Customer No." is equal to the "Sell-to Customer No."

=NL("Rows","Sales Invoice Header","No.","No.","=IF(NF(,""Bill-to Customer No."")=NF(,""Sell-to Customer No.""),NF(,""No.""))")

List all [Vendor Ledger Entry] records where the "Remaining Amt. (LCY)" is different than the "Amount (LCY)"

=NL("Rows","Vendor Ledger Entry",,"Remaining Amt. (LCY)","=""<>""&nf(,""Amount (LCY)"")")

For an optimal Community experience, Please view on Desktop