web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

F&O project module - filtering on batch creation of invoice proposals

(4) ShareShare
ReportReport
Posted on by 26
Hello!
 
Wondering of anyone has an Idea or solution to our problem. 
 
We are using the filtering in ”create project invoice proposal” in batch. We are trying to filter on specific sales order transaktions, but is unsuccesful as it seems to group everything on the project. 
 
Example of what we want to achieve:
 
Project A: Sales order 1 has sales origin = X
Project A: Sales order 2 has sales origin = blank
 
Project B: Sales order 3 has sales origin = X
Project B: Sales order 4 has sales origin = blank
 
We want to batch create invoice proposal for sales orders that has sales origin = X
Result = one proposal for sales order 1 and one proposal for sales order 3
No proposal for order 2 and 4. 
 
Anything have experience on using batch creation with this filtering options? We have tried all kinds of joins with sales order table for filtering. 
 
I have the same question (0)
  • Suggested answer
    Syed Haris Shah Profile Picture
    1,666 Super User 2026 Season 1 on at
     
    Did you try with joining the Sales order line table (SalesLine) in the parameters of the Project Invoice Proposal form?
     
     
    If you find this answer helpful, please consider verifying the answer. 👍
     
    Regards,
    Syed Haris Shah
     
  • André Arnaud de Calavon Profile Picture
    304,729 Super User 2026 Season 1 on at
    Hi,
     
    Can you explain what exactly you have done when you mention "We have tried all kinds of joins"? Did you use the advanced filter in the application or did you customize the process?
  • EN-04120816-0 Profile Picture
    26 on at
    Hello both! 

    Thank you for the quick response!

    Here is the ones we have tried:



    We don't have SalesLines to join with, are we doing something wrong/missing something?
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    5,135 Super User 2026 Season 1 on at
     
    The base table for the filteration in "Create Project Invoice proposal" form is Projects. So whatever filter you apply, it will try to filter the projects not the specific sales order transactions. If the base table would be of project transactions, it would have worked with some filters using joins.
     
    Regarding sales order line, you should search with word "Order lines" instead of "Sales", you will get it or you can use contains "SalesLine" option in last column of this filteration page. Although it will not help you any further since it will maximum include those projects which are having any sales order line > Sales order with origin = X. 
     
    Taking your example:
     
    Project A: Sales order 1 has sales origin = X
    Project A: Sales order 2 has sales origin = blank
     
    Even if you will filter based on SalesTable > Sales Origin = X, it will identify that Project A is to be included.. and then while creating proposal it will include all related transactions for Project A, it will not filter basis what we are trying in Advanced filteration page.
     
    Project B: Sales order 3 has sales origin = X
    Project B: Sales order 4 has sales origin = blank
     
    Similar to above explanation.
     
    Maximum that i can suggest here is.. to create Invoice from Invoice proposals page where you need to filter "Project A", include sales line and then once all lines come at that page, try to filter and select the required ones (here i can help further as advanced filter can give you transaction level filter). But unfortunately it will not help in automation that you are expecting here.
     
    If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified
     
    Regards,
    Neeraj Kumar
  • Suggested answer
    Syed Haris Shah Profile Picture
    1,666 Super User 2026 Season 1 on at
     
    you can search "Order Lines" using column filter Relation.
     
     
    If you find this answer helpful, please consider verifying the answer. 👍
     
    Regards,
    Syed Haris Shah

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 620

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 521 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 430

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans