Entering invoice number displays incorrect invoice number

[freefall]

When adding a new invoice if I enter an invoice number the number is stored correctly in the database. However in certain locations in the application I see the invoice number as the ROW NUMBER not my manually added invoice number.

 

It's clear that the bug is a display problem and is due to the auto incremental primary key number being displayed rather than the manually entered invoice number.

 

Is there a fix for this as we are reconciling accounts right now and it gets tricky when an invoice can display with differing invoice numbers in different parts of the application.

 

Thanks