You have subscribed to a wiki page or wiki category on "xTuple" for change =
The "320to321.gz" page has been changed by pclark:
=3D 320to321.gz =3D
+ =3D=3D Check for duplicate purchase order numbers =3D=3D
+ Purchase Order records exist with duplicate numbers please ensure each Pu=
rchase Order has a unique number.
+ Find the suspect pohead_numbers.
+ SELECT pohead_number, count(*) FROM pohead GROUP BY pohead_number HAVING =
count(*) > 1;
+ For example PO Number 6000 was returned with a duplicate.}}}
+ From that returned list, get a pohead_id for one of the duplicates.
+ SELECT pohead_id FROM pohead WHERE pohead_number =3D '6000';
+ You should investigate the actual hardcopy PO before modifying, and let p=
eople know there's been a number change.
+ Let's renumber one of the duplicates using the fetchponumber() function.
+ UPDATE pohead SET pohead_number =3D (SELECT fetchponumber()) WHERE pohead=
_id =3D 345;
+ COMMIT; If updated exactly 1 row, otherwise ROLLBACK;
=3D=3D One or more A/R Open records (aropen) exist with null Due Dates. =
One fix would be to add terms days to doc date to calculate due date.