Does anyone know that why the number sequence is not re-use even the "continuous" check box in the number sequence form is selected?
In my case, I have created PO or SO and then deleted it immediately. Then, when I create another new PO or SO the running number is not re-used.
Many thanks in advance.
I found time to play with it abit. Here's my finding...
Assuming a continuous number sequence is setup as PO Order number:
- If you create a new order and then delete it, no numbers added to the status list.
- If you create a new order using the "Create purchase order" form, and click "cancel" in the form. The number is now added to the status list. (Then the number can be freed by clean-up)
Continuous number sequence in AX is not very well executed. I was confused and created a thread on this. Andre gave some good advice. Please check it out here. (community.dynamics.com/.../106293.aspx)
As for how to make it work, you can try add the line below in PurchTableType.delete() method after "purchTable.doDelete();":
I hope that standard code already handle cleaning up other tables which have references to this purchTable record (e.g. PurchLine), you will need to check if you want to be 100% sure.
My blog | PBC
This forum post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
Number sequences can be continuous or non-continuous. A continuous number sequence does not skip any numbers, but numbers may not be used sequentially. Numbers from a non-continuous number sequence are used sequentially, but the number sequence may skip numbers. For example, if a user cancels a transaction, a number is generated, but not used. In a continuous number sequence, that number is recycled later. In a non-continuous number sequence, the number is not used.
Yes, I've tried to use the continuous number sequence on my PO number. But my problem is the number of my PO is not continuous or re-used as definition said.
1) I create PO (I get PO no. 001)
2) I delete PO no. 001
3) I create PO (I get PO no. 002)
So now my PO no. is skip and not continuous.
I'm tried it in 2012 R2 CU6 environment
Please go to the PO number sequence setup. Then click "status list". You should see a record with PO no. 001 there. Look at the "status" column. If it's "Active", then you should run manual cleanup on the number sequence. After that, PO no. 001 will have a status of "Free".
Only records having "Free" status will be considered when the system generate a new number from the number sequence. Now if you create a new PO, you should see 001 assigned.
Note that there is a "Automatic cleanup" fast tab in the number sequence form for you to setup regular clean ups.
Has someone seen the suggestion by Dolee work?
I did not see PO no. 001 in the Status List (right after it was deleted). Did not see any record in NumberSequenceList either.
PO Number seq is setup as Countinous.
Even if the manual cleanup of the number sequence worked, it is reasonable to expect users to perform this every time they delete a PO?
In the scenario mentioned "- If you create a new order and then delete it, no numbers added to the status list."
Is there any place in AX (AX2009) where this is recorded - that a PO # was created and deleted?
I want to be able to show auditors that the gaps in PO # are due to a delete action (and not being "hidden").
You can setup database log for PurchTable to record the addition/deletion of purchase orders.