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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Link Posted Shipments ...
Microsoft Dynamics NAV (Archived)

Link Posted Shipments line, Sales Line, (Sales to Assembly Order), and Assembly line

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I am using NAV 2013 and Jet Essentials. I want to create a Jet report that can link Posted Shipments line, Sales Line, (Sales to Assembly Order), and Assembly line (Sum of Unit Cost).

I need to track items. I have tried many times and I could not pull out some fields.

I would appreciate if some experts can give me some instruction. Or is there a way to get there?

Thanks!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    If you have Sales Line available, you can get the Assembly Line as follow.

    AsmLine.SETRANGE("Document Type",SalesLine."Assembly Document Type");

    AsmLine.SETRANGE("Document No.",SalesLine."Assembly Document No.");

    Sales Shipment Lines can be found as follow, if you post the Shipment from Sales Order.

    SalesShipmentLine.Setcurrentkey("Order No.","Order Line No.");

    SalesShipmentLine.Setrange("Order No.",SalesLine."Document No.");

    SalesShipmentLine.Setrange("Order Line No.",SalesLine."Line No.");

    Hope this helps.

  • Community Member Profile Picture
    Community Member on at

    Very helpful! I just made it! Thank you!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans