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) / Sales Order Types Missing
Microsoft Dynamics SL (Archived)

Sales Order Types Missing

(0) ShareShare
ReportReport
Posted on by Community Member

Hello

In my user manuals of MS Dynamics SL 2011 I read that I have several sales order types but in my system I don't have the RFC, REP, RPL or CS types available to choose. I have others like CM, DM, INVC, SO, Q, etc. but I need the RFC and REP for returns and CS for cash sales.

I have activated the Inventory, AR, AP, Accounting modules. 

Could you help me with a guide to manually create this order types with the correct steps or show me some process that I could run to create this missing order types in my system?

Kind Regards.

*This post is locked for comments

  • Agnes Priscilla Profile Picture
    Agnes Priscilla 295 on at
    Re: Sales Order Types Missing

    Hi Carolyn,

    It's my bad. The order type I created is not shown because, I copy and paste those order step from excel files. The Order sequence number comes into zero first. So I put an ' before 0 under the excel cell.

    After I remove all ' signs, and recopy again, the order type is shown up.

    About the script itself, it runs properly. The missing RFC is back again.

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: Sales Order Types Missing

    Hi Agnes,

    You ran the script because Order Types were missing?  Did you delete order types prior to running the script?  If so, you would have deleted those types that you manually created.  

    Or let me know the sequence of steps you took before you could no longer see your order types that you manually created.

  • Agnes Priscilla Profile Picture
    Agnes Priscilla 295 on at
    Re: Sales Order Types Missing

    Hi all,

    I've also run the same script.  After that, I cannot find Order TYpe that I've manually created before from OM Setup, Shipper and SO screen. Please advise.

  • Community Member Profile Picture
    Community Member on at
    Re: Sales Order Types Missing

    Hello Carolyn

    Yes I did replace the XXXXX for the Cpnyid.

    What I did was delete all the records on the table and then I reran the script and it worked, but then later I had to create an index in order to change the characterists of the order tupes.

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: Sales Order Types Missing

    Hi MMaafs,

    Did you remember to replace the x's with your company id?

  • Community Member Profile Picture
    Community Member on at
    Re: Sales Order Types Missing

    Hello Carolyn

    I have the same problem but when I ran the statment that you mention I got the follwong error

    Msg 515, Level 16, State 2, Procedure DMG_SOType_Insert, Line 20

    Cannot insert the value NULL into column 'ProjectStatus', table 'cvtapp.dbo.SOType'; column does not allow nulls. INSERT fails.

    And the sotype tables remains with no records

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: Sales Order Types Missing

    Hello Carolyn

    Many thanks for your support, this query works very well. Problem solved.

    Regards

  • Verified answer
    Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: Sales Order Types Missing

    Hello Alejandro,

    This situation appears to be a bug in SL 2011.  Run the following statement on the application database.  Replace the x's with the company id.

    DMG_SOType_Insert_All '1', 'XXXXXX', '0'

    Let me know if this resolves the issue.

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