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 RMS (Archived) / ERROR on PO Auto Numbe...
Microsoft Dynamics RMS (Archived)

ERROR on PO Auto Number Generation

(0) ShareShare
ReportReport
Posted on by Community Member

ERROR [tag:2147217913] 

Conversation failed when converting the nvarchar value '********' to data type int.

(Source: Microsoft OLE DB Provider for SQL Server)

(SQL State: 22018)

(NativeError: 245)

No Help file available

SET NOCOUNT on
select ISNULL(max(cast(right(ponumber,7) as int)),0) + 1 asnextponumber from PurchaseOrder where ISNUMERIC(ponumber)<> 0

I know

Hotfix #32

KB2735491

Suppose to Fix it but i get an error message 

The expected product version is not installed

Is there a way in SQL to fix this like Alter the command

the VARCHAR works 

select ISNULL(max(cast(right(ponumber,7) as varchar)),0) + 1 asnextponumber from PurchaseOrder where ISNUMERIC(ponumber)<> 0

Would this command change or alter function if entered as

SET NOCOUNT on
select ISNULL(max(cast(right(ponumber,7) as varchar)),0) + 1 asnextponumber from PurchaseOrder where ISNUMERIC(ponumber)<> 0

 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: ERROR on PO Auto Number Generation

    Looks like you are already on CU5 then.  

    So what is the highest PO Number in the system?

    It could be that you having a int overflow issue.  This happens when PONumbers are higher that 9999999.  For the next PO try typing in 10000000 manually for the PO Number, then auto generate the next one.

    I just tried that on my 2.0.2000 RMS demo and it worked.  My platform is Windows 7 64bit and SQL 2008R2.  

  • Community Member Profile Picture
    Community Member on at
    RE: ERROR on PO Auto Number Generation

    2.0.2000

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: ERROR on PO Auto Number Generation

    bettiene1  

    What version are you currently on?

    Normally the message means you need to install requried Feature Pack, or Service Pack.  But it can also mean that you have a newer version installed than the hotfix.  

  • Community Member Profile Picture
    Community Member on at
    RE: ERROR on PO Auto Number Generation

    I got an error saying that

    The expected version of the product was not found on system

    what does that mean

    SP1--->SP2--->SP3--->FP1--->SP4--->FP2--->CU5

    But error came up after I tried new feature for me

    Create New Purchase Order with Items that wasn't received clicked on get this error research found update or hotfix

    but thing is say that

    The expected version of the product was not found on system

    is there another update of hotfix I missed, or I did something wrong

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: ERROR on PO Auto Number Generation

    the command can not be altered.  The command is not stored in the database but is coded in the qsrules dll directly.  

    You have to have Feature Pack 2 installed prior to trying to install this hotfix.  

    Or you could just install CU5 which would include Freature Pack 2 and that hotfix.  

    Here is a link to all the service packs, feature packs, and hotfixes.

    mbs.microsoft.com/.../20SPHF-V2

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans