web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Unmatched landed cost
Microsoft Dynamics GP (Archived)

Unmatched landed cost

(0) ShareShare
ReportReport
Posted on by Stephane Jodouin 120

Hi! First post...

I'm looking for the table and/or a report to list all unmatched landed cost.

(Landed cost applied to a receiving for which the freight invoice is not yet matched)

Thanking you in advance!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi,

    You can try the following report under purchasing-Analysis.

    Purchasing >>Reports >> Analysis >> New or Modify button

    Select Purchase Order Analysis and compare by PO/Invoice Costs

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    1. Go to Smart List and select Receiving Line Items under purchasing.

    2. Add the columns Landed Cost and Total Landed Cost

    3. Click Ok to check the report.

    Hope this helps!!!

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    You can also find the details from below tables.

    1. POP10700 - Purchasing Landed Cost

    2. POP30700 - Purchasing Landed Cost History

    Hope this helps!!!

  • Verified answer
    Stephane Jodouin Profile Picture
    Stephane Jodouin 120 on at

    Thank you very much.

    It generated a very large report, but you pointed me in the right direction.

    The "Received/Not Invoiced" report gave exactly what I needed, "outstanding" landed cost applied to receiving's, but not yet matched with an invoice (freight bill)

  • Stephane Jodouin Profile Picture
    Stephane Jodouin 120 on at

    Thank you very much for your answer.

    As I mentioned in my answer to Mr. Baskaran, I found the report that would highlight tem, but even when adding the landed cost columns, the unmatched lines did not appear in the smartlist.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Glad to hear that your problem resolved by running this report.

  • Community Member Profile Picture
    Community Member on at

    Is it possible to get a this similar report in a smart list rather than a report. I am looking to put date parameters in a smart list.

    Thanks,

    Jelana

  • Community Member Profile Picture
    Community Member on at

    I believe this is a simple Landed Cost RNI . . .

    SELECT A.*, C.*

     FROM POP30700 AS A LEFT JOIN

          POP10600 AS B ON A.LCLINENUMBER = B.LCLINENUMBER AND

                       A.RCPTLNNM = B.RCPTLNNM AND

    A.POPRCTNM = B.POPRCTNM INNER JOIN

      POP30310 AS C ON A.POPRCTNM = C.POPRCTNM AND

                       A.RCPTLNNM = C.RCPTLNNM

    WHERE B.POPRCTNM IS NULL

    -- AND C.PONUMBER = 'Your PO Number'

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans