What is the issue?
When a user edits the Line Item Description of an invoice which was created from the Bulk Invoice Processing Suiteapp, the system changes the Line Unique Key.
Why is this an issue?
We feed invoicing data to our planning tool (Adaptive) and use the Line Unique Key ID as the primary key for line item updates. Since the values change, we end up with duplicate records as the old keys were synced (and will never get updated again since the now longer associated to the invoice) and then when the keys change the new lines are added to the tool.
Steps to replicate:
- Create a Vendor Bill with line items marked as billable
- Approve the Vendor Bill
- Navigate to the Bulk invoice Processing App i.e. Invoice Billable Customers
- Generate the billable items as an Invoice
- The invoice is generated. Although, initially without a line item description.
- Create a saved search and view the transaction and the Line Unique Keys associated. Keys below
- Edit the invoice and add a description on the existing line items
- Using the same saved search, review the results. After editing the line item description to be customer friendly, we see the Line Unique Keys change.