Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

Integrating Invoices From operations To Sales

Posted on by Microsoft Employee

Hi 

I want to integrate invoices from Operation to Sales. I am using CDS for that (Prospect to cash solution.) 

I am integrating Sales Invoice Header and Sales Invoice Lines To Invoice and Invoice Products.(Operations To CRM).

Mapping of Sales Invoice Header:

Header.png

Mapping of Sales Invoice Line:

Line.png

I am getting below error when I am running Sales Invoice Header Map.

The powerquery job failed with error: Exception ExceptionType:MashupEvaluationException, ExceptionMessage:Expression.Error: The column 'pricelevelid.name' of the table wasn't found., EvaluationResponse:{"ResultType":"Exception","Message":"Expression.Error: The column 'pricelevelid.name' of the table wasn't found.","Errors":[]}

4452.ERROR.png

I have map the price list with default value.

  • Andreas Cieslik Profile Picture
    Andreas Cieslik 9,265 on at
    RE: Integrating Invoices From operations To Sales

    Have you followed this guide?

    blogs.msdn.microsoft.com/.../dynamics-365-prospect-to-cash-integration

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans