1,270
Hi
I have a situation where the client noticed that there are missing purchases order numbers in the system that they cannot give account for.
Anyone could throw some light on what could cause PO numbers to be missing.
Thanks
*This post is locked for comments
Thanks guys, I thought for a moment the possibility of your suggestions and they sound very logical.
I did not want to go down that line but after executing a script to get all the tables in the database that consist of the PONbr field and then execute scripts on each of the tables in an attempt to locate the missing PO numbers and still nothing came up, I could only revert to those possibilities.
Appreciate your suggestions.
Sounds like you are the victim of people putting in their own number and making the system 'skip'
If I am on PO # 4567 and then someone hand keys in PO 4577, then the system will skip the ones in the middle and start auto numbering from 4577, you will never see 4568-4576.
That is how the system works, same with check numbers. Just make sure no clerks are typing in po numbers on their own.
Could someone have unchecked the AutoNumbering of POs and changed the Last PO Number field before rechecking AutoNumbering?
Hi, by voided do you mean cancel? I know that one can cancel a purchase order but it still will be shown in the PurchOrd table as being cancelled with a PO number.
In the client's case, it is not showing on the purchase order status history report, one cannot see it in the purchase maintenance screen and it is not in any one of the PO Tables that I have checked.
I pulled all the tables with a POnbr column and I execute a check for the PO numbers that were missing and they just seem to have disappeared from the database and I am looking for some logical explanation as to why this may happen.
Any other suggestions or checks that I may have missed?
It's not as simple as 'Voided' Orders?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (