Finance | Project Operations, Human Resources, ...

Bug in Importing vendor invoices

(1) Share

Report

Posted on by Community Member

Hi to all,

I am importing invoices with

Vendor invoice header
Vendor invoice line
Vendor invoice sub line

I found two issues which can not explain.

1. Vendor invoice line, has UnitPrice and NetAmount both having values, after importing the Unit Price field is empty in Pending vendor invoices line, but the price and sum matching is passed! When I leave NetAmount empty in Excel, the price comes to invoice line and sum are calculated too, but the matching on line amount failes.

2. Product Receipt matched in Vendor invoice sub line. After entering into imported pending invoce I see everything is matched fine. If I go to "match product reicept" the stauts changes immideatly to "Failed".

I was checking many days the reason, found the table "Vendor invoice sub line" containes "ReceiveNow" and "Inventnow". The "Inventnow" in the table contains for all imported invoice line the

Quantity of first position (bug?).

Table

Excel for subline

InvoiceLine

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Rich 320 on at

Like (0)

Report

Bug in Importing vendor invoices

From a little experimentation, it appears to me that specifying the NetAmount column will effectively mean that the UnitPrice is ignored in the Staging-to-Target step of the import.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Bug in Importing vendor invoices

Hi Warm,

The vendor invoice import does not import product receipt matching.

Doing that would require an extension of the standard functionality, which can however quickly get very complex.

Think about summary invoices that refer to multiple product receipts, partial invoices for partial receipts, etc.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Bug in Importing vendor invoices

Update.

finally I could test on another system. It has the same behaviour. I think the trouble is "Vendor Invoice sub line" entity, it should bind the record to correct VendorInvoiceInfoLine, but it links only to first invoice line. And that may be the bug.

Fields:

INVOICELINEREFERENCE

INVOICELINENUMBER

are enough for the entity to link, but for some reason it does not work. A development access to code could clear the issue.

An important thing is to know, if actually it is supposed to import product receipt matching with that entity at all? Maybe there is no such a function by design?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Bug in Importing vendor invoices

Thanks Andre'!

1) the system is a fresh installation, there are no developments or any other code.

2) To that system is no LCS, as it is an on-premise solution. But I would check on another cloud instnance and check LCS there. May be submit the bug from there.

Thanks for idea!

With the price and amount, it is common story, you change amount, the price is lost.

But when the entire invoice is imported over entity, you expect to see whole originaly provided information. Especially when price/netamount matching are passed, and prices were there.

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

Like (0)

Report

RE: Bug in Importing vendor invoices

Hi Warm,

If the "vendor invoice sub lines" are also incorrect in your other environment, I would suggest to:

1) Do you have customizations, ISV solutions or partner add-ons?

2) Check LCS issue search for possible known issues

3) Contact Microsoft support as it then might be a bug.

Note that when you provide a value in the net amount field, the unit price will be cleared. This is also the behavior in standard forms.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Bug in Importing vendor invoices

That all szenarios I tested. As I told, I created even a new pending invoice as I needed, matched all the lines with product receipt. After exported it intoa package, deleted the pending invoice and import back from the exported package, the trouble with price and quantity came back. I did it many times without success and checked all exported file with my manual files, as I tested really different scenarios.

I assume this is a bug, real help could if someone did the same import and check that behavior. I am going to test it in another environment, it takes time.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Bug in Importing vendor invoices

Hi Warm,

Can't you use the exported file and overwrite/update them with the data you want to import?

Shouldn't that allow you fixing your problem?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Bug in Importing vendor invoices

Hi Reinhard,

the import runs perfect, there are no error messages.

In staging I see all values are there valid, as provided in excel files

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Bug in Importing vendor invoices

Hi Warm,

I see.

Do you receive any error messages when trying the import?

Have you checked the staging and the log?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Bug in Importing vendor invoices

That is one of things, what I have tried many times last days.

After nothing special found on comparing files, I created fully matched invoice, after exported it as package, deleted the invoice and imported that package back. Still the same result.

Was this reply helpful? Yes No