web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Missing PO numbers
Microsoft Dynamics SL (Archived)

Missing PO numbers

(0) ShareShare
ReportReport
Posted on by Cynthia Audain 1,348

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

I have the same question (0)
  • NameBrands Profile Picture
    NameBrands 52 on at

    It's not as simple as 'Voided' Orders?

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,348 on at

    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?

  • Community Member Profile Picture
    Community Member on at

    Could someone have unchecked the AutoNumbering of POs and changed the Last PO Number field before rechecking AutoNumbering?

  • NameBrands Profile Picture
    NameBrands 52 on at

    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.

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,348 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans