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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Auditors Sequence check on PO numbers

(0) ShareShare
ReportReport
Posted on by

Hello,


Our auditors are performing a sequence check on our purchase orders and are finding many gaps. These gaps happen when a new PO for any reason is closed before completing the PO process.


Is there any means of retrieving the unused PO numbers from a specific table in MS AX? I have seen some posts on the same topic but would like to know whether there was any new update on this one?

Many thanks in advance.

kind regards,

JY

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Jean-Yves,

    You could built a report based on the number sequence list table filtering the "free" numbers if they do not regularly get cleaned up but you would need the help of a technical guy/developer to get this realized.

    Hope this helps,

    Ludwig

  • Sohaib Cheema Profile Picture
    49,438 User Group Leader on at

    I cannot see any extraordinary help from existing system. The existing standard system, can help to have a look at pending sequences, which you can delete.

    On other hand you can write a job to get the list of gaps or missing sequences and those numbers can be reutilized by keeping number sequence manual for some time, unless all missing sequences are utilized

  • Brandon Wiese Profile Picture
    17,788 on at

    Who the hell cares if the numbers are fully sequential with no gaps?  We get this nonsense from our SOX auditors every year.  For example, they want to see that all invoice numbers are sequential, I think because they mistakenly believe if they're sequential that somehow proves that no invoices were deleted (which of course does not follow).  The system has effective controls to prevent the delete of posted invoices.  Tell the auditors to get over it.  Not all systems guarantee that a given number sequence is continuous, and that doesn't mean the system should fail an audit.

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans