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

Assistance with Dynamics connector - Nav to CRM

(0) ShareShare
ReportReport
Posted on by

Hi guys.

Im having some issues with the connector, and mainly more so with the data coming from Nav. When importing invoices, we have some line items our posted sales invoices that are not complete. Our users use lines for commenting on the invoice, where they may select a line as a item, and then have no item number or QTY. Another scenario is that we may have a line that is an Item, and has a valid item number but no QTY as the item is on backorder.


Is there a way to filter out lines from being selected? Our criteria would be to only look at lines that have a number in the QTY... if there is no QTY in the line item to exclude that line? We already have some conditions in the lines to check if the product is a Item, resource or Charge Item... but im not sure how to get it to exclude line items with no QTY.


Any help would be greatly appreciated.

Pete

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ragnar Hilmarsson Profile Picture
    3,427 on at
    RE: Assistance with Dynamics connector - Nav to CRM

    Hi

    I think it's not possible, you can only filter on Sales Invoice not invoce lines.

    But maybe you can create some custom attribute on Sales invoice lines in NAV  and CRM and filtered in CRM

  • Community Member Profile Picture
    on at
    RE: Assistance with Dynamics connector - Nav to CRM

    I dont think that will work.. the historical sales invoices cant be changed once posted so they are failing, and will continue to fail.

    What about when you set the conditions? there is a section where you map the invoice lines...  See below. Is there some condition that i can set against the QTY field (its currently mapped to the QTY field in Nav) that says if NULL skip this row?

  • Community Member Profile Picture
    on at
    RE: Assistance with Dynamics connector - Nav to CRM

    1727.Untitled.jpg

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

#1
Community Member Profile Picture

Community Member 2

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans