Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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.
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
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?
Business Applications communities