Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

InvoiceApproval query changes

(0) ShareShare
ReportReport
Posted on by 76
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.
 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,162 Super User 2025 Season 1 on at
    InvoiceApproval query changes
    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?
  • RadekM Profile Picture
    RadekM 76 on at
    InvoiceApproval query changes
    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.
     
  • RadekM Profile Picture
    RadekM 76 on at
    InvoiceApproval query changes
    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.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,162 Super User 2025 Season 1 on at
    InvoiceApproval query changes
    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.
  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    InvoiceApproval query changes
    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.
  • RadekM Profile Picture
    RadekM 76 on at
    InvoiceApproval query changes
    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?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,162 Super User 2025 Season 1 on at
    InvoiceApproval query changes
    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 76 on at
    InvoiceApproval query changes
    @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.

  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    InvoiceApproval query changes
    Hi,
     
    Can you please more elaborate on this issue? 

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans