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 CRM (Archived)

Connector CRM to NAV: NAV Sales Order to Order: The entity cannot be locked because it is read-only

(0) ShareShare
ReportReport
Posted on by

Hi all, 

i have a strange thing in our CRM Online / NAV - Connector.

The Mapping: NAV Sales Order to Order creates errors like this:

- The entity cannot be locked because it is read-only.

- Generic SQL error.

I cant find any hint to solve this problems. i played arround with the mapping, but i am sure, i made everything undone, but the errors above will not let me sync any nav order to crm.

Does anyone have a solution for this?

many thx, Greets
peb

*This post is locked for comments

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

    Hi P,

    Do you get these error messages when trying to view a synced record in CRM?  If not, when/where do they appear?

    I'm not sure if this is going to solve your situation (there may need to be some code deactivated in CRM Online to get things to work - although there is no known issue logged that I can see) but I hope it will help isolate the issue for you.

    The NAV connector treats NAV as the primary record.

    Are you entering the orders into NAV and then syncing with CRM?

    *  After the connector installation, you can create and modify orders in Microsoft Dynamics CRM, but only until the order is submitted.

    What stage in the sales process / status reason are the records that are causing problems?

    After a certain stage the Order record becomes locked.  Are all your records erroring or only those in a certain status?

    * An Order that is created from a Quote will automatically be ‘locked’, however one that is created manually from scratch will start out unlocked. As with the quote, any product price changes while the order is not locked will automatically update the line items.

    * To lock the pricing on an Order, click the ‘Lock Pricing’ button on the ribbon. Once the pricing has been locked, it can be unlocked again by clicking the ‘Use Current Pricing’ button. Similar to the Quote, when you use current pricing on an Order, the prices for all related line items will be updated to the current product pricing.

    * In the Totals section of the Order, you will see a check box called ‘Prices Locked’, which indicates whether the Order pricing is currently locked or not.

    If there are orders in Microsoft Dynamics CRM to move to Microsoft Dynamics NAV, open the Microsoft Dynamics CRM Orders list. For each order that you will integrate, open the order form and click Submit Order at the top of the form. Only orders that have been submitted are integrated to Microsoft Dynamics NAV. Do not submit Microsoft Dynamics CRM orders that have already been recreated in Microsoft Dynamics NAV.

    You need to verify that the currencies or currency codes used are valid currencies or currency codes in Microsoft Dynamics NAV. All currencies and currency codes that are used in the Microsoft Dynamics CRM entities that you want to integrate with Microsoft Dynamics NAV must exist in the Currencies table in Microsoft Dynamics NAV (go to Departments, select Administration, select Application Setup, select Financial Management, and then select Finance).

    Sales orders and invoices created in Microsoft Dynamics NAV may have lines that do not contain a product number. You must verify that all sales lines in a sales order or invoice have an item or resource number before integrating the sales order or invoice to Microsoft Dynamics CRM.

    If sales orders are deleted in Microsoft Dynamics NAV, they will be cancelled

    in Microsoft Dynamics CRM and their status will change from “In progress” to “No money.”

    Note: When you create a new integration from a template, the date set to Check for data

    modified after is set to the current date for the following maps:

    * Sales Order to Order

    To integrate orders or invoices that are older than the current date, change the Check for data modified after date for these maps.

  • Peter Bohn Profile Picture
    on at

    Hi mscrmba,

    first of all, many many many many many THX for your detailed answer.

    No i get no error in crm, i get the error in connector, while/after sync.

    We are creating the orders in NAV and then we wanna sync them to CRM.

    Maybe i found a part of the solution in deaktivating all Workflows i start in crm for products, invoices and orders. Later (after check) more.

    btw: NAV is not providing any kind of workflows to manipulate Data bevor sync to crm?!

    Do you have any NAV Knowledge, where the orders are, after creating an invoice?

    I mean: Can orders "later" be synced to crm, even if an invoice is created? My hopefully wrong info is, that this isnt be possible, because the order will not exist anymore, cause it was converted to an invoice?!

    Your Info with the order/invoice lines with NO product number could be an solution for me.

    Because there are suche lines, but... if they are, how can i manipulate (see above: is there any kind of workflows in NAV possible to manipulate data) the lines that they get any 99999 standardnumber which i firstly create in crm.

    Because one of my problem is, that in crm will be lines, which i wont need, because they are no products, but i cant stop the sync in the connector, because the filters f.e. invoice oder order are only possible for the order/invoice itself, but not for the lines ...

    so i cant say.

    sync invoice if .....

    sync invoice line only if the line has an article No. or anything else.

    Wooow .. strance behavior here, dont you think?

    many many thx,

    greets from Karlsruhe/Germany

    peb

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 CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans