web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Brandon Wiese Profile Picture
    17,788 on at
    RE: Auditors Sequence check on PO numbers

    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.

  • Sohaib Cheema Profile Picture
    48,663 User Group Leader on at
    RE: Auditors Sequence check on PO numbers

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Auditors Sequence check on PO numbers

    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

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans