• From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,094

Topic: Purchase order primary key not in synch with PO #

* Delete a Purchase Order, (#2)
* Create a new one in it's place.
* Tested with the last one in the table (auto_increment)
* The New PO now takes this vacated value (#2) but the screen view shows the header line as PO #3 (the auto_incremented table id value) whilst the reference shows 2 and the printout (pdf) also shows it as PO 2.

This has potential for confusion but is probably left there to track the primary key of the actual record in the database.

@joe: any light?

apmuthu's Website

  • Registered: 12/25/2007
  • Posts: 2,447

Re: Purchase order primary key not in synch with PO #

This should be considered as small bug. The reference should be moved back if the last PO is cancelled, I will fix it in table branch repo in  a while. Thanks for pointing it out.

Janusz

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,094

Re: Purchase order primary key not in synch with PO #

Thanks Janusz. That was fast!

Commit Link.

apmuthu's Website