InvoiceApproval query changes

(0) Share

Report

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)

All responses (9)

Answers (0)

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you please more elaborate on this issue?

Was this reply helpful? Yes No
RadekM 174 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,714 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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..

Was this reply helpful? Yes No
RadekM 174 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,714 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RadekM 174 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RadekM 174 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,714 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No