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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / InvoiceApproval query ...
Finance | Project Operations, Human Resources, ...
Unanswered

InvoiceApproval query changes

(0) ShareShare
ReportReport
Posted on by RadekM 174
Hello, after the last update I've found that the Invoice Approval is broken (or optimalized the wrong way).
Before when Approvig the invoice going to Functions > Purchase Order I didn't even need to update any information as shown below. The right order was always found. 
Now I don't fill the OrderId it will just try to match every purchase for the invoice account.
Any idea how to fix this? Tried to join other tables and query it that way but nothing worked the way I need, and I need to keep this that simple as it was because people working with it don't know what orderId should be matched before.
 
I have the same question (0)
  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,634 Moderator on at
    Hi,
     
    Can you please more elaborate on this issue? 
  • RadekM Profile Picture
    RadekM 174 on at
    @Bharani as you can see below that is the result I get right now with the current setting I use always I always had the Purchase Order blank. But before the update it always showed one purchase order that had a purchase receipt. 
    Every single pucharse order below is wrong. As you can see it gets all orders from all the time, the only way for me is to add to the Purchase update query the right order ID I want to Post.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,461 Super User 2026 Season 1 on at
    Hi RadekM,
     
    Can you talk more about the differences? I'm not fully able to understand what is the current and expected behavior. When I look at your query, I would expect a list with multiple orders if they are not invoiced yet..
  • RadekM Profile Picture
    RadekM 174 on at
    From the users perspective there is only one difference, because he doesn't change any criteria but there is a new form in between VendInvoiceApprovalSelectPurchOrder.
    But the result is different. When I do the same thing on the second enviroment 10.0.29 the result is one row that I only need to post. 
    On the new enviroment 10.0.34 I get all that trash that is not connected to the invoice.
    I know that leaving Purchid blank I should expect a list but why did it previously ended with one correct order?
  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,634 Moderator on at
    Sorry. I could not get what the question is. When I see the query, it should return the record where invoice matches right? So now issue is it is not giving the expected result? Kindly give me more information on this.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,461 Super User 2026 Season 1 on at
    Hi Radek,
     
    Are you using the vendor invoice approval journal form? If so, is there a purchase order number (or numbers) provided on the Invoice register? If not, it will not fill the Purchase order criteria on the query form. If you provided one or more purchase order numbers during the registration of the invoice it should be pre-populated. If that is not working anymore, try to reset the query or usage data.
  • RadekM Profile Picture
    RadekM 174 on at
    Yes I'm using invoice approval form. As I can see every reated invoice registed purchase has no order number only invoice number added.
    But you're right when I did create a registered invoice and added the orderId there it went smooth on invoice approval form.
     
    Still it worked before without adding the orderId in register. 
    Another thing in pending vendor invoices form I do have the information what invoice - orderId - product receipt is connected yet when I joined this table with PurchTable and tried to query with the invoice number the result was broken, looks like only adding PurchaseId gives the right output.
  • RadekM Profile Picture
    RadekM 174 on at
    I want to make a extension so I can put the OrderId directly into the query form.
    Propably it will be PurchFormLetter or FormLetterParmData class but how can I chang that by code?
    I want that the PurchId will be added on formrun.
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,461 Super User 2026 Season 1 on at
    Hi Radek,

    Since about 20 years, the standard application works with having the purchase order(s) specified on the register. I haven't seen another behavior myself.
     
    I'm not able to understand what you want to achieve with an extension. There is already a purchase order range on the query. Can you explain more?

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 470

#3
Adis Profile Picture

Adis 270 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans