News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... create a query using c...

Finance | Project Operations, Human Resources, ...

Unanswered

create a query using custTable and CustInvoiceJour

(0) Share

Report

Report

Posted on by CRSW

619

Hi

I do have a class with a dialog, having range values entered by user.

I want to create a query having CustTable data matching the values. All range values except 1 are for custTable. 1 is for the invoicedate on custinvoicejour.

In the case there are records in the custinvoicejour with an invoicedate in a specific timeframe I want to get only those custTable records, if there is no time-frame specified I want to get all custTable records matching the ranges

How can I build up the query to match the effort

All responses Img

All responses (1)

Answers Img

Answers (0)

abdullah0094@hotmai... 85 on at

Like (0)

Report

RE: create a query using custTable and CustInvoiceJour

What is the meaning of all range values except 1? Do you have a new dialog field that is capturing values 1 and other values and if it is 1 build a range on custinvoiceTrans along with building a range on custTable and if it is anything other that 1 just build a range on custTable irrespective of invoice Date. Am i correct?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,430 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans