---- Reported by colin.campbell@ptfs-europe.com 2010-05-05 17:25:08 ---- A version of this is currently implemented on the system at UN FAO, Rome On order creation a Purchase Order Number is created based on a template, (at Fao this is a prefix of ordertype followed by orderbumber and year). Acquisitions can be searched by the PO Number in addition to the existing vendor and bib searches --- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:27 UTC --- This bug was previously known as _bug_ 4456 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4456 Actual time not defined. Setting to 0.0 Setting qa contact to the default for this product. This bug either had no qa contact or an invalid one.
Hi Colin, can you give a short update on the status of this development? Has a patch been sent for this feature?
Updated version of patch needs to be submitted to be 3.6-compatible
Created attachment 20283 [details] [review] Enable addition of PO Number to order The ability to have a running purchase order sequence Test Plan: 1) Set systempreference EnablePONumber to Enable for auto generating purchase order number. 2) Select prefix for ex: Direct to requestor (Create PONUMPREFIX in authorized value and insert values). 3) Create an basket. 4) Create an order. 5) Select prefix value for ex: Direct to requestor. 6) Purchase order number will come in purchase order section for ex: DIR0000001. 7) Click on save button
Applying: Bug-4456-Enable addition of PO Number to order Using index info to reconstruct a base tree... M C4/Acquisition.pm M installer/data/mysql/kohastructure.sql M installer/data/mysql/sysprefs.sql M installer/data/mysql/updatedatabase.pl M koha-tmpl/intranet-tmpl/prog/en/modules/acqui/neworderempty.tt Falling back to patching base and 3-way merge... Auto-merging koha-tmpl/intranet-tmpl/prog/en/modules/acqui/neworderempty.tt Auto-merging installer/data/mysql/updatedatabase.pl CONFLICT (content): Merge conflict in installer/data/mysql/updatedatabase.pl Auto-merging installer/data/mysql/sysprefs.sql CONFLICT (content): Merge conflict in installer/data/mysql/sysprefs.sql Auto-merging installer/data/mysql/kohastructure.sql Auto-merging C4/Acquisition.pm Patch failed at 0001 Bug-4456-Enable addition of PO Number to order The copy of the patch that failed is found in: /home/christopher/git/koha/.git/rebase-apply/patch When you have resolved this problem, run "git am --continue". If you prefer to skip this patch, run "git am --skip" instead. To restore the original branch and stop patching, run "git am --abort".
Created attachment 22031 [details] [review] Bug-4456-Enable-addition-of-PO-Number-to-order Enable addition of PO Number to order The ability to have a running purchase order sequence Test Plan: 1) Set systempreference EnablePONumber to Enable for auto generating purchase order number. 2) Select prefix for ex: Direct to requestor (Create PONUMPREFIX in authorized value and insert values). 3) Create an basket. 4) Create an order. 5) Select prefix value for ex: Direct to requestor. 6) Purchase order number will come in purchase order section for ex: DIR0000001. 7) Click on save button
Created attachment 22032 [details] [review] Adding new table po_sequence Adding new table po_sequence
Applying: Bug-4456 Adding table po_sequence Using index info to reconstruct a base tree... M installer/data/mysql/kohastructure.sql M installer/data/mysql/updatedatabase.pl Falling back to patching base and 3-way merge... Auto-merging installer/data/mysql/updatedatabase.pl CONFLICT (content): Merge conflict in installer/data/mysql/updatedatabase.pl Auto-merging installer/data/mysql/kohastructure.sql Patch failed at 0001 Bug-4456 Adding table po_sequence The copy of the patch that failed is found in: /home/christopher/git/koha/.git/rebase-apply/patch When you have resolved this problem, run "git am --continue". If you prefer to skip this patch, run "git am --skip" instead. To restore the original branch and stop patching, run "git am --abort".
Created attachment 22534 [details] [review] Bug-4456-Enable addition of PO Number to order The ability to have a running purchase order sequence Test Plan: 1) Set systempreference EnablePONumber to Enable for auto generating purchase order number. 2) Select prefix for ex: Direct to requestor (Create PONUMPREFIX in authorized value and insert values). 3) Create an basket. 4) Create an order. 5) Select prefix value for ex: Direct to requestor. 6) Purchase order number will come in purchase order section for ex: DIR0000001. 7) Click on save button.
Created attachment 22535 [details] [review] Bug-4456 Adding table po_sequence
Merge conflict in koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref
Should this be rescued, and if so how? The whole sequential number problem needs a better solution than writing sequence generation for each number we encounter. See bug 10454 which sort of got lost in discussion.
The approach taken here looks similar to the cataloguing plugin stocknumberAV.pl - maybe some kind of plugin mechanism would be helpful?