Modifying a purchase order creates multiple invoices

Products

• Asset Management Solution

Issue/Introduction

When generating a purchase order from a purchase request, if the purchase order has additional line items added, it will generate additional invoices when received.

Cause

The SQL from the report "All Invoices" incorrectly shows duplicate invoices.

 

Etrack: 3895070

 

Resolution

Support has created a replacement report for the issue, while the issue is evaluated by Development. 

The replacement report is available in the attachments link.

Steps to apply workaround:
 

1. Navigate to Reports > All Reports > Service and Asset Management > Picker Reports >  Asset Management. 
2. Backup the "All Invoices" Report by right clicking it and selecting "export".
3. Right click the folder "Asset Management" from the report tree and select "import"
4. Select the .xml from this knowledge base article

The issue should be resolved next time the report is ran from the invoices CI.